OpenStack Core Infrastructure

Select command not allowed on new databases

Bug #1284320 reported by Joshua Harlow
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
OpenStack Core Infrastructure
Fix Released
Medium
Clark Boylan
OpenStack Core Infrastructure icehouse

Bug Description

It appears like the SQL permissions are still not yet all correct for creating and using databases with our own temporary name (per-test database).

From: http://logs.openstack.org/72/72572/6/check/gate-taskflow-python26/fb72681/console.html.gz

"SELECT command denied to user 'openstack_citest'@'localhost' for table 'alembic_version'"

Revision history for this message
Roman Podoliaka (rpodolyaka) wrote :

The same is true for oslo.db: http://logs.openstack.org/63/74963/2/check/gate-oslo-incubator-python26/2295cbc/console.html

Revision history for this message
Clark Boylan (cboylan) wrote :

This was fixed in Ic92ff2f9c752d955e6f82eb4b88330b5448cfa75 change to openstack-infra/config to give the mysql user all privs on single use slaves. We use single use slaves for all unittests now.

Changed in openstack-ci:
status: New → Fix Released
importance: Undecided → Medium
assignee: nobody → Clark Boylan (cboylan)
milestone: none → icehouse
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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