View Single Post
  #5 (permalink)  
Old 08-02-2007, 07:40 AM
easytouch easytouch is offline
Senior Member
 
Posts: 59
Default Howto logger and graphs

I fixed today my logger and graphs with the following steps:

Read the Zimbra Wiki - Logger article and check that logger is working as expected
Logger - ZimbraWiki

check the contents of this directory
/opt/zimbra/zimbramon/rrdtool/work/

Verify that the gifs are created, and not of zero size
open one and verify that it's got a graph in it?
source: Disk: Statistics not produced

All commands beyond this point are run as user zimbra
# su zimbra

Is your hostname (as listed in the admin console) listed in the db?
# logmysql zimbra_logger
select distinct(host) from mta_aggregate;
Code:
+----------------------+
| host                 |
+----------------------+
| mx.examplea.com |
+----------------------+
1 row in set (0.01 sec)
exit (to leave mysql admin)
source: No data in server statistics


Check Disk Statistics in Zimbra's mySQL Database
logmysql zimbra_logger
select * from disk_aggregate;
select * from disk_status;
exit (to leave mysql admin)
do you get any rows displayed?


run logger manually

zimbra@mx:$ ~/libexec/zmlogprocess
(Attention! if lots are unprocessed, run it off business hours- cpu load,)
On a box with 200 mailboxes, 4000mails per day and 4 months of logs to process it took around half an hour.

check the running zmlogprocess from a second SSH shell
top
[Ctrl]+P (sort by CPU usage)
Code:
top - 11:47:42 up 2 days, 1:06, 3 users, load average: 2.25, 1.19, 0.52
Tasks: 125 total, 2 running, 123 sleeping, 0 stopped, 0 zombie
Cpu(s): 27.9% us, 4.6% sy, 0.0% ni, 36.3% id, 30.8% wa, 0.0% hi, 0.3% si
Mem: 3613204k total, 3492948k used, 120256k free, 21340k buffers
Swap: 8393952k total, 28k used, 8393924k free, 2258716k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19855 zimbra 25 0 1338m 489m 16m S 0.0 13.9 0:51.05 java
18355 zimbra 16 0 1263m 234m 4300 S 0.0 6.6 0:16.12 mysqld
25587 zimbra 16 0 89776 84m 2060 R 30.3 2.4 0:27.55 zmlogprocess <=====
generate graphs by hand
# ~/libexec/zmgengraphs

after doing this, my graphs showed up.

I am not sure at the moment if they are updated by the cronjobs. Thats another issue I have to check later.

Last edited by easytouch; 08-02-2007 at 07:44 AM..
Reply With Quote