type error with postgresql
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Core Infrastructure |
Fix Released
|
Medium
|
Unassigned | ||
OpenStack Identity (keystone) |
Fix Released
|
Medium
|
Dolph Mathews |
Bug Description
root@os:~# dpkg -l | grep keystone
ii keystone 1.0~d4~
ii python-keystone 1.0~d4~
I have changed the backend to be postgresql instead of sqlite like this:
sql_connection = postgresql:
But I get this error when I try to add a new tenant:
root@os:~# keystone-manage tenant add admin
ERROR: Failed to create tenant admin: (<class 'sqlalchemy.
Don't hesitate to ask me if you need more details.
Changed in keystone: | |
assignee: | Rackspace Integration (rackspace-integration) → Dolph Mathews (dolph) |
Changed in keystone: | |
importance: | Undecided → Medium |
status: | Confirmed → In Progress |
Changed in keystone: | |
status: | Fix Committed → Fix Released |
Changed in keystone: | |
milestone: | essex-3 → 2012.1 |
FYI, I fixed the bug this way:
sudo -u postgres psql keystone
keystone=# ALTER TABLE tenants add COLUMN enabled2 boolean;
ALTER TABLE
keystone=# ALTER TABLE tenants RENAME enabled TO enabled3;
ALTER TABLE
keystone=# ALTER TABLE tenants RENAME enabled2 TO enabled;
ALTER TABLE
keystone=# \q