created users can't see created databases
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:
<hub_cap> vgnbkr: ya maybe both? if no dbs are listed, cross product?
<vgnbkr> hub_cap: sounds good
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 |
Fix proposed to branch: master /review. openstack. org/68983
Review: https:/