Pierre,
Myslave working status is different to yours and as you can see there are values missing in yours such as Master_Log_File, etc. It seems your slave is not establishing successful replication communication with the master.
What is your SLAVE IP address?
What does your MASTER my.ini file have for bin-log and server-id parameters
What are the privileges for Replikator on the MASTER?
mysql> show slave status\G *************************** 1. row *************************** Master_Host: 192.168.1.141 Master_User: repl Master_Port: 3306 Connect_retry: 60 Master_Log_File: binary-log.002 Read_Master_Log_Pos: 551 Relay_Log_File: xmain-relay-bin.010 Relay_Log_Pos: 45 Relay_Master_Log_File: binary-log.002 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 551 Relay_log_space: 45 1 row in set (0.02 sec)
mysql>
On Jun 25, 2004, at 1:41 AM, Rousseau, Pierre wrote:
Re: Master Slave Problem :
mysql> show slave status\G *************************** 1. row *************************** Master_Host: 164.23.43.160 Master_User: Replikator Master_Port: 3306 Connect_retry: 60 Master_Log_File: Read_Master_Log_Pos: 1934 Relay_Log_File: WIH00106-relay-bin.015 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 0 Relay_log_space: 4 1 row in set (0.00 sec)
--- and my.ini file :
[mysqld] master_host=164.23.43.160 master_user=Replikator master_password=hackmack23 master_port=3306 server_id=10 [WinMySQLAdmin] Server=D:/databank/bin/mysqld-nt.exe
note : user/pw correct :(
-Pierre Rousseau
-x->-----Ursprüngliche Nachricht----- -x->Von: Kieran Kelleher [mailto:[EMAIL PROTECTED] -x->Gesendet: Donnerstag, 24. Juni 2004 22:05 -x->An: Rousseau, Pierre -x->Cc: [EMAIL PROTECTED] -x->Betreff: Re: Master Slave Problem. -x-> -x-> -x->Log into the slave and do this command -x->mysql> mysql> show slave status\G -x-> -x->..... what do you see? -x-> -x->Also, what is in your my.cnf file on the slave? -x-> -x->FYI, here is instructions on how I set up replication last week -x->http://homepage.mac.com/kelleherk/iblog/C711669388/E35122010 -x->0/index.html -x-> -x->-Kieran -x-> -x-> -x->________________________________________________________________ -x->Config = OS X 10.3.4 / Java 1.4.2 / WO 5.2.3 / XCode v1.2 / MySQL -x->4.0.20 / Connector-J 3.0.11 -x->Blog: http://webobjects.webhop.org/ -x-> -x-> -x->On Jun 24, 2004, at 9:15 AM, Rousseau, Pierre wrote: -x-> -x->> Hi Bug Team, -x->> -x->> I have set up a Master Slave System with MySQL 4.0.20. I've done -x->> completing every task from "6.4 How to Set Up Replication". -x->> -x->> But my problem is : -x->> 040624 14:44:44 Slave I/O thread: connected to master -x->> '[EMAIL PROTECTED]:3306', replication started in -x->log 'FIRST' -x->> at position 4 -x->> 040624 14:44:45 While trying to obtain the list of -x->slaves from the -x->> master '164.23.43.160:3306', user 'Replikator' got the following -x->> error: 'the master returned an invalid number of fields -x->for SHOW SLAVE -x->> HOSTS' -x->> 040624 14:44:45 Slave I/O thread exiting, read up to log -x->'FIRST', -x->> position 4 -x->> -x->> I have not found any support for this problem :( -x->> -x->> Your Faithfully -x->> Pierre Rousseau -x->> -x->> Deutsche Telekom AG -x->> T-Com, Technische Infrastruktur Niederlassung Nord -x->> Pierre Rousseau -x->> E-Mail: <mailto:[EMAIL PROTECTED]> -x->> Internet: <http://www.t-com.net> -x->> -x->> Diese E-Mail könnte vertrauliche und/oder rechtlich geschützte -x->> Informationen enthalten. Wenn Sie nicht der richtige -x->Adressat sind oder -x->> diese E-Mail irrtümlich erhalten haben, informieren Sie -x->bitte sofort -x->> den -x->> Absender und vernichten Sie diese Mail. Das unerlaubte -x->Kopieren sowie -x->> die -x->> unbefugte Weitergabe dieser Mail sind nicht gestattet. -x->> -x->> This e-mail may contain confidential and/or privileged -x->information. If -x->> you -x->> are not the intended recipient (or have received this -x->e-mail in error) -x->> please notify the sender immediately and destroy this e-mail. Any -x->> unauthorised copying, disclosure or distribution of the -x->material in -x->> this -x->> e-mail is strictly forbidden. -x->> -x->> -x->> -- -x->> MySQL General Mailing List -x->> For list archives: http://lists.mysql.com/mysql -x->> To unsubscribe: -x->> http://lists.mysql.com/[EMAIL PROTECTED] -x->> -x->
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
___________________________________ Kieran Kelleher SmartleadsUSA,LLC 2656 West Lake Rd Palm Harbor, FL 34684 [EMAIL PROTECTED] 727-785-0766 x33
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
