SA userprefs stored in SQL

[Martin Hepworth]

Jonathan

Short answer is no.

Long answer is...
MS calls SA via a perl function call. Therefore SA will 'think' it's 
being called by the MS user (as defined in MailScanner.conf) as thats 
the UID of the process running SA.

SHOULD there be any way of doing this you'd first have to split the 
emails into their unique recipients then pass off to SA. BUT so far 
we've only managed to do this in Sendmail and Exim. For other MTA's 
(Postfix/qmail etc) we've either not found a way (despite asking for 
help) or haven't looked.

Also alot of MS systems are gateway systems, so the end user may not be 
found in the email as it gets redirected via aliases etc on the actual 
email server, so emails might not get the correct SA preferences anyway.

--
Martin Hepworth
Snr Systems Administrator
Solid State Logic
Tel: +44 (0)1865 842300


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..
> 
> 
> 
> 
>>I am using the CustomConfig to do that, I had it working great on an old
>>server until a little hitch with MailScanner maintaining mysql connections
>>on the new one...  haven't had time to figure out the issue, but look at
>>CustomConfig.pm, I am using it to obtain if the domain should want mail
>>scanned, the score, actions, etc...
>>
>>-------------------------
>>Brian Taber
>>Manager/IT Specialist
>>Diverse Computer Group
>>Office: 508-758-4402
>>Cell: 508-496-9221
>>
>>This apparently has come up a few times in the past.  I may be asking
>>this in the wrong place, so if I need to post this question on the
>>spamassassin list please let me know.
>>
>>I even found a piece of information on the Faq-O-matic... here is an
>>excerpt.
>>
>>"..... problem is that SpamAssassin, according to what I've read at the
>>following http://spamassassin.apache.org/full/3.0.x/dist/sql/README,
>>will only use the DB for getting the user preferences if it's running in
>>client/server mode, i.e., as spamc and spamd.  So this means that if I
>>want to let end users manage their own whitelists, I would have to get
>>SpamAssassin running the old slow way.  Thoughts or suggestions? "
>>
>>After searching, I have not found a solution to this.  I am already
>>using a mysql bayes for my lvs mail cluster system.. I need a way to
>>store SA user preferences globally.. and i would rather not go back to
>>using spamc/spamd.
>>
>>thanks.
>>
>>
>>
>>Jonathan Higgins
>>IT R&D Project Manager
>>Kennesaw State University
> 
> 
> ------------------------ 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!

**********************************************************************

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote confirms that this email message has been swept
for the presence of computer viruses and is believed to be clean.	

**********************************************************************

------------------------ 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!