Open Stack

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/f15cd332/attachment.html>