Open Stack

Password is viimed1



On Wed, Nov 26, 2014 at 3:55 PM, Amit Anand <aanand at viimed.com> wrote:

> George
>
> Thanks. Yeah there no other nova.conf I went as far as to do a find in
> case I put somewhere nothing turned up except the proper one. I did have a
> nova.conf.orig (I always make a backup so i can always start over) and was
> hoping maybe you hit the nail on the head so I moved that out to my
>  /home/amit dir but alas that failed as well  :-(
>
> Permissions I made rwrwrw still same.
>
>
>
>
>
> On Wed, Nov 26, 2014 at 3:42 PM, Amit Anand <aanand at viimed.com> wrote:
>
>> Geo
>>
>> Error logs are here:
>>
>> http://paste.openstack.org/show/139035/
>>
>> When I run your command with password nova it fails - when I run it with
>> the real password it works fine
>>
>> [root at controller ~]# mysql -u nova -p -h controller nova
>> Enter password:
>> I entered nova here
>> ERROR 1045 (28000): Access denied for user 'nova'@'controller' (using
>> password: YES)
>>
>>
>> [root at controller ~]# mysql -u nova -p -h controller nova
>> Enter password:
>> I entered real password here
>> Welcome to the MariaDB monitor.  Commands end with ; or \g.
>> Your MariaDB connection id is 13
>> Server version: 5.5.40-MariaDB MariaDB Server
>>
>> Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> MariaDB [nova]> quit
>> Bye
>>
>>
>>
>>
>>
>> On Wed, Nov 26, 2014 at 3:36 PM, Amit Anand <aanand at viimed.com> wrote:
>>
>>> Jay,
>>>
>>> So this is the command that u sent, works just fine connect to Nova DB:
>>>
>>> [root at controller nova]# mysql -unova -hlocalhost -p -Dnova
>>> Enter password:
>>> Welcome to the MariaDB monitor.  Commands end with ; or \g.
>>> Your MariaDB connection id is 8
>>> Server version: 5.5.40-MariaDB MariaDB Server
>>>
>>> Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
>>>
>>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>>> statement.
>>>
>>> MariaDB [nova]>
>>>
>>>
>>> I also changed in nvoa.conf connection=mysql://nova:__PASSWORD@localhost/nova
>>> (I tried with both a space and a _ as I was not sure exactly what you meant
>>> - still same error) :-(
>>>
>>> I also took a look at a command you ran and I tried it, would this be
>>> correct output (notice I didnt specify a DB in command)?
>>>
>>> MariaDB [mysql]> SELECT * FROM db WHERE User = 'root'\G
>>> *************************** 1. row ***************************
>>>                  Host: %
>>>                    Db: nova
>>>                  User: root
>>>           Select_priv: Y
>>>           Insert_priv: Y
>>>           Update_priv: Y
>>>           Delete_priv: Y
>>>           Create_priv: Y
>>>             Drop_priv: Y
>>>            Grant_priv: Y
>>>       References_priv: Y
>>>            Index_priv: Y
>>>            Alter_priv: Y
>>> Create_tmp_table_priv: Y
>>>      Lock_tables_priv: Y
>>>      Create_view_priv: Y
>>>        Show_view_priv: Y
>>>   Create_routine_priv: Y
>>>    Alter_routine_priv: Y
>>>          Execute_priv: Y
>>>            Event_priv: Y
>>>          Trigger_priv: Y
>>> 1 row in set (0.01 sec)
>>>
>>> Also this is the output for user Nova:
>>>
>>> MariaDB [mysql]> SELECT * FROM db WHERE User = 'nova'\G;
>>> *************************** 1. row ***************************
>>>                  Host: localhost
>>>                    Db: nova
>>>                  User: nova
>>>           Select_priv: Y
>>>           Insert_priv: Y
>>>           Update_priv: Y
>>>           Delete_priv: Y
>>>           Create_priv: Y
>>>             Drop_priv: Y
>>>            Grant_priv: N
>>>       References_priv: Y
>>>            Index_priv: Y
>>>            Alter_priv: Y
>>> Create_tmp_table_priv: Y
>>>      Lock_tables_priv: Y
>>>      Create_view_priv: Y
>>>        Show_view_priv: Y
>>>   Create_routine_priv: Y
>>>    Alter_routine_priv: Y
>>>          Execute_priv: Y
>>>            Event_priv: Y
>>>          Trigger_priv: Y
>>> *************************** 2. row ***************************
>>>                  Host: %
>>>                    Db: nova
>>>                  User: nova
>>>           Select_priv: Y
>>>           Insert_priv: Y
>>>           Update_priv: Y
>>>           Delete_priv: Y
>>>           Create_priv: Y
>>>             Drop_priv: Y
>>>            Grant_priv: N
>>>       References_priv: Y
>>>            Index_priv: Y
>>>            Alter_priv: Y
>>> Create_tmp_table_priv: Y
>>>      Lock_tables_priv: Y
>>>      Create_view_priv: Y
>>>        Show_view_priv: Y
>>>   Create_routine_priv: Y
>>>    Alter_routine_priv: Y
>>>          Execute_priv: Y
>>>            Event_priv: Y
>>>          Trigger_priv: Y
>>> 2 rows in set (0.00 sec)
>>>
>>>
>>> On Wed, Nov 26, 2014 at 3:12 PM, Jay Pipes <jaypipes at gmail.com> wrote:
>>>
>>>> On 11/26/2014 02:36 PM, Amit Anand wrote:
>>>>
>>>>> Same error - also tried with 127.0.0.1. Even crazier I removed all
>>>>> keystone nova (user, service, etc) and dropped the nova DB and
>>>>> recreated
>>>>> that, then recreated keystone nova with a new different password,
>>>>> updated nova.conf with new password and still get the same error
>>>>> (notice
>>>>> below now nova has the different password):
>>>>>
>>>>
>>>> Permissions for a user are not affected by the removal of a database.
>>>> You can even add permissions for a user to operate on a database that
>>>> doesn't exist:
>>>>
>>>> mysql> SHOW DATABASES;
>>>> +--------------------+
>>>> | Database           |
>>>> +--------------------+
>>>> | information_schema |
>>>> | mysql              |
>>>> | performance_schema |
>>>> | test               |
>>>> +--------------------+
>>>> 4 rows in set (0.03 sec)
>>>>
>>>> mysql> GRANT ALL ON foo.* TO root at localhost;
>>>> Query OK, 0 rows affected (0.00 sec)
>>>>
>>>> mysql> GRANT ALL ON test.* TO root at localhost;
>>>> Query OK, 0 rows affected (0.00 sec)
>>>>
>>>> mysql> USE mysql
>>>> Database changed
>>>> mysql> SELECT * FROM db WHERE User = 'root' AND Db = 'foo'\G
>>>> *************************** 1. row ***************************
>>>>                  Host: localhost
>>>>                    Db: foo
>>>>                  User: root
>>>>           Select_priv: Y
>>>>           Insert_priv: Y
>>>>           Update_priv: Y
>>>>           Delete_priv: Y
>>>>           Create_priv: Y
>>>>             Drop_priv: Y
>>>>            Grant_priv: N
>>>>       References_priv: Y
>>>>            Index_priv: Y
>>>>            Alter_priv: Y
>>>> Create_tmp_table_priv: Y
>>>>      Lock_tables_priv: Y
>>>>      Create_view_priv: Y
>>>>        Show_view_priv: Y
>>>>   Create_routine_priv: Y
>>>>    Alter_routine_priv: Y
>>>>          Execute_priv: Y
>>>>            Event_priv: Y
>>>>          Trigger_priv: Y
>>>> 1 row in set (0.00 sec)
>>>>
>>>> Go figure :)
>>>>
>>>> If you manually specify the host on the command line, do you still get
>>>> in to the MySQL server?
>>>>
>>>> i.e., if you do this on the command line, does it work?
>>>>
>>>> mysql -unova -hlocalhost -p -Dnova
>>>>
>>>> Best,
>>>> -jay
>>>>
>>>>  MariaDB [mysql]> SELECT user,password,host FROM user;
>>>>> +----------+-------------------------------------------+-----------+
>>>>> | user     | password                                  | host      |
>>>>> +----------+-------------------------------------------+-----------+
>>>>> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
>>>>> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
>>>>> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1       |
>>>>> | keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
>>>>> | keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
>>>>> | glance   | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
>>>>> | glance   | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
>>>>> | nova     | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | localhost |
>>>>> | nova     | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | %         |
>>>>> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
>>>>> +----------+-------------------------------------------+-----------+
>>>>> 10 rows in set (0.00 sec)
>>>>>
>>>>>
>>>>> On Wed, Nov 26, 2014 at 2:26 PM, Jay Pipes <jaypipes at gmail.com
>>>>> <mailto:jaypipes at gmail.com>> wrote:
>>>>>
>>>>>     On 11/26/2014 02:21 PM, Amit Anand wrote:
>>>>>
>>>>>         Hi Jay - I believe so below is the part that is in the
>>>>> nova.conf
>>>>>
>>>>>         # The SQLAlchemy connection string used to connect to the
>>>>>         # bare-metal database (string value)
>>>>>         connection=mysql://nova:__PASSWORD@controller/nova
>>>>>
>>>>>         The PASSWORD is exactly the same what I have in the conf file
>>>>>         and what I
>>>>>         have in the nova.conf
>>>>>
>>>>>         Im doing this manually via the Juno instruction guide for
>>>>> CentOs 7.
>>>>>
>>>>>
>>>>>     try:
>>>>>
>>>>>     connection=mysql://nova:__PASSWORD@localhost/nova
>>>>>
>>>>>     Best,
>>>>>     -jay
>>>>>
>>>>>
>>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20141126/a90e226d/attachment.html>