# What's the plan of configuring database for savanna

Hi team,

I noticed that there is one configuration item involved with database in savanna.conf, it used to be : # URL for sqlalchemy database (string value) connection=sqlite:////var/lib/savanna/savanna-server.db connection=sqlite:////tmp/savanna-server.db

but in the latest build "openstack-savanna-0.3-2.el6.noarch" seems savanna works by setting as below: #connection=sqlite:////savanna/openstack/common/db/$sqlite_db Are there any history concerns on the savanna db? Thanks for any help. edit retag close merge delete ## 7 answers Sort by » oldest newest most voted @Xiang, when you comment a parameter, a default value is applied. For connection it is sqlite:////savanna/openstack/common/db/$sqlite_db (the one you can see in the sample config file)

more

The change you see is non intentional. Both current configuration and the old one will work fine. It is just a location for storing sqlite database.

more

The correct configuration is: connection=sqlite:////var/lib/savanna/savanna-server.db

openstack-savanna-0.3-2.el6.noarch should have the correct location. Check for a /etc/savanna/savanna.conf.rpmsave or .rpmnew file.

more

@Matthew, Hmm.. it works even when I comment the line connection=sqlite:////var/lib/savanna/savanna-server.db, and found that the savanna.sqlite exists under directory savanna-venv/lib/python2.6/site-packages/savanna/openstack/common/db/.

more

It will still run w/o the connection line, but your savanna-server.db may be written to /tmp, which may be wiped on system reboot.

Since you are using the RDO Havana RPMs, the correct location is /var/lib/savanna/savanna-server.db (happens to be ~savanna/savanna-server.db).

more

Thanks Mattew, but like Dmitry said, the default value is "sqlite:////savanna/openstack/common/db/\$sqlite_db" from code, thank you for your nice help ^^.

more

Thanks Dmitry Mescheryakov, that solved my question.

more

# Get to know Ask OpenStack

Resources for moderators