View Single Post
  #2 (permalink)  
Old 10-06-2006, 06:30 AM
claros claros is offline
Project Contributor
 
Posts: 58
Default

It works very well now, amavis stats are correct.
It may be that in a previus version the queued_as information were not included in the amavis log...
Another hack:
in the line 293 of /opt/zimbra/libexec/zmlogprocess I've changed this query:
$sth = sqlExec("select count(*) from amavis where ".
"host = '".$host."' and ".
"arrive_time >= '".$periodStart."' and ".
"arrive_time <= '".$periodEnd."' and ".
"status = 'SPAM'");


to read:

$sth = sqlExec("select count(*) from amavis where ".
"host = '".$host."' and ".
"arrive_time >= '".$periodStart."' and ".
"arrive_time <= '".$periodEnd."' and ".
"status like 'SPAM%'");

In this way my spam stat includes also SPAMMY messages and I like it..

Ciao
Reply With Quote