I installed spamassassin 3.0.4 and qmail-scanner and clam together with
the SQL feature described at http://wiki.apache.org/spamassassin/UsingSQL.
The problem is all mails are scored 0.0, and I cant figure out why. Any
hints why? I've included some logparts below which might give someone
more experienced a clue...
In the mail log i get the following.
Still running as root: user not specified with -u, not found, or set
to root. Fall back to nobody.
But I can see in the mysql log that it queries the following,
SELECT preference, value FROM userprefs WHERE username =
'[EMAIL PROTECTED] OR username = '$GLOBAL' OR username =
CONCAT('%','spamtest.persson.tm') ORDER BY username ASC
Which gives the following results.
+---------------+-------+
| preference | value |
+---------------+-------+
| required_hits | 5.0 |
| use_razor2 | 1 |
| use_pyzor | 1 |
| use_dcc | 1 |
| required_hits | 8 |
+---------------+-------+
And in the mailheader I get this, which alwaws is 0.0 for the spamscore.
Received: from xxx.xxx.xxx.206 by spam.3rex.net (envelope-from
<xadress(a)somehost>, uid 501) with qmail-scanner-1.25
(clamdscan: 0.86.1/955. spamassassin: 3.0.4.
Clear:RC:0(xxx.xxx.xxx.206):SA:0(0.0/5.0):.
Processed in 4.091793 secs); 08 Oct 2005 18:33:43 -0000
X-Spam-Status: No, hits=0.0 required=5.0
Best regards and thanks in advance,
Eric
