OpenStack Compute (nova)

Openstack nova.conf setting

Asked by chzu

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?

Question information

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

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!

Revision history for this message
chzu (hhgzju) said : 		#2

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!

Revision history for this message
Sateesh (sateesh-chodapuneedi) said : 		#3

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