MailScanner + SA with MySQL userprefs

Steve Freegard steve.freegard at
Fri Jan 29 13:44:23 GMT 2010

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 

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.


More information about the MailScanner mailing list