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" <[EMAIL PROTECTED]>
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
