perl-DBD-MySQL (Fedora 24)

[Alan Munday]

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