Ask Your Question
0

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@10.10.10.2/nova 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
0

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@10.10.10.2/nova

Hope that helps!

edit flag offensive delete link more
0

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
0

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.

-Sateesh

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

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

Seen: 84 times

Last updated: Nov 10 '11