Open Stack

On Wed, Nov 12, 2014 at 11:16 AM, Amit Anand <aanand at viimed.com> wrote:
> Hi all,
>
> So been trying to figure out why this is happening I was hoping yall could
> maybe shed some light on it asI really would not like to have recreate
> everything on my controller node!
>
> So whenever I try to sync the nova database:
> su -s /bin/sh -c "nova-manage db sync" nova
>
> I get this error in my logs:
> 2014-11-12 13:09:45.323 29721 TRACE nova     raise operational_error
> 2014-11-12 13:09:45.323 29721 TRACE nova OperationalError:
> (OperationalError) (1045, "Access denied for user 'nova'@'localhost' (using
> password: YES)") None None
>
>
> Ive tried dropping and recreating the nova table but still keep getting the
> same error. Ive looked into the mysql database for the users and this is
> what I have:
>
> Database changed
> 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 | localhost |
> | keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
> | glance   | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
> | glance   | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
> | neutron  | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
> | neutron  | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
> | nova     | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
> | nova     | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
> | root     | *7088873CEA983CB57491834389F9BB9369B9D756 | %         |
> +----------+-------------------------------------------+-----------+
> 12 rows in set (0.00 sec)
>
>
> Any ideas on how to fix this would be greatly appreciated. Thank you very
> much!
>
> Amit
>
> _______________________________________________
> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to     : openstack at lists.openstack.org
> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>

I seem to recall hitting something like this in an upgrade I did, and
I'm not sure but check your permissions on your /etc/nova directory,
particularly nova.conf.  I ran into the same problem and that's what
it turned out to be.