MySQL logging

[Chris Campbell]

Yup, changed the hostname, and supplied my password as well....
.....................................
Christopher S. Campbell
UNIX Admin





                    "Kearney, Rob"
                    <RKearney at AZERTY.C       To:     MAILSCANNER at JISCMAIL.AC.UK
                    OM>                      cc:
                    Sent by:                 Subject:     Re: MySQL logging
                    MailScanner
                    mailing list
                    <MAILSCANNER at JISCM
                    AIL.AC.UK>


                    08/11/03 02:31 PM
                    Please respond to
                    MailScanner
                    mailing list






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