Question about spamassassin using MySQL

[Cole Tuininga]

On Sat, 2005-04-23 at 13:04 -0400, Steven W. Orr wrote:
> I just found out that because I use spamassassin/sendmail and 
> spamass-milter, I have to use a sitewide bayes database.

If you don't want to use spamass-milter, you could do what I do.
Everybody gets a .procmailrc that looks something like this (keep in
mind that I use Maildir, not mbox):

MAILDIR=$HOME/Maildir

:0fw
| /usr/bin/spamc -f -t 60

:0: SPAM.lck
* ^X-Spam-Status: Yes
.Spam.Bulkmail/

:0
$HOME/Maildir/


Each user gets a top level "Spam" folder with "Bulkmail", "Missed", and
"NotSpam" folders beneath it.  The mail tagged by Spam Assassin goes
into "Bulkmail".  Any mail missed by Spam Assassin is dragged into
"Missed", and any false positives in "Bulkmail" are dragged to
"NotSpam".

Then I just have two scripts (attached).  One (spamscan) is designed to
run for a single user and scans through the folders, performing the
appropriate actions.  The second (spamscanall) scans through the list of
users and runs the first program (spamscan) for each user.

This setup doesn't work well for POP clients, but works just peachy for
IMAP clients.

-- 
"I have tact.  I just choose not to use it."
-Ben Scott

Cole Tuininga
Lead Developer
Code Energy, Inc
colet at code-energy.com
PGP Key ID: 0x43E5755D

-------------- next part --------------
A non-text attachment was scrubbed...
Name: spamscan
Type: application/x-shellscript
Size: 1085 bytes
Desc: not available
Url : http://mail.gnhlug.org/mailman/private/gnhlug-discuss/attachments/20050425/d1280606/spamscan.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: spamscanall
Type: application/x-shellscript
Size: 139 bytes
Desc: not available
Url : http://mail.gnhlug.org/mailman/private/gnhlug-discuss/attachments/20050425/d1280606/spamscanall.bin