← Back to team overview

openstack team mailing list archive

Incredibly odd mysql permission error

 

Hi All,

I have two nodes (test1 and test2) that I am trying to set up in a highly
available configuration.

During the setup process I tried running "nova-manage service list" on both
nodes.   It worked fine on test2, but fails on test1 even though I can
connect to the database with the mysql client from test1.

Here is a screen capture that shows the setup on the two nodes are
basically identical:  http://paste2.org/p/3084223

Here is one that shows that the command is working on test2:
http://paste2.org/p/3084234

In the first paste I logged into the mysql server by copying and pasting
the user name, host name and password from the nova.conf.

user nova has the following grants in mysql:

GRANT ALL PRIVILEGES ON nova.* to 'nova'@'test1' IDENTIFIED BY '
********************************';
GRANT ALL PRIVILEGES ON nova.* to 'nova'@'%' IDENTIFIED BY '
********************************';
GRANT ALL PRIVILEGES ON nova.* to 'nova'@'10.21.0.0/255.255.0.0' IDENTIFIED
BY '********************************';
GRANT ALL PRIVILEGES ON nova.* to 'nova'@'localhost' IDENTIFIED BY '
********************************';

I have mysql controlled by pacemaker so I have tried running it on both
test1, and test2 with the same exact results.


If anyone can help me with this it would greatly appreciated.  I am at wits
end.

Sam

Follow ups