Re: Bayes, possibly other network-dependent rules, intermittently not "working"

Bill Cole <[email protected]> Thu, 16 Oct 2025 10:30:54 -0400

Newsgroups	gmane.mail.spam.spamassassin.general
Message-ID	<[email protected]>

On 2025-10-16 at 09:48:23 UTC-0400 (Thu, 16 Oct 2025 09:48:23 -0400)
Ricky Boone <[email protected]>
is rumored to have said:

> Bayes is using the Mail::SpamAssassin::BayesStore::SQL store module
> with DBI:mysql (the actual backend server is MariaDB, though).

Oh, wait... This is BAD. See below

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

Use the right plugin. Wipe the DB first, as you may have mangled it by 
using the wrong plugin.


-- 
  Bill Cole
  [email protected] or [email protected]
  (AKA @[email protected] and many *@billmail.scconsult.com 
addresses)
  Not Currently Available For Hire