Well, I didnt re-learn it and now it works awsome. Also when I try to learn already learned mail I get that id didn`t learn as DB already contains same tokens.
So config error was storing tokens in OK way, but it was reading them wrong. Now all my bayes issues are gone this is like night and day differenc now :) Regards,Gregor ________________________________ From: hg user <mercurialu...@gmail.com> Sent: Tuesday, 12 November 2024 13:58 To: Grega Cc: users@spamassassin.apache.org Subject: Re: Bayes in V4 compared to V3 Yes Il Mar 12 Nov 2024, 13:53 Grega via users <users@spamassassin.apache.org<mailto: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<mailto:sausers-20150...@billmail.scconsult.com>> Sent: Tuesday, 12 November 2024 13:35 To: users@spamassassin.apache.org<mailto: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<mailto: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<mailto:b...@scconsult.com> or billc...@apache.org<mailto:billc...@apache.org> (AKA @grumpybozo@toad.social and many *@billmail.scconsult.com<http://billmail.scconsult.com> addresses) Not Currently Available For Hire
