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

[Andy McGarty]

On Sat, 01 Oct 2005 22:35:24 +0100, Adrian McMenamin  
<adrian at mcmen.demon.co.uk> wrote:

> On Sat, 2005-10-01 at 22:09 +0100, Andy McGarty wrote:
>> On Sat, 01 Oct 2005 22:02:18 +0100, Martin N Stevens
>> <budgester at budgester.com> wrote:
>>
>> >>
>> >> 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 assume you have used nmap to check that 3306 is open on the new
>> > machine ?
>>
>> Oh yes, and I can mysql -u myname -p -h www.myhost.com without problems.
>>
>> I've even tried connecting to two hosts (same error) and setting up on  
>> an
>> old redhat 9 system I have at home using the same config files and it
>> connected fine.  Looks like something in FC4?  I thought maybe the dns
>> washnt' resolving, my putting in IP gives same error.
>>
>> I'm almost bald now....
> What selinux settings did you choose for FC4 when you installed it?
>
Thats it!!!  I really would have been bored before I spotted that.
I turned it off with /usr/sbin/setenforce 0 and now it works.

I'm amazed it stopped outbound, whats it actually doing?  Guess I've got  
some reading to do!

Is there anyway round it without turning it off, as I guess the more  
security I can have the better.

Thanks for your help, I can sleep tonight!

Andy




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