Spamassassin 2.50 & SQL logging

[Steve Freegard]

Hi all,

I'm evaluating MailScanner + SA 2.50/DCC/Razor2 on RedHat 7.3 for use at my
company in place of MIMEsweeper that we use at the moment and I'm wondering
how to use the new Bayesian features effectively.

At the moment I'm thinking that I configure SpamAssassin to use auto
learning on all messages that it processes (auto_learn 1 in
spam.assassin.prefs.conf), and train it using false positives and false
negatives by getting my users to use the Outlook re-send feature to send the
messages to a 'not-spam', 'spam' & 'ham' mailbox held on the linux box and
then having a cron job that runs 'sa-learn' across the relevant mailboxes
each day, but I was wondering what other people are doing or thinking of
doing in this regard??

Also - I was wondering if anyone had tried getting MailScanner to log to a
MySQL database?? - I was looking at the CustomConfig.pm and was thinking
that I could create a custom function that would connect to the database and
do something like 'INSERT INTO maillog VALUES
('$message->{id}','$message->{size}','$message->{from}' etc..)' - or is this
just a really bad idea??  The existing software we use does this into an
Access database but we don't use it because it causes too much overhead, but
I thought Perl's DBI/DBD and MySQL would probably be much more efficient
than Access/ODBC!

Thoughts?

Kind regards,


Steve

--
Steve Freegard
Systems Manager
Littlehampton Book Services Ltd.
Tel: +44 (0)1903 82 8594
Fax: +44 (0)1903 82 8620


**********************************************************************
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 system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.lbsltd.co.uk
**********************************************************************