http://paste2.org/p/3085807
On Fri, Mar 8, 2013 at 2:46 PM, Jay Pipes <jaypi...@gmail.com> 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 <swinc...@gmail.com > > <mailto:swinc...@gmail.com>> 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 <jaypi...@gmail.com > > <mailto:jaypi...@gmail.com>> 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 <jaypi...@gmail.com > > <mailto:jaypi...@gmail.com> > > > <mailto:jaypi...@gmail.com <mailto:jaypi...@gmail.com>>> > 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 : openstack@lists.launchpad.net > > <mailto:openstack@lists.launchpad.net> > > > <mailto:openstack@lists.launchpad.net > > <mailto:openstack@lists.launchpad.net>> > > > Unsubscribe : https://launchpad.net/~openstack > > > More help : https://help.launchpad.net/ListHelp > > > > > > > > > > > > >
_______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
