Friday, September 21, 2007

Zimbra: Daily mail report always reports "No messages found"

http://www.zimbra.com/forums/installation/3332-daily-mail-report-always-reports-no-messages-found.html
http://www.zimbra.com/forums/27508-post20.html

zmloggerinit is probably not what you wanted to do. In either case you'll most likely need to run it again, but first remove the logger db files.

Code:
% su - zimbra
% rm -rf logger/db
% zmloggerinit
That will get you back to a functioning state.
The logger db was either not competely initialized or the database got corrupted somehow (did your disk fill up?). You can reset it with the above commands or try to recover the raw_logs table by logging into the logger db and running repair table raw_logs; You'll need the logger_root_passwd from zmlocalconfig.