hi guys , i have posted here a few times already and i have trawled the list
archives and tried every tutorial on the topic without any luk , i am still
getting this error, why cant it read the master log saying it isnt open ?
the user i have used has ALL permissions, if i set log-bin in the slave
aswell i wont get any errors but it wont sync or replicate anyway, what is
my problem this is a real pain , there is no leads to my problem and the
error log does not tell me anything and is confusing. can anyone help ?
030310 06:46:35 mysqld started
030310 6:46:38 InnoDB: Started
/usr/local/etc/mysqlslave/libexec/mysqld: ready for connections.
Version: '4.0.11a-gamma' socket: '/usr/local/etc/mysqlslave/tmp/mysql.sock'
port
: 3307
030310 6:46:39 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:330
6', replication started in log 'FIRST' at position 4
030310 6:46:39 Error reading packet from server: Binary log is not open
(server_
errno=1236)
030310 6:46:39 Got fatal error 1236: 'Binary log is not open' from master
when r
eading data from binary log
030310 6:46:39 Slave I/O thread exiting, read up to log 'FIRST', position
4
030310 7:33:18 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:330
6', replication started in log 'replication.003' at position 79
030310 7:33:18 Error reading packet from server: Binary log is not open
(server_
errno=1236)
030310 7:33:18 Got fatal error 1236: 'Binary log is not open' from master
when r
eading data from binary log
030310 7:33:18 Slave I/O thread exiting, read up to log 'replication.003',
posit
ion 79
030310 7:36:31 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:330
6', replication started in log 'replication.003' at position 79
030310 7:36:31 Error reading packet from server: Binary log is not open
(server_
errno=1236)
030310 7:36:31 Got fatal error 1236: 'Binary log is not open' from master
when r
eading data from binary log
030310 7:36:31 Slave I/O thread exiting, read up to log 'replication.003',
posit
ion 79
my mysql slave settings
[mysqld]
port = 3307
socket = /usr/local/etc/mysqlslave/tmp/mysql.sock
master-host=localhost
#master-user=replicate
master-user=electroteque
master-password=***********
#master-password=Replic8
master-port=3306
master-info-file = master.log
master-connect-retry = 60
#set-variable = net_read_timeout=3600
replicate-do-db = electroteque
log-slave-updates
slave_net_timeout = 3600
#master-connect-retry=60
#report-host=localhost
#report-port=3307
server-id=2
#log-bin
#skip-locking
slave status gives me
+-------------+--------------+-------------+---------------+----------------
-+----
-----------------+----------------------+---------------+-------------------
----+-
-----------------+-------------------+-----------------+--------------------
-+----
--------+------------+--------------+---------------------+-----------------
+
| Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File
| Rea
d_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos |
Relay_Master_Log_File |
Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db
| Las
t_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space
|
+-------------+--------------+-------------+---------------+----------------
-+----
-----------------+----------------------+---------------+-------------------
----+-
-----------------+-------------------+-----------------+--------------------
-+----
--------+------------+--------------+---------------------+-----------------
+
| localhost | electroteque | 3306 | 60 | replication.003
| 79
| celery-relay-bin.001 | 4 | replication.003
|
No | Yes | electroteque |
| 0
| | 0 | 79 | 4
|
+-------------+--------------+-------------+---------------+----------------
-+----
-----------------+----------------------+---------------+-------------------
----+-
-----------------+-------------------+-----------------+--------------------
-+----
--------+------------+--------------+---------------------+-----------------
+
master settings are
[mysqld]
port = 3306
socket = /usr/local/etc/mysqlmaster/tmp/mysql.sock
server-id=1
log-bin=/usr/local/etc/mysqlmaster/logs/replication.log
log-bin-index=db.index
log-slave-updates
binlog-do-db = electroteque
master status
+-----------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+-----------------+----------+--------------+------------------+
| replication.003 | 79 | electroteque | |
+-----------------+----------+--------------+------------------+
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
