mysql lookups - messages with score less than 0 are blocked as spam
Giovanni
giovanni at paclan.it
Fri Jan 13 19:08:51 CET 2017
Jozef Matický <cibula at gamepub.sk> wrote:
> [-- text/plain, encoding 8bit, charset: utf-8, 47 lines --]
>
> Hello,
>
> I have an amavisd-new (currently 2.8.1) with SA (currently 3.4.0)
> running for couple of years now and the same thing started happening to
> me today. It did work okay just couple of days ago. Not sure what the
> problem is, but it is the same as Dmitriy is describing:
>
> - Amavis is able to connect to MySQL
> - SQL query is working okay and returning correct values from database
> - Amavis is getting most of the results okay -> settings like
> spam_lover, virus_lover etc, however the values for scores are all zero (0):
>
> sql: preparing and executing (5 args): SELECT
> *,mail_users.id,mail_users.name AS sa_username FROM
> mail_users,mail_policy WHERE (mail_users.policy_id = mail_policy.id) AND
> (mail_users.name IN (?,?,?,?,?)) ORDER BY mail_users.id
> Dec 13 13:21:51 hostname amavis[27181]: (27181-01)
> lookup_sql(redacted at redacted.tld) matches, result=(id=>"28",
> user_id=>"1001", domain_id=>"20", policy_id=>"26", name=>"Default",
> description=>"", home=>"/srv/mail", maildir=>"redacted.tld/redacted",
> password=>"hidden", quota=>"0", used=>"0", id=>"28", user_id=>"1001",
> name=>"Default", description=>"", virus_lover=>"N", spam_lover=>"Y",
> banned_files_lover=>"Y", bad_header_lover=>"Y",
> bypass_virus_checks=>"N", bypass_spam_checks=>"N",
> bypass_banned_checks=>"N", bypass_header_checks=>"N",
> spam_tag_level=>"0", spam_tag2_level=>"0", spam_kill_level=>"0",
> message_size_limit=>"0", spam_subject_tag2=>"", id=>"28",
> sa_username=>"redacted at redacted.tld")
>
> This is with manual query taken from MySQL query log:
> Neznámá tabulka
> id;user_id;domain_id;policy_id;name;description;home;maildir;password;quota;used;id;user_id;name;description;virus_lover;spam_lover;banned_files_lover;bad_header_lover;bypass_virus_checks;bypass_spam_checks;bypass_banned_checks;bypass_header_checks;spam_tag_level;spam_tag2_level;spam_kill_level;message_size_limit;spam_subject_tag2;id;sa_username
> 28;1001;20;26;redacted at redacted.tld;;/srv/mail;redacted.tld/redacted;hidden;0;0;26;1001;Default;;N;Y;Y;Y;N;N;N;N;-100;6.2;20;0;;28;redacted at redacted.tld
>
> As stated before, it started today or maybe yesterday. Not sure if I
> reloaded amavisd recently. Last amavisd update was back in August and SA
> in May, however I can't tell if amavisd was reloaded back then. I did
> some Perl library updates as recommended by the packaging system couple
> of days ago, however nothing major.
> Pretty much I had to configure amavisd with SA static scores for now
> since most of the mail went to Spam folder with scores set to 0 instead
> of around 6 (X-Spam-Status: Yes, score=0.863 tagged_above=0 required=0).
>
> Any clues what might be wrong?
>
This could be the commit that caused the problem:
https://github.com/perl5-dbi/DBD-mysql/commit/caea0b774028650c0cbd9d8f9c4a0b47831116df
Giovanni
> Thank you.
>
More information about the amavis-users
mailing list