This looks like a good way of dealing with the AWL database, but I don't see anything in the documentation - did you hack in the MySQL support yourself, or is there an option that I missed?
For the moment, I'm trying to find a simple solution, such as locating a tool that is capable of managing whatever database SA uses by default for the AWL. >From looking at the scripts, it appears to be something built in to Perl. On Fri, 25 Apr 2008 18:49:01 -0500, Steven Stern wrote > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 04/25/2008 06:32 PM, listmail wrote: > | I noticed that the AWL database was getting rather large, so I > used the | check_whitelist script to remove the stale entries. While > this seems to have | removed a lot of entries from the database, it > did not reduce the database size. | | Does anyone know what kind of > a database this is, and in particular, how to do | a cleanup that > will remove unused records? The database is currently located | on a > RAM drive, so space is important due to scarcity as well as the potential > | speed issues from letting it grow too large. > | > > I use MySQL for the AWL database and added a timestamp, "lastupdate" > column to the table. I then have a script that runs every night: > > DELETE FROM awl WHERE lastupdate <= DATE_SUB(SYSDATE(), INTERVAL 2 > MONTH); DELETE FROM awl WHERE count = 1 AND lastupdate <= > DATE_SUB(SYSDATE(), INTERVAL 1 5 DAY); > > - -- > > ~ Steve > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.7 (GNU/Linux) > Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org > > iD8DBQFIEm3seERILVgMyvARAsADAJ9F+lgHlIkzP6Ny91FzR7F1xbt81wCfTeTn > SDK/TIP6FKhcpCXIBHNMrNk= > =Tvf1 > -----END PGP SIGNATURE-----