OpenStack Compute (nova)

Re-creating services and networks tables on nova db

Asked by arturo lorenzo

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
=========================

Question information

Language:
English Edit question
Status:
Solved
For:
OpenStack Compute (nova) Edit question
Assignee:
No assignee Edit question
Solved by:
arturo lorenzo
Solved:
Last query:
Last reply:
Revision history for this message
arturo lorenzo (arturo-lorenzo) said : 		#1

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.