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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
