Morning Jon,
You will not be too successful in using MySQL logging to trace this. You
need to be able to connect to the server at the very least before this
would help.
I don't know much about MailScanner but I would be checking a couple of
things, 1) do you have a firewall in place? is the port (generally 3306)
open? and 2) is there a configuration file for MailScanner that has been
set up correctly?
This sounds more like a network issue rather than a MySQL problem. Are
you able to ping 192.168.10.4 from the MailScanner box? Can you telnet
to it? You could use tcpdump or similar to check the network
conversations.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Jon Miller [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 3 January 2006 9:03 PM
To: mysql@lists.mysql.com
Subject: logging issue
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.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
