[Openstack] Nova DB sync Operational error

Geo Varghese gvarghese at aqorn.com
Wed Nov 26 20:02:56 UTC 2014


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


More information about the Openstack mailing list