Ask Your Question
0

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 '13.141.230.64' (111)") None None"

mysql> quit

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

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

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

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

Seen: 68 times

Last updated: Feb 17 '11