MySQL logging

[Steve Freegard]

Hi Chris,

It's up to you what you use ;-)), and it really depends on what you want to
do.

If you have a look at the archives (search for SQL Logging) - there was a
recent thread where I compared the two types of SQL Logging available for
MailScanner.

Going back to your original question - you are using the code supplied with
MailScanner, this writes the log to a temporary file first, then writes all
the values to the database when it restarts, so try restarting MailScanner,
check the logs for any errors, then check the database and see if it's got
anything in it...

Cheers,
Steve.

-----Original Message-----
From: Chris.Campbell at fac.com
To: Steve Freegard
Sent: 11/08/03 18:25
Subject: RE: MySQL logging


I am using the code with MailScanner... should I be using Mailwatch?

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






                    Steve Freegard

                    <steve.freegard at lbs       To:     "'Chris Campbell
'" <Chris.Campbell at FAC.COM>
                    ltd.co.uk>                cc:

                                              Subject:     RE: MySQL
logging
                    08/11/03 01:13 PM









Hi Chris,

Which version of the SQL logging are you using?? - the code supplied
with
MailScanner, or the code that comes with MailWatch??

If you using the former - then you won't see any data until you either
restart MailScanner, or when the MailScanner children die of old age.

Kind regards,
Steve

--
Steve Freegard
Systems Manager
Littlehampton Book Services Ltd.

-----Original Message-----
From: Chris Campbell
To: MAILSCANNER at JISCMAIL.AC.UK
Sent: 11/08/03 18:07
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

--
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender and delete the message from your mailbox.

This footnote also confirms that this email message has been swept by
MailScanner (www.mailscanner.info) for the presence of computer viruses.





--
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender and delete the message from your mailbox.

This footnote also confirms that this email message has been swept by
MailScanner (www.mailscanner.info) for the presence of computer viruses.