On policy_id=9 in your database, what are the values of the following columns?
Spam_tag_level Spam_tag2_level Spam_kill_level Thanks -----Original Message----- From: amavis-users [mailto:[email protected]] On Behalf Of Alan Munday Sent: Tuesday, January 2, 2018 10:41 AM To: [email protected] Subject: Re: perl-DBD-MySQL (Fedora 24) On 31/12/17 11:24, Alan Munday wrote: > On 30/12/17 15:55, Alan Munday wrote: >> On 26/11/16 15:17, Alan Munday wrote: >>> >>> Found an issue following an update to perl-DBD-MySQL (4.039-1.fc24 >>> arrived here 2016-11-24) after which amavisd-new was scanning mail >>> as clean and processing as spam. >>> >>> I'm using SQL lookups and found this affected versions 2.11.0-4 and >>> 2.10.1-7 of amavisd-new on my systems. >>> >>> >>> Downgrading perl-DBD-MySQL appears to have resolved the problem. >> >> >> A bit of a repeat but I'm now seeing similar behaviour having >> upgraded a mail server to Fedora 27 (perl-DBD-MySQL-4.043-6) >> >> Currently amavis is passing mail with scores <0 but processing as >> spam for scores > 0 < SPAM_THRESHOLD >> >> >> Anyone else running amavisd-new on Fedora 27 with SQL back end, and >> running OK? >> > > > Having increased the log level I can see the following: > > > For amavis running on Fedora 26 (using perl-DBD-MySQL-4.037) > > Dec 31 11:07:48 mx1 amavis[17513]: (17513-01) calling SA parse (0), SA > vers 3.4.1, 3.004001, data as STRING_REF, recips_ind [0], user: "amavis" > > > > For amavis running on Fedora 27 (using perl-DBD-MySQL-4.043) > > Dec 31 10:44:55 mx3 amavis[4182]: (04182-01) calling SA parse (0), SA > vers 3.4.1, 3.004001, data as GLOB, recips_ind [0], user: "amavis" The above turned out to be a red herring. I've spent some hours looking through logs at loglevel 5 and while I can see what is happening (that mails scoring less than the spam score are being treated as spam) I don't know why. If anyone wouldn't mind looking at an example log, I've posted a sample at https://pastebin.com/GNNs3Vbz Thanks Alan
