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

Thread: emtpy statistics charts in the administrative console

  1. #1
    k3rmit is offline Intermediate Member
    Join Date
    Nov 2006
    Posts
    22
    Rep Power
    8

    Default emtpy statistics charts in the administrative console

    Hi everybody,

    my server statistics charts have been empty since the day i moved the /var/log folder for space issues and linked /var/log to the real folder.

    I checked for permissions and so on and everything is fine. In fact zimbra correctly logs everything. It's just the graphing script that doesn't work.

    Any suggestion on how to fix or debug this?

    Thanks in advance for any help


    Albe

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

    Default

    Do you get any error messages if you run
    Code:
    su - zimbra
    /opt/zimbra/libexec/zmgengraphs
    Once that is run do you see any graphs ?

    Would you also update your profile with the following output so we know which version of ZCS you are running
    Code:
    su - zimbra
    zmcontrol -v

  3. #3
    k3rmit is offline Intermediate Member
    Join Date
    Nov 2006
    Posts
    22
    Rep Power
    8

    Default

    thanks for the quick reply, i've updated my profile.

    i forgot to mention in the previous post that i did try the graph generation command with no success... and no error messages.

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

    Default

    Quote Originally Posted by k3rmit View Post
    In fact zimbra correctly logs everything. It's just the graphing script that doesn't work.
    Do you mean to the flat files or to the MySQL database ?

  5. #5
    k3rmit is offline Intermediate Member
    Join Date
    Nov 2006
    Posts
    22
    Rep Power
    8

    Default

    i'm talking about the flat files. the logger service is up and running: how do i check if it is logging correctly?

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

    Default

    Code:
    su - zimbra
    logmysql
    use zimbra_logger;
    select * from mta_aggregate
    where date_format(period_start,"%Y%m%d") = date_format(now(),"%Y%m%d");

  7. #7
    k3rmit is offline Intermediate Member
    Join Date
    Nov 2006
    Posts
    22
    Rep Power
    8

    Default

    damn...

    last entry is very old, exactly the date were my graphs stop.

    How am i supposed to fix this now?

    Thanks a lot again...

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

    Default

    Check in /opt/zimbra/log/mysql_error.log for any error messages and you can also run a
    Code:
    check table mta_aggregate
    Perform that for each of the tables found using
    Code:
    show tables
    and if any have errors then just run
    Code:
    repair table {table name}

  9. #9
    k3rmit is offline Intermediate Member
    Join Date
    Nov 2006
    Posts
    22
    Rep Power
    8

    Default

    sorry but it took a while... there were errors in the mta table.

    nonetheless it still isn't logging.. i've restarted the logger service to no avail..

    any further suggestion?


    thanks..

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

    Default

    It takes a while for the changes and graphs to appear, has it been 24hrs since you fixed the tables?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

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] no usage statistics in Zimbra admin console
    By admin1 in forum Administrators
    Replies: 2
    Last Post: 03-03-2009, 03:11 PM
  2. Cannot access Administrative Console
    By ojkeyboard in forum Administrators
    Replies: 0
    Last Post: 10-19-2006, 06:58 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
  •