I've read everything i could find here and elsewhere with regards to my particular problem, and even started researching how rrd actually works, and have installed on linux and windows to try and resolve for the past 7 days.
Current platform and build info
WinXP SP2 (Virtual PC at the moment, have tried direct too, and FC6)
C:\cacti>php -v
PHP 5.2.4 (cli) (built: Aug 30 2007 07:06:31)
C:\cacti>rrdtool -v
RRDtool 1.2.15 Copyright 1997-2006 by Tobias Oetiker <tobi@oetiker.ch>
Cacti 0.8.6j
C:\net-snmp\bin>snmpget.exe -V
NET-SNMP version: 5.3.1
C:\net-snmp\bin>mysqladmin -V
mysqladmin Ver 8.41 Distrib 5.0.45, for Win32 on ia32
Objective
Monitor CPU utilisation on HP switches, with futher expansion into LAN and WAN monitoring. Currently only one device and one OID configured.
Problem Description
Typical hard to figure out NaN issue, i duplicated the cisco profile and created an HP profile with the new OID (as in the forums) for CPU load, i get the integer back perfectly, single digit. But the graph is NaN.
Manual SNMP Get
C:\net-snmp\bin>snmpget -v 1 -c public 192.168.0.4 1.3.6.1.4.1.11.2.14.11.5.1.9.6.1.0
SNMPv2-SMI::enterprises.11.2.14.11.5.1.9.6.1.0 = INTEGER: 7
rrdtool info of the above OID gather, basicly a mirror of the cisco one.
filename = "c:\htdocs\cacti\rra\hp_switch_5min_cpu_8.rrd"
rrd_version = "0003"
step = 300
last_update = 1192441108
ds[5min_cpu].type = "GAUGE"
ds[5min_cpu].minimal_heartbeat = 600
ds[5min_cpu].min = 0.0000000000e+00
ds[5min_cpu].max = 1.0000000000e+02
ds[5min_cpu].last_ds ="UNKN"
ds[5min_cpu].value = 0.0000000000e+00
ds[5min_cpu].unknown_sec = 208
rra[0].cf = "AVERAGE"
rra[0].rows = 600
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
manual poller debug mode important parts
10/15/2007 01:36:47 PM - POLLER: Poller[0] CACTI2RRD: c:\cacti\rrdtool.exe update C:\htdocs\cacti\rra\hp_switch_5min_cpu_8.rrd --template 5min_cpu 1192441006:8
10/15/2007 01:52:56 PM - SYSTEM STATS: Time:1.1255 Method:cactid Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:1
no other errors are reported (completely clean as far as i can tell)
The current CPU value of 8% is listed with no problem but when i do a rrdtool info again....
rrd_version = "0003"
step = 300
last_update = 1192441108
ds[5min_cpu].type = "GAUGE"
ds[5min_cpu].minimal_heartbeat = 600
ds[5min_cpu].min = 0.0000000000e+00
ds[5min_cpu].max = 1.0000000000e+02
ds[5min_cpu].last_ds = "UNKN"
last update hasn't changed at all.. when i perform a manual rrdtool command (the above one, but with a random time i guess, or i've tried even proper increments) plus a cpu load of 70%.. i get the below
filename = "hp_switch_5min_cpu_8.rrd
rrd_version = "0003"
step = 300
last_update = 2000000000
ds[5min_cpu].type = "GAUGE"
ds[5min_cpu].minimal_heartbeat = 600
ds[5min_cpu].min = 0.0000000000e+00
ds[5min_cpu].max = 1.0000000000e+02
ds[5min_cpu].last_ds = "UNKN"
ds[5min_cpu].value = NaN
ds[5min_cpu].unknown_sec = 200
if i remove the template part, again increment the time with 1 second and do another 70% cpu load.. (WITHOUT TEMPLATE)
rrd_version = "0003"
step = 300
last_update = 2000000001
ds[5min_cpu].type = "GAUGE"
ds[5min_cpu].minimal_heartbeat = 600
ds[5min_cpu].min = 0.0000000000e+00
ds[5min_cpu].max = 1.0000000000e+02
ds[5min_cpu].last_ds = "UNKN"
ds[5min_cpu].value = 7.0000000000e+01
ds[5min_cpu].unknown_sec = 200
it works and after a few manual entries.. i actually start getting an average somewhat
last_update = 2000000007
ds[5min_cpu].type = "GAUGE"
ds[5min_cpu].minimal_heartbeat = 600
ds[5min_cpu].min = 0.0000000000e+00
ds[5min_cpu].max = 1.0000000000e+02
ds[5min_cpu].last_ds = "UNKN"
ds[5min_cpu].value = 2.7000000000e+02
I've tried many many things to get this working, i have no idea what else can be wrong. Paths are fine, i can't see anything else to debug.. the rest is just sql.. which as far as i can tell is okay. I've gone through the nan troubleshooting guide and managed to fix the font issues i had and the rrd file issues.. but this issue remains.
I've also tried hacking with the templates, but i am using the one for CPU, and as far as the forums go.. it should be perfect. Also the debug doesn't say anything is wrong with the template.
Any suggestions? I'm at the end of my rope
I've also dumped the SQL database a few times, redid everything a few times aswell. I can now say i can get cacti installed on windows in about 2 mins with all the retries
