Ask Your Question
0

"nova-manage db sync" is not creating tables

asked 2012-11-06 19:57:18 -0600

gurrapu-narsing gravatar image

Hi,

I have successfully installed keystone and glance (Folsom) I have installed nova, and when executing the command "nova-manage db sync" it is displaying the following output

root@Controller:~# nova-manage db sync 2012-11-06 11:28:00 DEBUG nova.utils [-] backend <module 'nova.db.sqlalchemy.migration'="" from="" '="" usr="" lib="" python2.7="" dist-packages="" nova="" db="" sqlalchemy="" migration.pyc'=""> from (pid=8934) __get_backend /usr/lib/python2.7/dist-packages/nova/utils.py:658

==> /var/log/nova/nova-manage.log <== 2012-11-06 11:28:00 DEBUG nova.utils [-] backend <module 'nova.db.sqlalchemy.migration'="" from="" '="" usr="" lib="" python2.7="" dist-packages="" nova="" db="" sqlalchemy="" migration.pyc'=""> from (pid=8934) __get_backend /usr/lib/python2.7/dist-packages/nova/utils.py:658 root@Controller:~#

When checked the mysql database tables for nova, they havent created? Before executing "nova-manage db sync" I have made sure that I have created the database nova in mysql database

Can you please let me know if i have missed anthing?

Thanks, Narsing

edit retag flag offensive close merge delete

6 answers

Sort by ยป oldest newest most voted
0

answered 2012-11-06 20:02:51 -0600

gurrapu-narsing gravatar image

Following is the database information which I have mentioned in the nova.conf file (/etc/nova/nova.conf)

DATABASE

sql_connection=mysql://nova:nova@192.168.206.130/nova

Thanks, Narsing

edit flag offensive delete link more
0

answered 2012-11-14 23:53:54 -0600

chrislgrigg gravatar image

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

edit flag offensive delete link more
0

answered 2012-11-09 16:02:25 -0600

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

edit flag offensive delete link more
0

answered 2012-11-12 20:10:30 -0600

gurrapu-narsing gravatar image

Thanks Dimitri for the providing some pointers on my queries

I did the following

  1. Dropped and re-created the nova database in mysql servers
  2. Deleted /var/lib/nova/nova.sqlite file

and then executed 'nova-manage db sync' cmd, but resulted in same issues :(

edit flag offensive delete link more
0

answered 2012-11-14 14:13:00 -0600

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

edit flag offensive delete link more
0

answered 2012-12-20 00:28:45 -0600

lmatter gravatar image

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

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2012-11-06 19:57:18 -0600

Seen: 1,039 times

Last updated: Dec 20 '12