Results 1 to 5 of 5

Thread: zimbra daily reports problem - mta table is empty

  1. #1
    Join Date
    Aug 2007
    Posts
    3
    Rep Power
    8

    Default zimbra daily reports problem - mta table is empty

    Hello.

    I am receiving empty admin reports for some time.
    I have tried solutions mentioned in this thread:
    http://www.zimbra.com/forums/adminis...in-report.html

    I checked tables raw_log and service_status. Both are ok.
    I uncommented the print statements in /opt/zimbra/libexec/zmdailyreport, all of the SELECTions are from mta table.
    But mta table is empty.

    This is output from /tmp/logproccess.out

    Pruning service/server entries older then 2008-02-26 17:20:02
    xxxxxxx maps to mail.xxxxxx.com
    Processing mta entries from 149124001
    Found 1 messages
    Inserted 1 rows
    Saving ID 149124001
    Deleting processed postfix logs from raw_logs...Done
    Processing clamd entries from 149125690
    Found 0 entries
    Deleting processed clamd logs from raw_logs...Done
    Processing amavis entries from 150464000
    Found 35 entries
    Saving ID 150464214
    Deleting processed amavis logs from raw_logs...Done
    Processing sendmail entries from 0
    Found 0 entries
    Deleting processed sendmail logs from raw_logs...Done
    Processing zimbramon entries from 150463557
    Found 2 entries
    Saving ID 150464002
    Deleting processed zimbramon logs from raw_logs...Done
    Aggregating hour mta from 2008-01-17 20:00:00 to 2008-01-17 21:00:00
    Aggregating hour mta from 2008-01-17 21:00:00 to 2008-01-17 22:00:00
    Aggregating hour mta from 2008-01-17 22:00:00 to 2008-01-17 23:00:00
    Aggregating hour mta from 2008-01-17 23:00:00 to 2008-01-18 00:00:00
    Aggregating hour mta from 2008-01-18 00:00:00 to 2008-01-18 01:00:00
    Aggregating hour mta from 2008-01-18 01:00:00 to 2008-01-18 02:00:00
    Aggregating hour mta from 2008-01-18 02:00:00 to 2008-01-18 03:00:00
    .
    .
    .
    .
    Aggregating day mta from 2008-02-25 00:00:00 to 2008-02-26 00:00:00
    Aggregating hour amavis from 2008-02-26 16:00:00 to 2008-02-26 17:00:00
    Aggregating day amavis from 2008-02-25 00:00:00 to 2008-02-26 00:00:00
    Aggregating hour disk from 2008-02-26 16:00:00 to 2008-02-26 17:00:00
    Aggregating day disk from 2008-02-25 00:00:00 to 2008-02-26 00:00:00
    Retaining 5 days worth of raw logs based on zimbraLogRawLifetime config.
    Retaining 366 days worth of summary logs based on zimbraLogSummaryLifetime config.
    Pruning raw mta logs from 2008-02-21 00:00:00
    Pruning raw amavis logs from 2008-02-21 00:00:00
    Pruning raw disk logs from 2008-02-21 00:00:00
    Pruning summary mta logs from 2007-02-25 00:00:00
    Pruning summary amavis logs from 2007-02-25 00:00:00
    Pruning summary disk logs from 2007-02-25 00:00:00
    Pruning other raw logs from 2008-02-21 00:00:00
    Optimizing mta tables
    Optimizing raw amavis tables
    Optimizing raw disk logs table
    Optimizing summary mta logs table
    Optimizing summary amavis logs table
    Optimizing summary disk logs table
    Optimizing other raw logs table

    ~$ /opt/zimbra/libexec/zmdailyreport

    Generating report
    From 2008-02-25 00:00:00 to 2008-02-26 00:00:00

    No messages found

  2. #2
    Join Date
    Dec 2007
    Location
    Sydney, Australia
    Posts
    11
    Rep Power
    8

    Default

    I also have this issue.

  3. #3
    Join Date
    Feb 2007
    Posts
    32
    Rep Power
    8

    Default

    Yep same exact problem.... Though I've been asking for help for over a year now and still nothing. Yay.

  4. #4
    Join Date
    Nov 2007
    Location
    Louisiana
    Posts
    38
    Rep Power
    8

    Default

    My report is nearly empty only reports mail for/from the admin "user".

  5. #5
    staufj22 Guest

    Default

    Quote Originally Posted by sine View Post
    Hello.

    I am receiving empty admin reports for some time.
    I have tried solutions mentioned in this thread:
    http://www.zimbra.com/forums/adminis...in-report.html

    I checked tables raw_log and service_status. Both are ok.
    I uncommented the print statements in /opt/zimbra/libexec/zmdailyreport, all of the SELECTions are from mta table.
    But mta table is empty.

    Have you tried checking the mta table? That solved my problem.

Similar Threads

  1. zmperditionctl start asking for password
    By k7sle in forum Administrators
    Replies: 32
    Last Post: 02-20-2008, 11:13 AM
  2. Cleanup after many upgrades
    By tobru in forum Installation
    Replies: 1
    Last Post: 12-23-2007, 09:21 AM
  3. 4.5 Upgrade failure
    By brained in forum Installation
    Replies: 9
    Last Post: 03-03-2007, 03:30 PM
  4. Replies: 8
    Last Post: 02-27-2007, 04:10 AM
  5. FC3 Install and no zimbra ?
    By aws in forum Installation
    Replies: 10
    Last Post: 10-09-2005, 05:19 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
  •