[SOLVED] Statistics not updated after power outage

[garfield]

Hi,

Some days ago power was accidentially removed from my server running zimbra 5.0.2. After this the statistics graphs in the administration interface have gone flat-line. The daily mail sent by /opt/zimbra/libexec/zmdailyreport also just returns "No messages found". I don't see any errors anywhere obvious and everything else seems to work fine. I've tried running the cron commands that check the databases etc. manually and they don't find anything wrong.

Does anyone have a clue as to what can be causing this?

Regards from,
Martin Dalum

[phoenix]

Welcome to the forums.

Check the logfile /opt/zimbra/logger/db/data/yourserver.com.err and see if there's any errors in there and also check the Troubleshooting section of the logger page in the wiki.

[garfield]

Welcome to the forums.

Check the logfile /opt/zimbra/logger/db/data/yourserver.com.err and see if there's any errors in there and also check the Troubleshooting section of the logger page in the wiki.

Thanks, that did it.. The amavis and raw_logs tables had errors.

Regards from,
Martin Dalum