keystone does not support postgres database

Bug #999999 reported by koolhead17
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
Invalid
Low
Unassigned

Bug Description

I am using ubuntu 12.04 and tried to use postgres as my databases back end but keystone-manage db_sync fails with error below

keystone-manage db_sync
Traceback (most recent call last):
  File "/usr/bin/keystone-manage", line 28, in <module>
    cli.main(argv=sys.argv, config_files=config_files)
  File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 148, in main
    return run(cmd, (args[:1] + args[2:]))
  File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 134, in run
    return CMDS[cmd](argv=args).run()
  File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 36, in run
    return self.main()
  File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 57, in main
    driver.db_sync()
  File "/usr/lib/python2.7/dist-packages/keystone/identity/backends/sql.py", line 135, in db_sync
    migration.db_sync()
  File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration.py", line 50, in db_sync
    current_version = db_version()
  File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration.py", line 64, in db_version
    CONF.sql.connection, repo_path)
  File "<string>", line 2, in db_version
  File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 155, in with_engine
    engine = construct_engine(url, **kw)
  File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 116, in construct_engine
    raise ValueError("you need to pass either an existing engine or a database uri")
ValueError: you need to pass either an existing engine or a database uri

this is how my keystone.conf looks like http://paste.ubuntu.com/989906/

Joseph Heck (heckj)
Changed in keystone:
status: New → Triaged
importance: Undecided → Low
Alan Pevec (apevec)
tags: added: essex-backport-potential
removed: essex keystone
Revision history for this message
Alan Pevec (apevec) wrote :

> this is how my keystone.conf looks like http://paste.ubuntu.com/989906/

sql_connection = postgresql://keystone:keystone@192.168.1.3/keystone

This should be connection = ...
https://github.com/openstack/keystone/blob/master/etc/keystone.conf.sample#L53

tags: removed: essex-backport-potential
Alan Pevec (apevec)
Changed in keystone:
status: Triaged → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.