current,average,maximum is always 0. i don't get the calculated values.
I have set autoscale in graph template. Snapshot of graph template attached.
when i executed perl script manually I get following output
c:\Apache24\htdocs\cacti\scripts>perl try1.pl 192.168.200.9
usr:0.03 nice:0.00
c:\Apache24\htdocs\cacti\scripts>
so i am expecting Y axis units to range from 0.0 to 100.0
Graph template
**************
Graph Template
Title (--title)
Use Per-Graph Value (Ignore this Value)
CPU Utilization NOC controller NX9500-1
Image Format (--imgformat)
Use Per-Graph Value (Ignore this Value)
Height (--height)
Use Per-Graph Value (Ignore this Value)
120
Width (--width)
Use Per-Graph Value (Ignore this Value)
500
Slope Mode (--slope-mode)
Use Per-Graph Value (Ignore this Value) Slope Mode (--slope-mode)
Auto Scale
Use Per-Graph Value (Ignore this Value) Auto Scale
Auto Scale Options
Use Per-Graph Value (Ignore this Value) Use --alt-autoscale (ignoring given limits)
Use --alt-autoscale-max (accepting a lower limit)
Use --alt-autoscale-min (accepting an upper limit, requires rrdtool 1.2.x)
Use --alt-autoscale (accepting both limits, rrdtool default)
Logarithmic Scaling (--logarithmic)
Use Per-Graph Value (Ignore this Value) Logarithmic Scaling (--logarithmic)
SI Units for Logarithmic Scaling (--units=si)
Use Per-Graph Value (Ignore this Value) SI Units for Logarithmic Scaling (--units=si)
Rigid Boundaries Mode (--rigid)
Use Per-Graph Value (Ignore this Value) Rigid Boundaries Mode (--rigid)
Auto Padding
Use Per-Graph Value (Ignore this Value) Auto Padding
Allow Graph Export
Use Per-Graph Value (Ignore this Value) Allow Graph Export
Upper Limit (--upper-limit)
Use Per-Graph Value (Ignore this Value)
100
Lower Limit (--lower-limit)
Use Per-Graph Value (Ignore this Value)
0
Base Value (--base)
Use Per-Graph Value (Ignore this Value)
1000
Unit Grid Value (--unit/--y-grid)
Use Per-Graph Value (Ignore this Value)
Unit Exponent Value (--units-exponent)
Use Per-Graph Value (Ignore this Value)
0
Vertical Label (--vertical-label)
Use Per-Graph Value (Ignore this Value)
percentage utilization
C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start="-86400" \
--end="-300" \
--title="CPU Utilization NOC controller NX9500-1" \
--rigid \
--base="1000" \
--height="120" \
--width="500" \
--alt-autoscale \
--upper-limit="100" \
--lower-limit="0" \
--units-exponent="0" \
--vertical-label="percentage utilization" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="C\:/Apache24/htdocs/cacti/rra/3/51.rrd":"usr":AVERAGE \
DEF:b="C\:/Apache24/htdocs/cacti/rra/3/51.rrd":"nice":AVERAGE \
AREA:a#FFF200FF:"cpu util (usr)" \
GPRINT
LAST:" Current\:%8.0lf" \GPRINT
AVERAGE:"Average\:%8.0lf" \GPRINT
MAX:"Maximum\:%8.0lf\n" \AREA:b#FFAB00FF:"cpu util (nice)" \
GPRINT
LAST:"Current\:%8.0lf" \GPRINT
AVERAGE:"Average\:%8.0lf" \GPRINT
MAX:"Maximum\:%8.0lf\n" cacti logs
********
How to check the entry written into SQL database?
02/06/2016 06:15:01 PM - SYSTEM STATS: Time:0.9601 Method:cmd.php Processes:8 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:2 RRDsProcessed:2
02/06/2016 06:20:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1366', SQL:"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.00000', max_time = 'down', cur_time = 'down', avg_time = '1.3928571428571', total_polls = '14', failed_polls = '0', availability = '100' where hostname = '192.168.200.9''
02/06/2016 06:20:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:''
02/06/2016 06:20:01 PM - CMDPHP: Poller[0] Host[3] DS[12] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:20:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:'.1.3.6.1.4.1.9.2.1.58.0'
02/06/2016 06:20:01 PM - CMDPHP: Poller[0] Host[3] DS[17] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:20:01 PM - SYSTEM STATS: Time:0.9831 Method:cmd.php Processes:8 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:2 RRDsProcessed:2
02/06/2016 06:25:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1366', SQL:"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.00000', max_time = 'down', cur_time = 'down', avg_time = '1.3928571428571', total_polls = '14', failed_polls = '0', availability = '100' where hostname = '192.168.200.9''
02/06/2016 06:25:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:''
02/06/2016 06:25:01 PM - CMDPHP: Poller[0] Host[3] DS[12] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:25:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:'.1.3.6.1.4.1.9.2.1.58.0'
02/06/2016 06:25:01 PM - CMDPHP: Poller[0] Host[3] DS[17] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:25:01 PM - SYSTEM STATS: Time:1.0391 Method:cmd.php Processes:8 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:2 RRDsProcessed:2
02/06/2016 06:30:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1366', SQL:"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.00000', max_time = 'down', cur_time = 'down', avg_time = '1.3928571428571', total_polls = '14', failed_polls = '0', availability = '100' where hostname = '192.168.200.9''
02/06/2016 06:30:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:''
02/06/2016 06:30:01 PM - CMDPHP: Poller[0] Host[3] DS[12] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:30:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:'.1.3.6.1.4.1.9.2.1.58.0'
02/06/2016 06:30:01 PM - CMDPHP: Poller[0] Host[3] DS[17] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:30:01 PM - SYSTEM STATS: Time:0.9901 Method:cmd.php Processes:8 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:2 RRDsProcessed:2
02/06/2016 06:35:04 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1366', SQL:"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.00000', max_time = 'down', cur_time = 'down', avg_time = '1.3928571428571', total_polls = '14', failed_polls = '0', availability = '100' where hostname = '192.168.200.9''
02/06/2016 06:35:04 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:''
02/06/2016 06:35:04 PM - CMDPHP: Poller[0] Host[3] DS[12] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:35:04 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:'.1.3.6.1.4.1.9.2.1.58.0'
02/06/2016 06:35:04 PM - CMDPHP: Poller[0] Host[3] DS[17] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:35:04 PM - SYSTEM STATS: Time:1.1761 Method:cmd.php Processes:8 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:2 RRDsProcessed:2
02/06/2016 06:40:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1366', SQL:"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.00000', max_time = 'down', cur_time = 'down', avg_time = '1.3928571428571', total_polls = '14', failed_polls = '0', availability = '100' where hostname = '192.168.200.9''
02/06/2016 06:40:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:''
02/06/2016 06:40:01 PM - CMDPHP: Poller[0] Host[3] DS[12] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:40:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:'.1.3.6.1.4.1.9.2.1.58.0'
02/06/2016 06:40:01 PM - CMDPHP: Poller[0] Host[3] DS[17] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:40:01 PM - SYSTEM STATS: Time:0.9151 Method:cmd.php Processes:8 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:2 RRDsProcessed:2
02/06/2016 06:45:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1366', SQL:"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.00000', max_time = 'down', cur_time = 'down', avg_time = '1.3928571428571', total_polls = '14', failed_polls = '0', availability = '100' where hostname = '192.168.200.9''
02/06/2016 06:45:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:''
02/06/2016 06:45:01 PM - CMDPHP: Poller[0] Host[3] DS[12] WARNING: Result from SNMP not valid. Partial Result: U
02/06/2016 06:45:01 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.200.9', and OID:'.1.3.6.1.4.1.9.2.1.58.0'