Open Stack

—
Raghu


On Wednesday, Nov 12, 2014 at 2:13 PM, John Griffith <john.griffith at solidfire.com>, wrote:
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. 
[rvv]


Most likely the mysql password and configuration file don't match. 
_______________________________________________

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20141112/adcedbd6/attachment.html>