Hi, > Jozef Matický <cibula at gamepub.sk > <http://lists.amavis.org/cgi-bin/mailman/listinfo/amavis-users>> 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 > <http://lists.amavis.org/cgi-bin/mailman/listinfo/amavis-users>) > 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 > <http://lists.amavis.org/cgi-bin/mailman/listinfo/amavis-users>") />//>/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 > <http://lists.amavis.org/cgi-bin/mailman/listinfo/amavis-users>;;/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 > <http://lists.amavis.org/cgi-bin/mailman/listinfo/amavis-users> />//>/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 I will try to start looking in the problem (I still think it is a bug in dbd-mysql, dbd-postgresql doesn't have that issue). Can someone with the problem mail me its amavis configuration? And maybe some instructions for reproducing the problem? (in private if you think your configuration contains sensitive information)
Thanks in advance Alex - Debian amavisd-new maintainer
