oops. guess I need to change the root password now :P
On Fri, Mar 8, 2013 at 3:09 PM, Samuel Winchenbach <swinc...@gmail.com>wrote: > > 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
