openstack team mailing list archive
-
openstack team
-
Mailing list archive
-
Message #21714
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