Hi Raymond, That's an interesting message you're getting. Obviously there is an issue with IP address not getting to mysqld. The only thing that can make any sense to me in this one is double check the name and location of the my.cnf file.
See ya, Terrence ----- Original Message ----- From: Raymond Brighenti <[EMAIL PROTECTED]> Date: Fri, 10 May 2002 10:23:30 +0100 To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Subject: Replication Problem > Hi, > > Trying to get replication going between to W2K machines and getting the > following errors in the Slave log file. > > MySql: ready for connections > 020509 18:58:52 Slave thread: error connecting to master:Can't connect to > MySQL server on '' (10049)(0), retry in 60 sec > 020509 18:59:54 Slave thread: error connecting to master:Can't connect to > MySQL server on '' (10049)(0), retry in 60 sec > 020509 19:00:57 Slave thread: error connecting to master:Can't connect to > MySQL server on '' (10049)(0), retry in 60 sec > > Below are the two my.cnf files which as far as I can see should be ok. > > my.cnf Master > [mysqld] > log-bin > server-id=1 > > my.cnf Slave > [MYSQLD] > master-host=20.0.0.54 > master-user=echo > master-password=<password> > master-port=3306 > server-id=2 > > Below are the output from some other checks, it's got the "connecting to > master" in the colum. > Looking at the log file it's getting the "MySQL server on ''" which seems to > indicate that it doesn't have a host or IP address to connect to! > > Any ideas? > > Thanks > > Ray > > > > So from Master... > mysql> show master status; > +-------------------+----------+--------------+------------------+ > | File | Position | Binlog_do_db | Binlog_ignore_db | > +-------------------+----------+--------------+------------------+ > | dnatest03-bin.002 | 73 | | | > +-------------------+----------+--------------+------------------+ > 1 row in set (0.00 sec) > > > And from Slave... > mysql> show slave status > -> ; > +-------------+-------------+-------------+---------------+----------+-----+ > ---------------+-----------------+---------------------+------------+------- > -----+--------------+ > | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | > Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | > Last_error | Skip_counter | > +-------------+-------------+-------------+---------------+----------+-----+ > ---------------+-----------------+---------------------+------------+------- > -----+--------------+ > | | test | 3306 | 60 | | 4 > | Yes | | | 0 | > | 0 | > +-------------+-------------+-------------+---------------+----------+-----+ > ---------------+-----------------+---------------------+------------+------- > -----+--------------+ > 1 row in set (0.00 sec) > > mysql> show processlist > +----+---------------+-----------+------+---------+------+------------------ > ----+------------------+ > | Id | User | Host | db | Command | Time | State| Info > | > +----+---------------+-----------+------+---------+------+------------------ > ----+------------------+ > | 1 | system user | none | NULL | Connect | 985 | connecting to > master| NULL | > | 2 | administrator | localhost | NULL | Sleep | 5 || NULL > | > | 3 | ODBC | localhost | NULL | Query | 0 | NULL| show > processlist | > +----+---------------+-----------+------+---------+------+------------------ > ----+------------------+ > 3 rows in set (0.02 sec) > > > > > --------------------------------------------------------------------- > 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 > > -- _______________________________________________ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze --------------------------------------------------------------------- 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
