Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Jun 23, 2017 2:05 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Data not filling graph -nan
PostPosted: Tue May 09, 2017 1:01 pm 
Offline

Joined: Mon Oct 20, 2014 12:50 pm
Posts: 12
I have gone through the troubleshooting steps available and I can can run snmpwalk and it actually pulls the data. I can also do a verbose query and all the data comes up with that. I can pull the name for the graphs from the xml file and that works, but data does not populate the graph.

cacti:~# spine --verbosity=5 768 768
SPINE: Using spine config file [/etc/cacti/spine.conf]
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The path_php_server variable is /usr/share/cacti/site/script_server.php
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /var/log/cacti/cacti.log
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The log_destination variable is 2 (BOTH)
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 2
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 1
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 400
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The snmp_retries variable is 6
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The boost_redirect variable is 0
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 1
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The threads variable is 15
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The polling interval is 60 seconds
05/09/2017 01:53:35 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 8
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: The script timeout is 72
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 4
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: StartHost='768', EndHost='768', TotalPHPScripts='0'
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 5
05/09/2017 01:53:36 PM - SPINE: Poller[0] Version 0.8.8b starting
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: Spine is running asroot.
05/09/2017 01:53:36 PM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: Issues with SNMP Header Version information, assuming old version of Net-SNMP.
05/09/2017 01:53:36 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
05/09/2017 01:53:36 PM - SPINE: Poller[0] NOTE: Spine will support multithread device polling.
05/09/2017 01:53:36 PM - SPINE: Poller[0] NOTE: Spine is behaving in a 0.8.7g+ manner
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 2
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] DEBUG: Entering SNMP Ping
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[0] TH[1] Total Time: 0.0014 Seconds
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[0] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] SNMP Result: Host responded to SNMP
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] TH[1] RECACHE: Processing 2 items in the auto reindex cache for '192.168.205.154'
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] TH[1] Recache DataQuery[1] OID: .1.3.6.1.2.1.1.3.0, output: 182642040
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] TH[1] Recache DataQuery[47] OID: .1.3.6.1.2.1.1.3.0, output: 182642040
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] TH[1] NOTE: There are '3' Polling Items for this Host
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] ERROR: Problems parsing Multi SNMP OID! (oid: ), Set MAX_OIDS to 1 for this host to isolate bad OID
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] TH[1] DS[25595] SNMP: v1: 192.168.205.154, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value: 0
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] TH[1] DS[25595] SNMP: v1: 192.168.205.154, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: 590304194
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] TH[1] DS[25629] SNMP: v1: 192.168.205.154, dsname: westronic_state, oid: , value: U
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] TH[1] Total Time: 0.42 Seconds
05/09/2017 01:53:36 PM - SPINE: Poller[0] Host[768] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
05/09/2017 01:53:36 PM - SPINE: Poller[0] DEBUG: Net-SNMP Close Completed
05/09/2017 01:53:36 PM - SPINE: Poller[0] Time: 0.4639 s, Threads: 15, Hosts: 2


-cacti:~# rrdtool info /var/lib/cacti/rra/768/25629.rrd
filename = "/var/lib/cacti/rra/768/25629.rrd"
rrd_version = "0003"
step = 300
last_update = 1494352210
header_size = 3704
ds[westronic_state].index = 0
ds[westronic_state].type = "GAUGE"
ds[westronic_state].minimal_heartbeat = 600
ds[westronic_state].min = 0.0000000000e+00
ds[westronic_state].max = NaN
ds[westronic_state].last_ds = "U"
ds[westronic_state].value = 0.0000000000e+00
ds[westronic_state].unknown_sec = 10
rra[0].cf = "AVERAGE"
rra[0].rows = 8640
rra[0].cur_row = 7747
rra[0].pdp_per_row = 5
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 4
rra[1].cf = "AVERAGE"
rra[1].rows = 4320
rra[1].cur_row = 2514
rra[1].pdp_per_row = 30
rra[1].xff = 5.0000000000e-01
rra[1].cdp_prep[0].value = NaN
rra[1].cdp_prep[0].unknown_datapoints = 4
rra[2].cf = "AVERAGE"
rra[2].rows = 2160
rra[2].cur_row = 2021
rra[2].pdp_per_row = 120
rra[2].xff = 5.0000000000e-01
rra[2].cdp_prep[0].value = NaN
rra[2].cdp_prep[0].unknown_datapoints = 94
rra[3].cf = "AVERAGE"
rra[3].rows = 797
rra[3].cur_row = 756
rra[3].pdp_per_row = 1440
rra[3].xff = 5.0000000000e-01
rra[3].cdp_prep[0].value = NaN
rra[3].cdp_prep[0].unknown_datapoints = 214
rra[4].cf = "MIN"
rra[4].rows = 8640
rra[4].cur_row = 3588
rra[4].pdp_per_row = 5
rra[4].xff = 5.0000000000e-01
rra[4].cdp_prep[0].value = NaN
rra[4].cdp_prep[0].unknown_datapoints = 4
rra[5].cf = "MIN"
rra[5].rows = 4320
rra[5].cur_row = 264
rra[5].pdp_per_row = 30
rra[5].xff = 5.0000000000e-01
rra[5].cdp_prep[0].value = NaN
rra[5].cdp_prep[0].unknown_datapoints = 4
rra[6].cf = "MIN"
rra[6].rows = 2160
rra[6].cur_row = 721
rra[6].pdp_per_row = 120
rra[6].xff = 5.0000000000e-01
rra[6].cdp_prep[0].value = NaN
rra[6].cdp_prep[0].unknown_datapoints = 94
rra[7].cf = "MIN"
rra[7].rows = 797
rra[7].cur_row = 296
rra[7].pdp_per_row = 1440
rra[7].xff = 5.0000000000e-01
rra[7].cdp_prep[0].value = NaN
rra[7].cdp_prep[0].unknown_datapoints = 214
rra[8].cf = "MAX"
rra[8].rows = 8640
rra[8].cur_row = 6666
rra[8].pdp_per_row = 5
rra[8].xff = 5.0000000000e-01
rra[8].cdp_prep[0].value = NaN
rra[8].cdp_prep[0].unknown_datapoints = 4
rra[9].cf = "MAX"
rra[9].rows = 4320
rra[9].cur_row = 76
rra[9].pdp_per_row = 30
rra[9].xff = 5.0000000000e-01
rra[9].cdp_prep[0].value = NaN
rra[9].cdp_prep[0].unknown_datapoints = 4
rra[10].cf = "MAX"
rra[10].rows = 2160
rra[10].cur_row = 1644
rra[10].pdp_per_row = 120
rra[10].xff = 5.0000000000e-01
rra[10].cdp_prep[0].value = NaN
rra[10].cdp_prep[0].unknown_datapoints = 94
rra[11].cf = "MAX"
rra[11].rows = 797
rra[11].cur_row = 406
rra[11].pdp_per_row = 1440
rra[11].xff = 5.0000000000e-01
rra[11].cdp_prep[0].value = NaN
rra[11].cdp_prep[0].unknown_datapoints = 214
rra[12].cf = "LAST"
rra[12].rows = 8640
rra[12].cur_row = 8359
rra[12].pdp_per_row = 5
rra[12].xff = 5.0000000000e-01
rra[12].cdp_prep[0].value = NaN
rra[12].cdp_prep[0].unknown_datapoints = 4
rra[13].cf = "LAST"
rra[13].rows = 4320
rra[13].cur_row = 129
rra[13].pdp_per_row = 30
rra[13].xff = 5.0000000000e-01
rra[13].cdp_prep[0].value = NaN
rra[13].cdp_prep[0].unknown_datapoints = 4
rra[14].cf = "LAST"
rra[14].rows = 2160
rra[14].cur_row = 1035
rra[14].pdp_per_row = 120
rra[14].xff = 5.0000000000e-01
rra[14].cdp_prep[0].value = NaN
rra[14].cdp_prep[0].unknown_datapoints = 94
rra[15].cf = "LAST"
rra[15].rows = 797
rra[15].cur_row = 600
rra[15].pdp_per_row = 1440
rra[15].xff = 5.0000000000e-01
rra[15].cdp_prep[0].value = NaN
rra[15].cdp_prep[0].unknown_datapoints = 214

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start='-86400' \
--end='-1500' \
--title='Hudson Westronic - Alarm State - GENERATOR RUNNING' \
--rigid \
--base='1000' \
--height='50' \
--width='500' \
--alt-autoscale-max \
--lower-limit='0' \
--vertical-label='status' \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a='/var/lib/cacti/rra/768/25629.rrd':'westronic_state':LAST \
AREA:a#7EE600FF:'State' \
GPRINT:a:LAST:'%8.2lf %s\n' \
COMMENT:'(1 = Up | 2 = Down)\n'

RRDTool Says:

OK

Data Source Debug

/usr/bin/rrdtool create \
/var/lib/cacti/rra/768/25629.rrd \
--step 300 \
DS:westronic_state:GAUGE:600:0:U \
RRA:AVERAGE:0.5:5:8640 \
RRA:AVERAGE:0.5:30:4320 \
RRA:AVERAGE:0.5:120:2160 \
RRA:AVERAGE:0.5:1440:797 \
RRA:MIN:0.5:5:8640 \
RRA:MIN:0.5:30:4320 \
RRA:MIN:0.5:120:2160 \
RRA:MIN:0.5:1440:797 \
RRA:MAX:0.5:5:8640 \
RRA:MAX:0.5:30:4320 \
RRA:MAX:0.5:120:2160 \
RRA:MAX:0.5:1440:797 \
RRA:LAST:0.5:5:8640 \
RRA:LAST:0.5:30:4320 \
RRA:LAST:0.5:120:2160 \
RRA:LAST:0.5:1440:797 \

cacti:~# snmpwalk -c public -v 1 192.168.205.154 .1.3.6.1.4.1.10385.2.3.2.1.1.4.1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.1 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.2 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.3 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.4 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.5 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.6 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.7 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.8 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.9 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.10 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.11 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.12 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.13 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.14 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.15 = INTEGER: 1
iso.3.6.1.4.1.10385.2.3.2.1.1.4.1.16 = INTEGER: 1

The integer will go to 2 when it is in alarm. Let me know if there is any other information that would help solve this.


Edit: forgot to add this. This is my xml file

<interface>
<name>Get Westronic Alarm State</name>
<description>Alarm State</description>
<oid_index>.1.3.6.1.4.1.10385.2.3.2.1.1</oid_index>
<oid_num_indexes>.1.3.6.1.4.1.10385.2.3.2.1.1.8</oid_num_indexes>
<index_order>discreteDescription</index_order>
<index_order_type>numeric</index_order_type>
<index_title_format>|chosen_order_field|</index_title_format>

<fields>
<discreteDescription>
<name>Index</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.4.1.10385.2.3.2.1.1.8.1</oid>
</discreteDescription>
<discreteAlarmState>
<name>Index</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.10385.2.3.2.1.1.4.1</oid>
</discreteAlarmState>
</fields>
</interface>


Top
 Profile  
 
 Post subject: Re: Data not filling graph -nan
PostPosted: Thu May 11, 2017 8:01 am 
Offline

Joined: Mon Oct 20, 2014 12:50 pm
Posts: 12
I figured out what I was doing wrong. under data queries and then associated graph templates on the far right of data source there is an unlabeled checkbox I had been overlooking. I checked that recreated the graphs and it started working. Not sure why that would not be enabled by default.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: Google Adsense [Bot], kawin and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group