<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html><body>
<span id="mailbox-conversation"></span><br><br><span class="none"><div class="mailbox_signature" style="display: block;">
<br>—<br>Raghu</div>
<span id="orc-full-body-initial-text" style="display: inline;"><br>On Wednesday, Nov 12, 2014 at 2:13 PM, John Griffith <<a href="mailto:john.griffith@solidfire.com" target="_blank">john.griffith@solidfire.com</a>>, wrote:<br></span><blockquote class="gmail_quote">On Wed, Nov 12, 2014 at 11:16 AM, Amit Anand <aanand@viimed.com> wrote:
<br>> Hi all,
<br>>
<br>> So been trying to figure out why this is happening I was hoping yall could
<br>> maybe shed some light on it asI really would not like to have recreate
<br>> everything on my controller node!
<br>>
<br>> So whenever I try to sync the nova database:
<br>> su -s /bin/sh -c "nova-manage db sync" nova
<br>>
<br>> I get this error in my logs:
<br>> 2014-11-12 13:09:45.323 29721 TRACE nova raise operational_error
<br>> 2014-11-12 13:09:45.323 29721 TRACE nova OperationalError:
<br>> (OperationalError) (1045, "Access denied for user 'nova'@'localhost' (using
<br>> password: YES)") None None
<br>>
<br>>
<br>> Ive tried dropping and recreating the nova table but still keep getting the
<br>> same error. Ive looked into the mysql database for the users and this is
<br>> what I have:
<br>>
<br>> Database changed
<br>> MariaDB [mysql]> SELECT user,password,host FROM user;
<br>> +----------+-------------------------------------------+-----------+
<br>> | user | password | host |
<br>> +----------+-------------------------------------------+-----------+
<br>> | root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
<br>> | root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
<br>> | root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
<br>> | keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
<br>> | keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
<br>> | glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
<br>> | glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
<br>> | neutron | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
<br>> | neutron | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
<br>> | nova | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
<br>> | nova | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
<br>> | root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
<br>> +----------+-------------------------------------------+-----------+
<br>> 12 rows in set (0.00 sec)
<br>>
<br>>
<br>> Any ideas on how to fix this would be greatly appreciated. Thank you very
<br>> much!
<br>>
<br>> Amit
<br>>
<br>> _______________________________________________
<br>> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
<br>> Post to : openstack@lists.openstack.org
<br>> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
<br>>
<br><br>I seem to recall hitting something like this in an upgrade I did, and
<br>I'm not sure but check your permissions on your /etc/nova directory,
<br>particularly nova.conf. I ran into the same problem and that's what
<br>it turned out to be. </blockquote>
<blockquote class="gmail_quote"><span style="-webkit-tap-highlight-color: transparent;">[rvv]</span></blockquote>
<blockquote class="gmail_quote"><br></blockquote>
<blockquote class="gmail_quote"><span style="-webkit-tap-highlight-color: transparent;">Most likely the mysql password and configuration file don't match. </span></blockquote>
<blockquote class="gmail_quote">_______________________________________________
<br>Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
<br>Post to : openstack@lists.openstack.org
<br>Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
<br>
</blockquote></span>
</body></html>