On 2024-11-12 at 00:33:13 UTC-0500 (Tue, 12 Nov 2024 00:33:13 -0500)
Shawn Iverson <shawniver...@gmail.com>
is rumored to have said:
[...]
> The "-D bayes" parameter was quite informative. Thank you. Turns out the
> database wasn't being read properly with the bayes_store_module in use.
> Maybe it has something to do with the database collation and character set
> in use (utf8mb4).
>
> Doing this appears to resolve the issue, at least for MariaDB 10.5.22:
>
> Change from:
>
> bayes_store_module Mail::SpamAssassin::BayesStore::SQL
>
> Change to:
>
> bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
As documented:
# perldoc Mail::SpamAssassin::BayesStore::SQL
NAME
Mail::SpamAssassin::BayesStore::SQL - SQL Bayesian Storage Module
Implementation
DESCRIPTION
This module implements a SQL based bayesian storage module. It's
compatible with SQLite and possibly other standard SQL servers.
Do not use this for MySQL/MariaDB or PgSQL, they have their own specific
modules.
--
Bill Cole
b...@scconsult.com or billc...@apache.org
(AKA @grumpybozo@toad.social and many *@billmail.scconsult.com addresses)
Not Currently Available For Hire
