[Openstack] Nova DB sync Operational error

Jay Pipes jaypipes at gmail.com
Wed Nov 26 18:25:37 UTC 2014


On 11/25/2014 05:10 PM, Amit Anand wrote:
> Hi all,
>
> Setup: 3 node, one controller, one compute and one network all separate
> machines. Juno install.
>
> Recreating my Juno install and this is the second time Ive gotten this
> error whne running "su -s /bin/sh -c "nova-manage db sync" nova" ( I got
> in in another install so I started over):
>
> 2014-11-25 16:16:51.707 3238 CRITICAL nova [-] OperationalError:
> (OperationalError) (1045, "Access denied for user 'nova'@'localhost'
> (using password: YES)") None None
>
> I am confident that all is ok with my nova.conf (Ill be happy to send
> it) - I think this maybe a bug within openstack as this is the second
> time I have gotten the exact same error on a totally new install? Ive
> checked MaraiDB and all looks good there:
>
> MariaDB [mysql]> SELECT user,password,host FROM user;
> +----------+-------------------------------------------+-----------+
> | user     | password                                  | host      |
> +----------+-------------------------------------------+-----------+
> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1       |
> | keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
> | keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
> | glance   | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
> | glance   | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
> | nova     | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
> | nova     | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
> +----------+-------------------------------------------+-----------+
>
> Im using the exact same password for all my acccounts in this DEV
> enviroment to keep it simple.
>
> I can also connect just fine from command line:
>
> [root at controller nova]# mysql -u nova -p nova
> Enter password:
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 11
> Server version: 5.5.40-MariaDB MariaDB Server
>
> Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> MariaDB [nova]>
>
> So I have no idea what is wrong. Ive dropped the database and added it
> back following the insturctions again via the install guide and same
> error. I was hoping anyone had any pointers before I go ahead and report
> this as a bug. Ive tried everything that Ask Openstack answers have
> shown and no go. I am suprised that Im the only one getting this error
> repeatedly...I see that root % is in there twice and no idea how to get
> rid of it but since its using user nova anyways I dont see how that
> would affect anyting. Please help!! Thanks!

Are you absolutely sure that the user and password that is in your 
nova.conf file (the [database] sql_connection string) is the same as 
what you are typing in on the command line?

How are you deploying your OpenStack environment? Using a configuration 
management tool or manually?

Best,
-jay




More information about the Openstack mailing list