Re: Bayes in V4 compared to V3

Yes

Il Mar 12 Nov 2024, 13:53 Grega via users <[email protected]>
ha scritto:

> If we used SQL and now switched to MySQL do we have to re-train bayes?
>
> ------------------------------
> *From:* Bill Cole <[email protected]>
> *Sent:* Tuesday, 12 November 2024 13:35
> *To:* [email protected]
> *Subject:* Re: Bayes in V4 compared to V3
>
> 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.
>
>
>
>    [email protected] or [email protected]
>    (AKA @[email protected] and many *@billmail.scconsult.com addresses)
>    Not Currently Available For Hire
>
>