created users can't see created databases

Bug #1272421 reported by Morgan Jones
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
python-troveclient
Fix Released
Undecided
Sushil Kumar

Bug Description

When creating a trove instance via:

    trove create t1 7 --size=2 --users mwj:pwd --databases foo --datastore_version mysql-5.5

I expect to be able to:

    mysql -h10.0.0.2 -umwj -ppwd foo

But the user created by the --users option has not been granted access to the databases created by the --databases option.

From #openstack-trove:

<vgnbkr> So I expected that if I did "trove create ... --users mwj:pwd --databases foo", I should be able to "mysql -h10.0.0.2 -umwj -ppwd foo", but that doesn't work.
<vgnbkr> It works if I leave the db off, but I can't see the database. I see it as root. Am I misunderstanding, or is it a bug?
<hub_cap> bug
<hub_cap> the create call doesnt associate the dbs properly
<hub_cap> but thats a cli bug
<vgnbkr> Great, thanks. I'll see if I can find a bug already in, otherwise add it.
<hub_cap> we could do a cross product type thing tho on teh cli and say 'every user has access to every db u pass in, if u pass them both in'
<vgnbkr> Or could change syntax to "user:pwd:db1,db2,db3", though it is a bit cryptic.
<hub_cap> vgnbkr: ya maybe both? if no dbs are listed, cross product?
<vgnbkr> hub_cap: sounds good

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to python-troveclient (master)

Fix proposed to branch: master
Review: https://review.openstack.org/68983

Changed in python-troveclient:
assignee: nobody → Sushil Kumar (sushil-kumar2)
status: New → In Progress
Revision history for this message
Sushil Kumar (sushil-kumar2) wrote :

This is not a bug for trove, it was fixed with the changes in trove-client only.

Someone needs to update the relevant status(if it is gonna ne "Won't Fix").

Changed in trove:
status: New → Confirmed
status: Confirmed → Invalid
no longer affects: trove
Changed in python-troveclient:
status: In Progress → Fix Released
milestone: none → python-troveclient-v1
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.