Is the server Id for your slave setup? What does the my.cnf for the slave look like?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/5/04, 10:17:11 AM, <[EMAIL PROTECTED]> wrote regarding 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
