List:General Discussion« Previous MessageNext Message »
From:Bastian Balthazar Bux Date:February 8 2005 9:25pm
Subject:Re: ERROR 1189 (08S01): Net error reading from master
View as plain text  
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 ?





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;
>>
>> root@db0:~# 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
>>
>>
>> root@db0:~# 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 repl@stripped 
>> 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
>>
>>
>>

Thread
ERROR 1189 (08S01): Net error reading from masterOlivier Kaloudoff8 Feb
  • Re: ERROR 1189 (08S01): Net error reading from masterGleb Paharenko8 Feb
  • Re: ERROR 1189 (08S01): Net error reading from masterOlivier Kaloudoff8 Feb
    • Re: ERROR 1189 (08S01): Net error reading from masterBastian Balthazar Bux8 Feb
      • default valuesEmmett Bishop8 Feb
        • Re: default valuesJeff Smelser8 Feb
          • Re: default valuesMichael Stassen9 Feb
      • Re: ERROR 1189 (08S01): Net error reading from masterOlivier Kaloudoff8 Feb