OpenStack Identity (keystone)

(OperationalError) unable to open database file None None

Bug #860885 reported by Juan L. Negron on 2011-09-27

This bug affects 4 people

Affects		Status	Importance	Assigned to	Milestone
	OpenStack Identity (keystone)	Invalid	Undecided	Unassigned

Bug Description

Installed keystone, python-paste, python-pastedeploy, python-eventlet.
Added configuration file ( http://paste.ubuntu.com/698105/ ) to /etc/keystone/keystone.conf
Started the daemon.
ran: keystone-manage tenant add admin
I get the following error: ERROR: (OperationalError) unable to open database file None None

Any idea what's going on here?

Revision history for this message

Juan L. Negron (negronjl) wrote on 2011-09-27:

keystone configuration file Edit (2.5 KiB, text/plain)

Revision history for this message

Patrick Hetu (patrick-hetu) wrote on 2011-10-03:

Same here, a slash is missing in the sqlite database path. It should be:

sql_connection = sqlite:////var/lib/keystone/keystone.db

For an absolute path. See: http://www.sqlalchemy.org/docs/core/engines.html#database-urls

Revision history for this message

Yogeshwar (yogesh-srikrishnan) wrote on 2011-10-12:

This is what see in keystone conf file present in repo
sql_connection = sqlite:///keystone.db

This is what I see in the doc.

SQLite connects to file based databases. The same URL format is used, omitting the hostname, and using the “file” portion as the filename of the database. This has the effect of four slashes being present for an absolute file path:

# sqlite://<nohostname>/<path>
# where <path> is relative:
sqlite_db = create_engine('sqlite:///foo.db') => Three slashes

So I would assume that we dont need to change anything on keystone.

Yogeshwar (yogesh-srikrishnan) on 2011-10-12