keystone database connection error

Bug #878282 reported by koolhead17 on 2011-10-19
20
This bug affects 2 people
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
Undecided
Dolph Mathews
keystone (Ubuntu)
High
Unassigned
Oneiric
Medium
Unassigned
Precise
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.

koolhead17 (koolhead17) wrote :
Dolph Mathews (dolph) wrote :

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
Launchpad Janitor (janitor) wrote :

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

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
koolhead17 (koolhead17) wrote :

@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
Dave Walker (davewalker) wrote :

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
Dave Walker (davewalker) wrote :

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

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

koolhead17 (koolhead17) wrote :

@Martin

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

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

Dave Walker (davewalker) wrote :

@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
Changed in keystone:
status: New → In Progress
delib (delib) wrote :

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

tags: added: verification-done
removed: verification-needed
Launchpad Janitor (janitor) wrote :

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

Changed in keystone (Ubuntu Oneiric):
status: Fix Committed → Fix Released
Dolph Mathews (dolph) wrote :

This is no longer applicable to the new codebase in keystone master.

Changed in keystone:
status: In Progress → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Bug attachments