Mailing-List: contact users-help@spamassassin.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (nike.apache.org: domain of
 sf-spamassassin-talk@m.gmane.org designates 80.91.229.3 as permitted sender)
To: users@spamassassin.apache.org
From: Walter Hurry <walterhurry@gmail.com>
Subject: Re: Bayes - Problem using SQLite: SOLVED
Date: Thu, 21 Mar 2013 03:07:44 +0000 (UTC)
Lines: 22
Message-ID: <kidti0$u63$1@ger.gmane.org>
References: <kiadu9$f1b$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508
	git://git.gnome.org/pan2)

On Tue, 19 Mar 2013 19:22:49 +0000, Walter Hurry wrote:

> I am experimenting with using SQLite for my Bayes db.
> 
> However when I start spamd, it reports the following in
> /var/log/maillog:
> 
> bayes: tok_get_all: SQL error: no such function: RPAD
> 
> This is correct, in that SQLite does not support RPAD.
> 
> I believe this call is in SQL.pm (part of
> Mail::SpamAssassin::BayesStore).
> Is it possible to hack that module in any way to work around the issue?
> 
> Sorry if this is too simple a question; whilst I am familiar with SQL, I
> know nothing of perl.
> 
> In case it matters, this is SA 3.3.2

It looks to be solved by hacking SQL.pm. I'll report back in a day or so 
in case anyone is interested.