83MB auto-whitelist?

[Henry Kwan <li...@designmedia.com>]

Just noticed that my AWL is up to 83MB.  Not sure if it should be that large so
I ran check_whitelist and it removed the single entries but did not compact the
file.  I then checked the SA site and it said to use sa-awlUtil but I can't find
this utility on my system.  Was it included in the standard 3.25 tarball?

Thanks.

Re: 83MB auto-whitelist?

[Henry Kwan <li...@designmedia.com>]

Karsten Bräckelmann <guenther <at> rudersport.de> writes:

> On Thu, 2009-05-28 at 10:50 -0400, Kris Deugau wrote:
> > > 
> > > For more info and the script's link see
> > >   http://markmail.org/message/qqsm35q5bqpbb3in
> > 
> > (For the lazy, the original hack is at 
> > http://www.deepnet.cx/~kdeugau/spamtools/trim_whitelist .)
> 
> For the even lazier, injected a space to protect the links integrity. ;)

Hi,

Thanks to all for the links to the utility script.

I'll give it a shot later tonight when the mail server is calmer.

Re: 83MB auto-whitelist?

[Karsten Bräckelmann <gu...@rudersport.de>]

On Thu, 2009-05-28 at 10:50 -0400, Kris Deugau wrote:
> Karsten Bräckelmann wrote:
> > I use Kris Deugau's trim_whitelist -- though very infrequently, just
> > when I spot the DB gets out of hand. That hack seems to works perfectly
> > for me.
> > 
> > For more info and the script's link see
> >   http://markmail.org/message/qqsm35q5bqpbb3in
> 
> (For the lazy, the original hack is at 
> http://www.deepnet.cx/~kdeugau/spamtools/trim_whitelist .)

For the even lazier, injected a space to protect the links integrity. ;)

> Nice to hear it's still working for the purpose it was written for.  I 
> still have it in crontab entries on two production systems with global 
> AWL files myself.  That way I don't have to have a mild panic attack 
> when the mail system becomes mysteriously slow.  <g>  I usually do Bayes 
> maintenance in the same cron job.
> 
> > Also see the first link to a list archive in that file.
> 
> Er, wha?  I checked and I didn't include a link to anything in the script...

Oops, did I add those myself? :)  Perfectly possible I did, to have some
references in context.

 $ head .spamassassin/trim_whitelist | grep http
 # http://www.nabble.com/AWL-Database-Cleanup-td16907407.html#a16946805
 # http://www.deepnet.cx/~kdeugau/spamtools/trim_whitelist

Anyway, I was referring to the above, for the "need some disk space" and
"no in-place shrinking" notes.


BTW, thanks for that hack, Kris. :)

  guenther

-- 
char *t="\10pse\0r\0dtu\0.@ghno\x4e\xc8\x79\xf4\xab\x51\x8a\x10\xf4\xf4\xc4";
main(){ char h,m=h=*t++,*x=t+2*h,c,i,l=*x,s=0; for (i=0;i<l;i++){ i%8? c<<=1:
(c=*++x); c&128 && (s+=h); if (!(h>>=1)||!t[s+h]){ putchar(t[s]);h=m;s=0; }}}

Re: 83MB auto-whitelist?

[Kris Deugau <kd...@vianet.ca>]

Karsten Bräckelmann wrote:
> I use Kris Deugau's trim_whitelist -- though very infrequently, just
> when I spot the DB gets out of hand. That hack seems to works perfectly
> for me.
> 
> For more info and the script's link see
>   http://markmail.org/message/qqsm35q5bqpbb3in

(For the lazy, the original hack is at 
http://www.deepnet.cx/~kdeugau/spamtools/trim_whitelist.)

Nice to hear it's still working for the purpose it was written for.  I 
still have it in crontab entries on two production systems with global 
AWL files myself.  That way I don't have to have a mild panic attack 
when the mail system becomes mysteriously slow.  <g>  I usually do Bayes 
maintenance in the same cron job.

> Also see the first link to a list archive in that file.

Er, wha?  I checked and I didn't include a link to anything in the script...

-kgd

Re: 83MB auto-whitelist?

[Karsten Bräckelmann <gu...@rudersport.de>]

On Wed, 2009-05-27 at 19:49 +0000, Henry Kwan wrote:
> Just noticed that my AWL is up to 83MB.  Not sure if it should be that large so

Well, it keeps track of all sender addresses it sees, including the
forged ones which usually hit your site once only...

> I ran check_whitelist and it removed the single entries but did not compact the
> file.  I then checked the SA site and it said to use sa-awlUtil but I can't find
> this utility on my system.  Was it included in the standard 3.25 tarball?

I use Kris Deugau's trim_whitelist -- though very infrequently, just
when I spot the DB gets out of hand. That hack seems to works perfectly
for me.

For more info and the script's link see
  http://markmail.org/message/qqsm35q5bqpbb3in

Also see the first link to a list archive in that file.


-- 
char *t="\10pse\0r\0dtu\0.@ghno\x4e\xc8\x79\xf4\xab\x51\x8a\x10\xf4\xf4\xc4";
main(){ char h,m=h=*t++,*x=t+2*h,c,i,l=*x,s=0; for (i=0;i<l;i++){ i%8? c<<=1:
(c=*++x); c&128 && (s+=h); if (!(h>>=1)||!t[s+h]){ putchar(t[s]);h=m;s=0; }}}

Re: 83MB auto-whitelist?

[LuKreme <kr...@kreme.com>]

On 27-May-2009, at 13:49, Henry Kwan wrote:
> Just noticed that my AWL is up to 83MB.  Not sure if it should be  
> that large so
> I ran check_whitelist and it removed the single entries but did not  
> compact the
> file.  I then checked the SA site and it said to use sa-awlUtil but  
> I can't find
> this utility on my system.  Was it included in the standard 3.25  
> tarball?

Doesn't appear to be.  It's not part of my 3.2.5 install (in fact,  
doesn't appear anywehre on my server). It also does not appear in the  
ports tree as a separate program.  Where do you get it?  Got me, I  
searched several ways on google and only found references to other  
people asking where it was.

the page in question does list, under ToDo, "upload sw-alwUtil"


-- 
...I started playing Myst at 4:30 in the afternoon and looked up
	suddenly and realized it was February.