Graphs are not displaying

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
Ady
Posts: 5
Joined: Thu Apr 27, 2006 2:58 pm

Graphs are not displaying

Post by Ady »

Hi,

I've managed to get the poller working and reteiving data from my firewall, however when I create a graph I don't get the image.

Below is the debug data for the graph:
c:/progra~1/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Netscreen Firewall - Traffic - 85.234.130.120 (untrust)" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes per second" \
DEF:a="D\:/Sites/paperheads.co.uk/cacti/rra/netscreen_firewall_traffic_in_9.rrd":traffic_in:AVERAGE \
DEF:b="D\:/Sites/paperheads.co.uk/cacti/rra/netscreen_firewall_traffic_in_9.rrd":traffic_out:AVERAGE \
AREA:a#00CF00:"Inbound" \
GPRINT:a:LAST:" Current\:%8.2lf %s" \
GPRINT:a:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:a:MAX:"Maximum\:%8.2lf %s" \
COMMENT:"Total In: 0 bytes\n" \
LINE1:b#002A97:"Outbound" \
GPRINT:b:LAST:"Current\:%8.2lf %s" \
GPRINT:b:AVERAGE:"Average\:%8.2lf %s" \
GPRINT::MAX:"Maximum\:%8.2lf %s" \
COMMENT:"Total Out: 0 bytes"
By the looks of things no data is being sent to the rrdtool, but I cant work out why.

Does anyone have any ideas, or know where I can start looking?

Ta,
Ady
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please change Settings -> Logging Level to DEBUG for ONE polling cycle and check log/cacti.log. You should see the SNMP request (including host and OID), the result and an rrdtool update for this. Please post
Reinhard
Ady
Posts: 5
Joined: Thu Apr 27, 2006 2:58 pm

Post by Ady »

Hi,

Thanks for the reply, as requested this is the output:

Ta,
Ady
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','d:/Sites/paperheads.co.uk/cacti')"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
04/27/2006 09:25:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/progra~1/php/php.exe, ARGS: -q d:/sites/paperheads.co.uk/cacti/cmd.php 0 3]
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 0 and id <= 3) ORDER by id"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= 3) ORDER by host_id"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= 3))"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP
04/27/2006 09:25:00 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 = '4.57000', max_time = '63.73000', cur_time = '4.71', avg_time = '8.12467294118', total_polls = '17', failed_polls = '0', availability = '100' where hostname = '192.168.101.1'"
04/27/2006 09:25:00 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=3"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] Host[3] RECACHE: Processing 1 items in the auto reindex cache for '192.168.101.1'.
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='202517414' where host_id='3' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] Host[3] DS[9] SNMP: v1: 192.168.101.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, output: 3088754971
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (9,'traffic_in','2006-04-27 21:25:00','3088754971')"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] Host[3] DS[9] SNMP: v1: 192.168.101.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, output: 383069158
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (9,'traffic_out','2006-04-27 21:25:00','383069158')"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] Host[3] DS[8] SNMP: v1: 192.168.101.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, output: 3088754971
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (8,'traffic_in','2006-04-27 21:25:00','3088754971')"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] Host[3] DS[8] SNMP: v1: 192.168.101.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, output: 383069158
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (8,'traffic_out','2006-04-27 21:25:00','383069158')"
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] Time: 0.0367 s, Theads: N/A, Hosts: 1
04/27/2006 09:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
04/27/2006 09:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
04/27/2006 09:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
04/27/2006 09:25:01 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)"
04/27/2006 09:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='9' and rrd_name='traffic_in' and time='2006-04-27 21:25:00'"
04/27/2006 09:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='9' and rrd_name='traffic_out' and time='2006-04-27 21:25:00'"
04/27/2006 09:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='8' and rrd_name='traffic_in' and time='2006-04-27 21:25:00'"
04/27/2006 09:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='8' and rrd_name='traffic_out' and time='2006-04-27 21:25:00'"
04/27/2006 09:25:01 PM - POLLER: Poller[0] CACTI2RRD: c:/progra~1/rrdtool/rrdtool.exe update D:\Sites\paperheads.co.uk\cacti\rra\netscreen_firewall_traffic_in_9.rrd --template traffic_in:traffic_out 1146169500:3088754971:383069158
04/27/2006 09:25:01 PM - POLLER: Poller[0] CACTI2RRD: c:/progra~1/rrdtool/rrdtool.exe update D:\Sites\paperheads.co.uk\cacti\rra\netscreen_firewall_traffic_in_8.rrd --template traffic_in:traffic_out 1146169500:3088754971:383069158
04/27/2006 09:25:01 PM - SYSTEM STATS: Time:1.0271 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:4 RRDsProcessed:2
04/27/2006 09:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.0271 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:4 RRDsProcessed:2')"
04/27/2006 09:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
04/27/2006 09:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

1) read this post: http://forums.cacti.net/viewtopic.php?t=11747

2) are the rrd files actually updating?

3) Enable graph debugging and post the commandline output. What is the error?
Ady
Posts: 5
Joined: Thu Apr 27, 2006 2:58 pm

Post by Ady »

Hi,

Yes I did use this topic to get as far as I have. I have applied all patches, and temporarily set the user account to administrator.

How do I know if the RRD files are actually being updated?

My first post shows the graph debug output.

Thanks,
Ady
Webserver: Windows Server 2003 (SP1)
Cacti: 0.8.6h
Cactid: 0.8.6g
MySQL: 4.0.26-nt
PHP: 5.1.2
RRDTool: cygwin 1.2.9
Net-SNMP: 5.1.2
Cygwin: Yes
Attachments
cacti.zip
Cacti Log
(2.57 KiB) Downloaded 73 times
netscreen_firewall_traffic_in_9.zip
Generated RRD File
(3.76 KiB) Downloaded 85 times
Ady
Posts: 5
Joined: Thu Apr 27, 2006 2:58 pm

Post by Ady »

Hi,

Looks like I was selecting the wrong type of graph. Selecting bits/per second rather than bytes/per second creates a graph.

Ta,
Ady
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Ady wrote: How do I know if the RRD files are actually being updated?
Use

Code: Select all

rrdtool fetch <rrd file> AVERAGE
and check the last lines. They should NOT hold NaN's
Reinhard
Ady
Posts: 5
Joined: Thu Apr 27, 2006 2:58 pm

Post by Ady »

Hi lvm, BSOD2600,

Thanks for all the help and your swift replies. Looks like everything was set up ok in the first place, and it was only me being dense. Nice bit of software by the way, pitty it look me nearly 4 hours to get everything working.

Ta,
Ady
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests