<div dir="ltr">Geo <div><br></div><div>Error logs are here:</div><div><br></div><div><a href="http://paste.openstack.org/show/139035/">http://paste.openstack.org/show/139035/</a><br></div><div><br></div><div>When I run your command with password nova it fails - when I run it with the real password it works fine</div><div><br></div><div><div>[root@controller ~]# mysql -u nova -p -h controller nova</div><div>Enter password:</div><div>I entered nova here</div><div>ERROR 1045 (28000): Access denied for user 'nova'@'controller' (using password: YES)</div><div><br></div><div><br></div><div>[root@controller ~]# mysql -u nova -p -h controller nova</div><div>Enter password:</div><div>I entered real password here</div><div>Welcome to the MariaDB monitor. Commands end with ; or \g.</div><div>Your MariaDB connection id is 13</div><div>Server version: 5.5.40-MariaDB MariaDB Server</div><div><br></div><div>Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.</div><div><br></div><div>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</div><div><br></div><div>MariaDB [nova]> quit</div><div>Bye</div></div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 26, 2014 at 3:36 PM, Amit Anand <span dir="ltr"><<a href="mailto:aanand@viimed.com" target="_blank">aanand@viimed.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Jay,<div><br></div><div>So this is the command that u sent, works just fine connect to Nova DB:</div><div><br></div><div><div>[root@controller nova]# mysql -unova -hlocalhost -p -Dnova</div><span class=""><div>Enter password:</div><div>Welcome to the MariaDB monitor. Commands end with ; or \g.</div></span><div>Your MariaDB connection id is 8</div><span class=""><div>Server version: 5.5.40-MariaDB MariaDB Server</div><div><br></div><div>Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.</div><div><br></div><div>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</div><div><br></div><div>MariaDB [nova]></div></span></div><div><br></div><div><br></div><div>I also changed in nvoa.conf <span style="font-size:13px;font-family:arial,sans-serif">connection=mysql://nova:__</span><u style="font-size:13px;font-family:arial,sans-serif"></u><span style="font-size:13px;font-family:arial,sans-serif">PASS</span><span style="font-size:13px;font-family:arial,sans-serif">WORD@localhost/nova (I tried with both a space and a _ as I was not sure exactly what you meant - still same error) :-(</span></div><div><span style="font-size:13px;font-family:arial,sans-serif"><br></span></div><div><font face="arial, sans-serif">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)?</font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif"><div>MariaDB [mysql]> SELECT * FROM db WHERE User = 'root'\G</div><div>*************************** 1. row ***************************</div><div> Host: %</div><div> Db: nova</div><span class=""><div> User: root</div><div> Select_priv: Y</div><div> Insert_priv: Y</div><div> Update_priv: Y</div><div> Delete_priv: Y</div><div> Create_priv: Y</div><div> Drop_priv: Y</div><div> Grant_priv: Y</div><div> References_priv: Y</div><div> Index_priv: Y</div><div> Alter_priv: Y</div><div>Create_tmp_table_priv: Y</div><div> Lock_tables_priv: Y</div><div> Create_view_priv: Y</div><div> Show_view_priv: Y</div><div> Create_routine_priv: Y</div><div> Alter_routine_priv: Y</div><div> Execute_priv: Y</div><div> Event_priv: Y</div><div> Trigger_priv: Y</div></span><div>1 row in set (0.01 sec)</div><div><br></div></font></div><div>Also this is the output for user Nova:</div><div><br></div><div><div>MariaDB [mysql]> SELECT * FROM db WHERE User = 'nova'\G;</div><span class=""><div>*************************** 1. row ***************************</div><div> Host: localhost</div></span><div> Db: nova</div><div> User: nova</div><span class=""><div> Select_priv: Y</div><div> Insert_priv: Y</div><div> Update_priv: Y</div><div> Delete_priv: Y</div><div> Create_priv: Y</div><div> Drop_priv: Y</div><div> Grant_priv: N</div><div> References_priv: Y</div><div> Index_priv: Y</div><div> Alter_priv: Y</div><div>Create_tmp_table_priv: Y</div><div> Lock_tables_priv: Y</div><div> Create_view_priv: Y</div><div> Show_view_priv: Y</div><div> Create_routine_priv: Y</div><div> Alter_routine_priv: Y</div><div> Execute_priv: Y</div><div> Event_priv: Y</div><div> Trigger_priv: Y</div></span><div>*************************** 2. row ***************************</div><div> Host: %</div><div> Db: nova</div><div> User: nova</div><span class=""><div> Select_priv: Y</div><div> Insert_priv: Y</div><div> Update_priv: Y</div><div> Delete_priv: Y</div><div> Create_priv: Y</div><div> Drop_priv: Y</div><div> Grant_priv: N</div><div> References_priv: Y</div><div> Index_priv: Y</div><div> Alter_priv: Y</div><div>Create_tmp_table_priv: Y</div><div> Lock_tables_priv: Y</div><div> Create_view_priv: Y</div><div> Show_view_priv: Y</div><div> Create_routine_priv: Y</div><div> Alter_routine_priv: Y</div><div> Execute_priv: Y</div><div> Event_priv: Y</div><div> Trigger_priv: Y</div></span><span class=""><div>2 rows in set (0.00 sec)</div></span></div><div><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 26, 2014 at 3:12 PM, Jay Pipes <span dir="ltr"><<a href="mailto:jaypipes@gmail.com" target="_blank">jaypipes@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>On 11/26/2014 02:36 PM, Amit Anand wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Same error - also tried with 127.0.0.1. Even crazier I removed all<br>
keystone nova (user, service, etc) and dropped the nova DB and recreated<br>
that, then recreated keystone nova with a new different password,<br>
updated nova.conf with new password and still get the same error (notice<br>
below now nova has the different password):<br>
</blockquote>
<br></span>
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:<br>
<br>
mysql> SHOW DATABASES;<br>
+--------------------+<br>
| Database |<br>
+--------------------+<br>
| information_schema |<br>
| mysql |<br>
| performance_schema |<br>
| test |<br>
+--------------------+<br>
4 rows in set (0.03 sec)<br>
<br>
mysql> GRANT ALL ON foo.* TO root@localhost;<br>
Query OK, 0 rows affected (0.00 sec)<br>
<br>
mysql> GRANT ALL ON test.* TO root@localhost;<br>
Query OK, 0 rows affected (0.00 sec)<br>
<br>
mysql> USE mysql<br>
Database changed<br>
mysql> SELECT * FROM db WHERE User = 'root' AND Db = 'foo'\G<br>
*************************** 1. row ***************************<br>
Host: localhost<br>
Db: foo<br>
User: root<br>
Select_priv: Y<br>
Insert_priv: Y<br>
Update_priv: Y<br>
Delete_priv: Y<br>
Create_priv: Y<br>
Drop_priv: Y<br>
Grant_priv: N<br>
References_priv: Y<br>
Index_priv: Y<br>
Alter_priv: Y<br>
Create_tmp_table_priv: Y<br>
Lock_tables_priv: Y<br>
Create_view_priv: Y<br>
Show_view_priv: Y<br>
Create_routine_priv: Y<br>
Alter_routine_priv: Y<br>
Execute_priv: Y<br>
Event_priv: Y<br>
Trigger_priv: Y<br>
1 row in set (0.00 sec)<br>
<br>
Go figure :)<br>
<br>
If you manually specify the host on the command line, do you still get in to the MySQL server?<br>
<br>
i.e., if you do this on the command line, does it work?<br>
<br>
mysql -unova -hlocalhost -p -Dnova<br>
<br>
Best,<br>
-jay<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>
MariaDB [mysql]> SELECT user,password,host FROM user;<br>
+----------+------------------<u></u>-------------------------+----<u></u>-------+<br>
| user | password | host |<br>
+----------+------------------<u></u>-------------------------+----<u></u>-------+<br>
| root | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | localhost |<br>
| root | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | 127.0.0.1 |<br>
| root | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | ::1 |<br>
| keystone | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | % |<br>
| keystone | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | localhost |<br>
| glance | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | localhost |<br>
| glance | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | % |<br>
| nova | *<u></u>3DA97D7423D54524806BFF6A19D94F<u></u>78EEF97338 | localhost |<br>
| nova | *<u></u>3DA97D7423D54524806BFF6A19D94F<u></u>78EEF97338 | % |<br>
| root | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | % |<br>
+----------+------------------<u></u>-------------------------+----<u></u>-------+<br>
10 rows in set (0.00 sec)<br>
<br>
<br>
On Wed, Nov 26, 2014 at 2:26 PM, Jay Pipes <<a href="mailto:jaypipes@gmail.com" target="_blank">jaypipes@gmail.com</a><br></span><span>
<mailto:<a href="mailto:jaypipes@gmail.com" target="_blank">jaypipes@gmail.com</a>>> wrote:<br>
<br>
On 11/26/2014 02:21 PM, Amit Anand wrote:<br>
<br>
Hi Jay - I believe so below is the part that is in the nova.conf<br>
<br>
# The SQLAlchemy connection string used to connect to the<br>
# bare-metal database (string value)<br></span>
connection=mysql://nova:__<u></u>PASSWORD@controller/nova<span><br>
<br>
The PASSWORD is exactly the same what I have in the conf file<br>
and what I<br>
have in the nova.conf<br>
<br>
Im doing this manually via the Juno instruction guide for CentOs 7.<br>
<br>
<br>
try:<br>
<br></span>
connection=mysql://nova:__<u></u>PASSWORD@localhost/nova<br>
<br>
Best,<br>
-jay<br>
<br>
<br>
</blockquote>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>