Ask Your Question

Re-creating services and networks tables on nova db

asked 2011-02-17 00:16:18 -0600

arturo-lorenzo gravatar image

For some weird reason the tables for the nova db on mysql server were lost. how can I recreate them or repopulate them? I have restarted the cloud compute and done a nova-manage db sync unsuccessfully. See below: mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | nova | +--------------------+ 3 rows in set (0.00 sec)

mysql> use nova Database changed mysql> show tables;

Empty set (0.00 sec)

This is the error I am getting: Operational Error 2003 "Can't connect to MySQL server on '' (111)") None None"

mysql> quit

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2011-02-17 03:13:44 -0600

arturo-lorenzo gravatar image

Sorry, problem was found. Password was changed so when the nova services started access was denied. Fixed the root password for mysql, ran nova-manage db sync and voila my tables services and network are back.

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2011-02-17 00:16:18 -0600

Seen: 97 times

Last updated: Feb 17 '11