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

Thread: Statistics Not Working

  1. #1
    aguerrave is offline Member
    Join Date
    Dec 2007
    Posts
    13
    Rep Power
    7

    Exclamation Statistics Not Working

    I use the last version of zimbra open source and ubuntu 7.10.

    I tried all the possibilities found in the forums and my statistics do not work, somebody has some other solution? Help please!!!!

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    What does
    Code:
    su - zimbra
    zmgengraphs
    produce ? Does it run through and generate the GIF files from the RRDs ? Have a look at this Disk Statistics show other partition for checking to see if the MySQL tables are being updated aswell.

  3. #3
    mbd
    mbd is offline Senior Member
    Join Date
    Dec 2006
    Location
    Melbourne, AU
    Posts
    58
    Rep Power
    8

    Default

    Unsure if it's the same problem that I had, but I found that stats weren't working on our system for quite a while, and it was fixed by checking/repairing the databases. From advice at [SOLVED] Database Integrity check report I typed:

    Code:
    sudo su - zimbra
    cd /opt/zimbra/libexec
    ./zmdbintegrityreport -v       (to verify data)
    ./zmdbintegrityreport -r       (to repair data)
    ./zmdbintegrityreport -v       (to verify data again)
    and stats started working again for me.

  4. #4
    aguerrave is offline Member
    Join Date
    Dec 2007
    Posts
    13
    Rep Power
    7

    Default

    Quote Originally Posted by uxbod View Post
    What does
    Code:
    su - zimbra
    zmgengraphs
    produce ? Does it run through and generate the GIF files from the RRDs ? Have a look at this Disk Statistics show other partition for checking to see if the MySQL tables are being updated aswell.
    Sorry but dosen't working

  5. #5
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Okay, perhaps we need to ask for more specific information. As mbd has said it could be a corrupt database so could you check please /opt/zimbra/logger/db/data/<server_hostname>.err for any errors. Do you have any gif and rrd files under /opt/zimbra/logger/db/work ?

    Then try
    Code:
    su - zimbra
    logmysql
    use zimbra_logger;
    select distinct(device) from disk_aggregate;
    quit
    does that select any data from the MySQL database ?

  6. #6
    aguerrave is offline Member
    Join Date
    Dec 2007
    Posts
    13
    Rep Power
    7

    Default

    I got some errors in two tables, but i repair .was succesuss..

    Database changed
    mysql> select distinct(device) from disk_aggregate;
    +-----------------------------+
    | device |
    +-----------------------------+
    | /dev/hda1 |
    | /dev/mapper/mailserver-root |
    +-----------------------------+
    2 rows in set (0.01 sec)

    I am not expert in zimbra either in linux.... but I am repairs all tables that was danage. Everything are working fine only that not work is stati

  7. #7
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Yay progress Do you get something displayed even though it may be the wrong disk partition ?

  8. #8
    aguerrave is offline Member
    Join Date
    Dec 2007
    Posts
    13
    Rep Power
    7

    Default

    only this Sr.,
    +-----------------------------+
    | device |
    +-----------------------------+
    | /dev/hda1 |
    | /dev/mapper/mailserver-root |
    +-----------------------------+
    2 rows in set (0.01 sec)

    Tell me what info do u need

  9. #9
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Apologies I should have been more specific do you see anything in the admin GUI now ? (even if wrong partition)

  10. #10
    aguerrave is offline Member
    Join Date
    Dec 2007
    Posts
    13
    Rep Power
    7

    Default

    No Sr., only that not work is statistics, the other works perfect

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. [SOLVED] Server statistics does not working
    By boblin in forum Administrators
    Replies: 46
    Last Post: 11-20-2008, 05:15 AM
  2. Zimbra 5.0 RC1 - Server Statistics not working
    By xflip in forum Installation
    Replies: 4
    Last Post: 12-19-2007, 08:44 PM
  3. Server Statistics not working RHEL4 NE
    By peter@mxtoolbox.com in forum Installation
    Replies: 3
    Last Post: 11-29-2007, 02:03 PM
  4. Monitoring statistics and mail queues not working
    By superboer12 in forum Installation
    Replies: 9
    Last Post: 01-13-2007, 12:15 PM
  5. Server statistics and Server Status not working right
    By calebwalker in forum Administrators
    Replies: 2
    Last Post: 01-08-2007, 03:34 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
  •