MySQL ODBC Connector - logging issue

Author

logging issue

Jon Miller

2006-01-03, 7:23 am

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:=20
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. =20

Thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Chander Ganesan

2006-01-03, 11:23 am

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/mysql? unsub...sie.nctu.edu.tw

Logan, David

2006-01-03, 8:24 pm

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=20
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: david.logan@hp.com
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ****** =20
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia=20
i n v e n t =20
---------------------------------------------------------------

-----Original Message-----
From: Jon Miller & #91;mailto:jlmiller@
mmtnetworks.com.au]=20
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:=20
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. =20

Thanks

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Ddavid.logan@hp.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Imran Chaudhry

2006-01-04, 9:23 am

I'm inclined to think this is a database config issue in MailScanner.
Double check the Port setting that MailScanner is using and check that
against the port that your MySQL server binds to. It is normally 3306,
and they should match. If you don't know how to check, can you send me
the output of: netstat -tan | grep 3306

Your log output shows an error code of 110 which means 'Connection
timed out'. This is different to 'Connection refused'. Is there a
possibility of very high database activity from another source while
MailScanner is trying to get at the database? How you tried invoking
the MailScanner connection at different times of the day?

What interface does MailScanner use to connect? It looks like Perl
DBI, but you may be using ODBC? Finally, can you tell me your perl
version by: perl -v

Imran Chaudhry

--
http://www.EjectDisc.com
Get your Digital Identity - Domain Names, Web Space, E-mail & More!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links