Can you ping the master from the slave? What do you have in the master.info file?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/5/04, 12:19:29 PM, <[EMAIL PROTECTED]> wrote regarding Re: replication: slave returns a 1236 error_code.: > Since you asked ...... > here is the my.cnf from the slave: > I "Think" it is ok: > In the .cnf file I have edited out the IP addresses and password for obvious > reasons. > ######################################################## > # 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 > # 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=2 > # Replication Slave (comment out master section to use this) > # > # To configure this host as a replication slave, you can choose between > # two methods : > # > # 1) Use the CHANGE MASTER TO command (fully described in our manual) - > # the syntax is: > # > # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>, > # MASTER_USER=<user>, MASTER_PASSWORD=<password> ; > # > # where you replace <host>, <user>, <password> by quoted strings and > # <port> by the master's port number (3306 by default). > # > # Example: > # > #CHANGE MASTER TO MASTER_HOST='nimbus2.hexal.de', MASTER_PORT=3306, > #MASTER_USER='rep1', MASTER_PASSWORD='repman'; > # > # OR > # > # 2) Set the variables below. However, in case you choose this method, then > # start replication for the first time (even unsuccessfully, for example > # if you mistyped the password in master-password and the slave fails to > # connect), the slave will create a master.info file, and any later > # change in this file to the variables' values below will be ignored and > # overridden by the content of the master.info file, unless you shutdown > # the slave server, delete master.info and restart the slaver server. > # For that reason, you may want to leave the lines below untouched > # (commented) and instead use CHANGE MASTER TO (see above) > # > # required unique id between 2 and 2^32 - 1 > # (and different from the master) > # defaults to 2 if master-host is set > # but will not function as a slave if omitted > #server-id = 2 > # > # The replication master for this slave - required > master-host= 123.123.123.123 > # > # The username the slave will use for authentication when connecting > # to the master - required > master-user= rep1 > # > # The password the slave will authenticate with when connecting to > # the master - required > master-password= <PASSWORD GOES HERE> > # > # The port the master is listening on. > # optional - defaults to 3306 > #master-port = <port> > # > # binary logging - not required for slaves, but recommended > log-bin > # Point the following paths to different dedicated disks > tmpdir = /tmp/ > #log-update = /var/log/nim1rep > log-update > # Uncomment the following if you are using BDB tables > #bdb_cache_size = 4M > #bdb_max_lock = 10000 > # Uncomment the following if you are using InnoDB tables > #innodb_data_home_dir = /var/lib/mysql/ > #innodb_data_file_path = ibdata1:10M:autoextend > #innodb_log_group_home_dir = /var/lib/mysql/ > #innodb_log_arch_dir = /var/lib/mysql/ > # You can set .._buffer_pool_size up to 50 - 80 % > # of RAM but beware of setting memory usage too high > #innodb_buffer_pool_size = 16M > #innodb_additional_mem_pool_size = 2M > # Set .._log_file_size to 25 % of buffer pool size > #innodb_log_file_size = 5M > #innodb_log_buffer_size = 8M > #innodb_flush_log_at_trx_commit = 1 > #innodb_lock_wait_timeout = 50 > # The safe_mysqld script > [safe_mysqld] > err-log=/var/lib/mysql/mysqld.log > [mysqldump] > quick > max_allowed_packet = 16M > [mysql] > no-auto-rehash > # Remove the next comment character if you are not familiar with SQL > #safe-updates > [isamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > [myisamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > [mysqlhotcopy] > interactive-timeout > > Is the server Id for your slave setup? What does the my.cnf for the slav > > e > > 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 maste > > r > > > - 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 fak > > e) > > > > > 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 play > > s > > > # 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] > > > -- > 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]
