mysql lookups - messages with score less than 0 are blocked as spam

[Jozef Matický]

Hello Alan,

You are right, that was it. Just checked the install log, and 
perl-DBD-MySQL was upgraded to 4.40 from 4.37 yesterday (Mon Dec 12 
04:42:42 2016 >>> dev-perl/DBD-mysql-4.40.0).
Downgrading it back to 4.37 solved the problem, now Amavis is returning 
correct values for SA scores. This is on Gentoo.
Should this maybe be reported somewhere as a bug?

Thanks a lot anyways.

On 13. 12. 2016 16:55, Alan Munday wrote:
> On 13/12/16 15:20, Jozef Matický wrote:
>> 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):
>
>
> I saw a similar behaviour on Fedora 24
>
> Have a look at your version of perl-DBD-MySQL and maybe try 
> downgrading it.
>
> Alan
>