Hi Damian, Thanks a lot. you saved my time.
Below 5 lines solved the issue. ALTER TABLE policy MODIFY spam_tag_level varchar(10) NULL; ALTER TABLE policy MODIFY spam_tag2_level varchar(10) NULL; ALTER TABLE policy MODIFY spam_kill_level varchar(10) NULL; ALTER TABLE policy MODIFY spam_dsn_cutoff_level varchar(10) NULL; ALTER TABLE policy MODIFY spam_quarantine_cutoff_level varchar(10) NULL; I also want to know if these modifications will affect some other things? In addition, I can see two more float values. in TABLE msgs, spam_level float and in TABLE msgrcpt, bspam_level float I did not alter these. Should I need to alter in the following manner? ALTER TABLE msgs MODIFY spam_level varchar(10); ALTER TABLE msgrcpt MODIFY bspam_level varchar(10); Hope to hear from you. Anyway, perl-DBD-MariaDB is available for Alma Linux 9. https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwjQ-NDEiMaBAxV3fGwGHQlaCbkQFnoECBMQAQ&url=https%3A%2F%2Falmalinux.pkgs.org%2F9%2Falmalinux-appstream-x86_64%2Fperl-DBD-MariaDB-1.21-16.el9_0.x86_64.rpm.html&usg=AOvVaw15J8rvvSTZIGg2v9QgurJH&opi=89978449 Another option will be using Alma Linux 9 instead of Alma LInux 8 since CentOS 7 is set to reach its end-of-life (EOL) on June 30, 2024. I will have to try with AlmaLinux 9. On Mon, Sep 25, 2023 at 5:18 PM Damian <ama...@arcsin.de> wrote: > > Could you please come up with your ideas? > > Not sure, but it sounds like another case of [1]. The quickest > workaround would be to use `DBI::MariaDB` instead of `DBI::mysql` in > @lookup_sql_dsn. However it seems that perl-DBD-MariaDB is not shipped > with AlmaLinux 8. You could try [2] instead. > > [1] https://gitlab.com/amavis/amavis/-/issues/7 > [2] https://gitlab.com/amavis/amavis/-/issues/7#note_967007752 > > -- cat /etc/motd Thank you Indunil Jayasooriya http://www.theravadanet.net/