Can't configure nova to use MySQL as backend

Bug #1076825 reported by Eduardo Patrocinio
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
nova (Ubuntu)
Expired
Undecided
Unassigned

Bug Description

Linux version: Ubuntu 12.10 server

root@openstack:/var/lib/nova# nova-manage version
2012.2 (2012.2-LOCALBRANCH:LOCALREVISION)

Even thou I have configured nova.conf to use MySQL:

root@openstack:/etc/nova# grep sql_connection nova.conf
sql_connection=mysql://root:password@localhost/nova

It still uses sqlite as the backend. I added these 2 lines to nova/db/sqlalchemy/session.py

def get_engine():
    """Return a SQLAlchemy engine."""
    global _ENGINE
    LOG.warn('-- Eduardo -- _ENGINE: %s', _ENGINE)
    LOG.warn('-- Eduardo -- sql_connection: %s', FLAGS.sql_connection)
    if _ENGINE is None:
        connection_dict = sqlalchemy.engine.url.make_url(FLAGS.sql_connection)

and obtain the following
2012-11-08 02:59:31 WARNING nova.db.sqlalchemy.session [-] -- Eduardo -- _ENGINE: Engine(sqlite:////var/lib/nova/nova.sqlite)
2012-11-08 02:59:31 WARNING nova.db.sqlalchemy.session [-] -- Eduardo -- sql_connection: sqlite:////var/lib/nova/nova.sqlite

confirming nova is using sqlite as the database.

Tags: mysql nova
Revision history for this message
Chuck Short (zulcss) wrote :

The packaging uses sqlite by default, did you change your /etc/nova/nova.conf and then re-run nova-manage db sync?

Changed in nova (Ubuntu):
status: New → Incomplete
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for nova (Ubuntu) because there has been no activity for 60 days.]

Changed in nova (Ubuntu):
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.