[Openstack] Nova DB sync Operational error

Amit Anand aanand at viimed.com
Wed Nov 26 19:42:30 UTC 2014


HI Geo - Pasted above in the email chain but here it is again:

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


On Wed, Nov 26, 2014 at 2:17 PM, Geo Varghese <gvarghese at aqorn.com> wrote:

> Hi Amit,
>
> Please open => /etc/nova/nova.conf
>
> Find a line with starting with "connection = "
>
> Please paste it here. That will help us to fix the issue.
>
> On Wed, Nov 26, 2014 at 11:55 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
>>
>
>
>
> --
> --
> Regards,
> Geo Varghese
>
> _______________________________________________
> 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/6854aefe/attachment.html>


More information about the Openstack mailing list