Nova unable to connect to mysql server [closed]

asked 2014-05-27 07:17:22 -0600

vyom gravatar image

hello,

I have installed IceHouse with packstack --allinone on RHEL 6, I am not able to create instances from nova, I see the following error:

(OperationalError) (1045, "Access denied for user 'nova'@'ostackdev' (using password: YES)

I tried all the GRANT ALL .. SQLs to allow user nova but still unable to get this working!

Whereas, from the command line, I am able to connect as user nova, i.e:

mysql -u nova -p -h $HOSTNAME

and I get to the mysql> prompt with the password. The nova.conf has the config:

sql_connection=mysql://nova:<mypasswd>@<hostIP>/nova

I have also ensured that the mysql.users table has entries for all services, for localhost and % hosts with the _correct_ passwords (and, there are no entries with empty user names - which seems to be a common cause for this error) . Now sure what else is missing.

Any pointers for further debugging much appreciated.

These are the versions I have:

  • Mysql: Server version: 5.5.36-MariaDB-wsrep MariaDB Server
  • packstack: Icehouse 2014.1.1dev1068

/etc/hosts file has an entry for my host. And bind-address = 0.0.0.0 in /etc/my.cnf.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by larsks
close date 2014-05-28 08:40:24.704574

Comments

1

I was experiencing similar issue on F20 with 'nova' account
Try direct (insert/update) to MariaDB Server :-
shell> mysql -u root -p
mysql> insert into mysql.user (User,Host,Password) values ('nova','ostackdev',' ');
mysql> UPDATE mysql.user SET Password = PASSWORD('password-from-answer-file')
-> WHERE User = 'nova';
mysql> FLUSH PRIVILEGES;
CONFIG_NOVA_DB_PW should provide string for UPDATE statement

dbaxps gravatar imagedbaxps ( 2014-05-27 07:32:33 -0600 )edit

So, this should override the wildcard host (%), will try this. ..

vyom gravatar imagevyom ( 2014-05-28 03:49:28 -0600 )edit

Just insert new record , update it. See does it help you ?

dbaxps gravatar imagedbaxps ( 2014-05-28 04:13:39 -0600 )edit

I rebooted the host (with no changes to the DB) and I am seeing that nova is able to access mysql !

vyom gravatar imagevyom ( 2014-05-28 04:16:02 -0600 )edit