>Description:
Access denied errores, for the replication user, are not reported in:
SHOW SLAVE STATUS;
They show all relevant information, and queries like:
CHANGE MASTER TO
report no error.
Subsequent LOAD TABLE % FROM MASTER queries, hang indefinetely.
>How-To-Repeat:
Create a dummy user, and don't enable it on the master.
>Fix:
No known work-around.
Error mesages do appear in the server log.
>Submitter-Id: <submitter ID>
>Originator: Melvyn Sopacua
>Organization:
>MySQL support: none
>Synopsis: Access denied errors, don't appear in SHOW SLAVE STATUS
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.49 (Source distribution)
>Server: /sql/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for pc-bsdi4.2 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.49-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /sql/tmp/mysql.sock
Uptime: 17 min 20 sec
Threads: 1 Questions: 7 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1
Queries per second avg: 0.007
>Environment:
System: BSD/OS server21.idg.nl 4.2 BSDI BSD/OS 4.2 Kernel #0: Wed Oct 25 17:38:20 MDT
2000 [EMAIL PROTECTED]:/mnt/proto/4.2-i386/usr/src/sys/compile/GENERIC i386
Some paths: /perl/bin/perl /home/mdev/local/bin/make /usr/contrib/bin/gmake
/usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
-r--r--r-- 1 bin bin 1648744 Oct 8 2000 /usr/lib/libc.a
-r--r--r-- 1 bin bin 8561 Oct 8 2000 /usr/lib/libc.except
Configure command: ./configure --prefix=/sql --with-berkeley-db
--with-mysqld-username=root --without-docs
---------------------------------------------------------------------
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
