Utility for SQL logging

Magnusson, Andrew Andrew.Magnusson at COCC.COM
Mon May 5 15:23:47 IST 2003


Here's a quick utility I just wrote up that will convert the old-style
default SQL table (maillog) to the new style (maillog_mail,
maillog_recipient, maillog_report) included in 4.20. It does rudimentary
duplicate-checking, etc, but probably isn't safe to be run multiple times on
datasets with attachments, as writing to the maillog_report table isn't
checked for dupes. This may be useful to those who want to upgrade.

Andrew Magnusson
Internet Product Analyst
COCC
1-877-678-0444 extension 640


 <<convert.pl>>

*** This message originates from COCC, Inc.

If the reader of this message, regardless of the address or routing, is not an intended recipient, you are hereby notified that you have received this transmittal in error and any review; use, distribution, dissemination or copying is strictly prohibited.  If you have received this message in error, please delete this e-mail and all files transmitted with it from your system and immediately notify COCC, Inc. by sending reply e-mail to the sender of this message.

Thank you. ***

-------------- next part --------------
A non-text attachment was scrubbed...
Name: convert.pl
Type: application/octet-stream
Size: 2160 bytes
Desc: not available
Url : http://lists.mailscanner.info/pipermail/mailscanner/attachments/20030505/c5107734/convert.obj


More information about the MailScanner mailing list