OpenStack Identity (keystone)

keystone database connection error

Bug #878282 reported by koolhead17 on 2011-10-19

This bug affects 2 people

	Status	Importance	Assigned to
OpenStack Identity (keystone)	Invalid	Undecided	Dolph Mathews
keystone (Ubuntu)	Fix Released	High	Unassigned
Oneiric	Fix Released	Medium	Unassigned
Precise	Fix Released	High	Unassigned

Bug Description

Keystone is not able to connect to the sqlite database.

$keystone-manage token add 999888777666 admin admin 2015-02-05T00:00
ERROR: (OperationalError) unable to open database file None None
Traceback (most recent call last):
  File "/usr/local/bin/keystone-manage", line 7, in <module>
    execfile(__file__)
  File "/opt/stack/keystone/bin/keystone-manage", line 16, in <module>
    keystone.manage.main()
  File "/opt/stack/keystone/keystone/manage/__init__.py", line 249, in main
    raise exc
sqlalchemy.exc.OperationalError: (OperationalError) unable to open database file None None

The solution is the current keystone.conf file mentions about relative path of database it should provide absolute path instead.

After adding the patch i was able to create the auth token.

Tags:

Related branches

lp:ubuntu/precise/keystone

lp:~ubuntu-server-dev/keystone/essex

lp:ubuntu/oneiric-proposed/keystone

lp:~openstack-ubuntu-packagers/keystone/ubuntu

lp:~openstack-ubuntu-testing/+junk/ksl

lp:~ubuntu-server-dev/keystone/diablo

Revision history for this message

koolhead17 (koolhead17) wrote on 2011-10-19:

db.patch Edit (588 bytes, text/x-diff)

Revision history for this message

Dolph Mathews (dolph) wrote on 2011-10-19:

Related to bug 874284 (similar cause, different symptoms).

Changed in keystone:
assignee:	nobody → Dolph Mathews (dolph)

Dave Walker (davewalker) on 2011-10-21

Changed in keystone (Ubuntu Oneiric):
status:	New → Confirmed
Changed in keystone (Ubuntu Precise):
status:	New → Confirmed
importance:	Undecided → High
Changed in keystone (Ubuntu Oneiric):
importance:	Undecided → Medium

Revision history for this message

Launchpad Janitor (janitor) wrote on 2011-10-21:

This bug was fixed in the package keystone - 1.0~d4~20110909.1108-0ubuntu4

---------------
keystone (1.0~d4~20110909.1108-0ubuntu4) precise; urgency=low

* debian/patches/sql_connection.patch: Correct keystone.db path, as
identified by Atul Jha. (LP: #878282)
-- Dave Walker (Daviey) <email address hidden> Fri, 21 Oct 2011 13:17:51 +0100

Changed in keystone (Ubuntu Precise):
status:	Confirmed → Fix Released

Revision history for this message

Martin Pitt (pitti) wrote on 2011-10-25: Please test proposed package

Hello koolhead17, or anyone else affected,

Accepted keystone into oneiric-proposed, the package will build now and be available in a few hours. Please test and give feedback here. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Thank you in advance!

Changed in keystone (Ubuntu Oneiric):
status:	Confirmed → Fix Committed
tags:	added: verification-needed

Revision history for this message

koolhead17 (koolhead17) wrote on 2011-10-27:

@Martin

$ dpkg -l keystone

ii keystone 1.0~d4~20110909.1108-0 Proposed OpenStack identity service - Daemons

I installed it just now and i see same issue, also when i opened the keystone.conf i don`t see it modified as per patch i submitted and i see same connection error.

$ sudo keystone-manage token add 999888777666 admin admin 2015-02-05T00:00
ERROR: (OperationalError) unable to open database file None None

I am going to reopen this bug with "in progress status"

Changed in keystone (Ubuntu Oneiric):
status:	Fix Committed → In Progress
Changed in keystone (Ubuntu Precise):
status:	Fix Released → In Progress

Revision history for this message

Dave Walker (davewalker) wrote on 2011-10-27:

Discussed issue with koolhead17, and verified that the proposed package was not being tested. Reverting states.

Changed in keystone (Ubuntu Precise):
status:	In Progress → Fix Released
Changed in keystone (Ubuntu Oneiric):
status:	In Progress → Fix Committed

koolhead17 (koolhead17) on 2011-10-27

Changed in keystone (Ubuntu Precise):
status:	Fix Released → Fix Committed

Dave Walker (davewalker) on 2011-10-27

Changed in keystone (Ubuntu Precise):
status:	Fix Committed → Fix Released

koolhead17 (koolhead17) on 2011-10-27

Changed in keystone (Ubuntu Oneiric):
status:	Fix Committed → In Progress
Changed in keystone (Ubuntu Precise):
status:	Fix Released → In Progress

Revision history for this message

Dave Walker (davewalker) wrote on 2011-10-27:

Reverting Fix Released for Precise task, as it is in the archive.

@koolhead17, You shouldn't need to change the status. :)

Revision history for this message

koolhead17 (koolhead17) wrote on 2011-10-27:

@Martin

My bad i did not check it in oneiric-proposed earlier.

I downloaded keystone again from oneiric-proposed and looks fine.
:D

Revision history for this message

Dave Walker (davewalker) wrote on 2011-10-27:

@koolhead17, please stop changing the status...

Thanks.

Changed in keystone (Ubuntu Precise):
status:	In Progress → Fix Released
Changed in keystone (Ubuntu Oneiric):
status:	In Progress → Fix Committed

Ziad Sawalha (ziad-sawalha) on 2011-11-24

Changed in keystone:
status:	New → In Progress

Revision history for this message

delib (delib) wrote on 2011-12-04:

#10

Reproduced the bug and the command runs successfully with proposed version.

tags:

added: verification-done
removed: verification-needed

Revision history for this message

Launchpad Janitor (janitor) wrote on 2011-12-05:

#11

This bug was fixed in the package keystone - 1.0~d4~20110909.1108-0ubuntu3.1

---------------
keystone (1.0~d4~20110909.1108-0ubuntu3.1) oneiric-proposed; urgency=low

* debian/patches/sql_connection.patch: Correct keystone.db path, as
identified by Atul Jha. (LP: #878282)
-- Dave Walker (Daviey) <email address hidden> Fri, 21 Oct 2011 13:17:51 +0100