Results 1 to 6 of 6

Thread: zmdailyreport send empty mail

  1. #1
    fathianf is offline Intermediate Member
    Join Date
    May 2007
    Location
    Iran
    Posts
    21
    Rep Power
    8

    Default zmdailyreport send empty mail

    one week ago, my server stopped working because of full hard disk. After some hours, I could delete some extra files and made some free space and zimbra started again. But after that i realized that dailyreport is sending empty message (no messages found). I checked databases and I found that raw_logs is corrupt, then I fixed it, but still I can't receive daily report. Would you let me know what should I do, Ofcourse I have read all forums about it and done eveything, at the moment it seems everthing is working properly except daily report and zmmsgtrace and what ever needs to work with retireving from mysql via cli.

  2. #2
    tiger2000 is offline Elite Member
    Join Date
    May 2008
    Location
    Taiwan
    Posts
    296
    Rep Power
    7

    Default

    not sure if this helps, but have you tried to run "zmdailyreport" by yourself? any obvious error message?

  3. #3
    fathianf is offline Intermediate Member
    Join Date
    May 2007
    Location
    Iran
    Posts
    21
    Rep Power
    8

    Default

    Yes, I have run zmdailyreport via cli and without no errors, it says: no messages found

  4. #4
    chozz is offline Starter Member
    Join Date
    Jul 2008
    Posts
    2
    Rep Power
    7

    Default Daily mail report always reports "No messages found"

    Hi,

    Let mi bring up this topic again because I am also having the same problem with one of my servers.

    The logs are fine but no report

  5. #5
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,586
    Rep Power
    57

    Default

    See if there's any errors in the log files, check these Troubleshooting tips and search the forums for the words 'daily report'.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  6. #6
    styelz is offline Junior Member
    Join Date
    Dec 2007
    Location
    Melbourne/Australia
    Posts
    8
    Rep Power
    7

    Default

    i have the same problem and it ended up being a corrupt mysql zimbra_logger.raw_logs table.

    I see lots of this in /opt/zimbra/logs/logger_mysql_error.log:
    [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired

    As zimbra user, I ran this command to find the logger root password:
    zmlocalconfig -s | grep mysql | grep logger_root

    Then this to repair the tables (your path may differ):
    /opt/zimbra/mysql-standard-5.0.67-pc-linux-gnu-i686-glibc23/bin/mysqlcheck -rA -uroot -pROOT_LOGGER_PASS -S /opt/zimbra/logger/db/mysql.sock

    run /opt/zimbra/libexec/zmdailyreport -now (i see results yay!)
    Last edited by styelz; 01-26-2012 at 12:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 02-03-2011, 07:01 AM
  2. [SOLVED] mailbox and apache not running
    By rtwick in forum Administrators
    Replies: 4
    Last Post: 11-15-2008, 08:21 AM
  3. zmamavisdctl stopped and won't restart
    By alto in forum Installation
    Replies: 2
    Last Post: 04-18-2008, 12:41 AM
  4. [SOLVED] Upgraded to 5.0 OSS - Sendmail Problem
    By Chewie71 in forum Installation
    Replies: 11
    Last Post: 12-28-2007, 07:07 PM
  5. DynDNS and Zimbra
    By afterwego in forum Installation
    Replies: 30
    Last Post: 04-01-2007, 03:34 PM

Posting Permissions

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