MySQL Forums
Forum List  »  Replication

Error connecting to master
Posted by: chan pat
Date: July 29, 2005 01:49AM

Hello!

Hello!

I'm trying to set up replication between two servers and even though I
did everything according to the documentation, the slave keeps failing
to connect to the master like this:

050721 17:31:52 [ERROR] Slave I/O thread: error connecting to master 'repluser@192.168.8.16:3306': Error: 'Can't connect to MySQL server on '192.168.8.16' (13)' errno: 2003 retry-time: 60 retries: 86400

050721 17:31:52 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './localhost-relay-bin.000001' position: 4


But when I try to connect with mysql-client myself, using the same host,
same user and same password, I get in correctly.

On master's my.cnf

[mysqld]
log-bin=mysql-bin
server-id=1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

On slave's my.cnf

[mysqld]
server-id=2
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I have done everything according to the books. The GRANT originally was
'GRANT REPLICATION SLAVE ON *.* TO ...' but during my tries to fix this
I tried other grants with the privileges shown above... I locked the
tables, copied everything, recorded the position, etc, etc...

I can login doing:

| shell> mysql -u repl -h xxx.xxx.xxx.xxx -p
| Password:
| mysql>


I am using Fedora Core 4 and MySQL 4.1.11

Can anybody tell me what is missing?

Thanks
Pat


I have set up the replication in

Options: ReplyQuote


Subject
Views
Written By
Posted
Error connecting to master
4262
July 29, 2005 01:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.