MailScanner + SA with MySQL userprefs

[Steve Freegard]

On 29/01/10 13:31, Jonathan Respeto wrote:
> Hi,
>
> Trying to setup MailScanner to use SpamAssassin with a MySQL DB for
> the userprefs.
>
> This is to use Squirrelmail with SpamAssassin+SQL Plugin
>
> I am able to do it with out MailScanner but then I lose Virus Scanning.
> The SA docs says "spamd can use SQL user_prefs by calling it with the
> -q or -Q flags."
>
> How does MailScanner call SA? Is there a way I can add the -q option
> when SA is run? If there is where? Where does MailScanner gets SA
> configs from?
>
> My setup is on CentOS 5.4 with just the basics.
> Apache, sendmail, MySQL, MailScanner, SpamAssassin, Squirrelmail with
> SpamAssassin+SQL Plugin.
>

Can't be done as MailScanner calls the SpamAssassin libraries directly 
under a single user and does not use spamd (which implements the 
user_prefs).

See the list archives; I posted a plug-in some time ago that implements 
spamd support in MailScanner - however it's not been tested much and 
would require a bit of extra logic to work out which user should be sent 
to SpamAssassin as in the case of multi-recipient messages user 
preferences become quite 'tricky' to implement.

Regards,
Steve.