Re: SA-LEARN HANGING when database over 2000 SPAM messages

2006-03-03 Thread Marc Dufresne
I temporarily fixed the issue be replacing the bayes_toks file from the original starterDB. Luckily, I moved daily copies of my spam account to an archived location. It didn't take me long to feed SA. It seems the Berkley format is easily corrupted. I will have to get this ported over to SQL. Tha

Re: SA-LEARN HANGING when database over 2000 SPAM messages

2006-03-01 Thread Steve Thomas
> I think it was Steve that said his database is in SQL format. How do I > convert the spamassassin database on FreeBSD 5.4 to SQL? I used the procedure found on this page as a guide: http://www200.pair.com/mecham/spam/fc4-spamassassin-sql.html

RE: SA-LEARN HANGING when database over 2000 SPAM messages

2006-03-01 Thread Matthew.van.Eerde
Marc Dufresne wrote: > I think it was Steve that said his database is in SQL format. How do I > convert the spamassassin database on FreeBSD 5.4 to SQL? http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes -- Matthew.van.Eerde (at) hbinc.com 805.964.4554 x902 Hisp

Re: SA-LEARN HANGING when database over 2000 SPAM messages

2006-03-01 Thread Marc Dufresne
I think it was Steve that said his database is in SQL format. How do I convert the spamassassin database on FreeBSD 5.4 to SQL? I just renamed the bayes_toks file to .org and copied a backup over. Now sa-learn --sync and sa-learn --dump magic work. Marc Dufresne, Corporate IT Officer St. Lawrenc

RE: SA-LEARN HANGING when database over 2000 SPAM messages

2006-03-01 Thread Marc Dufresne
What are my options at this point to resolve the issue? Marc Dufresne, Corporate IT Officer St. Lawrence Parks Commission 13740 County Road 2 Morrisburg, ON K0C 1X0 E-mail: [EMAIL PROTECTED] Voice: 613-543-3704 Ext#2455 Fax: 613-543-2847 Corporate website: www.parks.on.ca >>> <[EMAIL PROTECTE

RE: SA-LEARN HANGING when database over 2000 SPAM messages

2006-02-28 Thread Matthew.van.Eerde
Steve Thomas wrote: >> -rw--- 1 root wheel 549775048704 Feb 28 10:47 bayes_toks > > I'll leave it to the experts to help you out here, but I would assume > that a token db that's apparently half a terrabyte in size is a > *slight* indication of a problem somewhere... ;) BerkeleyDB uses spa

Re: SA-LEARN HANGING when database over 2000 SPAM messages

2006-02-28 Thread Steve Thomas
> -rw--- 1 root wheel 549775048704 Feb 28 10:47 bayes_toks I'll leave it to the experts to help you out here, but I would assume that a token db that's apparently half a terrabyte in size is a *slight* indication of a problem somewhere... ;)

Re: SA-LEARN HANGING when database over 2000 SPAM messages

2006-02-28 Thread Marc Dufresne
SA-LEARN is still running from my daily cronjob Time: 399:04.25 Here is the ps -ax Output ps -ax | grep sa-learn 24906 ?? R399:04.25 /usr/local/bin/perl -T -w /usr/local/bin/sa-learn --s 37740 p0 RV 0:00.00 grep sa-learn (csh) Output from /root/.spamassassin (BayesDB stored here) -

Re: SA-LEARN HANGING when database over 2000 SPAM messages

2006-02-27 Thread C. Bensend
> I can't offer much assistance with your problem, but on the db size, I can > say that we were running it with around 25k spams and 25k hams learned, > with sa-learn running on shared imap folders every hour adding more. This is from this morning's sa-learn run: Total number of HAM messages : 1

Re: SA-LEARN HANGING when database over 2000 SPAM messages

2006-02-27 Thread Steve Thomas
> The first time I encountered this problem is when the spam database has > around 3000 SPAM and about 1 HAM, the database seems to become > corrupt. I start to receive PERL errors. > ... > Is there a problem with the database when it > reaches a certain size? I can't offer much assistance wit