[Openstack] Nova DB sync Operational error

Amit Anand aanand at viimed.com
Tue Nov 25 22:10:59 UTC 2014


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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20141125/ea11abed/attachment.html>


More information about the Openstack mailing list