[Openstack] Nova DB sync Operational error
George Mihaiescu
lmihaiescu at gmail.com
Wed Nov 26 20:34:01 UTC 2014
Make sure that nova.conf you edited it's actually being used, if you have a
nova.conf in your root directory it will be used before the one in
"/etc/nova/".
You could start the db sync with strace and see what config file is
actually used just to make sure. Also, if the nova.conf has wrong
permissions then the error message might point to bad credentials but in
fact it couldn't even read them.
On Wed, Nov 26, 2014 at 3:12 PM, 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
>>
>
>
> _______________________________________________
> 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/81453009/attachment.html>
More information about the Openstack
mailing list