[Bug 1076825] [NEW] Can't configure nova to use MySQL as backend

[Eduardo Patrocinio]

Public bug reported:

Linux version:   Ubuntu 12.10 server

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

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

root at 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.

** Affects: nova (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: mysql nova

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to nova in Ubuntu.
https://bugs.launchpad.net/bugs/1076825

Title:
  Can't configure nova to use MySQL as backend

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/nova/+bug/1076825/+subscriptions