List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 11 2001 1:06pm
Subject:Re: Slave to host connection
View as plain text  
On the slave:

telnet 192.168.1.2 3306

DO you get a connected message and sone garbage?

If not, your master is not open for connections on port 3306.
You could have skip-networking in /etc/my.cnf , or perhaps you specified
a different
port.

If you did get the connection, then it is something else.



MCA Department PESIT wrote:
> 
>          i have granted the correct privileges to the slave machine on the
> master. like i said before it doesnt really come to that stage. had it come
> to that stage, it would have said something like Access Denied if the
> privileges were not proper.
> 
>          The 2 machines are able to ping each other. The versions are both
> new. for that matter, i created a user name on the slave machine and the
> master can connect to the slave using this.
> 
> slave is 192.168.1.5
> master is 192.168.1.2
> 
> i.e [at the master] mysql -h 192.168.1.5 -u master -p
>       this is successful where master is a user name i created on the slave
> machine with appropriate privileges.
> 
> [at the slave] mysql -h 192.168.1.2 -u slave -p
>      does not work, where slave is a user name i created on the master
> machine with appropriate privileges.
> 
>          the error is
> [root@linux] ~# mysql -h 192.168.1.2 -u slave -p
> Enter password:> ERROR 2003: Can't connect to MySQL server on '192.168.1.2'
> (111)
> 
> my etc/host file looks suspect, can you give me a typical example for a
> setup as mentioned above. although the entries seem okay, i will double
> check if you can give me a sample entry. my linux skills are limited hence
> the uncertainity.
> 
> At 08:59 AM 4/10/01 -0500, you wrote:
> >You granted the proper priveleges for the slave machine on the master as
> >specified in
> >the instructions?
> >
> >You can ping each way?
> >
> >You have the master and slave port numbers set the same?
> >
> >They are both running the latest version?
> >
> >Running out of ideas.
> >
> >MCA Department PESIT wrote:
> > >
> > > Hi,
> > >    i have edited the host file but still the error message is the same.
> > > There seems to be no problem in connecting the master to slave, but vice a
> > > versa, no luck.
> > >
> > > [root@linux] ~# mysql -h 192.168.1.2 -u slave -p
> > > Enter password:
> > > ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111)
> > >
> > > Mathew
> > >
> > > At 09:07 AM 4/9/01 -0500, you wrote:
> > > >To eliminate DNS problems, put each machine in the others /etc/hosts
> > > >file.
> > > >
> > > >MCA Department PESIT wrote:
> > > > >
> > > > > Hi there,
> > > > >    the master is running on 192.168.1.2 and the slave on
> > 192.168.1.5 , yes,
> > > > > the master is running. the user name and password are correct.
> > actually i
> > > > > dont think it gets to the state of actually verifying the user
> name and
> > > > > password. even if i do just a mysql -h 192.168.1.2 it gives me
> an
> > immediate
> > > > > error
> > > > >
> > > > > at 192.168.1.5
> > > > >
> > > > > [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u
> slave -p
> > > > > Enter password:
> > > > > ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111)
> > > > >
> > > > > there are no errors at the server side and the error log is
> clean
> > > > >
> > > > > Mathew
> > > > >
Thread
Slave to host connectionMCA Department PESIT9 Apr
  • Re: Slave to host connectionGerald Clark9 Apr
    • Re: Slave to host connectionMCA Department PESIT10 Apr
  • Re: Slave to host connectionGerald Clark10 Apr
    • Re: Slave to host connectionMCA Department PESIT11 Apr
  • Re: Slave to host connectionGerald Clark11 Apr
RE: Slave to host connectionSimon Green10 Apr