SpamAssassin SQL User Preferences

Jones, Chris chris.jones at ATMOSENERGY.COM
Mon Sep 27 17:17:24 IST 2004


I have configured the auto white list based on spamassassin sql querry
to work as expected. So it seems that the sql functionality is working
just not userprefs. I have also upgraded to MailScanner-4.34.6-1

Sep 27 11:14:56 dfw1wu22 MailScanner[9276]: Message i8RGEqr8009293 from
172.16.6.199 (spamsender at aol.com) to u22.atmosenergy.com is spam,
SpamAssassin (score=216.179, required 5, ALL_TRUSTED -2.82, AWL 218.82,
NO_REAL_NAME 0.18)

-----Original Message-----
From: Jones, Chris 
Sent: Monday, September 27, 2004 9:33 AM
To: 'MAILSCANNER at JISCMAIL.AC.UK'
Subject: RE: SpamAssassin SQL User Preferences


What version are you running? I am running mailscanner-4.33.3-1. Could
this release be the problem? 

FYI--

I am seeing the same thing. It looks like MailScanner does not utilize
SpamAssassin's sql userprefs lookup.


Here is the log from spamassassin using sql to get user Prefs ( ie spamd
-D -q ). This will correctly identify the sender as a spammer.

# echo -e "From:spamsender at aol.com\nTo:user\Subject: Test\n\n" | spamc
-u '$GLOBAL'
Received: from localhost by u22.atmosenergy.com
        with SpamAssassin (version 3.0.0);
        Mon, 27 Sep 2004 09:20:29 -0500
From: spamsender at aol.com
To: user\Subject: Test
X-Spam-Flag: YES
X-Spam-Checker-Version: SpamAssassin 3.0.0 (2004-09-13) on
        u22.atmosenergy.com
X-Spam-Level: **************************************************
X-Spam-Status: Yes, score=101.2 required=5.0
tests=ALL_TRUSTED,MISSING_DATE,
        MISSING_SUBJECT,NO_REAL_NAME,TO_MALFORMED,USER_IN_BLACKLIST
        autolearn=no version=3.0.0
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----------=_415821AD.24225098"

This is a multi-part message in MIME format.

This is the log from the MailScanner. It does not appear to be using the
SQL to get userprefs.

# maillog
Sep 27 09:18:03 u22 MailScanner[4790]: Spam Checks: Starting Sep 27
09:18:03 u22 MailScanner[4790]: Spam Checks completed at 851 bytes per
second Sep 27 09:18:03 u22 MailScanner[4790]: Virus and Content
Scanning: Starting Sep 27 09:18:04 u22 MailScanner[4790]: Content
Checks: Need to convert HTML to plain text in 1 messages Sep 27 09:18:04
u22 MailScanner[4790]: Virus Scanning completed at 851 bytes per second
Sep 27 09:18:04 u22 MailScanner[4790]: Uninfected: Delivered 1 messages
Sep 27 09:18:04 u22 MailScanner[4790]: Virus Processing completed at 851
bytes per second Sep 27 09:18:04 u22 MailScanner[4790]: Disinfection
completed at 851 bytes per second Sep 27 09:18:04 u22 MailScanner[4790]:
Batch completed at 851 bytes per second (851 / 1) Sep 27 09:18:04 u22
sendmail[4805]: i8REHxmB004791: to=chris.jones at atmosenergy.com,
delay=00:00:05, xdelay=00:00:00, mailer=relay, pri=120347,
relay=mail.atmosenergy.com. [0.0.0.0], dsn=2.0.0, stat=Sent
(i8RED2k0027140 Message accepted for delivery)

-----Original Message-----
From: MailScanner mailing list [mailto:MAILSCANNER at JISCMAIL.AC.UK] On
Behalf Of Edmond Yeoh
Sent: Sunday, September 26, 2004 4:54 AM
To: MAILSCANNER at JISCMAIL.AC.UK
Subject: SpamAssassin SQL User Preferences


Hi everyone,

I am re-sending this email as my initial email was rejected by the list
server. My apologies if you are getting 2 copies of this email.

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. Is there a way I can do this without running spamc or
spamd ? What is the best way to workaround this issue?

Any kind of help / comments would be greatly appreciated. Thanks!

Regards,
Edmond Yeoh

------------------------ 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).

------------------------ 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).



More information about the MailScanner mailing list