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 > >
