Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: [SOLVED] Empty admin report

Hybrid View

  1. #1
    Join Date
    May 2007
    Location
    Turkey
    Posts
    43
    Rep Power
    8

    Default [SOLVED] Empty admin report

    Hi,

    Version 4.5.5

    I am receiving empty daily admin reports since last month.


    Generating report
    From 2007-11-27 00:00:00 to 2007-11-28 00:00:00

    No messages found


    what may be causing this ?

  2. #2
    Join Date
    Aug 2007
    Posts
    103
    Rep Power
    8

    Default

    check out /tmp/logprocess.out
    Probably have a corrupt database

  3. #3
    Join Date
    May 2007
    Location
    Turkey
    Posts
    43
    Rep Power
    8

    Default

    This is what I have in /tmp/logprocess.out

    DBD::mysql::st execute failed: Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired at /opt/zimbra/libexec/zmlogprocess line 1040.
    Can't call method "fetchall_arrayref" on an undefined value at /opt/zimbra/libexec/zmlogprocess line 780.
    Pruning service/server entries older then 2007-12-05 16:20:03
    mail maps to <mymailserver>
    Processing mta entries from 16506438
    Error executing select distinct(postfix_qid) from raw_logs where postfix_qid is not null and app like 'postfix%' and id > '16506438' with
    Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired
    Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired at /opt/zimbra/libexec/zmlogprocess line 1041.

  4. #4
    Join Date
    Aug 2007
    Posts
    103
    Rep Power
    8

    Default

    yup you need to repair the table.

    there is probably a way to do this in one line but I do this as zimbra.
    $ logmysql zimbra_logger
    mysql> repair table raw_logs;

    after it is repaired you can run '/opt/zimbra/libexec/zmdailyreport' to see if it will generate a log.
    It may take some times to build some info after the repair

  5. #5
    Join Date
    May 2007
    Location
    Turkey
    Posts
    43
    Rep Power
    8

    Default

    logger seems ok now with the following logs in /tmp/logprocess.out

    ...
    Aggregating day amavis from 2007-12-04 00:00:00 to 2007-12-05 00:00:00
    Aggregating hour disk from 2007-12-05 16:00:00 to 2007-12-05 17:00:00
    Aggregating day disk from 2007-12-04 00:00:00 to 2007-12-05 00:00:00
    Retaining 31 days worth of raw logs based on zimbraLogRawLifetime config.
    Retaining 730 days worth of summary logs based on zimbraLogSummaryLifetime config.
    Pruning raw mta logs from 2007-11-04 00:00:00
    Pruning raw amavis logs from 2007-11-04 00:00:00
    Pruning raw disk logs from 2007-11-04 00:00:00
    Pruning summary mta logs from 2005-12-05 00:00:00
    Pruning summary amavis logs from 2005-12-05 00:00:00
    Pruning summary disk logs from 2005-12-05 00:00:00
    Pruning other raw logs from 2007-11-04 00:00:00

    but I still have no messages in admin report. Waited about 30 mins.

  6. #6
    Join Date
    Aug 2007
    Posts
    103
    Rep Power
    8

    Default

    that looks good so you will probably get a report now.

    you could try running zmdailyreport -t and a date like 20070101, but since your raw_logs were messed up it might not have any data.

  7. #7
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    8

    Default

    Quote Originally Posted by mcesari View Post
    check out /tmp/logprocess.out
    Probably have a corrupt database
    I have been getting empty daily reports since my server crashed about a month ago. I have upgraded to 5.0.8 since then hoping that would fix it but it hasn't. I tried to run the logprocess.out but I get permission denied.

    dj

  8. #8
    Join Date
    Aug 2007
    Posts
    103
    Rep Power
    8

    Default

    dont run it just 'cat /tmp/logprocess.out'

  9. #9
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    8

    Default

    Quote Originally Posted by mcesari View Post
    dont run it just 'cat /tmp/logprocess.out'
    yea just realized that I ran it and then repaired the mta table. we will see what happens now.

    can I run a repair on the tables that was listed as having errors in my database check? I listed the errors here


    dj

  10. #10
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    8

    Default

    Ok. due to some fileserver issues our Zimbra crashed the other day and now my daily report is blank again I checked the tmp/logprocessout and this is what I have.

    DBD::mysql::st execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed at /opt/zimbra/libexec/zmlogprocess line 1134.
    DBD::mysql::st execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed at /opt/zimbra/libexec/zmlogprocess line 1134.
    DBD::mysql::st execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed at /opt/zimbra/libexec/zmlogprocess line 1134.
    DBD::mysql::st execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed at /opt/zimbra/libexec/zmlogprocess line 1134.
    DBD::mysql::st execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed at /opt/zimbra/libexec/zmlogprocess line 1134.
    DBD::mysql::st execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed at /opt/zimbra/libexec/zmlogprocess line 1134.
    Pruning service/server entries older then 2008-10-21 08:30:05
    dj

Similar Threads

  1. Disable SSL on the Admin Port 7071
    By rasputin in forum Installation
    Replies: 2
    Last Post: 04-06-2008, 03:29 AM
  2. Admin Extension fail view
    By deugenin in forum Developers
    Replies: 5
    Last Post: 11-22-2007, 02:01 PM
  3. Postfix problem
    By jimbo in forum Administrators
    Replies: 46
    Last Post: 07-23-2007, 05:24 AM
  4. How do I set Admin password?
    By sjames in forum Installation
    Replies: 4
    Last Post: 07-24-2006, 04:01 PM
  5. Zimbra refuses to auth admin.
    By alexbsa in forum Administrators
    Replies: 1
    Last Post: 12-05-2005, 11:23 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
  •