SA userprefs stored in SQL

[Julian Field]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Rakesh wrote:

> Jonathan Higgins wrote:
>
>> I looked through the customconfig, and found the section talking about
>> white/black lists per domain.... which is not what im looking for.
>>
>> global storage of user preferences.  thats what I need.  Spamassassin
>> provides it only in thier client server configuration.  I want to 
>> continue
>> to use spamassassin the way that MailScanner wants to.
>>
>> anyone else out there doing this?.. are you running spamd/spamc?  and 
>> so on..
>>
>>
>>  
>>
> Unfortunately its not possible to use userwise prefs in Mysql for SA 
> (I realised this recently) if you are using MailScanner.  SA needs to 
> switch user its is running as to load the prefs of the user from SQL, 
> but incase of MailScanner SA is always invoked as the user which is 
> running the MailScanner processes, also since MailScanner processes 
> mails in batches and compiles (i.e. loads rulesets and other params) 
> SA modules once per batch its not possible to switch user and invoke 
> SA from within MailScanner. One time compilation of SA (per batch) in 
> MailScanner makes anti-spam checks more efficient. Things would become 
> worse if MailScanner had to compile SA per message.

It doesn't even load rulesets and SA modules once per batch (though it 
has to do that for MCP). It loads the rulesets and SA modules once every 
restart (by default every 4 hours, see "Restart Every") so that it is as 
fast as I can make it.

If you have to compile SA for every message, things get really slow. The 
same sort of lack of speed that most of my competitors have. :-)

- -- 
Julian Field
www.MailScanner.info
Buy the MailScanner book at www.MailScanner.info/store
Professional Support Services at www.MailScanner.biz
MailScanner thanks transtec Computers for their support

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


-----BEGIN PGP SIGNATURE-----
Version: PGP Desktop 9.0.1 (Build 2185)

iQA/AwUBQqG3lBH2WUcUFbZUEQJyqgCgwiZtcHs19FWs7uakK0i362VDXtYAn1tJ
ugBPVuZUcYvkjcgVzfZOQvLG
=xCpI
-----END PGP SIGNATURE-----

------------------------ 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 Wiki (http://wiki.mailscanner.info/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).

Support MailScanner development - buy the book off the website!