On Wed, 14 Apr 2010 15:58:07 -0700 (PDT) john espiro <john_esp...@yahoo.com> wrote:
> I just found the awesoem scripts in the tarball... > That one here should be better as it does all the magic needed for DSPAM maintenance at once: http://dspam.git.sourceforge.net/git/gitweb.cgi?p=dspam/dspam;a=tree;f=contrib/dspam_maintenance;hb=HEAD > If I set a daily cron job to use the purge-4.1.sql, and it has: > > > START TRANSACTION; > delete from dspam_signature_data > where from_days(@a-14) > created_on; > COMMIT; > > Then for the logrotate script (/usr/bin/dspam_logrotate -a XX -d > /var/dspam/data), I am guessing that XX should be replaced with 14... since > the purge script is removing tokens that are 2 week or more old, it doesn't > make sense to keep history for longer than that, right? > Depends on your setup. But in general it's okay to purge user logs after 15 days or so. > Thanks, > John > -- Kind Regards from Switzerland, Stevan Bajić ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
