Open Stack

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