Thanks Kris -
That has cleaned up my AWL nicely. I still got the out of memory error, but in getting your tool to work I found a way to get the address removed.
My AWL is owned by amavisd, and is located in /var/amavisd/.spamassassin instead of ~user/.spamassassin. If I copy the db to /root/.spamassassin and run the removal tool line as root (rather than as amavisd), then copy the db file back, everything works perfectly.
I don't know why. I won't ask. I'm just happy it works.
Thanks, all!
Evan II
-----Original Message----- From: Kris Deugau Sent: Wednesday, August 04, 2004 1:15 PM To: [EMAIL PROTECTED] Subject: Re: AWL headache...
"E. Falk" wrote: > I have an address I need to remove from the AWL completely, but when > I run "spamassassin > [EMAIL PROTECTED]" I get two "Out of > memory!" messages, one after the other. And the address remains in > the AWL. > > Any ideas how I can either get this address out or trim out the extra > one-time entries that are clogging the AWL?
Well, you could start by trying my trim_whitelist script (adapted from the check_whitelist script provided by SA) to trim out the entries that only appear once. http://www.deepnet.cx/~kdeugau/spamtools/
You may need to modify it for the peculiarities of your particular DB_File/BerkelyDB setup, as I've seen three different file extensions depending on which version of which component is installed. :/
If that fails, your AWL data file is likely broken, and you MAY be able to recover some of the data with the BerkelyDB tools- if you can find them.
However, if the AWL data is hosed, you might be better off to just start fresh; unless it's absolutely CRITICAL that you retain that data for some reason.
-kgd -- Get your mouse off of there! You don't know where that email has been!
