MailScanner+SpamAssassin SQL User Preferences

[Julian Field]

<x-flowed>
At 08:26 26/09/2004, you wrote:
>Hi everyone,
>
>I would like to ask if anyone have managed to load user-based spam
>rules from a mysql database.
>
>I have did the following in the configuration file, but it does not work.
>
>   user_scores_dsn                       DBI:mysql:spam:localhost
>   user_scores_sql_username        spam
>   user_scores_sql_password        pass
>   user_scores_sql_table               userpref
>
> >From my research so far, I found out that MailScanner's use of
>spamassassin does not use the spamc / spamd but calls the perl
>function library directly.
>
>Can anyone provide some hints on what can be done to load the user
>spam rules from a database? Any kind of help / comments would be
>greatly appreciated. Thanks!

When MailScanner is running on a message, there is no way for it to know
the final recipient address, as that is only determined by the MTA
immediately before it calls the local mail delivery agent (MDA). So
MailScanner wouldn't know what to look up.

There is code in CustomConfig.pm that will implement per-user white and
blacklists for you in MailScanner.
--
Julian Field
www.MailScanner.info
Professional Support Services at www.MailScanner.biz
MailScanner thanks transtec Computers for their support
Buy the MailScanner book at www.MailScanner.info/store

PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654

------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the MAQ (http://www.mailscanner.biz/maq/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).
</x-flowed>