> 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
It looks to me like SA isn't finding the /share/spamassassin folder where all the rules and scores are defined. Bret
