On Tue, 8 Feb 2005, Bastian Balthazar Bux wrote:
Just a shot in the dark
do you have "skip-networking" or "bind-address" uncommented in your my.cnf ?
Reading better what you write I suppose the answer is yes ;)
can you connect from one server to the other using the replication user ?
no skip-networking or bind to localhost activated.
The two servers are clearly speaking to each other, as
the first try was refused with : db0 does not allow from 192.168.0.177,
and after the grant, I got the error 1189..
(lsof -i has open socket to *:mysql)
Additionnaly, I can see clearly that db0 receives the command, as
the Query Cache is completely wiped out to 0 Queries when "load
data from master is issued"
So there does not seem like a network problem to me :)
another idea ?
Olivier Kaloudoff ha scritto:
Hi,
As no one answered to the question below, I'm
wondering wether it's a FAQ ... or a bug for which I should
fill a report ..
My network is ok between the two machines, I can
ssh from one to another and any traffic can flow.
But this error prevents me to start replication
at all..
Olivier
On Tue, 8 Feb 2005, Olivier Kaloudoff wrote:
Hi,
I have some problems here with two
mysql servers, version 4.1.8;
on the master server, binary logs are
activated, free disk space is not null;
[EMAIL PROTECTED]:~# ls -l /repl/mysql/data/master.*
-rw-rw---- 1 mysql mysql 1814256 2005-02-08 11:43
/repl/mysql/data/master.000001
-rw-rw---- 1 mysql mysql 16 2005-02-07 22:28
/repl/mysql/data/master.index
[EMAIL PROTECTED]:~# df -h /repl/mysql/data/
Sys. de fich. Tail. Occ. Free. %Occ. Monté sur
/dev/hd0/repl0 4,0G 607M 3,4G 15% /repl0
the correct grant has been typed on
the master server to allow the slave to connect and
replicate; (launched with --skip-name-resolve)
mysql> grant replication slave, file on *.* to [EMAIL PROTECTED]
identified by 'pass';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
now I change the "master to", and ask for the master (in production),
to give his data to the slave;
mysql> change master to MASTER_HOST='db0', MASTER_USER='repl',
MASTER_PASSWORD='pass', MASTER_LOG_FILE='master.000001';
Query OK, 0 rows affected (0.03 sec)
the only thing I can get is:
mysql> load data from master;
ERROR 1189 (08S01): Net error reading from master
Any ideas ? is this a bug in 4.1.8 ?
Regards,
Olivier Kaloudoff
CKR Solutions Open Source
Mandelieu, France
http://www.ckr-solutions.com
--
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]