Hello.
Setting master to 127.0.0.1 could produce a problem. "MASTER_HOST and MASTER_PORT are the hostname (or IP address) of the master host and its TCP/IP port. Note that if MASTER_HOST is equal to localhost, then, like in other parts of MySQL, the port may be ignored (if Unix socket files can be used, for example)." See: http://dev.mysql.com/doc/mysql/en/change-master-to.html Jan Schneider <[EMAIL PROTECTED]> wrote: > 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. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
