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

Thread: Server/Disk Statistics revisited

  1. #1
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,499
    Rep Power
    56

    Default Server/Disk Statistics revisited

    I have the 3_0_1 GA version of Zimbra installed on CentOS 4 (this was a clean install of 3_0_0 and an upgrade to the current release) and I see no message or disk statistics for the individual server although message counts are shown in the roll-up totals.

    As far as I can tell everything is running OK but there are no gif files created in /opt/zimbra/zimbramon/rrdtool/work/ for the disk stats. I've been through every post that seems relevant to this problem but nothing has helped, I'm probably missing something obvious.

    OK, info so far is:

    Code:
    mysql> use zimbra_logger;
    Database changed
    mysql> show tables;
    +-------------------------+
    | Tables_in_zimbra_logger |
    +-------------------------+
    | amavis                  |
    | amavis_aggregate        |
    | config                  |
    | disk_aggregate          |
    | disk_status             |
    | mta                     |
    | mta_aggregate           |
    | processing_history      |
    | raw_logs                |
    | service_status          |
    +-------------------------+
    10 rows in set (0.01 sec)
    
    mysql> select * from mta_aggregate;
    +---------------------+---------------------+---------+--------+-----------+-----------+
    | period_start        | period_end          | host    | period | msg_count | msg_bytes |
    +---------------------+---------------------+---------+--------+-----------+-----------+
    | 2006-02-07 18:00:00 | 2006-02-07 19:00:00 | chinook | hour   |        34 |     86970 |
    | 2006-02-07 16:00:00 | 2006-02-07 17:00:00 | chinook | hour   |        78 |    258349 |
    | 2006-02-07 15:00:00 | 2006-02-07 16:00:00 | chinook | hour   |        56 |    463932 |
    | 2006-02-07 14:00:00 | 2006-02-07 15:00:00 | chinook | hour   |        12 |    140448 |
    | 2006-02-07 13:00:00 | 2006-02-07 14:00:00 | chinook | hour   |        36 |    409568 |
    | 2006-02-07 12:00:00 | 2006-02-07 13:00:00 | chinook | hour   |        28 |    475167 |
    | 2006-02-07 11:00:00 | 2006-02-07 12:00:00 | chinook | hour   |        14 |     47887 |
    | 2006-02-07 10:00:00 | 2006-02-07 11:00:00 | chinook | hour   |        28 |    434784 |
    | 2006-02-07 09:00:00 | 2006-02-07 10:00:00 | chinook | hour   |        21 |    136332 |
    | 2006-02-07 08:00:00 | 2006-02-07 09:00:00 | chinook | hour   |        28 |    127162 |
    | 2006-02-07 07:00:00 | 2006-02-07 08:00:00 | chinook | hour   |        12 |     34116 |
    | 2006-02-07 06:00:00 | 2006-02-07 07:00:00 | chinook | hour   |       407 |   2849363 |
    | 2006-02-07 19:00:00 | 2006-02-07 20:00:00 | chinook | hour   |        84 |    311780 |
    | 2006-02-07 20:00:00 | 2006-02-07 21:00:00 | chinook | hour   |        78 |    214812 |
    | 2006-02-07 00:00:00 | 2006-02-08 00:00:00 | chinook | day    |       916 |   5990670 |
    | 2006-02-08 06:00:00 | 2006-02-08 07:00:00 | chinook | hour   |       711 |   5492390 |
    | 2006-02-08 07:00:00 | 2006-02-08 08:00:00 | chinook | hour   |       336 |  11950680 |
    | 2006-02-08 00:00:00 | 2006-02-09 00:00:00 | chinook | day    |      1047 |  17443070 |
    | 2006-02-09 06:00:00 | 2006-02-09 07:00:00 | chinook | hour   |       567 |   5644527 |
    | 2006-02-09 07:00:00 | 2006-02-09 08:00:00 | chinook | hour   |       474 |   4371307 |
    | 2006-02-09 00:00:00 | 2006-02-10 00:00:00 | chinook | day    |      1041 |  10015834 |
    | 2006-02-10 06:00:00 | 2006-02-10 07:00:00 | chinook | hour   |       140 |   1838816 |
    | 2006-02-10 07:00:00 | 2006-02-10 08:00:00 | chinook | hour   |        14 |     81137 |
    | 2006-02-10 08:00:00 | 2006-02-10 09:00:00 | chinook | hour   |         7 |     35028 |
    | 2006-02-10 09:00:00 | 2006-02-10 10:00:00 | chinook | hour   |        35 |    131334 |
    | 2006-02-10 10:00:00 | 2006-02-10 11:00:00 | chinook | hour   |        21 |     66500 |
    | 2006-02-10 11:00:00 | 2006-02-10 12:00:00 | chinook | hour   |        63 |    135107 |
    | 2006-02-10 12:00:00 | 2006-02-10 13:00:00 | chinook | hour   |        28 |    353395 |
    | 2006-02-10 13:00:00 | 2006-02-10 14:00:00 | chinook | hour   |        32 |    128116 |
    | 2006-02-10 15:00:00 | 2006-02-10 16:00:00 | chinook | hour   |       112 |    761838 |
    | 2006-02-10 16:00:00 | 2006-02-10 17:00:00 | chinook | hour   |        12 |     29692 |
    | 2006-02-10 17:00:00 | 2006-02-10 18:00:00 | chinook | hour   |        34 |    124264 |
    | 2006-02-10 18:00:00 | 2006-02-10 19:00:00 | chinook | hour   |       105 |    389319 |
    | 2006-02-10 19:00:00 | 2006-02-10 20:00:00 | chinook | hour   |        34 |    137585 |
    | 2006-02-10 20:00:00 | 2006-02-10 21:00:00 | chinook | hour   |        38 |    119854 |
    | 2006-02-10 21:00:00 | 2006-02-10 22:00:00 | chinook | hour   |         5 |     13580 |
    | 2006-02-10 00:00:00 | 2006-02-11 00:00:00 | chinook | day    |       680 |   4345565 |
    | 2006-02-11 07:00:00 | 2006-02-11 08:00:00 | chinook | hour   |       982 |   4716013 |
    | 2006-02-11 08:00:00 | 2006-02-11 09:00:00 | chinook | hour   |       438 |   2332277 |
    | 2006-02-11 20:00:00 | 2006-02-11 21:00:00 | chinook | hour   |        54 |   1097174 |
    | 2006-02-11 21:00:00 | 2006-02-11 22:00:00 | chinook | hour   |        40 |     97507 |
    | 2006-02-11 00:00:00 | 2006-02-12 00:00:00 | chinook | day    |      1514 |   8242971 |
    | 2006-02-12 07:00:00 | 2006-02-12 08:00:00 | chinook | hour   |        98 |    581777 |
    | 2006-02-12 08:00:00 | 2006-02-12 09:00:00 | chinook | hour   |       117 |    229686 |
    | 2006-02-12 09:00:00 | 2006-02-12 10:00:00 | chinook | hour   |        56 |    153314 |
    | 2006-02-12 10:00:00 | 2006-02-12 11:00:00 | chinook | hour   |        21 |     69272 |
    | 2006-02-12 11:00:00 | 2006-02-12 12:00:00 | chinook | hour   |         7 |     21042 |
    | 2006-02-12 12:00:00 | 2006-02-12 13:00:00 | chinook | hour   |        35 |    149359 |
    | 2006-02-12 13:00:00 | 2006-02-12 14:00:00 | chinook | hour   |        65 |    272740 |
    | 2006-02-12 15:00:00 | 2006-02-12 16:00:00 | chinook | hour   |        35 |     75866 |
    | 2006-02-12 16:00:00 | 2006-02-12 17:00:00 | chinook | hour   |        14 |    454013 |
    | 2006-02-12 17:00:00 | 2006-02-12 18:00:00 | chinook | hour   |        41 |    206185 |
    | 2006-02-12 18:00:00 | 2006-02-12 19:00:00 | chinook | hour   |       164 |    510404 |
    | 2006-02-12 19:00:00 | 2006-02-12 20:00:00 | chinook | hour   |       189 |   1009393 |
    | 2006-02-12 20:00:00 | 2006-02-12 21:00:00 | chinook | hour   |         6 |     26559 |
    | 2006-02-12 00:00:00 | 2006-02-13 00:00:00 | chinook | day    |       848 |   3759610 |
    | 2006-02-13 06:00:00 | 2006-02-13 07:00:00 | chinook | hour   |       572 |   3120918 |
    | 2006-02-13 07:00:00 | 2006-02-13 08:00:00 | chinook | hour   |      1408 |   7450256 |
    | 2006-02-13 00:00:00 | 2006-02-14 00:00:00 | chinook | day    |      1980 |  10571174 |
    | 2006-02-14 06:00:00 | 2006-02-14 07:00:00 | chinook | hour   |       182 |   1988098 |
    | 2006-02-14 07:00:00 | 2006-02-14 08:00:00 | chinook | hour   |       574 |   2274270 |
    | 2006-02-14 00:00:00 | 2006-02-15 00:00:00 | chinook | day    |       756 |   4262368 |
    | 2006-02-15 07:00:00 | 2006-02-15 08:00:00 | chinook | hour   |      5667 |  35166017 |
    | 2006-02-15 00:00:00 | 2006-02-16 00:00:00 | chinook | day    |      5667 |  35166017 |
    | 2006-02-16 06:00:00 | 2006-02-16 07:00:00 | chinook | hour   |       180 |   1552027 |
    | 2006-02-16 07:00:00 | 2006-02-16 08:00:00 | chinook | hour   |       279 |   2246849 |
    | 2006-02-16 12:00:00 | 2006-02-16 13:00:00 | chinook | hour   |        35 |  45983651 |
    | 2006-02-16 13:00:00 | 2006-02-16 14:00:00 | chinook | hour   |         7 |     98980 |
    | 2006-02-16 14:00:00 | 2006-02-16 15:00:00 | chinook | hour   |         7 |     46578 |
    | 2006-02-16 15:00:00 | 2006-02-16 16:00:00 | chinook | hour   |        42 |    156324 |
    | 2006-02-16 16:00:00 | 2006-02-16 17:00:00 | chinook | hour   |        21 |     65933 |
    | 2006-02-16 17:00:00 | 2006-02-16 18:00:00 | chinook | hour   |        56 |    622615 |
    | 2006-02-16 18:00:00 | 2006-02-16 19:00:00 | chinook | hour   |         7 |     46774 |
    | 2006-02-16 19:00:00 | 2006-02-16 20:00:00 | chinook | hour   |        54 |    300321 |
    | 2006-02-16 20:00:00 | 2006-02-16 21:00:00 | chinook | hour   |        60 |    202696 |
    | 2006-02-16 00:00:00 | 2006-02-17 00:00:00 | chinook | day    |       748 |  51322748 |
    | 2006-02-17 06:00:00 | 2006-02-17 07:00:00 | chinook | hour   |       251 |   1120441 |
    | 2006-02-17 07:00:00 | 2006-02-17 08:00:00 | chinook | hour   |        31 |     99448 |
    | 2006-02-17 13:00:00 | 2006-02-17 14:00:00 | chinook | hour   |        64 |    191029 |
    | 2006-02-17 14:00:00 | 2006-02-17 15:00:00 | chinook | hour   |        21 |     62321 |
    | 2006-02-17 15:00:00 | 2006-02-17 16:00:00 | chinook | hour   |        34 |     74375 |
    | 2006-02-17 16:00:00 | 2006-02-17 17:00:00 | chinook | hour   |        63 |    262563 |
    | 2006-02-17 17:00:00 | 2006-02-17 18:00:00 | chinook | hour   |        56 |    276941 |
    | 2006-02-17 18:00:00 | 2006-02-17 19:00:00 | chinook | hour   |        14 |     26523 |
    | 2006-02-17 19:00:00 | 2006-02-17 20:00:00 | chinook | hour   |         7 |     22211 |
    | 2006-02-17 20:00:00 | 2006-02-17 21:00:00 | chinook | hour   |        70 |    199780 |
    | 2006-02-17 21:00:00 | 2006-02-17 22:00:00 | chinook | hour   |        21 |     14644 |
    | 2006-02-17 00:00:00 | 2006-02-18 00:00:00 | chinook | day    |       632 |   2350276 |
    | 2006-02-18 07:00:00 | 2006-02-18 08:00:00 | chinook | hour   |      2975 |  21913510 |
    | 2006-02-18 00:00:00 | 2006-02-19 00:00:00 | chinook | day    |      2975 |  21913510 |
    | 2006-02-19 06:00:00 | 2006-02-19 07:00:00 | chinook | hour   |       397 |   1637748 |
    | 2006-02-19 07:00:00 | 2006-02-19 08:00:00 | chinook | hour   |       924 |   6962592 |
    | 2006-02-19 00:00:00 | 2006-02-20 00:00:00 | chinook | day    |      1321 |   8600340 |
    | 2006-02-20 06:00:00 | 2006-02-20 07:00:00 | chinook | hour   |      3227 |  27397989 |
    | 2006-02-20 00:00:00 | 2006-02-21 00:00:00 | chinook | day    |      3227 |  27397989 |
    | 2006-02-21 06:00:00 | 2006-02-21 07:00:00 | chinook | hour   |       733 |   3709667 |
    | 2006-02-21 07:00:00 | 2006-02-21 08:00:00 | chinook | hour   |       324 |   4143879 |
    | 2006-02-21 00:00:00 | 2006-02-22 00:00:00 | chinook | day    |      1057 |   7853546 |
    | 2006-02-22 06:00:00 | 2006-02-22 07:00:00 | chinook | hour   |        56 |    182257 |
    | 2006-02-22 08:00:00 | 2006-02-22 09:00:00 | chinook | hour   |         7 |     11927 |
    | 2006-02-22 09:00:00 | 2006-02-22 10:00:00 | chinook | hour   |         3 |     14688 |
    | 2006-02-22 10:00:00 | 2006-02-22 11:00:00 | chinook | hour   |         3 |      7458 |
    | 2006-02-22 11:00:00 | 2006-02-22 12:00:00 | chinook | hour   |         9 |     39666 |
    | 2006-02-22 12:00:00 | 2006-02-22 13:00:00 | chinook | hour   |         4 |     10818 |
    | 2006-02-22 13:00:00 | 2006-02-22 14:00:00 | chinook | hour   |        24 |     94548 |
    | 2006-02-22 14:00:00 | 2006-02-22 15:00:00 | chinook | hour   |         5 |     51082 |
    | 2006-02-22 15:00:00 | 2006-02-22 16:00:00 | chinook | hour   |         9 |     19673 |
    | 2006-02-22 16:00:00 | 2006-02-22 17:00:00 | chinook | hour   |         7 |     23986 |
    | 2006-02-22 17:00:00 | 2006-02-22 18:00:00 | chinook | hour   |         3 |     22748 |
    | 2006-02-22 18:00:00 | 2006-02-22 19:00:00 | chinook | hour   |         2 |      6742 |
    | 2006-02-22 19:00:00 | 2006-02-22 20:00:00 | chinook | hour   |         9 |     27034 |
    | 2006-02-22 20:00:00 | 2006-02-22 21:00:00 | chinook | hour   |        20 |     63812 |
    | 2006-02-22 00:00:00 | 2006-02-23 00:00:00 | chinook | day    |       161 |    576439 |
    | 2006-02-23 06:00:00 | 2006-02-23 07:00:00 | chinook | hour   |        23 |    288706 |
    | 2006-02-23 00:00:00 | 2006-02-24 00:00:00 | chinook | day    |        23 |    288706 |
    | 2006-02-24 07:00:00 | 2006-02-24 08:00:00 | chinook | hour   |        58 |    486190 |
    | 2006-02-24 00:00:00 | 2006-02-25 00:00:00 | chinook | day    |        58 |    486190 |
    | 2006-02-25 07:00:00 | 2006-02-25 08:00:00 | chinook | hour   |        35 |    444780 |
    | 2006-02-26 06:00:00 | 2006-02-26 07:00:00 | chinook | hour   |         6 |     11570 |
    | 2006-02-25 00:00:00 | 2006-02-26 00:00:00 | chinook | day    |        35 |    444780 |
    | 2006-02-26 07:00:00 | 2006-02-26 08:00:00 | chinook | hour   |        51 |    225079 |
    | 2006-02-26 15:00:00 | 2006-02-26 16:00:00 | chinook | hour   |         4 |      9852 |
    | 2006-02-26 16:00:00 | 2006-02-26 17:00:00 | chinook | hour   |         1 |      3472 |
    | 2006-02-26 17:00:00 | 2006-02-26 18:00:00 | chinook | hour   |        10 |     83519 |
    | 2006-02-26 18:00:00 | 2006-02-26 19:00:00 | chinook | hour   |         8 |    382427 |
    | 2006-02-26 19:00:00 | 2006-02-26 20:00:00 | chinook | hour   |        16 |    134183 |
    | 2006-02-26 20:00:00 | 2006-02-26 21:00:00 | chinook | hour   |         7 |     21490 |
    | 2006-02-27 06:00:00 | 2006-02-27 07:00:00 | chinook | hour   |         1 |      4406 |
    | 2006-02-26 00:00:00 | 2006-02-27 00:00:00 | chinook | day    |       103 |    871592 |
    | 2006-02-27 07:00:00 | 2006-02-27 08:00:00 | chinook | hour   |        59 |    518165 |
    | 2006-02-27 08:00:00 | 2006-02-27 09:00:00 | chinook | hour   |        12 |     83593 |
    | 2006-02-27 09:00:00 | 2006-02-27 10:00:00 | chinook | hour   |        10 |     84626 |
    | 2006-02-27 10:00:00 | 2006-02-27 11:00:00 | chinook | hour   |        17 |    146617 |
    | 2006-02-27 11:00:00 | 2006-02-27 12:00:00 | chinook | hour   |        17 |    113482 |
    | 2006-02-27 12:00:00 | 2006-02-27 13:00:00 | chinook | hour   |        17 |     74652 |
    | 2006-02-27 13:00:00 | 2006-02-27 14:00:00 | chinook | hour   |         7 |     83602 |
    | 2006-02-27 15:00:00 | 2006-02-27 16:00:00 | chinook | hour   |        13 |     71833 |
    | 2006-02-27 16:00:00 | 2006-02-27 17:00:00 | chinook | hour   |        13 |     22958 |
    | 2006-02-27 18:00:00 | 2006-02-27 19:00:00 | chinook | hour   |         5 |      8620 |
    | 2006-02-27 19:00:00 | 2006-02-27 20:00:00 | chinook | hour   |         5 |     16422 |
    | 2006-02-27 20:00:00 | 2006-02-27 21:00:00 | chinook | hour   |         7 |     30063 |
    | 2006-02-27 21:00:00 | 2006-02-27 22:00:00 | chinook | hour   |         1 |      5429 |
    | 2006-02-27 00:00:00 | 2006-02-28 00:00:00 | chinook | day    |       184 |   1264468 |
    | 2006-02-28 07:00:00 | 2006-02-28 08:00:00 | chinook | hour   |        57 |    381125 |
    | 2006-02-28 00:00:00 | 2006-03-01 00:00:00 | chinook | day    |        57 |    381125 |
    | 2006-03-01 06:00:00 | 2006-03-01 07:00:00 | chinook | hour   |        58 |    234571 |
    | 2006-03-01 12:00:00 | 2006-03-01 13:00:00 | chinook | hour   |        20 |    331698 |
    +---------------------+---------------------+---------+--------+-----------+-----------+
    147 rows in set (0.00 sec)
    
    mysql> select * from disk_status;
    Empty set (0.00 sec)
    
    mysql> select * from disk_aggregate;
    Empty set (0.00 sec)
    What's the next step?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  2. #2
    marcmac is offline Expert Member
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    13

    Default

    what do you get from zmhostname? Is it chinook, or chinook.something.something?

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

    Default

    Sorry, I missed that one. It's the FQDN of the server.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  4. #4
    marcmac is offline Expert Member
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    13

    Default

    This is bug 5508 - which is fixed, but the fix didn't make it into the 3.0.1 release (it requires some db schema massaging, so we decided not to put it in.)

  5. #5
    graffiti is offline Loyal Member
    Join Date
    Sep 2005
    Posts
    95
    Rep Power
    9

    Default

    Quote Originally Posted by phoenix
    Sorry, I missed that one. It's the FQDN of the server.
    Would you please tell me how to fix this problem?

    TIA,

    -g

  6. #6
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,499
    Rep Power
    56

    Default

    Quote Originally Posted by marcmac
    This is bug 5508 - which is fixed, but the fix didn't make it into the 3.0.1 release (it requires some db schema massaging, so we decided not to put it in.)
    That was a sneaky trick, I checked bugzilla for that fix number first. OK, I'll wait for the next release. Many thanks.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

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

    Default

    Quote Originally Posted by graffiti
    Would you please tell me how to fix this problem?

    TIA,

    -g
    What is the problem you're having? Doesn't your system display the FQDN with that command?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  8. #8
    graffiti is offline Loyal Member
    Join Date
    Sep 2005
    Posts
    95
    Rep Power
    9

    Default

    Quote Originally Posted by phoenix
    What is the problem you're having? Doesn't your system display the FQDN with that command?
    Yes, I have the same problem with you. zmhostname returns the FQDN but mysql contains only the hostname. Please help.

    -g

  9. #9
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,499
    Rep Power
    56

    Default

    Ah, I see. That's actually not the problem I'm having, the zmhostname on my system does return the FQDN. I think it's possibly an LDAP setting that needs to be set to the FQDN rather than just the hostname.

    Unfortunately I'm away from my machines at the moment and I won't be back for a few days, I'd suggest you start a new thread describing your problem and one of the Zimbra guys will give you the necessary steps to diagnose the problem.

    Is this causing you any problems with your server?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  10. #10
    marcmac is offline Expert Member
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    13

    Default Disk stats missing

    Phoenix:

    crontab -l

    zmdisklog
    tail /var/log/zimbra.log - disk info being logged?

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. Zimbra Disk Statistics, non-EXT3 Volumes
    By ccmacmil in forum Administrators
    Replies: 6
    Last Post: 04-07-2008, 09:59 AM
  2. Admin Statistics
    By bellzerr in forum Administrators
    Replies: 8
    Last Post: 11-21-2007, 01:50 AM
  3. centos 5 zimbra 4.5.6 no statistics
    By rutman286 in forum Installation
    Replies: 9
    Last Post: 08-14-2007, 09:30 AM
  4. statistics problem
    By rutman286 in forum Installation
    Replies: 5
    Last Post: 08-04-2007, 08:00 AM
  5. No Status or Statistics Showing
    By tron in forum Administrators
    Replies: 7
    Last Post: 10-17-2005, 09:23 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
  •