Ask Your Question
0

What's the plan of configuring database for savanna

asked 2013-10-22 02:37:50 -0500

xianghui gravatar image

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 flag offensive close merge delete

7 answers

Sort by ยป oldest newest most voted
0

answered 2013-10-23 14:23:57 -0500

dmitrymex gravatar image

@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)

edit flag offensive delete link more
0

answered 2013-10-22 06:28:06 -0500

dmitrymex gravatar image

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.

edit flag offensive delete link more
0

answered 2013-10-22 10:32:57 -0500

mattf gravatar image

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.

edit flag offensive delete link more
0

answered 2013-10-23 14:19:28 -0500

xianghui gravatar image

@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/.

edit flag offensive delete link more
0

answered 2013-10-23 14:26:11 -0500

mattf gravatar image

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).

edit flag offensive delete link more
0

answered 2013-10-23 14:32:42 -0500

xianghui gravatar image

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 ^^.

edit flag offensive delete link more
0

answered 2013-10-23 14:32:53 -0500

xianghui gravatar image

Thanks Dmitry Mescheryakov, that solved my question.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2013-10-22 02:37:50 -0500

Seen: 34 times

Last updated: Oct 23 '13