yahoo-eng-team team mailing list archive

[Clark Boylan <clark.boylan@xxxxxxxxx>]

The CI "unittest" nodes now provide both mysql and postgres servers for
testing against. The openstack_citest DB user has access to a schema
called openstack_citest against which DB testing can happen. Nova and
others are using this to test DB migrations.

In addition to unittest nodes providing access to postgres we now have a
postgres tempest job. It can be found at
https://jenkins.openstack.org/job/gate-tempest-devstack-vm-postgres-
full/. Note this test may not pass but the ability to test with postgres
is there.

** Changed in: openstack-ci
       Status: Triaged => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/885426

Title:
  type error with postgresql

Status in OpenStack Identity (Keystone):
  Fix Released
Status in OpenStack Core Infrastructure:
  Fix Released

Bug description:
  root@os:~# dpkg -l | grep keystone
  ii  keystone                        1.0~d4~20110909.1108-0ubuntu3           Proposed OpenStack identity service - Daemons
  ii  python-keystone                 1.0~d4~20110909.1108-0ubuntu3           Proposed OpenStack identity service - Python library

  I have changed the backend to be postgresql instead of sqlite like
  this:

    sql_connection =
  postgresql://keystone:password@localhost:5432/keystone

  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.exc.ProgrammingError'>, ProgrammingError('(ProgrammingError) column "enabled" is of type integer but expression is of type boolean\nLINE 1: ...O tenants (id, "desc", enabled) VALUES (\'admin\', NULL, true)\n                                                                  ^\nHINT:  You will need to rewrite or cast the expression.\n',), <traceback object at 0x2573d88>)

  Don't hesitate to ask me if you need more details.

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/885426/+subscriptions