Hello, I have two different SpamAssassin installed on two different server. Thet store information on two different MySQL server database.
On both I have scheduled several jobs for forcing expiration of tokens. In crontab I have the following lines: 30 4 * * 0 sa-learn -u amavis --dump magic 40 4 * * 0 sa-learn --sync --force-expire 50 4 * * 0 sa-learn -u amavis --dump magic 0 5 * * 0 echo "optimize table bayes_expire, bayes_seen, bayes_token, awl;" | mysql -u bayes -h mysql2.sttspa.intranet -p***** bayes While on one server I get that regularly tokens are expired (for example: Date: Sun, 17 Dec 2006 04:40:38 +0100 From: Cron Daemon <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Cron <[EMAIL PROTECTED]> sa-learn --sync --force-expire expired old bayes database entries in 37 seconds 18682012 entries kept, 76418 deleted token frequency: 1-occurrence tokens: 1.83% token frequency: less than 8 occurrences: 0.33% ) on the other one I get always that the token are not expired (for example: Date: Sun, 4 Feb 2007 04:40:01 +0100 From: Cron Daemon <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Cron <[EMAIL PROTECTED]> sa-learn --sync --force-expire X-Cron-Env: <SHELL=/bin/sh> X-Cron-Env: <HOME=/var/amavis> X-Cron-Env: <PATH=/usr/bin:/bin> X-Cron-Env: <LOGNAME=amavis> X-Virus-Scanned: by amavisd-new [16717] warn: FuzzyOcr: Cannot find executable for ocrad [16717] warn: FuzzyOcr: Cannot find executable for pamthreshold [16717] warn: FuzzyOcr: Cannot find executable for tesseract expired old bayes database entries in 617 seconds 13109996 entries kept, 0 deleted token frequency: 1-occurrence tokens: 79.61% token frequency: less than 8 occurrences: 16.04% ) Could someone explai why on the secon machine the tokens are never expired? PS: The local.cf is the the same on both machine and I don't get any error message.. BR, rocsca