perl-DBD-MySQL (Fedora 24)
dino.edwards at mydirectmail.net
Tue Jan 2 17:21:03 CET 2018
On policy_id=9 in your database, what are the values of the following columns?
From: amavis-users [mailto:amavis-users-bounces+dino.edwards=mydirectmail.net at amavis.org] On Behalf Of Alan Munday
Sent: Tuesday, January 2, 2018 10:41 AM
To: amavis-users at amavis.org
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-01) calling SA parse (0), SA
> vers 3.4.1, 3.004001, data as STRING_REF, recips_ind , user: "amavis"
> For amavis running on Fedora 27 (using perl-DBD-MySQL-4.043)
> Dec 31 10:44:55 mx3 amavis: (04182-01) calling SA parse (0), SA
> vers 3.4.1, 3.004001, data as GLOB, recips_ind , 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
More information about the amavis-users