Daily mail report always reports "No messages found"

[patcsy88]

Hi all,

Am new to the threads and just wanted to say Zimbra rocks!

Ok down to the problem, I have tried all of the above and am still getting "No messages found". Am not sure where else to poke into...am ruiing 5.0.2 GA OE on Ubuntu 6.06 LTS.

Please advise which other log files I should look into or I can post.

[terencelhl]

Originally Posted by Franck

I found that to repair bad mysql tables:

su -zimbra 
zmloggerctl stop
su - root
cd /opt/zimbra/logger/db/data/zimbra_logger
../../../mysql/bin/myisamchk -r *.MYI
su - zimbra
zmloggerctl start

Hi Franck,

It works on the Zimbra 5.0.26 64bit Ubuntu 8.04 too. Thank you so much.

[terencelhl]

Originally Posted by mmorse

For the collective knowledge:
Q: Can I run without logger?
A: Yes, but you should actually disable it & not leave it in a broken state.

To fix, the commands I had him run were:
su - zimbra
logmysql.server stop
exit/su - root/sudo -i (switch back to root however)
ps aux | grep logger (kill -9 any remaining)

Note:
-The below will remove all currently recorded data.
-Make sure you use the word 'logger' where given below, else you'll wipe your data db if you use the wrong path!

rm -rf /opt/zimbra/logger/db/data/*
chown zimbra:zimbra /opt/zimbra/logger/db/data
chmod 775 /opt/zimbra/logger/db/data
su - zimbra
cd /opt/zimbra/libexec
./zmloggerinit
logmysql.server start (or zmcontrol stop/start)
cd /opt/zimbra/libexec
./zmgengraphs
(And ./zmdailyreport as wanted, but it will proably be empty the first time.)

Hi Mike,

It works on the Zimbra 5.0.26 64bit Ubuntu 8.04 too. Thank you so much.