SOLVED: no graph, but command line graphing works fine

koma · Post by **koma** » Mon Jul 07, 2008 4:55 pm

Hi,

I imported the JVM Host template from this forum, configured my java virtual machine, created a device, data source and graph but I am not seeing any graphs. I checked everything according to http://docs.cacti.net/node/283 (Debug NaN). This is the result of my investigation :

debug mode I can see the SNMP data being gathered, no errors appear :
07/07/2008 08:45:02 PM - CMDPHP: Poller[0] Host[2] DS[9] SNMP: v2: athena.vsko.be, dsname: jvmMemoryHeapCommit, oid: 1.3.6.1.4.1.42.2.145.3.163.1.1.2.12.0, output: 192679936
07/07/2008 08:45:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (9, 'jvmMemoryHeapCommit', '2008-07-07 20:45:02', '192679936')"
07/07/2008 08:45:02 PM - CMDPHP: Poller[0] Host[2] DS[10] SNMP: v2: athena.vsko.be, dsname: jvmMemoryHeapMaxSiz, oid: 1.3.6.1.4.1.42.2.145.3.163.1.1.2.13.0, output: 533528576
07/07/2008 08:45:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (10, 'jvmMemoryHeapMaxSiz', '2008-07-07 20:45:02', '533528576')"
07/07/2008 08:45:02 PM - CMDPHP: Poller[0] Host[2] DS[11] SNMP: v2: athena.vsko.be, dsname: jvmMemoryHeapUsed, oid: 1.3.6.1.4.1.42.2.145.3.163.1.1.2.11.0, output: 117073752
07/07/2008 08:45:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (11, 'jvmMemoryHeapUsed', '2008-07-07 20:45:02', '117073752')"

** The RRD's are being updated without problems :

07/07/2008 08:45:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_11.rrd --template jvmMemoryHeapUsed 1215456302:117073752
07/07/2008 08:45:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapmaxsiz_10.rrd --template jvmMemoryHeapMaxSiz 1215456302:533528576
07/07/2008 08:45:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_9.rrd --template jvmMemoryHeapCommit 1215456302:192679936

** RRD ownership is OK, I doubled check by "su - apache" and accessing the files :
[root@leros rra]# ll
total 516
-rw-rw-r-- 1 cacti apache 56220 Jul 8 01:15 jvm_athena_vsko_be_jvmmemoryheapcommit_9.rrd
-rw-rw-r-- 1 cacti apache 56220 Jul 8 01:15 jvm_athena_vsko_be_jvmmemoryheapmaxsiz_10.rrd
-rw-rw-r-- 1 cacti apache 56220 Jul 8 01:15 jvm_athena_vsko_be_jvmmemoryheapused_11.rrd
-rw-rw-r-- 1 cacti apache 141484 Jul 8 01:15 localhost_load_1min_5.rrd
-rw-rw-r-- 1 cacti apache 47836 Jul 8 01:15 localhost_mem_buffers_3.rrd
-rw-rw-r-- 1 cacti apache 47836 Jul 8 01:15 localhost_mem_swap_4.rrd
-rw-rw-r-- 1 cacti apache 47836 Jul 8 01:15 localhost_proc_7.rrd
-rw-rw-r-- 1 cacti apache 47836 Jul 8 01:15 localhost_users_6.rrd

I checked the rrd file numbers and the graph statement, everything looks ok,
the data in mysql database is fine too.

Final test, I change to user apache (tried to change to user cacti to, same) and I run the graph statement from the command line and output the result to test.png. The graph is perfectly what I expect !!!!

What more can I check ??? Why does this not work via the browser/webserver? Any help very welcome.

Here's the command line execution, attached you find the resulting graph.

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="JVM athena.vsko.be - JVM Heap Utilization" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
DEF:a="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapmaxsiz_10.rrd":jvmMemoryHeapMaxSiz:AVERAGE \
DEF:b="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapmaxsiz_10.rrd":jvmMemoryHeapMaxSiz:MAX \
DEF:c="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_9.rrd":jvmMemoryHeapCommit:AVERAGE \
DEF:d="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_9.rrd":jvmMemoryHeapCommit:MAX \
DEF:e="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_11.rrd":jvmMemoryHeapUsed:AVERAGE \
DEF:f="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_11.rrd":jvmMemoryHeapUsed:MAX \
LINE1:a#FF0000:"Max" \
GPRINT

LAST:" Current\:%8.2lf %s" \
GPRINT

AVERAGE:"Average\:%8.2lf %s" \
GPRINT

MAX:"Maximum\:%8.2lf %s\n" \
LINE1:c#00FF00:"Committed" \
GPRINT:c:LAST:"Current\:%8.2lf %s" \
GPRINT:c:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:d:MAX:"Maximum\:%8.2lf %s\n" \
AREA:e#0000FF:"Used" \
GPRINT:e:LAST:" Current\:%8.2lf %s" \
GPRINT:e:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:f:MAX:"Maximum\:%8.2lf %s\n" > /tmp/test.png

Post by **gandalf** » Tue Jul 08, 2008 2:43 am

Please have a look at httpd's error_log for more information
Reinhard

koma · Post by **koma** » Tue Jul 08, 2008 4:43 am

Hi,

thx for your reply !

I recreated my graphs while doing a "tail -f" on the apache logs files. Cacti graph debug says :
RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="JVM athena.vsko.be - JVM Heap Utilization" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
DEF:a="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapmaxsiz_10.rrd":jvmMemoryHeapMaxSiz:AVERAGE \
DEF:b="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapmaxsiz_10.rrd":jvmMemoryHeapMaxSiz:MAX \
DEF:c="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_9.rrd":jvmMemoryHeapCommit:AVERAGE \
DEF:d="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_9.rrd":jvmMemoryHeapCommit:MAX \
DEF:e="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_11.rrd":jvmMemoryHeapUsed:AVERAGE \
DEF:f="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_11.rrd":jvmMemoryHeapUsed:MAX \
LINE1:a#FF0000:"Max" \
GPRINT

LAST:" Current\:%8.2lf %s" \
GPRINT

AVERAGE:"Average\:%8.2lf %s" \
GPRINT

MAX:"Maximum\:%8.2lf %s\n" \
LINE1:c#00FF00:"Committed" \
GPRINT:c:LAST:"Current\:%8.2lf %s" \
GPRINT:c:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:d:MAX:"Maximum\:%8.2lf %s\n" \
AREA:e#0000FF:"Used" \
GPRINT:e:LAST:" Current\:%8.2lf %s" \
GPRINT:e:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:f:MAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:

OK

And no errors in my log file ??

==> error_log <==
[Sun Jul 06 04:02:35 2008] [notice] Digest: done
[Sun Jul 06 04:02:35 2008] [notice] mod_python: Creating 4 session mutexes based on 256 max processes and 0 max threads.
[Sun Jul 06 04:02:35 2008] [notice] Apache/2.2.3 (Red Hat) configured -- resuming normal operations
[Sun Jul 06 12:29:11 2008] [error] [client 196.35.158.178] File does not exist: /mnt/u01/wiki/mediawiki-1.11.0/phpmyadmin
[Mon Jul 07 18:02:10 2008] [error] [client 81.241.155.150] File does not exist: /mnt/u01/wiki/mediawiki-1.11.0/cacti
[Mon Jul 07 18:02:10 2008] [error] [client 81.241.155.150] File does not exist: /mnt/u01/wiki/mediawiki-1.11.0/favicon.ico
Timeout: No Response from athena.vsko.be:1161.
[Tue Jul 08 09:29:13 2008] [error] [client 10.253.200.28] File does not exist: /mnt/u01/wiki/mediawiki-1.11.0/favicon.ico
[Tue Jul 08 10:52:28 2008] [error] [client 10.253.200.81] File does not exist: /mnt/u01/wiki/mediawiki-1.11.0/favicon.ico
[Tue Jul 08 11:01:52 2008] [error] [client 10.253.200.36] File does not exist: /mnt/u01/wiki/mediawiki-1.11.0/favicon.ico

==> ssl_access_log <==

==> ssl_error_log <==
[Sun Jul 06 04:02:35 2008] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Sun Jul 06 04:02:35 2008] [warn] RSA server certificate CommonName (CN) `localhost.localdomain' does NOT match server name!?

==> ssl_request_log <==

==> access_log <==
81.241.155.150 - - [08/Jul/2008:13:12:08 +0200] "GET /cacti/graphs.php HTTP/1.1" 200 11785 "http://wiki.vsko.be/cacti/graphs.php?ac ... =8&debug=1" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"
81.241.155.150 - - [08/Jul/2008:13:12:11 +0200] "POST /cacti/graphs.php HTTP/1.1" 200 7044 "http://wiki.vsko.be/cacti/graphs.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"
81.241.155.150 - - [08/Jul/2008:13:12:13 +0200] "POST /cacti/graphs.php HTTP/1.1" 302 - "http://wiki.vsko.be/cacti/graphs.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"
81.241.155.150 - - [08/Jul/2008:13:12:13 +0200] "GET /cacti/graphs.php HTTP/1.1" 200 10534 "http://wiki.vsko.be/cacti/graphs.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"
81.241.155.150 - - [08/Jul/2008:13:12:16 +0200] "GET /cacti/graphs.php?action=graph_edit&host_id=-1 HTTP/1.1" 200 10522 "http://wiki.vsko.be/cacti/graphs.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"
81.241.155.150 - - [08/Jul/2008:13:12:24 +0200] "POST /cacti/graphs.php HTTP/1.1" 302 - "http://wiki.vsko.be/cacti/graphs.php?ac ... host_id=-1" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"
81.241.155.150 - - [08/Jul/2008:13:12:24 +0200] "GET /cacti/graphs.php?action=graph_edit&id=9&host_id=2 HTTP/1.1" 200 15672 "http://wiki.vsko.be/cacti/graphs.php?ac ... host_id=-1" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"
81.241.155.150 - - [08/Jul/2008:13:12:30 +0200] "POST /cacti/graphs.php HTTP/1.1" 302 - "http://wiki.vsko.be/cacti/graphs.php?ac ... &host_id=2" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"
81.241.155.150 - - [08/Jul/2008:13:12:31 +0200] "GET /cacti/graphs.php HTTP/1.1" 200 11970 "http://wiki.vsko.be/cacti/graphs.php?ac ... &host_id=2" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"
81.241.155.150 - - [08/Jul/2008:13:12:33 +0200] "GET /cacti/graphs.php?action=graph_edit&id=9 HTTP/1.1" 200 16276 "http://wiki.vsko.be/cacti/graphs.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.15) Gecko/20061201 Firefox/2.0.0.15 (Ubuntu-feisty)"

Do you have any other advice / pointers for me ?

Koen
thank you very much in addvance

Post by **gandalf** » Tue Jul 08, 2008 6:54 am

Does the error occur for all graphs or for JVM graphs only?
Reinhard

koma · Post by **koma** » Tue Jul 08, 2008 8:57 am

I tried to add monitoring for mysql, same problem;

But now I must also admit that the RRD files are not created from the interface either, so I take the output from the data source debug and I create them manually. This problem is most likely related to the problem with the graphs.

Anymore suggestions ??

thx again for your time !!! Most appreciated !

Koen

Post by **gandalf** » Tue Jul 08, 2008 9:06 am

What is the userid for the poller, then (see crontab). Is it "cacti" or "cactiuser" or "root" or ???
Reinhard

koma · Post by **koma** » Tue Jul 08, 2008 9:29 am

[root@leros ~]# cat /etc/cron.d/cacti
*/5 * * * * cacti php /var/www/cacti/poller.php >/dev/null 2>/var/www/cacti/log/poller-error.log

The user for cron/poller is cacti, but I'm guessing it is the webserver user creating the RRDs ? The webserver is running under the apache account.

koma · Post by **koma** » Tue Jul 08, 2008 10:30 am

did a "chmod -R 777 /var/www/cacti", recreated my graphs but no improvement

koma · Post by **koma** » Tue Jul 08, 2008 1:58 pm

Ok, the RRD are being created, I just have to wait for the poller to do so, a bit impatient apparently.

07/08/2008 08:55:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool create /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_13.rrd --step 300 DS:jvmMemoryHeapUsed:GAUGE:600:0:U RRA:AVERAGE:0.5:1:500 RRA:AVERAGE:0.5:1:600 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:500 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797
07/08/2008 08:55:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_13.rrd --template jvmMemoryHeapUsed N:247860032
07/08/2008 08:55:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_11.rrd --template jvmMemoryHeapCommit 1215543302:426074112

I cleaned up the whole database and restarted from scratch but apparently with the same result. No graphs

Am I correct that the graphs are created on the fly during the web request ?

koma · Post by **koma** » Tue Jul 08, 2008 2:24 pm

Ok, I'm clueless now, everything seems to work fine, but I have no graphs

I started from a clean database, created datasources and graphs. The RRD files are created during the poller run. The poller debug looks just fine.

POLLER DEBUG :

07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item where rrd_next_step<=0"
07/08/2008 09:20:02 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '301', Max Runtime '298', Poller Runs: '1'
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('poller_lastrun',1215544802)"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/var/www/cacti')"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "TRUNCATE TABLE poller_time"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
07/08/2008 09:20:02 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/cacti/cmd.php 0 2]
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 0 AND id <= 2) ORDER by id"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 0 AND host_id <= 2 AND rrd_next_step <= 0) ORDER by host_id"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 2 AND rrd_next_step <= 0)"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 0 AND host_id <= 2)"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 2)"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] Host[2] PING: Host is alive
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '0000-00-00 00:00:00', status_rec_date = '0000-00-00 00:00:00', status_last_error = '', min_time = '0.24000', max_time = '0.27000', cur_time = '0.26', avg_time = '0.25833166666667', total_polls = '12', failed_polls = '0', availability = '100' where hostname = 'athena.vsko.be'"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_reindex.data_query_id, poller_reindex.action, poller_reindex.op, poller_reindex.assert_value, poller_reindex.arg1 from poller_reindex where poller_reindex.host_id=2"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] Host[2] DS[12] SNMP: v2: athena.vsko.be, dsname: jvmMemoryHeapMaxSiz, oid: 1.3.6.1.4.1.42.2.145.3.163.1.1.2.13.0, output: 533528576
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (12, 'jvmMemoryHeapMaxSiz', '2008-07-08 21:20:02', '533528576')"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] Host[2] DS[11] SNMP: v2: athena.vsko.be, dsname: jvmMemoryHeapCommit, oid: 1.3.6.1.4.1.42.2.145.3.163.1.1.2.12.0, output: 426074112
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (11, 'jvmMemoryHeapCommit', '2008-07-08 21:20:02', '426074112')"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] Host[2] DS[13] SNMP: v2: athena.vsko.be, dsname: jvmMemoryHeapUsed, oid: 1.3.6.1.4.1.42.2.145.3.163.1.1.2.11.0, output: 282853728
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (13, 'jvmMemoryHeapUsed', '2008-07-08 21:20:02', '282853728')"
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] Time: 0.0305 s, Theads: N/A, Hosts: 2
07/08/2008 09:20:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"

==> log/poller-error.log <==

==> log/cacti.log <==
07/08/2008 09:20:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
07/08/2008 09:20:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) "
07/08/2008 09:20:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='13' and rrd_name='jvmMemoryHeapUsed' and time='2008-07-08 21:20:02'"
07/08/2008 09:20:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='11' and rrd_name='jvmMemoryHeapCommit' and time='2008-07-08 21:20:02'"
07/08/2008 09:20:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='12' and rrd_name='jvmMemoryHeapMaxSiz' and time='2008-07-08 21:20:02'"
07/08/2008 09:20:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_13.rrd --template jvmMemoryHeapUsed 1215544802:282853728
07/08/2008 09:20:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_11.rrd --template jvmMemoryHeapCommit 1215544802:426074112
07/08/2008 09:20:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapmaxsiz_12.rrd --template jvmMemoryHeapMaxSiz 1215544802:533528576
07/08/2008 09:20:03 PM - SYSTEM STATS: Time:1.1530 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:3 RRDsProcessed:3
07/08/2008 09:20:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.1530 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:3 RRDsProcessed:3')"
07/08/2008 09:20:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"

The graph debug says everything is fine, no errors in the apache log either :

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="JVM athena.vsko.be - JVM Heap Utilization" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
DEF:a="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapmaxsiz_12.rrd":jvmMemoryHeapMaxSiz:AVERAGE \
DEF:b="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapmaxsiz_12.rrd":jvmMemoryHeapMaxSiz:MAX \
DEF:c="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_11.rrd":jvmMemoryHeapCommit:AVERAGE \
DEF:d="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_11.rrd":jvmMemoryHeapCommit:MAX \
DEF:e="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_13.rrd":jvmMemoryHeapUsed:AVERAGE \
DEF:f="/var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_13.rrd":jvmMemoryHeapUsed:MAX \
LINE1:a#FF0000:"Max" \
GPRINT

LAST:" Current\:%8.2lf %s" \
GPRINT

AVERAGE:"Average\:%8.2lf %s" \
GPRINT

MAX:"Maximum\:%8.2lf %s\n" \
LINE1:c#00FF00:"Committed" \
GPRINT:c:LAST:"Current\:%8.2lf %s" \
GPRINT:c:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:d:MAX:"Maximum\:%8.2lf %s\n" \
AREA:e#0000FF:"Used" \
GPRINT:e:LAST:" Current\:%8.2lf %s" \
GPRINT:e:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:f:MAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:

OK

I can see the icons that should appear next to the graph and I can download the CSV file, you can find it attached. But no graph is drawn !

Any help very welcome !!

Koen

koma · Post by **koma** » Tue Jul 08, 2008 2:57 pm

Ok, this must give the gurus a clue :

when i drill down in my not-appearing graph, then this the result (see attached screenshot)

Post by **gandalf** » Tue Jul 08, 2008 3:54 pm

koma wrote:[root@leros ~]# cat /etc/cron.d/cacti
*/5 * * * * cacti php /var/www/cacti/poller.php >/dev/null 2>/var/www/cacti/log/poller-error.log

The user for cron/poller is cacti, but I'm guessing it is the webserver user creating the RRDs ? The webserver is running under the apache account.

No, rrd files are created from the poller only.
Reinhard

Post by **gandalf** » Tue Jul 08, 2008 3:56 pm

koma wrote:Ok, the RRD are being created, I just have to wait for the poller to do so, a bit impatient apparently.

07/08/2008 08:55:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool create /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_13.rrd --step 300 DS:jvmMemoryHeapUsed:GAUGE:600:0:U RRA:AVERAGE:0.5:1:500 RRA:AVERAGE:0.5:1:600 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:500 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797
07/08/2008 08:55:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapused_13.rrd --template jvmMemoryHeapUsed N:247860032
07/08/2008 08:55:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/jvm_athena_vsko_be_jvmmemoryheapcommit_11.rrd --template jvmMemoryHeapCommit 1215543302:426074112

During your debugging, you may have created some rrd files under wrong ownership (at least I did this several times in the past). Please make sure, the poller is alloowed to update those rrd files. Thenn ,please make sure that the data sources MAX limit is not exceeded. The fact, that rrdtool update did NOT produce a failure does NOT mean, that a valid number was updated! NaN is fine for rrdtool!

Am I correct that the graphs are created on the fly during the web request ?

Yes
Reinhard

Post by **gandalf** » Tue Jul 08, 2008 3:59 pm

koma wrote:Ok, this must give the gurus a clue :

when i drill down in my not-appearing graph, then this the result (see attached screenshot)

Well, which time difference is used for that graph??? From the command, I assume that's 1 second only!?! This is not a good idea
Reinhard

koma · Post by **koma** » Wed Jul 09, 2008 1:26 am

But I just clicked on the little wrench to drill down and then the command shows up on the webpage, instead of generating a graph !! I thought this would make it clear what is wrong.

When i point my browser directly to graph_image.php + params, I immediately receive "Connection reset".

I continue my quest....

Cacti

SOLVED: no graph, but command line graphing works fine

SOLVED: no graph, but command line graphing works fine

Nothing in error_log

Other graphs too !

Who is online