i initially had a master-host=A defined in my.cnf.
later i changed that to master-host=B.
i was mystified when i got a connection error:
Slave thread: error connecting to master:Host 'dumbo.pobox.com' is not allowed to
connect to this MySQL server(0), retry in 60 sec
i spent much time prodding and poking before i realized that
due to the preexisting master.info, the slave was trying to
connect to the old master A, not the new master B.
i propose the following patch to make the error string more
verbose: it indicates what host, user, and password are in
use.
it may need to be edited to be NULL-safe --- if password is null, etc.
--- mysql-3.23.36/sql/slave.cc Tue Mar 27 05:11:05 2001
+++ mysql-3.23.36/sql/slave.cc-verboser Mon Apr 2 18:34:02 2001
@@ -1372,8 +1372,8 @@
!mc_mysql_connect(mysql, mi->host, mi->user, mi->password, 0,
mi->port, 0, 0))
{
- sql_print_error("Slave thread: error connecting to master:%s(%d),\
- retry in %d sec", mc_mysql_error(mysql), errno, mi->connect_retry);
+ sql_print_error("Slave thread: error connecting to master %s as %s with password
+%s: %s(errno %d), will retry in %d sec",
+ mi->host, mi->user, mi->password, mc_mysql_error(mysql), errno,
+mi->connect_retry);
safe_sleep(thd, mi->connect_retry);
}
---------------------------------------------------------------------
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
