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

[Adrian McMenamin]

On Sat, 2005-10-01 at 22:48 +0100, Andy McGarty wrote:
> 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.

It will fundamentally harden the security on your machine but having
been in your position once too often I gave up trying to use it and now
just turn it off.

It will only let those daemons you select communicate with the outside
world.

At a basic level FC4 + SELINUX is a different OS from FC4 (to be fair to
RH/F they acknowledge that)

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