Re: Bayes in V4 compared to V3

Bill Cole <[email protected]>
Newsgroups gmane.mail.spam.spamassassin.general
Message-ID <[email protected]>
On 2024-11-12 at 00:33:13 UTC-0500 (Tue, 12 Nov 2024 00:33:13 -0500)
Shawn Iverson <[email protected]>
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
[email protected] or [email protected]
(AKA @[email protected] and many *@billmail.scconsult.com addresses)
Not Currently Available For Hire
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.