Yes Il Mar 12 Nov 2024, 13:53 Grega via users <users@spamassassin.apache.org> ha scritto:
> If we used SQL and now switched to MySQL do we have to re-train bayes? > > ------------------------------ > *From:* Bill Cole <sausers-20150...@billmail.scconsult.com> > *Sent:* Tuesday, 12 November 2024 13:35 > *To:* users@spamassassin.apache.org > *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 <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. > > > > b...@scconsult.com or billc...@apache.org > (AKA @grumpybozo@toad.social and many *@billmail.scconsult.com addresses) > Not Currently Available For Hire > >