<div dir="ltr">HI Geo - Pasted above in the email chain but here it is again:<div><br></div><div><div># The SQLAlchemy connection string used to connect to the</div><div># bare-metal database (string value)</div><div>connection=mysql://nova:PASSWORD@localhost/nova</div></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 26, 2014 at 2:17 PM, Geo Varghese <span dir="ltr"><<a href="mailto:gvarghese@aqorn.com" target="_blank">gvarghese@aqorn.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>Hi Amit,<br></div><div><br></div><div>Please open => /etc/nova/nova.conf</div><div><br></div><div>Find a line with starting with "connection = " </div><div><br></div><div>Please paste it here. That will help us to fix the issue.</div></div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">On Wed, Nov 26, 2014 at 11:55 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"><div><div>On 11/25/2014 05:10 PM, Amit Anand wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi all,<br>
<br>
Setup: 3 node, one controller, one compute and one network all separate<br>
machines. Juno install.<br>
<br>
Recreating my Juno install and this is the second time Ive gotten this<br>
error whne running "su -s /bin/sh -c "nova-manage db sync" nova" ( I got<br>
in in another install so I started over):<br>
<br>
2014-11-25 16:16:51.707 3238 CRITICAL nova [-] OperationalError:<br>
(OperationalError) (1045, "Access denied for user 'nova'@'localhost'<br>
(using password: YES)") None None<br>
<br>
I am confident that all is ok with my nova.conf (Ill be happy to send<br>
it) - I think this maybe a bug within openstack as this is the second<br>
time I have gotten the exact same error on a totally new install? Ive<br>
checked MaraiDB and all looks good there:<br>
<br>
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>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | localhost |<br>
| nova | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | % |<br>
| root | *<u></u>7088873CEA983CB57491834389F9BB<u></u>9369B9D756 | % |<br>
+----------+------------------<u></u>-------------------------+----<u></u>-------+<br>
<br>
Im using the exact same password for all my acccounts in this DEV<br>
enviroment to keep it simple.<br>
<br>
I can also connect just fine from command line:<br>
<br>
[root@controller nova]# mysql -u nova -p nova<br>
Enter password:<br>
Welcome to the MariaDB monitor. Commands end with ; or \g.<br>
Your MariaDB connection id is 11<br>
Server version: 5.5.40-MariaDB MariaDB Server<br>
<br>
Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the current input<br>
statement.<br>
<br>
MariaDB [nova]><br>
<br>
So I have no idea what is wrong. Ive dropped the database and added it<br>
back following the insturctions again via the install guide and same<br>
error. I was hoping anyone had any pointers before I go ahead and report<br>
this as a bug. Ive tried everything that Ask Openstack answers have<br>
shown and no go. I am suprised that Im the only one getting this error<br>
repeatedly...I see that root % is in there twice and no idea how to get<br>
rid of it but since its using user nova anyways I dont see how that<br>
would affect anyting. Please help!! Thanks!<br>
</blockquote>
<br></div></div>
Are you absolutely sure that the user and password that is in your nova.conf file (the [database] sql_connection string) is the same as what you are typing in on the command line?<br>
<br>
How are you deploying your OpenStack environment? Using a configuration management tool or manually?<br>
<br>
Best,<br>
-jay<br>
<br>
______________________________<u></u>_________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/<u></u>cgi-bin/mailman/listinfo/<u></u>openstack</a><br>
Post to : <a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/<u></u>cgi-bin/mailman/listinfo/<u></u>openstack</a><br>
</blockquote></div><br><br clear="all"><br></div></div><span class="HOEnZb"><font color="#888888">-- <br><div><div dir="ltr">--<div>Regards,</div><div>Geo Varghese</div></div></div>
</font></span></div>
<br>_______________________________________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to : <a href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
<br></blockquote></div><br></div>