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
[email protected]
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
