Amavis doesn't get the right spam score values from policy table in MySQL

[Tomaž]

Thank you Damian and Indunil, it took a while for me to get to 
production server, but now I switched from DBI:mysql to DBI:MariaDB and 
it works.

Greetings!
Tomaž


On 2024-03-29 03:48, Indunil Jayasooriya wrote:
> Damian, Yes, You and I discussed this in this list before.
> 
> Here's the URL.
> 
> https://www.mail-archive.com/amavis-users@amavis.org/msg06624.html
> 
> I am happily running in production on Alma Linux 9 with
> perl-DBD-MariaDB-1.21-16.el9_0.x86_64 and mariadb.
> 
> in amavisd.conf file.
> 
> @lookup_sql_dsn =  (
> ['DBI:MariaDB:database=amavisdb;host=127.0.0.1;port=3306', 'myadmin',
> 'justpassword']);
> 
> Here are others.
> 
> # cat /etc/redhat-release
> AlmaLinux release 9.2 (Turquoise Kodkod)
> 
> # rpm -qa |grep -i amavis
> perl-Amavis-2.13.0-4.el9.noarch
> amavis-2.13.0-4.el9.noarch
> 
> # rpm -qa |grep -i mariadb
> MariaDB-shared-10.11.5-1.el9.x86_64
> MariaDB-common-10.11.5-1.el9.x86_64
> MariaDB-client-10.11.5-1.el9.x86_64
> MariaDB-server-10.11.5-1.el9.x86_64
> perl-DBD-MariaDB-1.21-16.el9_0.x86_64
> 
> Hi, Tomaz, the above will help you.
> 
> On Thu, Mar 28, 2024 at 4:43 PM Damian <amavis at arcsin.de> wrote:
> 
>>> Is this temporary fix safe to use
>> 
>> I have not seen feedback on Gitlab or amavis-users that it lead to
>> problems.
>> 
>>> until a new version of perl-DBD-MySQL is released for RHEL9 (and
>> AlmaLinux9 and others)?
>> 
>> Unless some changed their mind, there won't be a fix in
>> perl-DBD-MySQL.
>> Instead you can try with perl-DBD-MariaDB and DBI:MariaDB as
>> *sql_dsn.
> 
> --
> 
> cat /etc/motd
> 
> Thank you
> Indunil Jayasooriya
> http://www.theravadanet.net/