[Openstack] Nova DB sync Operational error

Amit Anand aanand at viimed.com
Wed Nov 26 19:36:46 UTC 2014


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


More information about the Openstack mailing list