Ask Your Question

Openstack nova.conf setting

asked 2011-11-09 08:00:29 -0500

hhgzju gravatar image

In Openstack -starter-guide-diablo.pdf, when setting the file of /etc/nova/nova.conf ,it write as :

For configuring with PostgreSQL change the line with --sql_connection to:

--sql_connection=postgresql://novadbadmin:novasecret@ For configuring with SQLite change the line with --sql_connection to:

--sql_connection=sqlite:////var/lib/nova/nova.sqlite Could you tell me how should I chang the --sql_connection?

edit retag flag offensive close merge delete

3 answers

Sort by ยป oldest newest most voted

answered 2011-11-09 09:38:19 -0500

Which database are you looking to connect to?

For mysql, --sql_connection=mysql://USER:PASSWORD@HOST/nova

for your environment, you can use, --sql_connection=mysql://novadbadmin:novasecret@

Hope that helps!

edit flag offensive delete link more

answered 2011-11-09 09:49:58 -0500

hhgzju gravatar image

Thanks for your help,Is that means I only choose one from MySQL , PostgreSQL and sqlite .if so ,I get a little understande,thanks again!

edit flag offensive delete link more

answered 2011-11-10 06:48:05 -0500

No we are not restricted to MySQL, PostgreSQL or sqlite. OpenStack uses sqlachemy as db layer to allow flexibility to choose between the pluggable DB backends. Hence you can use any database (oracle, MSSQL Server, Informix, Sybase etc.) what ever sqlalchemy supports. You can refer to SqlAlchemy's documentation to know more.


edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2011-11-09 08:00:29 -0500

Seen: 84 times

Last updated: Nov 10 '11