Honestly, I don't know what was wrong, but I have managed to get this problem fixed. It was one of two things...
I upgraded the MySQL slave server to 3.23.49a. I also deleted the master.info file based on something I read in the release info for all of the releases in between the release that I was running and the one that I just installed. Deleting the master.info file must have done the trick because I fired up the slave server and everything is now running beautifully. Next question: do you have to manually delete the bin files on the master server and how do you know when you can do that? Thanks, Leonard At 05:30 PM 3/27/2002 -0800, Steven Hajducko wrote: >Leonard, > >What command are you using to start the slave server? I was thinking >maybe it wasn't reading the correct configuration file? > >This one is pretty strange. Have you thought about upgrading the slave >mysql version, just to disregard that it might be a problem between the >two versions? > >One thing, in your user table, are you using the hostname of the slave >server to specify where it's coming from? ( I know you said you did % >already, so this shouldn't matter.. but.. who knows? ). > >Here's what my replication user looks like - > >| % | bkup | password | N | N | N | >N | N | N | N | N | >N | Y | N | N | N | >N | > >What do you currently have in the mysql 'user' table for the repl user? > >-- >sh > >On Wed, 2002-03-27 at 17:18, Leonard Megliola wrote: > > > > Thanks Scott. It looks like permissions could be the issue, but checking > > out the table shows that I have all of the correct permissions setup > > exactly as you have listed them below. > > > > If you have any other ideas, I'd appreciate them. > > > > Thanks, > > > > Leonard > > > > At 12:49 PM 3/27/2002 -0500, you wrote: > > >Leonard, > > > > > > This is pretty clearly (IMHO) a permissions issue. Make sure the > > >username you use to replicate with, has a '%' in the Host field of the > user > > >table. > > > > > >mysql> use mysql > > >mysql> select * from user where user = '<your_replication_user>' \G > > >*************************** 1. row *************************** > > > Host: % > > > User: <your_replication_user> > > > Password: <encrypted_password> > > > Select_priv: N > > > Insert_priv: N > > > Update_priv: N > > > Delete_priv: N > > > Create_priv: N > > > Drop_priv: N > > > Reload_priv: N > > > Shutdown_priv: N > > > Process_priv: N > > > File_priv: Y > > > Grant_priv: N > > >References_priv: N > > > Index_priv: N > > > Alter_priv: N > > >1 row in set (0.01 sec) > > > > > > > > >Scott Helms > > >Director of Technology, ZCorum > > > > > > > > >----- Original Message ----- > > >From: "Leonard Megliola" <[EMAIL PROTECTED]> > > >To: <[EMAIL PROTECTED]> > > >Sent: Wednesday, March 27, 2002 12:16 PM > > >Subject: Re: Replication Failure (or Bug?): Cannot Connect, but Should? > > > > > > > > > > > > > > Sorry to bring this up again, but I haven't received any helpful > > > > responses. Does anyone have any clues about this or is this > something I > > > > should report as a bug? I can't imagine it is. > > > > > > > > Thank you, > > > > > > > > Leonard > > > > > > > > At 12:43 AM 3/26/2002 -0800, you wrote: > > > > > > > > >Hello, > > > > > > > > > >I have been attempting to get replication working for a week now > and am > > > > >having little luck. I have followed the instructions in the > documentation > > > > >but get the following errors in the error log on the slave server: > > > > > > > > > >020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is > > >not > > > > >allowed to connect to this MySQL server(0), retry in 0 sec > > > > >020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is > > >not > > > > >allowed to connect to this MySQL server(0), retry in 0 sec > > > > >020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is > > >not > > > > >allowed to connect to this MySQL server(0), retry in 0 sec > > > > >020325 0:32:24 Slave thread: error connecting to master:Can't > connect to > > > > > > > >MySQL server on '0' (11)(107), retry in 0 sec > > > > >020325 0:32:24 Slave thread: error connecting to master:Can't > connect to > > > > >MySQL server on '0' (11)(107), retry in 0 sec > > > > >020325 0:32:24 Slave thread: error connecting to master:Can't > connect to > > > > >MySQL server on '0' (11)(107), retry in 0 sec > > > > > > > > > >Here are the relevant lines from my configuration files.... > > > > > > > > > >Master my.cnf: > > > > >[mysqld] > > > > >socket=/var/lib/mysql/mysql.sock > > > > >log-bin > > > > >server-id=1 > > > > > > > > > >Slave my.cnf: > > > > >[mysqld] > > > > >socket=/var/lib/mysql/mysql.sock > > > > >master-host=10.0.0.10 > > > > >master-user=repl > > > > >master-password=password > > > > >master-connect-retry=10 > > > > >master-port=3306 > > > > >server-id=2 > > > > > > > > > >I created the repl account on the master and have tried giving it FILE > > > > >privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname > of the > > > > >slave server. > > > > > > > > > >The thing that stands out most for me about the error messages is > that it > > > > >says "Can't connect to MySQL server on '0'" when I have clearly > entered > > > > >the IP address, and that it says retrying in 0 seconds when I made the > > > > >timeout 10 seconds. > > > > > > > > > >The MySQL version on the master server is 3.23.35 and the slave > version > > >is > > > > >at 3.23.32. > > > > > > > > > >Any help would be greatly appreciated. > > > > > > > > > >Thanks, > > > > > > > > > >Leonard > > > > > > > > > >P.S. sql query > > > > > > > > > > > > > > >--------------------------------------------------------------------- > > > > >Before posting, please check: > > > > > http://www.mysql.com/manual.php (the manual) > > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > > > > >To unsubscribe, e-mail > > > > ><[EMAIL PROTECTED]> > > > > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > Before posting, please check: > > > > http://www.mysql.com/manual.php (the manual) > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > ><[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > >--------------------------------------------------------------------- > > >Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > > >To unsubscribe, e-mail > > ><[EMAIL PROTECTED]> > > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
