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

Thread: Missing Stats Message Count / Message Volume

  1. #1
    rhostager is offline Senior Member
    Join Date
    Nov 2005
    Posts
    61
    Rep Power
    9

    Default Missing Stats Message Count / Message Volume

    I have had this problem from the start. This server is running on Fedora Core 4 and running Zimbra OS 4.0.3. This server has followed the upgrade path for quite some time. I feel that there is some configuration issue that has carried through all the upgrades.

    All statistics(spam/virus, disk, quota) show except Message Count and Message Volume both system-wide and for the individual server. The logmysql db has data in everything except mta and mta_aggregate, which are both empty.

    logprocess.out has no errors.

    swatch.out shows:
    *** swatch version 3.1.1 (pid:6052) started at Thu Nov 2 08:04:56 PST 2006

    logswatch.out shows:
    *** logswatch version 3.1.1 (pid:5299) started at Thu Nov 2 08:04:47 PST 2006

    swatch and logswatch are both running.

    I hate to do a clean install to fix this as it would be a nightmare to add all the users back in and not loose mail.

    Any ideas on how to fix this?

    - Rob

  2. #2
    keynet is offline Junior Member
    Join Date
    Nov 2006
    Location
    London, UK
    Posts
    9
    Rep Power
    8

    Default Similar problem - data not yet available

    I've had a similar problem since the beginning, now updated to 4.0.3 (OSS) on SuSe 10. I get a whole set of .csv files with lots of stats in /opt/zimbra/log, there are no logprocess errors, but I get "data not yet available" under all of the server stats on the web GUI and no graphs.

    Originally I didn't have the logger running, then started it, now I get ticks against all the status, but still no stats though I feel sure they are being generated. I've also checked the database, (following thread "no data in server statistics") and see all the stats actually in the db. But no GUI stats or graphs :-( Any ideas?


    Quote Originally Posted by rhostager
    I have had this problem from the start. This server is running on Fedora Core 4 and running Zimbra OS 4.0.3. This server has followed the upgrade path for quite some time. I feel that there is some configuration issue that has carried through all the upgrades.

    All statistics(spam/virus, disk, quota) show except Message Count and Message Volume both system-wide and for the individual server. The logmysql db has data in everything except mta and mta_aggregate, which are both empty.

    logprocess.out has no errors.

    - Rob

  3. #3
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,491
    Rep Power
    56

    Default

    Did you search the forums, this has been covered many times and one of the 'fixes' may apply. How about this one for instance, any use?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  4. #4
    rhostager is offline Senior Member
    Join Date
    Nov 2005
    Posts
    61
    Rep Power
    9

    Default

    I have read through the forums and followed every thread on this subject. I have done the corrections suggested but to no avail.

    I initially thought that the problem was in the zmlogprocess script. After taking a look at the script I now suspect that the problem is in swatch or logswatch.

    When I send some messages through the sever, they do not seem to show up in the raw_logs. That would explain why mta and mta_aggregate are empty.

    The amavis and disk info seem to process just fine.

    - Rob

  5. #5
    keynet is offline Junior Member
    Join Date
    Nov 2006
    Location
    London, UK
    Posts
    9
    Rep Power
    8

    Default Stats fixed

    I did spend a long time searching threads, but your post didn't show up
    Anyway, your fix worked for me, thanks.

    Quote Originally Posted by phoenix
    Did you search the forums, this has been covered many times and one of the 'fixes' may apply. How about this one for instance, any use?

  6. #6
    multicast is offline Active Member
    Join Date
    Feb 2007
    Posts
    32
    Rep Power
    8

    Default Same issue...

    Hey Guys,

    I'm having the same issue as well... All the other stats are updating but message count/Volume.

    Anyone have any ideas?

    Multicast

  7. #7
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,491
    Rep Power
    56

    Default

    Quote Originally Posted by multicast View Post
    I'm having the same issue as well... All the other stats are updating but message count/Volume

    Anyone have any ideas?
    .Did you try the answer in the post immediately above yours? If not then what, exactly, have you tried to fix it?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  8. #8
    multicast is offline Active Member
    Join Date
    Feb 2007
    Posts
    32
    Rep Power
    8

    Default What I've done..

    Hey Bill,

    Yep tried that and the output was correct as you showed it should be so I didn't have to fix the location. The graphs are there, they show old data as it was working for a time then it stopped.

    I've deleted my logger files and reset it with the loggerinit which worked great. The Disk, Spam, Quota information is all updated correctly and the system status is as well. Only the Message Count/Volume is not getting updated. The system almost looks like it's not parsing the right log files or something else is amiss.

    I'm open to any other ideas.

    Cyrus

  9. #9
    multicast is offline Active Member
    Join Date
    Feb 2007
    Posts
    32
    Rep Power
    8

    Default

    Hi Bill,

    Here is the ouput of my logprocess.out:
    Processing mta entries from 0
    Found 2 messages
    Inserted 2 rows
    Saving ID 0
    Deleting processed postfix logs from raw_logs...Done
    Processing clamd entries from 0
    Found 0 entries
    Deleting processed clamd logs from raw_logs...Done
    Processing amavis entries from 124901
    Found 197 entries
    Saving ID 125337
    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 124407
    Found 39 entries
    Saving ID 125323
    Deleting processed zimbramon logs from raw_logs...Done

    That is what is making me think that it isn't seeing the logs... Though in the zimbra.log I see tons of Postfix logging information so I know its there...

    Cyrus

  10. #10
    multicast is offline Active Member
    Join Date
    Feb 2007
    Posts
    32
    Rep Power
    8

    Default

    Anyone have any ideas here?

    Oh and a little more info this is what I get when I do:

    mysql> select * from mta_aggregate;
    Empty set (0.00 sec)

    I also tried this:
    mysql> select distinct(host) from mta_aggregate;
    Empty set (0.00 sec)

    Thanks gang.
    Last edited by multicast; 12-11-2007 at 01:14 AM.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Web client logon fails (INVALID_PDU)
    By jermxx in forum Installation
    Replies: 8
    Last Post: 02-20-2007, 02:20 PM
  2. Traslation SVN tree status
    By meikka in forum I18N/L10N - Translations
    Replies: 7
    Last Post: 02-13-2007, 11:13 AM
  3. Tomcat broken after upgrade to 4
    By dotslashroot in forum Migration
    Replies: 13
    Last Post: 01-31-2007, 06:05 PM
  4. message stats in admin area
    By primz in forum Users
    Replies: 3
    Last Post: 12-20-2006, 02:21 PM
  5. Message count graph
    By reneanb in forum Administrators
    Replies: 1
    Last Post: 03-17-2006, 09:04 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
  •