Hi, I tried using a FreeBSD box with MySQL as the Master and W2K as the slave and it works fine. I then swapped it so the W2K was master and I get the following from the Unix box.
020510 14:14:22 mysqld started /usr/local/libexec/mysqld: ready for connections 020510 14:14:22 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020510 14:14:22 Slave: received 0 length packet from server, apparent master shutdown: (0) 020510 14:14:22 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 31 020510 14:14:22 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31 020510 14:14:22 Slave: received 0 length packet from server, apparent master shutdown: (0) 020510 14:15:23 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 31 020510 14:15:23 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31 020510 14:15:23 Slave: received 0 length packet from server, apparent master shutdown: (0) 020510 14:16:23 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 31 020510 14:16:23 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31 020510 14:16:23 Slave: received 0 length packet from server, apparent master shutdown: (0) 020510 14:17:23 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 31 020510 14:17:23 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31 020510 14:17:23 Slave: received 0 length packet from server, apparent master shutdown: (0) 020510 14:18:23 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 31 020510 14:18:23 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31 020510 14:18:23 Slave: received 0 length packet from server, apparent master shutdown: (0) 020510 14:19:23 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 31 020510 14:19:23 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31 020510 14:19:23 Slave: received 0 length packet from server, apparent master shutdown: (0) 020510 14:20:23 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 31 020510 14:20:23 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31 020510 14:20:23 Slave: received 0 length packet from server, apparent master shutdown: (0) So it's reading the my.cnf file because I wouldn't be able to use it as a slave otherwise. Very strange, any other things to try? Ray -----Original Message----- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 2:24 To: 'Raymond Brighenti'; MYSQL-List (E-mail) Subject: RE: Replication Problem actually you may want to change [MYSQLD] to [mysqld] and restart your slave server I don't think it has read your my.cnf file correctly ( that means the other settings will not have taken affect either, like password and server ID) -----Original Message----- From: Raymond Brighenti [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 5:24 AM To: Subject: Replication Problem Hi, Trying to get replication going between to W2K machines and getting the following errors in the Slave log file. MySql: ready for connections 020509 18:58:52 Slave thread: error connecting to master:Can't connect to MySQL server on '' (10049)(0), retry in 60 sec 020509 18:59:54 Slave thread: error connecting to master:Can't connect to MySQL server on '' (10049)(0), retry in 60 sec 020509 19:00:57 Slave thread: error connecting to master:Can't connect to MySQL server on '' (10049)(0), retry in 60 sec Below are the two my.cnf files which as far as I can see should be ok. my.cnf Master [mysqld] log-bin server-id=1 my.cnf Slave [MYSQLD] master-host=20.0.0.54 master-user=echo master-password=<password> master-port=3306 server-id=2 Below are the output from some other checks, it's got the "connecting to master" in the colum. Looking at the log file it's getting the "MySQL server on ''" which seems to indicate that it doesn't have a host or IP address to connect to! Any ideas? Thanks Ray So from Master... mysql> show master status; +-------------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +-------------------+----------+--------------+------------------+ | dnatest03-bin.002 | 73 | | | +-------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) And from Slave... mysql> show slave status -> ; +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ | | test | 3306 | 60 | | 4 | Yes | | | 0 | | 0 | +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ 1 row in set (0.00 sec) mysql> show processlist +----+---------------+-----------+------+---------+------+------------------ ----+------------------+ | Id | User | Host | db | Command | Time | State| Info | +----+---------------+-----------+------+---------+------+------------------ ----+------------------+ | 1 | system user | none | NULL | Connect | 985 | connecting to master| NULL | | 2 | administrator | localhost | NULL | Sleep | 5 || NULL | | 3 | ODBC | localhost | NULL | Query | 0 | NULL| show processlist | +----+---------------+-----------+------+---------+------+------------------ ----+------------------+ 3 rows in set (0.02 sec) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
