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]>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]> 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]>> 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]> >> > 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
