<div dir="ltr">Ok well figured it out!!!<div><br></div><div>I guess its either me or the documentation. I basically got rid of the original nova.conf (that comes with the distro) and then I just made a new nova.conf with only the changes that are listed in the documentation (ie I created [database] [DEFAULT] etc sections listed there only) and then ran DB sync an viola! It seems to work. Crazy</div><div><br></div><div>Now Im worried (even tho everything seems to have worked) that the conf files for glance and keystone maybe incorrect because just edited the original conf files that came with the distro. Would anyone have any idea? </div><div><br></div><div>Also do you think this would be valuable to post on Ask Openstack and/or report it as a bug??</div><div><br></div><div>My new nova.conf: <a href="http://paste.openstack.org/show/139105/">http://paste.openstack.org/show/139105/</a></div><div><br></div><div>Thanks everyone!!!</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 26, 2014 at 4:56 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">Well created a new controller on a whole new machine and get all the way up until compute and get same error again. I have to think it something with my nova.conf but I cant figure it out. Ive pasted here so if anyone can take a look and see maybe what Im doing incorrect I would appreciate it...<div><br></div><div><a href="http://paste.openstack.org/show/139079/" target="_blank">http://paste.openstack.org/show/139079/</a><br></div><div><br></div><div><br></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 4:09 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">Im going to try building a new controller on a whole new nuc see if I get the same I will keep yall abreast if it works or not. In any case thank you very much for all your help!!!</div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 26, 2014 at 3:56 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"><div><br></div><div>Password is viimed1 </div><div><br></div><div><br></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 26, 2014 at 3:55 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">George<div><br></div><div>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 :-(</div><div><br></div><div>Permissions I made rwrwrw still same. </div><div><br></div><div><br></div><div><br></div><div><br></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 26, 2014 at 3:42 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">Geo <div><br></div><div>Error logs are here:</div><div><br></div><div><a href="http://paste.openstack.org/show/139035/" target="_blank">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><span><div>Welcome to the MariaDB monitor. Commands end with ; or \g.</div></span><div>Your MariaDB connection id is 13</div><span><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></span><div>MariaDB [nova]> quit</div><div>Bye</div></div><div><br></div><div><br></div><div><br></div><div><br></div></div><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><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><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><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><div>*************************** 1. row ***************************</div><div> Host: localhost</div></span><div> Db: nova</div><div> User: nova</div><span><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><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><div>2 rows in set (0.00 sec)</div></span></div><div><br></div></div><div><div><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>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>