Re: AWL bloat-reducer

[Rob Mangiafico <rm...@lexiconn.com>]

On Fri, 27 Feb 2004, Kris Deugau wrote:

> I've been having user quota problems due to AWL bloat in a growing
> number of accounts.  Most customers' AWL files include a *long* list of
> one-off spam addresses which *SIGNIFICANTLY* increase disk usage.
> ...
> I finally got disgusted with this, and hacked check_whitelist into
> trim_whitelist.  It makes a backup copy of the "old" AWL db, creates a
> fresh db and copies only those addresses that have a count greater than
> 1 from old to new.  It then moves the new db over the old one and makes
> sure ownership of the new db is correct if running as root.  I didn't
> want to autodelete the old db in case something broke.
> 
> Download at http://www.deepnet.cx/~kdeugau/spamtools/trim_whitelist

Just wanted to say thanks for this script! It works great, can be run as 
root globally on all users, and we even scripted it to run on multiple 
servers from one command. Disk space saved was quite large, and it helps 
our users' quotas as well.

Rob M.

Re: AWL bloat-reducer

[Kris Deugau <kd...@webhart.net>]

Rob Mangiafico wrote:
> Just wanted to say thanks for this script! It works great,

So far.  I haven't yet set up any automated calls to it- I'm a little
too paranoid about losing customer AWL files.  <g>  (Although I haven't
heard any complaints yet.)  I've just used in in extreme cases where the
customer is getting close to the automated "You are almost out of disk
space for you spam folder" warning...

> can be run
> as root globally on all users,

Or by individual users;  although I've just realized a regular user
could attempt to run it on any .db file they have write access to.  :/

Not a *major* security problem, but it could be a nuisance.

> Disk space saved was quite large, and it helps
> our users' quotas as well.

Which is why I wrote it.  <g>

-kgd
-- 
"Sendmail administration is not black magic.  There are legitimate
technical reasons why it requires the sacrificing of a live chicken."
   - Unknown