[Gllug] Pulling my hair out - mysql replication not trying the remote server

[Andy McGarty]

Hi,

I've had replication running for several months but the slave harddrive  
went down during the week so I'm setting it up again.  It was previous FC2  
and its now FC4.  Mysql 4.1.12 on the new slave 4.1.12 on the master.

I saved the my.cnf file but I seem to be hitting a brick wall

When it starts I get

051001 20:47:26 [ERROR] Slave I/O thread: error connecting to master  
'myname at www.myserver.com:3306': Error: 'Can't connect to MySQL server on  
'www.myserver.com' (13)'  errno: 2003  retry-time: 60  retries: 86400

I reused the settings for the previous working server and even tried  
recreating a new valid user.

It doesn't appear to be even trying to connect to the remote server (i've  
checked the address and also tried just using the IP).  The slave status  
shows the correct values.

If I do a tcpdump on the remote side I don't even see it trying.

Error 13 is a privilege error, but on the ongoing connection?

I can mysql onto the remote server using the master username and password  
without problems (and the tcpdump sees the transaction).  And I can mysql  
back from the remote server to the new one, so I don't think any ports are  
being blocked?

I've googled so much I'm going round in cirlces.  None of the pages I can  
find talk about privileges to get out and I've even tried reinstalling  
mysql and reentering my my.conf file.  I have O'Reilly's hogh performance  
MySQL and I've gone over the setup several times.

Any help on where to look next appreciated!

Andy
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug