MySQL logging

[Kearney, Rob]

Supposing your using SQLLogging that comes with MailScanner, and have this
enabled this in your MailScanner.conf,

1) Did you change the DSN/connection string in EndSQLLogging function in
CustomConfig.pm to point to a different host.
("DBI:mysql:mailscanner:<hostname>:")?

2) MailScanner writes to a temp-file, and will purge these to the Database
when MailScanner is gracefully killed,   try to stop and start Mailscanner
to see the results, otherwise, wait for MailScanner to restart, depending on
the "Restart Every" option in MailScanner.conf



-rob


-----Original Message-----
From: Chris Campbell [mailto:Chris.Campbell at FAC.COM]
Sent: Monday, August 11, 2003 1:08 PM
To: MAILSCANNER at JISCMAIL.AC.UK
Subject: MySQL logging


I have done all the documented changes needed for SQL logging, and I see no
errors in the maillog.  I have tested to make sure the mailscanner box can
log into the remote mysql server with the supplied username and password.

Has anyone else ran across any problems logging to a remote mysql box?  Can
anyone help me out here?

Thanks.
.....................................
Christopher S. Campbell
UNIX Admin
First Albany Corp
518.447.8544
chris.campbell at fac.com