I combine Spamassassin with MySQL and it seems to work just fine on a
domain-wide installation. My .qmail-default (for domain-wide filtering)
looks like this:
/usr/local/bin/spamc -f -u $EXT@$HOST | /home/vpopmail/bin/vdelivermail
This is OK, but I would like to have it differently:
1. Have it user based and just using it domain-wide if the domain
administrator wishes to (to reduce the overhead)
2. User based I would like to get rid of flat .qmail files and JUST use
MySQL to check wether a specific user want to be filtered and if yes
then get the spamfilter settings.
Normally it would be quite simple to have Step 1 configured, but since I
want to migrate vpopmail totally into MySQL (for different PHP Frontends
and other administrative purpose) this might be a little bit more
If there is no straightforward solution on that issue, is it possible to
set the domain-wide spamassassin config (
/etc/mail/spamassassin/local.cf ) NOT to check spam by default and then
override these settings per user from MySQL? In that case I could leave
.qmail-default as it is and still having a user based filtering.
Has anyone worked with that so far? I know that this is not the usual
way to user Spamassassin but there might be people out there who have
the same thoughts about MySQL ease as I.
Thanks for giving clues.