Re: auto-whitelist file size (Tips @ Tricks)

[Klaus Pforte <kl...@gmx.de>]

A small dialogue with the creator of the script "trim_whitelist":


Kris Deugau wrote:

 >> Klaus Pforte wrote:
 >>
 >
 >>>>The script make a backup of the DB-File (I changed the location in the
 >>>>script), o.k.
 >>>>But after this comes everytime "Cannot tie to old db."
 >>>>I changed the ownership and rights many times.
 >>>>I run the script as root, the db has root:root and 666 for sure.
 >
 >>
 >>
 >> You've probably got a different type of file for your AWL;  my systems
 >> all use "DB_File" (BerkeleyDB) AWL and Bayes files.  The default on 
many
 >> systems is something else.  :/
 >>
 >> Run "file <awl file>" and see what comes back.  Exactly what comes back
 >> will depend heavily on exactly how your Perl install is set up to 
handle
 >> tied hashes.  Try changing the "tie ..." statements to use 
"AnyDBM_File"
 >> rather than "DB_File" and that should help.  Note that the filenames 
may
 >> endup mangled;  some of the tied hash types include filename extensions
 >> and some don't.  :(


All perfect:
file type: Berkeley DB (Hash, version 5, native byte-order)
file name: auto-whitelist.db
I have a zero byte file "auto-whitelist" too.

In the script I wrote the file name without ".db".
All runs smooth with "AnyDBM_File".
File size down from 60 MB to 7 MB!
Great!


 >>
 >>
 >
 >>>>The original "check_whitelist" from source of 2.63 runs good and list
 >>>>all addresses.
 >
 >>
 >>
 >> Yep.  Changing to AnyDBM_File should work for you.
 >>
 >> -kgd


Bill Landry wrote:

> ----- Original Message ----- 
> From: "Juliano Simões" <ju...@axios.com.br>
> 
>>We started usign AWL on our site-wide setup after upgrading
>>from 2.64 to 3.0.1.
>>
>>As I was checking system files today, I noticed that the
>>auto-whitelist file size is 163MB, and growing.
>>
>>Is there a way to limit the size of auto-whitelist or expire
>>some of its entries?
>>
>>I checked SA documentation and found no information on this
>>issue.
> 
> 
> Here is a nice script that someone posted to the list awhile back:
> 
> http://www.deepnet.cx/~kdeugau/spamtools/trim_whitelist
> 
> This will trim all of the single-hit entries from the database.
> 
> Bill
> 
>