HELP! I cant get this figured out for the life of me. Here is what I have...
I have SA 3.0.2, using a Postgres database to store user preferences. When I run a test instance and pass a test message to it (using spamc and spamd) and the blacklist_from entries never get read... Here is my local.cf: ---------------------------------------------------------------------------- user_scores_dsn DBI:Pg:dbname=exim;host=localhost user_scores_sql_username spam user_scores_sql_password pass user_scores_sql_custom_query SELECT preference, value FROM userpref WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username = '%'||_DOMAIN_ ORDER BY username ASC # ........................................................................ # These values can be overridden by editing ~/.spamassassin/user_prefs.cf # (see spamassassin(1) for details) # These should be safe assumptions and allow for simple visual sifting # without risking lost emails. required_hits 5 report_safe 0 rewrite_header Subject [SPAM] # Default template. Try to keep it under 78 columns (inside the the dots below). # ........................................................................ clear_report_template report Spam detection software, running on the system "_HOSTNAME_", has report processed this incoming email If you have any questions, see report _CONTACTADDRESS_ for details. report report Content analysis details: (_SCORE_ points) report report " pts rule name description" report ---- ---------------------- -------------------------------------------------- report _SUMMARY_ # ........................................................................ ---------------------------------------------------------------------------- This file, along with a duplicate of the other files in my /etc/mail/spamassassin folder are stored in /etc/mail/test. I run the following as the test server: ---------------------------------------------------------------------------- spamd -x -q -D -C /etc/mail/test --siteconfigpath=/etc/mail/test -p 9898 ---------------------------------------------------------------------------- And this for the test client: ---------------------------------------------------------------------------- spamc -d localhost -p 9898 -u [EMAIL PROTECTED] < mb2 ---------------------------------------------------------------------------- Here are the contents of mb2 ---------------------------------------------------------------------------- >From [EMAIL PROTECTED] Wed Feb 2 10:10:15 2005 Return-Path: <[EMAIL PROTECTED]> X-Originating-IP: [66.194.13.227] X-Originating-Email: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] From: "Kevin Marvin" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Test Message from CLI Date: Wed, 02 Feb 2005 16:09:21 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 02 Feb 2005 16:10:02.0339 (UTC) FILETIME=[A6A6A330:01C50941] This is a test / demo message. It should / should not get tagged based on the SQL settings. I used this message from another mailbox as a template for the header content. - Kevin ---------------------------------------------------------------------------- And here is the log from the server... ---------------------------------------------------------------------------- logmsg: connection from Safe02 [127.0.0.1] at port 35842 debug: Conf::SQL: executing SQL: SELECT preference, value FROM userpref WHERE username = '[EMAIL PROTECTED]' OR username = '$GLOBAL' OR username = '%'||'architel.com' ORDER BY username ASC debug: retrieving prefs for [EMAIL PROTECTED] from SQL server debug: user has changed debug: bayes: no dbs present, cannot tie DB R/O: /usr/exim/.spamassassin/bayes_toks debug: Score set 1 chosen. logmsg: processing message (unknown) for [EMAIL PROTECTED]:501. debug: bayes: no dbs present, cannot tie DB R/O: /usr/exim/.spamassassin/bayes_toks debug: metadata: X-Spam-Relays-Trusted: debug: metadata: X-Spam-Relays-Untrusted: debug: ---- MIME PARSER START ---- debug: main message type: text/plain debug: parsing normal part debug: added part, type: text/plain debug: ---- MIME PARSER END ---- debug: decoding: no encoding detected debug: URIDNSBL: domains to query: debug: Running tests for priority: 0 debug: running header regexp tests; score so far=0 debug: running body-text per-line regexp tests; score so far=0 debug: running uri tests; score so far=0 debug: running raw-body-text per-line regexp tests; score so far=0 debug: running full-text regexp tests; score so far=0 debug: Running tests for priority: 500 debug: running meta tests; score so far=0 debug: running header regexp tests; score so far=0 debug: running body-text per-line regexp tests; score so far=0 debug: running uri tests; score so far=0 debug: running raw-body-text per-line regexp tests; score so far=0 debug: running full-text regexp tests; score so far=0 debug: auto-learn: currently using scoreset 1. debug: auto-learn: message score: 0, computed score for autolearn: 0 debug: auto-learn? ham=0.1, spam=12, body-points=0, head-points=0, learned-points=0 debug: auto-learn? yes, ham (0 < 0.1) debug: Learning Ham debug: all '*From' addrs: [EMAIL PROTECTED] debug: all '*To' addrs: [EMAIL PROTECTED] debug: lock: 2844 created /usr/exim/.spamassassin/bayes.lock.Safe02.architel.com.2844 debug: lock: 2844 trying to get lock on /usr/exim/.spamassassin/bayes with 0 retries debug: lock: 2844 link to /usr/exim/.spamassassin/bayes.lock: link ok debug: bayes: 2844 tie-ing to DB file R/W /usr/exim/.spamassassin/bayes_toks debug: bayes: 2844 tie-ing to DB file R/W /usr/exim/.spamassassin/bayes_seen debug: bayes: found bayes db version 0 debug: bayes: new db, set db version 3 and 0 tokens debug: tokenize: header tokens for *p = "U*kevin.marvin D*gmail.com D*com" debug: tokenize: header tokens for X-Originating-IP = " [66.194.13.227]" debug: tokenize: header tokens for X-Originating-Email = " [EMAIL PROTECTED]" debug: tokenize: header tokens for *F = "U*kevin.marvin D*gmail.com D*com" debug: tokenize: header tokens for To = "U*kevin D*architel.com D*com" debug: tokenize: header tokens for Mime-Version = " 1.0" debug: tokenize: header tokens for *c = " /plain; format=flowed" debug: tokenize: header tokens for *RT = " " debug: tokenize: header tokens for *RU = " " debug: bayes: Learned '[EMAIL PROTECTED]', atime: 1107320400 debug: bayes: 2844 untie-ing debug: bayes: 2844 untie-ing db_toks debug: bayes: 2844 untie-ing db_seen debug: bayes: files locked, now unlocking lock debug: unlock: 2844 unlink /usr/exim/.spamassassin/bayes.lock debug: is spam? score=0 required=2 debug: tests= debug: subtests=__RATWARE_0_TZ_DATE logmsg: clean message (0.0/2.0) for [EMAIL PROTECTED]:501 in 0.4 seconds, 670 bytes. logmsg: result: . 0 - scantime=0.4,size=670,mid=(unknown),autolearn=ham ---------------------------------------------------------------------------- As you can see, the message is not getting blacklisted. Any light you can shed is appreciated. - Kevin