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
'rep1@stripped: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.
