Re: Rebuilding SpamProbe database

On 2008.10.14 16:53:20, you,
 the extraordinary Thomas Schrger, emitted:

> 
> what is the best way to clean (i.e., export and import) a SpamProbe 
> database to reduce
> its size?
> 
> Some readme.txt suggests using
> 
> cd ~
> mkdir new.spamprobe
> spamprobe export | spamprobe -d new.spamprobe import
> mv .spamprobe old.spamprobe
> mv new.spamprobe .spamprobe
> 
> Is this feasible on a production system where mail can come in at any 
> time? I've
> experienced serious issues with that (SpamProbe hanging, qmail lockups, 
> destroyed
> SpamProbe databases). It seems that SpamProbe doesn't like this kind of 
> rebuilding
> while it is running, at least with BerkeleyDB.

I use SpamProbe with BerkeleyDB, but with mbox files, not the
scheme used by qmail, so this may not be relevant. The script
I use - also based on a readme.txt from some years ago - is:

#!/bin/sh
if [ -e ~/.spamprobe/sp_words ];then
cd .spamprobe
cp sp_words sp_words.old
/opt/local/bin/spamprobe cleanup 3 17 1024 365
/usr/local/BerkeleyDB.4.7/bin/db_dump sp_words|/usr/local/BerkeleyDB.4.7/bin/db_load sp_words.new
mv sp_words.new sp_words
fi

I have never noticed any problems.

(Mac OSX 10.4.11 (unix), spamprobe 1.4d)

Cheers, N.

-- 
Nollaig MacKenzie
http://www.amhuinnsuidhe.net

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/