You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by Stéphane LEPREVOST <st...@soget.fr> on 2006/08/31 18:00:40 UTC

Very big auto-whitelist file

A little question about AWL : I have an auto_whitelist how looks VERY HUGE
to me :
-rw-------    1 root     root     1241124864 Aug 31 17:51 auto-whitelist
 
Do you think a 1.2 Gb AWL file is NORMAL ?
 
I don't think so and plan to use check_whitelist tool to clean it, something
like :
check_whitelist --clean --min 2
 
Does it looks right for you ? I'm a bit afraid it might be a very long
process because of it's size ...
 
Any advice or information from someone who experienced it is welcome
 
Regards,
Stephane

Re: Very big auto-whitelist file

Posted by Kris Deugau <kd...@vianet.ca>.
Stéphane LEPREVOST wrote:
> As you noticed, I get worried very very very late... But in fact I wasn't in
> charge of spamassassin when we first saw this growth, that's why I'm back on
> the problem only now... I guess I'll pay more attention to this now ;D

<g>  It became a problem for me with a 10G hard drive in the server 
supporting ~250-300 accounts with 20M "not-the-INBOX" quotas.

My *personal* server, where I've long had much more disk, far fewer 
accounts, and no quotas, has been less of a concern - but even there the 
AWL file has sort of levelled off at ~10M (still on SA2.64).

-kgd

RE: Very big auto-whitelist file

Posted by Stéphane LEPREVOST <st...@soget.fr>.
Thanks Kris for this usefull tool, I'll try it tommorow (and thanks to Roger
too who noticed the existence of your tool)

As you noticed, I get worried very very very late... But in fact I wasn't in
charge of spamassassin when we first saw this growth, that's why I'm back on
the problem only now... I guess I'll pay more attention to this now ;D

Stephane

-----Message d'origine-----
De : Kris Deugau [mailto:kdeugau@vianet.ca] 
Envoyé : jeudi 31 août 2006 21:58
À : users@spamassassin.apache.org
Objet : Re: Very big auto-whitelist file

Roger Taranto wrote:
> There's an additional tool to run after you run check_whitelist.  It's 
> called trim_whitelist, and it compacts the db file.  I can't remember 
> where I found it, but you should be able to google for it.  It should 
> reduce the size of your db file quite a bit.

That would be the ancient creaky tool I wrote ~2 years ago.  <g>  Make sure
to read the notes and caveats regarding DB_File/AnyDBM_File.

Google seems to have lost, or *very* heavily downrated, the direct link to
the space I posted it (and a few other tools) to, so:

http://www.deepnet.cx/~kdeugau/spamtools/

And I wrote it because of this exact problem of AWL files growing
indefinitely...  although I got worried around 5M instead of 1.2G.  ;)

-kgd



Re: Very big auto-whitelist file

Posted by Kris Deugau <kd...@vianet.ca>.
Roger Taranto wrote:
> There's an additional tool to run after you run check_whitelist.  It's
> called trim_whitelist, and it compacts the db file.  I can't remember
> where I found it, but you should be able to google for it.  It should
> reduce the size of your db file quite a bit.

That would be the ancient creaky tool I wrote ~2 years ago.  <g>  Make 
sure to read the notes and caveats regarding DB_File/AnyDBM_File.

Google seems to have lost, or *very* heavily downrated, the direct link 
to the space I posted it (and a few other tools) to, so:

http://www.deepnet.cx/~kdeugau/spamtools/

And I wrote it because of this exact problem of AWL files growing 
indefinitely...  although I got worried around 5M instead of 1.2G.  ;)

-kgd

Re: Very big auto-whitelist file

Posted by Roger Taranto <ro...@rogflies.com>.
On Thu, 2006-08-31 at 09:00, Stéphane LEPREVOST wrote:
> A little question about AWL : I have an auto_whitelist how looks VERY
> HUGE to me :
> -rw-------    1 root     root     1241124864 Aug 31 17:51
> auto-whitelist
>  
> Do you think a 1.2 Gb AWL file is NORMAL ?
>  
> I don't think so and plan to use check_whitelist tool to clean it,
> something like :
> check_whitelist --clean --min 2
>  
> Does it looks right for you ? I'm a bit afraid it might be a very long
> process because of it's size ...
>  
> Any advice or information from someone who experienced it is welcome

There's an additional tool to run after you run check_whitelist.  It's
called trim_whitelist, and it compacts the db file.  I can't remember
where I found it, but you should be able to google for it.  It should
reduce the size of your db file quite a bit.

-Roger

RE: Very big auto-whitelist file

Posted by Stéphane LEPREVOST <st...@soget.fr>.
 
Thanks Logan, it was a good idea to check the du -k :

696046  auto-whitelist

Looks like the file is half used in fact...

Regarding the volume, I have about 40000 messages by day including spam, and
if I remember well, I thing this file has never been cleared...

Stephane

-----Message d'origine-----
De : Logan Shaw [mailto:lshaw@emitinc.com] 
Envoyé : jeudi 31 août 2006 19:09
À : users@spamassassin.apache.org
Objet : Re: Very big auto-whitelist file

On Thu, 31 Aug 2006, Stéphane LEPREVOST wrote:
> A little question about AWL : I have an auto_whitelist how looks VERY 
> HUGE to me :
> -rw-------    1 root     root     1241124864 Aug 31 17:51 auto-whitelist
>
> Do you think a 1.2 Gb AWL file is NORMAL ?

You might try typing "du -k auto-whitelist".  It could be a sparse file, and
the amount of disk it's actually using isn't as large as what you think.

It does seem a little large, but it's hard to tell.  Mine is this size:

     -rw-------   1 root root 5234688 2006-08-31 12:04 auto-whitelist

but then, I have a fairly low-volume site (less than 1000 messages a day,
including spam) with not all that many users.

   - Logan



Re: Very big auto-whitelist file

Posted by Logan Shaw <ls...@emitinc.com>.
On Thu, 31 Aug 2006, St�phane LEPREVOST wrote:
> A little question about AWL : I have an auto_whitelist how looks VERY HUGE
> to me :
> -rw-------    1 root     root     1241124864 Aug 31 17:51 auto-whitelist
>
> Do you think a 1.2 Gb AWL file is NORMAL ?

You might try typing "du -k auto-whitelist".  It could be a
sparse file, and the amount of disk it's actually using isn't
as large as what you think.

It does seem a little large, but it's hard to tell.  Mine is
this size:

     -rw-------   1 root root 5234688 2006-08-31 12:04 auto-whitelist

but then, I have a fairly low-volume site (less than 1000
messages a day, including spam) with not all that many users.

   - Logan