Daily reports stopped working

[atevewr]

>zmcontrol -v
Release 5.0.18_GA_3011.RHEL5_20090707164432 RHEL5 FOSS edition

A few days back the daily reports stopped working. I haven't updated any components. No major/minor changes in the server either.

Executing this
>/opt/zimbra/libexec/zmdailyreport -m

i get the result as

DBD::mysql::st execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed at /opt/zimbra/libexec/zmdailyreport line 506, <CONF> line 340.

The Server Status on the console shows the data is stale besides the current date & time.

Can you please guide me to the right direction, as to, how should i make the daily reports work again.

Thanks

[raj]

your logger database has crashed or crroupted
you can delete it and create again
Please Backup first in full, you can follow any of the methods listed in the wiki
Open Source Edition Backup Procedure - Zimbra :: Wiki
double check that your backup is good

Now you can delete and recreate the Logger

su - zimbra
logmysql.server stop
logout
rm -rf /opt/zimbra/logger/db/data/*
chown zimbra:zimbra /opt/zimbra/db/data
chmod 775 /opt/zimbra/db/data
cd /opt/zimbra/libexec
./zmloggerinit
./zmfixperms --verbose --extended
su - zimbra
zmlogswatchctl start
logout

Raj

[atevewr]

Thank you !
i will try it soon.