Dimitri, you are the man. Same problem here. How'd you figure that out?

I have the same issue.

As far I investigated on, I noticed 'that nova-manage db sync' creates the database within the default sqlite file (/var/lib/nova/nova.sqlite) even if the flag sql_connection points to a mysql server.

Dimitri

You welcome.

I figured out my issue was related to a mistake in the configuration file nova.conf.

The configuration file I used was copied from the documentation appendix. Around line 13, the line "[keystone_authtoken]" seems to cause all the other flags to be unavailable to nova. I commented it and was then able to synchronize the correct database (MySQL). I do not know if that line "[keystone_authtoken]", which is a section header in INI syntax, is required by nova to authenticate itself to keystone, but at least so far, that fixed my issue with the database.

Maybe should the documentation example fixed about that?

Hope this helps, Dimitri

I was following this guide: https://help.ubuntu.com/12.10/serverguide/ubuntucloud.html (https://help.ubuntu.com/12.10/serverg...) and had this same problem (debug message from db sync and no tables in the nova database in mysql).

If you notice this guide tells you to append to nova.conf a bunch of lines starting with "--". Long story short, if you remove the "--" for each line in the file then the db sync will work (I restarted all the nova services just to be safe, not sure if that is strictly required).

For example, you should see:

Nova config FlatDHCPManager

sql_connection=mysql://novauser:novapassword@localhost/nova