Thanks Steven,
I can telnet to port 3306 of the master system just fine. A (likely unimportant and useless) test I did was to telnet to 3306 on the master and then run "netstat -an" on the master to see if the connect was made. Yes it was... tcp 0 0 10.0.0.10:3306 10.0.0.9:3017 ESTABLISHED What are the chances that MySQL doesn't work so well with 10.0.0.0 network addresses? I did flush privileges after adding the user. It didn't help. I had the same feeling about the configuration file being incorrect because of the IP address and timeout not being set correctly. I have compared yours and mine and don't see any significant differences except that I am using a numerical IP address for my master-host. Here is my slave my.cnf: [mysqld] datadir=/home/mysql socket=/var/lib/mysql/mysql.sock server-id=2 master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 [mysql.server] user=mysql basedir=/home/mysql [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Thanks for any more help you can give, Leonard At 09:39 AM 3/27/2002 -0800, Steven Hajducko wrote: >Hrm, I'll take a stab at it, since I've got replication working atm... > >Have you tried basic connectivity tests between the slave and master? ( >Just making sure.. ie - can you telnet to port 3306 on the master, from >the slave? ) > >Did you flush the privileges after adding the repl user? > >Here's my master my.cnf - > >[mysqld] >port = 3306 >socket = /tmp/mysql.sock >skip-locking >skip-innodb >set-variable = key_buffer=16M >set-variable = max_allowed_packet=1M >set-variable = table_cache=64 >set-variable = sort_buffer=512K >set-variable = net_buffer_length=8K >set-variable = myisam_sort_buffer_size=8M >log-bin >server-id = 1 > >And slave my.cnf - > >[mysqld] >port = 3306 >socket = /tmp/mysql.sock >skip-locking >skip-innodb >set-variable = key_buffer=16M >set-variable = max_allowed_packet=1M >set-variable = table_cache=64 >set-variable = sort_buffer=512K >set-variable = net_buffer_length=8K >set-variable = myisam_sort_buffer_size=8M >log-bin >server-id = 2 > >master-host=db.mine.com >master-user=bkup >master-password=password >master-port=3306 > >Can you copy and paste your whole my.cnf from the slave? It doesn't >sound like it's reading it correctly ( maybe why it's keeping the >timeout at 0 and trying to connect to the wrong ip? ) > >-- >sh > >On Wed, 2002-03-27 at 09:16, Leonard Megliola wrote: > > > > 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
