Hello, I have a mostly-working setup that queries a database to determine a user's filter settings.
First, my understanding (so someone can correct me if I'm just wrong) is that it should add spam headers at the spam_tag_level. Then at spam_tag2_level it would add ***SPAM*** (or similar) to the subject line. The issue for me is that holds true if I use the config file variable settings. But when I activate the SQL lookups, it does this: X-Spam-Flag: NO X-Spam-Score: 4.066 X-Spam-Level: **** X-Spam-Status: No, score=4.066 tagged_above=2 required=6.31 tests=[ALL_TRUSTED=-1.44, AWL=-1.109, DNS_FROM_OPENWHOIS=2.431, MISSING_SUBJECT=1.285, TVD_SPACE_RATIO=2.899] autolearn=no Subject: ***SPAM*** How is it possible that X-Spam-Flag says NO yet it modifies the subject line? It does correctly read values for "tagged_above" and "required" from the database, if I change them it reflects in the headers. If I disable the SQL lookup it acts as I expect, not tagging subject until it reaches "tag2" level. Here's my table definition: 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) And my query: 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 point me in the right direction it would be greatly apprecfiated! ------------------------------------------------------------------------------ Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user Please visit http://www.ijs.si/software/amavisd/ regularly For administrativa requests please send email to rainer at openantivirus dot org