openstack team mailing list archive

[Ahmed Al-Mehdi <ahmed@xxxxxxxxxx>]

Sorry, that did not work. :(


ŠŠ..
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
root@novato:~/ahmed/images# mysql -h "localhost" -u "keystoneUser"
-p"keystonePass" "keystone" -ss -e "SELECT id FROM service WHERE
type='"compute"';"
ERROR 1045 (28000): Access denied for user 'keystoneUser'@'localhost'
(using password: YES)
root@novato:~/ahmed/images#
root@novato:~/ahmed/images#
root@novato:~/ahmed/images#
root@novato:~/ahmed/images# mysql -h "localhost" -u "root" -p"mysqlpass"
"keystone" -ss -e "SELECT id FROM service WHERE type='"compute"';"
f5919383a5da4d6a9513e1318eccbf0a

Regards,

Ahmed.



On 11/26/12 10:33 AM, "Mathieu Fortin" <mathieu.fortin@xxxxxxxxxxxx> wrote:

>mysql> flush privileges;
>
>On lun, 2012-11-26 at 11:15 -0600, Ahmed Al-Mehdi wrote:
>> Hello,
>> 
>> 
>> I have a mysql specific question related to my OpenStack
>> installation.  I apologize in advance if this is not the right forum
>> for such a question.
>> 
>> 
>> As user root, I created the keystone db as follows:
>> 
>> 
>> root@novato:~/ahmed# mysql -u root -pmysqlpass
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> .......
>> mysql> CREATE DATABASE keystone;
>> Query OK, 1 row affected (0.00 sec)
>> 
>> 
>> mysql> GRANT ALL ON keystone.* TO 'keystoneUser'@'%' IDENTIFIED BY
>> 'keystonePass';
>> Query OK, 0 rows affected (0.00 sec)
>> 
>> 
>> mysql> quit;
>> Bye
>> root@novato:~# keystone service-list
>> 
>>+----------------------------------+----------+----------+---------------
>>---------------+
>> |                id                |   name   |   type   |
>> description          |
>> 
>>+----------------------------------+----------+----------+---------------
>>---------------+
>> | 1d97a1ca72f84489911b0e1f7665038b |  glance  |  image   |   OpenStack
>> Image Service    |
>> | 3a52155dab1048ce942476bfb1b2be20 |  cinder  |  volume  |   OpenStack
>> Volume Service   |
>> | 4980e68e98174e6aae7149b98c7ae3f0 |   ec2    |   ec2    |
>>  OpenStack EC2 service     |
>> | 5aff04cebb1d4ba9a92bdf651b2123ef | quantum  | network  | OpenStack
>> Networking service |
>> | a1cfb6677b0a4188bf054663f89bfe70 | keystone | identity |
>>  OpenStack Identity      |
>> | f5919383a5da4d6a9513e1318eccbf0a |   nova   | compute  |  OpenStack
>> Compute Service   |
>> 
>>+----------------------------------+----------+----------+---------------
>>---------------+
>> root@novato:~# 
>> 
>> 
>> However, when I access the keystone db  as
>> "keystoneUser/keystonePass",  I get an "Error: Access denied",
>> however, however when I use "root/mysqlpass", the command succeeds.
>> 
>> 
>> root@novato:~# mysql -h "localhost" -u "keystoneUser" -p"keystonePass"
>> "keystone" -ss -e "SELECT id FROM service WHERE type='"compute"';"
>> ERROR 1045 (28000): Access denied for user
>> 'keystoneUser'@'localhost' (using password: YES)
>> root@novato:~# mysql -h "localhost" -u "root" -p"mysqlpass"
>>  "keystone" -ss -e "SELECT id FROM service WHERE type='"compute"';"
>> f5919383a5da4d6a9513e1318eccbf0a
>> 
>> 
>> Why I cannot access keystone db as  "keystoneUser/keystonePass", even
>> though I gave that user access to the keystone db.
>> 
>> 
>> Thank you,
>> Ahmed.
>> 
>> 
>> _______________________________________________
>> Mailing list: https://launchpad.net/~openstack
>> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~openstack
>> More help   : https://help.launchpad.net/ListHelp
>
>
>
>_______________________________________________
>Mailing list: https://launchpad.net/~openstack
>Post to     : openstack@xxxxxxxxxxxxxxxxxxx
>Unsubscribe : https://launchpad.net/~openstack
>More help   : https://help.launchpad.net/ListHelp