Hi,

I have slave-master-setup that is special in two ways:
1) The slave connects through an stunnel
2) The slave replicates only one db

As soon as I start the slave process, the server connects but fails with the following log messages:

Jul 6 14:58:11 ijssel1 mysqld[11755]: 050706 14:58:11 Slave SQL thread initialized, starting replication in log 'mysql-bin.001' at position 227973, relay log './ijssel1-relay-bin.001' position: 4 Jul 6 14:58:11 ijssel1 mysqld[11755]: 050706 14:58:11 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3307', replication started in log 'mysql-bin.001' at position 227973 Jul 6 14:58:11 ijssel1 mysqld[11755]: 050706 14:58:11 Error reading packet from server: Misconfigured master - server id was not set (server_errno=1236) Jul 6 14:58:11 ijssel1 mysqld[11755]: 050706 14:58:11 Got fatal error 1236: 'Misconfigured master - server id was not set' from master when reading data from binary log Jul 6 14:58:11 ijssel1 mysqld[11755]: 050706 14:58:11 Slave I/O thread exiting, read up to log 'mysql-bin.001', position 227973 Jul 6 14:58:18 ijssel1 mysqld[11755]: 050706 14:58:18 Error reading relay log event: slave SQL thread was killed

On the master side I see the stunnel connecting.

To rule out corrupted binary logs, I did a RESET MASTER on the master. I verified with "SHOW VARIABLES" and "SHOW BINLOG EVENTS" that the master has server-id 1, the slave 2, and the server-id 1 is correctly used in the binlogs.

Any ideas?

Jan.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to