[SOLVED] Graphs don't show up (or Graphs are broken)

diddi · Post by **diddi** » Mon May 11, 2009 3:12 am

Hi there,

you're probably tired of another graphs-don't-show-up-post, but I’ve been trying to debug this for hours, but it still doesn't work and I would greatly appreciate your help...

Versions used:
Operating System: Win 2003
Webserver: IIS 6
Cacti: 0.8.7d
MySQL: 5.1.32
PHP: 5.2.9
RRDTool (Win32 version): 1.2.30
Net-SNMP: 5.4.2.1

The problem is that the graphs don't show up, see attachement.

1. Cacti log says:

05/08/2009 11:45:02 AM - SYSTEM STATS: Time:2.1258 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:4 RRDsProcessed:2
05/08/2009 11:45:02 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update D:\wwwroot\cacti\rra\10_121_100_4_traffic_in_14.rrd --template traffic_in:traffic_out 1241775901:2303459145:1785765053
05/08/2009 11:45:02 AM - CMDPHP: Poller[0] Time: 1.8427 s, Theads: N/A, Hosts: 2
05/08/2009 11:45:02 AM - CMDPHP: Poller[0] Host[3] DS[14] SNMP: v3: 10.121.100.4, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.12002, output: 2303459145
05/08/2009 11:45:01 AM - CMDPHP: Poller[0] Host[3] DS[14] SNMP: v3: 10.121.100.4, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.12002, output: 1785765053
05/08/2009 11:45:01 AM - CMDPHP: Poller[0] Host[3] RECACHE: Processing 1 items in the auto reindex cache for '10.121.100.4'.
05/08/2009 11:45:01 AM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP
05/08/2009 11:45:01 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update D:\wwwroot\cacti\rra\10_121_100_3_traffic_in_12.rrd --template traffic_out:traffic_in 1241775900:2619382913:2843927221
05/08/2009 11:45:01 AM - CMDPHP: Poller[0] Host[2] DS[12] SNMP: v3: 10.121.100.3, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.12002, output: 2619382913
05/08/2009 11:45:01 AM - CMDPHP: Poller[0] Host[2] DS[12] SNMP: v3: 10.121.100.3, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.12002, output: 2843927221
05/08/2009 11:45:00 AM - CMDPHP: Poller[0] Host[2] RECACHE: Processing 1 items in the auto reindex cache for '10.121.100.3'.
05/08/2009 11:45:00 AM - CMDPHP: Poller[0] Host[2] SNMP: Host responded to SNMP
05/08/2009 11:45:00 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q "d:/wwwroot/cacti/cmd.php" 0 3]
05/08/2009 11:45:00 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '300', Max Runtime '298', Poller Runs: '1'

SNMP-requests apparently work and rrd files do get updated.

2. Graph debug mode says: "RRDTool Says: OK". DEF-Line seems fine: (e.g. "DEF:a="D\:/wwwroot/cacti/rra/10_121_100_3_traffic_in_12.rrd":traffic_in:AVERAGE")

3. Dito Data Source Debug mode

4. When trying to view the graph this message appears in the log:
05/08/2009 11:55:06 AM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1241690105 --end=1241776505 --title="10.121.100.3 - Traffic - ge.1.2" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2009/05/07 11\:55\:05 To 2009/05/08 11\:55\:05\c" COMMENT:" \n" --vertical-label="bytes per second" --slope-mode --font TITLE:12: --font AXIS:8: --font LEGEND:10: --font UNIT:8: DEF:a="D\:/wwwroot/cacti/rra/10_121_100_3_traffic_in_12.rrd":traffic_in:AVERAGE DEF:b="D\:/wwwroot/cacti/rra/10_121_100_3_traffic_in_12.rrd":traffic_out:AVERAGE AREA:a#00CF00FF:"Inbound" GPRINT

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

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

MAX:"Maximum\:%8.2lf %s\n" LINE1:b#002A97FF:"Outbound" GPRINT

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

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

MAX:"Maximum\:%8.2lf %s\n"

Seems ok, right?

5. NTFS-Permissions are set as suggested in the Install Guide (http://docs.cacti.net/manual:087:1_inst ... _webserver [1] and http://bsod2600.home.comcast.net/~bsod2 ... ndows.html). For debugging purposes I even gave EVERYBODY FULL permissions on the "cacti\rra" directory -- doesn't help.

6. In http://docs.cacti.net/manual:087:4_help.2_debugging it says: "From debug log, please find the MySQL update statement for that host concerning table poller_output." Well, in debug log there is no such statement at all. Turning log to devel mode, there is no update-statement eiter. (or did I oversee it?)
Log in detail:

05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT COUNT(*) FROM poller_item WHERE rrd_next_step<=0"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT host_id, COUNT(*) AS data_sources FROM poller_item WHERE rrd_next_step<=0 GROUP BY host_id ORDER BY host_id"
05/08/2009 12:05:00 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '300', Max Runtime '298', Poller Runs: '1'
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('poller_lastrun',1241777100)"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM host WHERE disabled = '' ORDER BY id"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('path_webroot','d:/wwwroot/cacti')"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "TRUNCATE TABLE poller_time"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('date',NOW())"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: 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"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 0 AND id <= 3) ORDER by id"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 0 AND host_id <= 3 AND rrd_next_step <= 0) ORDER by host_id"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 3 AND rrd_next_step <= 0)"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 0 AND host_id <= 3)"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 3)"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] Host[2] SNMP: Host responded to SNMP
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: 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 = '9.99999', max_time = '1471.79000', cur_time = '245.48', avg_time = '295.59139418605', total_polls = '86', failed_polls = '0', availability = '100' where hostname = '10.121.100.3'"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: 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"
05/08/2009 12:05:00 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "update poller_reindex set assert_value='1918503033' where host_id='2' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] Host[2] DS[12] SNMP: v3: 10.121.100.3, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.12002, output: 1048319548
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (12, 'traffic_in', '2009-05-08 12:05:00', '1048319548')"
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] Host[2] DS[12] SNMP: v3: 10.121.100.3, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.12002, output: 3542852215
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (12, 'traffic_out', '2009-05-08 12:05:00', '3542852215')"
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: 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"
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "delete from poller_output where local_data_id='12' and rrd_name='traffic_out' and time='2009-05-08 12:05:00'"
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "delete from poller_output where local_data_id='12' and rrd_name='traffic_in' and time='2009-05-08 12:05:00'"
05/08/2009 12:05:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update D:\wwwroot\cacti\rra\10_121_100_3_traffic_in_12.rrd --template traffic_out:traffic_in 1241777100:3542852215:1048319548
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: 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 = '9.99999', max_time = '236.47000', cur_time = '231.4', avg_time = '227.00428214286', total_polls = '14', failed_polls = '0', availability = '100' where hostname = '10.121.100.4'"
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: 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"
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "update poller_reindex set assert_value='1918531649' where host_id='3' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] Host[3] DS[14] SNMP: v3: 10.121.100.4, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.12002, output: 1786494599
05/08/2009 12:05:01 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (14, 'traffic_out', '2009-05-08 12:05:01', '1786494599')"
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] Host[3] DS[14] SNMP: v3: 10.121.100.4, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.12002, output: 2303603217
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (14, 'traffic_in', '2009-05-08 12:05:01', '2303603217')"
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] Time: 1.8477 s, Theads: N/A, Hosts: 2
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] DEVEL: 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) "
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "delete from poller_output where local_data_id='14' and rrd_name='traffic_in' and time='2009-05-08 12:05:01'"
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "delete from poller_output where local_data_id='14' and rrd_name='traffic_out' and time='2009-05-08 12:05:01'"
05/08/2009 12:05:02 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update D:\wwwroot\cacti\rra\10_121_100_4_traffic_in_14.rrd --template traffic_in:traffic_out 1241777101:2303603217:1786494599
05/08/2009 12:05:02 PM - SYSTEM STATS: Time:2.1279 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:4 RRDsProcessed:2
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:2.1279 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:4 RRDsProcessed:2')"
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT COUNT(*) FROM poller_command"
05/08/2009 12:05:02 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')"

Any hints?
Christian

[1] BTW: There's seems to be a typo at paragraph "Configure IIS", point 7, where it says "cacti_web_root/cacti/rrd" instead "cacti_web_root/cacti/rra"...

BSOD2600 · Post by **BSOD2600** » Mon May 11, 2009 5:52 pm

1) if you click on a graph, does it display anything?
2) correct rrdtool version set?
3) correct NTFS permissions on cmd.exe and rrdtool.exe for the IUSR_ and IIS_WPG accounts?

Otherwise, from the logs it appears cacti is getting data and updating the rrd files fine.

diddi · Post by **diddi** » Tue May 12, 2009 5:01 am

Thanks for replying.

1. No. No images show up either.
2. Yes.
3. Yes.

More hints?

BSOD2600 · Post by **BSOD2600** » Tue May 12, 2009 12:03 pm

graph management, click on the broken graph, turn on graph debugging. any errors?

diddi · Post by **diddi** » Wed May 13, 2009 4:58 am

Nope, no errors. ("Ok")

As I was bored I figured that I maybe should try to use a different browser... Well, I started firefox and for a blink of an eye a graph showed up and disappeared again. Pressing reload button -- same result. One thing I could notice was that the graph was populated with data. Ok, next: starting Opera. Have a look at the attachement and you can see what opera shows me:

* The graph definitely gets populated with data (don't mind that there's not much to see -- I just created the graph a few minutes earlier).
* The lower part of the graph is broken. This lower part keeps being broken (but always in a "different" way) after reloading the webpage.

As it seems to be a RRDtool issue I reinstalled it, but that doesn't help.

Further ideas? (Yeah, RRDtool-version is set correctly...)

Christian

diddi · Post by **diddi** » Wed May 13, 2009 4:59 am

Here's the screenshot.

BSOD2600 · Post by **BSOD2600** » Wed May 13, 2009 1:16 pm

Weird. So in graph management the image doesn't disappear, but in the Graphs tab it does?

Turn on php error logging (error_log in php.ini), see if that reveals anything. Do you have an valid rrdtool font set in cacti's settings?

diddi · Post by **diddi** » Thu May 14, 2009 1:54 am

Wooho, it works now.

I didn't set a font... that's a bit strange, because I have been setting up cacti before and hadn't set a font and it surely worked like that...

Thx, BSOD,
Christian

[SOLVED] Graphs don't show up (or Graphs are broken)

[SOLVED] Graphs don't show up (or Graphs are broken)

Who is online