Results 1 to 3 of 3

Thread: Daily reports stopped working

  1. #1
    Join Date
    Jul 2009
    Posts
    32
    Rep Power
    6

    Default Daily reports stopped working

    >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

  2. #2
    Join Date
    Oct 2005
    Location
    USA, Canada and India
    Posts
    777
    Rep Power
    10

    Default

    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
    i2k2 Networks
    Dedicated & Shared Zimbra Hosting Provider

  3. #3
    Join Date
    Jul 2009
    Posts
    32
    Rep Power
    6

    Default

    Thank you !
    i will try it soon.

Similar Threads

  1. [SOLVED] Daily Reports stopped with 6.0.2 upgrade
    By 3dinfluence in forum Administrators
    Replies: 9
    Last Post: 11-16-2009, 07:03 AM
  2. [SOLVED] Upgraded to 4.5.11 - Daily Reports Stopped
    By msf004 in forum Administrators
    Replies: 15
    Last Post: 07-27-2008, 10:11 AM
  3. Replies: 1
    Last Post: 10-28-2007, 01:35 AM
  4. Daily mail reports!
    By celeron in forum Administrators
    Replies: 7
    Last Post: 03-22-2007, 09:11 PM
  5. Daily Reports Finally working, now caught as [SPAM]
    By glitch23 in forum Administrators
    Replies: 1
    Last Post: 10-02-2006, 05:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •