SpamAssassin SQL User Preferences

[Jones, Chris]

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