All my accounts are virtual in mysql. I have Mailscanner sitting between two copies of postfix, handling spamassassin, blacklists, and clamAV. Mailscanner supports almost every major *nix virus scanner, and was a breeze to set up.
My mail servers with mailscanner first scan for virii, then check against blacklists, then run SA. You can delete messages before SA if it has triggered 1 or more blacklists too.
Look up mailscanner. I'm using it with two gentoo servers.
On Fri, 2004-08-27 at 13:36, Ziekke wrote:
Hello, I'm trying to get SpamAssassin set up to locate all the user prefs from MySQL. The problem I am running into is that all my mail users are virtual users, none of them hae local accounts. Thus, setting spamd to use the userid calling spamc isn't really useful. Is there any way to get spamassassin to use the "to" e-mail address as the "userid" it looks up in the mysql tables? I looked all over for an option or something like that, and tried many combinations of commandline switches. Unfortunately the -V switch isn't very useful to me, however an extension off the -V would be exactly what I need. I've got php-sa up and running perfectly, I just need to figure out this part of the puzzle. Any assistance would be great. I am using spamassassin 2.64 commandline arguments are: --nouser-config --sql-config --auto-whitelist --username=spamfilter My sql-related things in local.cf are: user_scores_dsn DBI:mysql:spamassassin:localhost user_scores_sql_username *USERNAME* user_scores_sql_password *PASSWORD* user_scores_sql_table userpref user_scores_sql_field_username username user_scores_sql_field_preference preference user_scores_sql_field_value value user_scores_sql_field_scope spamassassin
