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
