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]
