RE: When force-expire doesn't work...

2012-08-31 Thread Rob Sterenborg
On Wed, 29 Aug 2012 14:42:30 +0200 Rob Sterenborg wrote: What bothers me is that I can't update the spam_count and ham_count fields because AFAIK I don't have information about that. You shoudn't normally touch those in an expire. Why not? Is it not related to the number

RE: When force-expire doesn't work...

2012-08-30 Thread Rob Sterenborg
-Original Message- From: Mark Martinec [mailto:mark.martinec...@ijs.si] Sent: Wednesday, August 29, 2012 5:00 PM To: users@spamassassin.apache.org Subject: Re: When force-expire doesn't work... Rob, Because bayes_seen was also quite big I read up on that too. Since the table

Re: When force-expire doesn't work...

2012-08-30 Thread RW
On Wed, 29 Aug 2012 17:00:00 +0200 Mark Martinec wrote: Rob, The main purpose of bayes_seen is to prevent a stream of same-contents messages arriving in a short succession from polluting a bayes database. I'd say that's more of a bug than a feature since you can only learn one spam out of

When force-expire doesn't work...

2012-08-29 Thread Rob Sterenborg
Hello, I'm in the process of installing a new relay MTA, and part of it means moving the current Bayes database to the new server (bdb - MySQL). The database is quite big because of the bayes_token and bayes_seen tables, so I wanted to expire old data. I've set bayes_expiry_max_db_size=100

Re: When force-expire doesn't work...

2012-08-29 Thread RW
On Wed, 29 Aug 2012 09:40:29 +0200 Rob Sterenborg wrote: Hello, I'm in the process of installing a new relay MTA, and part of it means moving the current Bayes database to the new server (bdb - MySQL). The database is quite big because of the bayes_token and bayes_seen tables, so I

RE: When force-expire doesn't work...

2012-08-29 Thread Rob Sterenborg
-Original Message- From: RW [mailto:rwmailli...@googlemail.com] Sent: Wednesday, August 29, 2012 1:23 PM To: users@spamassassin.apache.org Subject: Re: When force-expire doesn't work... On Wed, 29 Aug 2012 09:40:29 +0200 Rob Sterenborg wrote: Hello, I'm in the process

Re: When force-expire doesn't work...

2012-08-29 Thread Mark Martinec
Rob, Because bayes_seen was also quite big I read up on that too. Since the table doesn't include any age information and (most) everything I found says just delete it, I emptied the table. Although I think it's strange to just throw away information about previous seen messages that have