I'm stumped :( Looks like everything is set up correctly to me. What is interested is that your nova user access works from test2, but there is no nova@test2 user in the mysql.user table. What about doing a DROP USER nova@test1; FLUSH PRIVILEGES; and then see if that fixes things... since the [email protected]/255.255.0.0 user is clearly working for the access from test2.
Also, I'd recommend highly removing the nova@% user. Best, -jay On 03/08/2013 03:09 PM, Samuel Winchenbach wrote: > > http://paste2.org/p/3085807 > > > On Fri, Mar 8, 2013 at 2:46 PM, Jay Pipes <[email protected] > <mailto:[email protected]>> wrote: > > Please paste the results of SELECT User, Host, Password FROM mysql.user > when running as root... > > Thanks! > -jay > > On 03/08/2013 02:25 PM, Samuel Winchenbach wrote: > > Here are my grants. I don't know if this helps, but I did verify that > > the password was identical for each grant: > http://paste2.org/p/3085361 > > > > > > On Fri, Mar 8, 2013 at 2:17 PM, Samuel Winchenbach > <[email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>>> wrote: > > > > root@test1:/var/log# mysql -hmysql-ha -unova > > -p******************************** -e"SELECT User, Host, Password > > FROM mysql.user;" > > ERROR 1142 (42000) at line 1: SELECT command denied to user > > 'nova'@'test1' for table 'user' > > > > > > On Fri, Mar 8, 2013 at 2:06 PM, Jay Pipes <[email protected] > <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>>> wrote: > > > > What does this show? > > > > mysql -hmysql-ha -unova -p<PASS> -e"SELECT User, Host, > Password FROM > > mysql.user" > > > > -jay > > > > On 03/08/2013 01:46 PM, Samuel Winchenbach wrote: > > > Sorry, that must have been a copy and paste error. Here > is what I > > > actually ran: > > > > > > http://paste2.org/p/3084996 > > > > > > > > > On Fri, Mar 8, 2013 at 12:40 PM, Jay Pipes > <[email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > <mailto:[email protected] <mailto:[email protected]> > <mailto:[email protected] <mailto:[email protected]>>>> wrote: > > > > > > On 03/08/2013 12:19 PM, Samuel Winchenbach wrote: > > > > 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 > > > > > > In the above paste you are doing: > > > > > > mysql -unova - hmysql-ha -u root nova > > > -p******************************** > > > > > > Note you are supplying 2 -u arguments, and mysql > will take > > the second > > > (root). > > > > > > -jay > > > > > > _______________________________________________ > > > Mailing list: https://launchpad.net/~openstack > > > Post to : [email protected] > <mailto:[email protected]> > > <mailto:[email protected] > <mailto:[email protected]>> > > > <mailto:[email protected] > <mailto:[email protected]> > > <mailto:[email protected] > <mailto:[email protected]>>> > > > Unsubscribe : https://launchpad.net/~openstack > > > More help : https://help.launchpad.net/ListHelp > > > > > > > > > > > > > > _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : [email protected] Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
