[Openstack] Nova DB sync Operational error

Amit Anand aanand at viimed.com
Wed Nov 26 19:21:18 UTC 2014


Hi Jay - I believe so below is the part that is in the nova.conf

# The SQLAlchemy connection string used to connect to the
# bare-metal database (string value)
connection=mysql://nova:PASSWORD@controller/nova

The PASSWORD is exactly the same what I have in the conf file and what I
have in the nova.conf

Im doing this manually via the Juno instruction guide for CentOs 7.




On Wed, Nov 26, 2014 at 1:25 PM, Jay Pipes <jaypipes at gmail.com> wrote:

> 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
>
> _______________________________________________
> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/
> openstack
> Post to     : openstack at lists.openstack.org
> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/
> openstack
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20141126/75b0d598/attachment.html>


More information about the Openstack mailing list