Is the server-id of slave different from that of master? Check this. both the serverid's must be different..
Regards T.Nagendra Prasad Professional Services OSI Technologies ______________________________________________________________________________ ---------- Original Message ----------- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thu, 5 Feb 2004 17:17:11 +0100 (MET) Subject: replication: slave returns a 1236 error_code. > Hallo, > > I am having trouble setting up replication. After sorting out most > things I get a connection from the slave to the master, but then a > mysql_errorno=1236. Here is an extract of the system log: > > ######################################################################## > ################### > 040205 16:45:42 mysqld started > /usr/sbin/mysqld: ready for connections. > Version: '4.0.15-log' socket: '/var/lib/mysql/mysql.sock' port: > 3306 > 040205 16:45:42 Slave I/O thread: connected to master > '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at > position 4 > 040205 16:45:42 Error reading packet from server: Misconfigured > master - server id was not set (server_errno=1236) > 040205 16:45:42 Got fatal error 1236: 'Misconfigured master - > server id was not set' from master when reading data from binary log > 040205 16:45:42 Slave I/O thread exiting, read up to log 'FIRST', > position 4 > > However, in the master, the serveri-id is already set to 1. (see > below). In addition, the slave contains the correct user parameters > to login on the master. (The ip-address above is a fake) > > Here is aome of the my.cnf file from the master: > > ######################################################################## > ################## > # Example mysql config file for medium systems. > # > # This is for a system with little memory (32M - 64M) where MySQL plays > # a important part and systems up to 128M very MySQL is used together > with > # other programs (like a web server) > # > # You can copy this file to > # /etc/my.cnf to set global options, > # mysql-data-dir/my.cnf to set server-specific options (in this > # installation this directory is /var/lib/mysql) or > # ~/.my.cnf to set user-specific options. > # > # One can in this file use all long options that the program supports. > # If you want to know which options a program support, run the program > # with --help option. > > # The following options will be passed to all MySQL clients > [client] > #password = your_password > port = 3306 > socket = /var/lib/mysql/mysql.sock > > # Here follows entries for some specific programs > > # The MySQL server > [mysqld] > port = 3306 > socket = /var/lib/mysql/mysql.sock > skip-locking > key_buffer = 16M > max_allowed_packet = 1M > table_cache = 64 > sort_buffer_size = 512K > net_buffer_length = 8K > myisam_sort_buffer_size = 8M > log-bin > log-bin-index > > # Don't listen on a TCP/IP port at all. This can be a security > enhancement, > # if all processes that need to connect to mysqld run on the same host. > # All interaction with mysqld must be made via Unix sockets or named > pipes. > # Note that using this option without enabling named pipes on Windows > # (via the "enable-named-pipe" option) will render mysqld useless! > # > #skip-networking > > # Replication Master Server (default) > # binary logging is required for replication > # log-bin > > # required unique id between 1 and 2^32 - 1 > # defaults to 1 if master-host is not set > # but will not function as a master if omitted > > server-id=1 > > <snip> > > Can anyone give me a pointer to what might be wrong ?? Whatever it > is it doesn't seem to really be a missing master server-id. > > Thanks > > Mike Anderson > > -- > I saw the best minds of my generation > destroyed by madness. Allen Ginsberg 1956. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > tech.com ------- End of Original Message ------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
