Amavis on Alma Linux 8 with Quarantined issue.

[Indunil Jayasooriya]

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 <amavis at 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20230925/df4c1b8e/attachment.htm>