perl-DBD-MySQL (Fedora 24)

[Dino Edwards]

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: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]: (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