Hi all, I am using a Gentoo system with amavisd-new-2.6.1-r1
My setup uses a postgres db to determine policy. Everything seems to be working except the subject line tagging. My understanding is that if the spam_tag_level column value is lower than the score of a mail, spam headers are added, and it is safe to set this to -999. I also believe if the value of spam_tag2_level is lower than the mail's score, the subject line is modified. Please correct me if my thinking is wrong. In my case, if spam_tag_level is lower than the mail score, it modifies the subject. If not, it doesn't do anything to headers at all. Here's a sample log entry: Jul 28 15:49:27 rosie amavis[888]: (00888-01) SPAM-TAG, <removed> -> <removed>, No, score=2.754 tagged_above=-999 required=5 tests=[AWL=-0.245, RDNS_NONE=0.1, TVD_SPACE_RATIO=2.899] Jul 28 15:49:27 rosie amavis[888]: (00888-01) FWD via SMTP: <removed> -> <removed>,BODY=7BIT 250 2.0.0 Ok, id=00888-01, from MTA([127.0.0.1]:10026): 250 2.0.0 Ok: queued as 99E9957834D Jul 28 15:49:27 rosie amavis[888]: (00888-01) Passed CLEAN, [removed] [removed] <removed> -> <removed>, Message-ID: <200907281549.04136>, mail_id: MsiAgAGMAwg9, Hits: 2.754, size: 1464, queued_as: 99E9957834D, 5234 ms This message came through with ***SPAM*** in the subject. Relevant headers: X-Spam-Flag: NO X-Spam-Score: 2.754 X-Spam-Level: ** X-Spam-Status: No, score=2.754 tagged_above=-999 required=5 tests=[AWL=-0.245, RDNS_NONE=0.1, TVD_SPACE_RATIO=2.899] Subject: ***SPAM***test001 In case it matters, here is my db schema: Column | Type | Modifiers -----------------------+--------------+----------- email_user_id | integer | not null virus_lover | boolean | not null spam_lover | boolean | not null banned_files_lover | boolean | not null bad_header_lover | boolean | not null bypass_virus_checks | boolean | not null bypass_spam_checks | boolean | not null bypass_banned_checks | boolean | not null bypass_header_checks | boolean | not null spam_modifies_subj | boolean | not null spam_tag_level | numeric(6,2) | not null spam_tag2_level | numeric(6,2) | not null spam_kill_level | numeric(6,2) | not null spam_dsn_cutoff_level | numeric(6,2) | not null warnvirusrecip | boolean | not null warnbannedrecip | boolean | not null warnbadhrecip | boolean | not null spam_subject_tag | text | Indexes: "email_filters_pkey" PRIMARY KEY, btree (email_user_id) Foreign-key constraints: "email_filters_email_user_id_fkey" FOREIGN KEY (email_user_id) REFERENCES email_users(id) Also, my policy query: $sql_select_policy = 'SELECT email_filters.*, users.id FROM email_filters,users WHERE email_filters.email_user_id = users.id AND users.name IN (%k)'; If someone can figure out what I'm doing wrong, it would be greatly appreciated. Nick ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/