[Openstack] Nova DB sync Operational error

Geo Varghese gvarghese at aqorn.com
Wed Nov 26 20:29:53 UTC 2014


Also verify from controller node

mysql -u nova -p -h controller nova

is working with password => nova

On Thu, Nov 27, 2014 at 1:42 AM, Amit Anand <aanand at viimed.com> wrote:

> I tried and still same errors. I dont see how that would fix in any case
> as the guide says I need to put the password into the connection config?
>
> Tried below and same error:
>
> # The SQLAlchemy connection string used to connect to the
> # bare-metal database (string value)
> connection=mysql://nova:nova@controller/nova
>
>
> On Wed, Nov 26, 2014 at 3:02 PM, Geo Varghese <gvarghese at aqorn.com> wrote:
>
>> Try this
>>
>> connection=mysql://nova:nova@controller/nova
>>
>> This will fix the issue.
>>
>> On Thu, Nov 27, 2014 at 1:06 AM, Amit Anand <aanand at viimed.com> wrote:
>>
>>> Same error - also tried with 127.0.0.1. Even crazier I removed all
>>> keystone nova (user, service, etc) and dropped the nova DB and recreated
>>> that, then recreated keystone nova with a new different password, updated
>>> nova.conf with new password and still get the same error (notice below now
>>> nova has the different password):
>>>
>>> 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     | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | localhost |
>>> | nova     | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | %         |
>>> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
>>> +----------+-------------------------------------------+-----------+
>>> 10 rows in set (0.00 sec)
>>>
>>>
>>> On Wed, Nov 26, 2014 at 2:26 PM, Jay Pipes <jaypipes at gmail.com> wrote:
>>>
>>>> On 11/26/2014 02:21 PM, Amit Anand wrote:
>>>>
>>>>> 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.
>>>>>
>>>>
>>>> try:
>>>>
>>>> connection=mysql://nova:PASSWORD@localhost/nova
>>>>
>>>> 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
>>
>
>


-- 
--
Regards,
Geo Varghese
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20141127/835f7d7a/attachment.html>


More information about the Openstack mailing list