Jon Miller wrote:
System:
Red hat 7.2
My SQL modules:
MySQL-devel-4.0.13-0
php-mysql-4.1.2-7.2.6
MySQL-shared-3.23.55-1
MySQL-server-4.0.13-0
MySQL-client-4.0.13-0
CAMysql-9.0-220
Msql-Mysql-DBI-perl-bin-1.1823-1
I would like to log or turn on the facility to do a verbose logging to
troubleshoot an issue I'm having with a program on another (mail) server trying
to access the mysql server. From the mail server I can issue the following:
mysql -h 192.168.10.4 -u mailwatch -p and enter the password and it connects. Yet from within the initial program it does not work and in the mail logs it has:
Jan 3 18:19:31 mail MailScanner[11376]: Unable to initialise database connection: Can't connect to MySQL server on '192.168.10.4' (110)
I've ask the mailscanner list, the mailwatch list and the postfix list and we are not getting anywhere.
If you're not using SSL, I'd recommend that you fire up ethereal on the
client or the server . You can have ethereal show you the entire
conversation - should help you filter out several different types of
problems that could occur.
A lot of things could be happening outside of what MySQL would see (for
example, the mailscanner could be trying to connect to the wrong port on
the server - the (110) makes me wonder if it's trying to connect to port
110). This would help diagnose a lot of those.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
