No Graphs - Upgrade Cacti-0.8.6f

[Phobos182]

Upgraded from version 0.8.6c. Everything was working fine before. Now after upgrading, I have no graphs showing at all. Is anybody else having this problem? I've never experienced this with the time I've been using MRTG / RRDTOOL / Cacti.

Versions - Windows 2000 Server Host System
Cacti
0.8.6f
PHP
PHP 4.4.0 (cgi-fcgi) (built: Jul 11 2005 16:13:04)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
Net-Snmp
NET-SNMP version: 5.2.1
RRDTOOL
RRDtool 1.2.11 Copyright 1997-2005 by Tobias Oetiker <tobi@oetiker.ch>
Compiled Tue Aug 2 21:46:25 EST 2005

CACTI Log File: Debugging
08/04/2005 10:38:24 AM - SYSTEM STATS: Time: 8.8412 s, Method: cmd.php, Processes: 5, Threads: N/A, Hosts: 20, Hosts/Process: 4, Data Sources 555, RRDs Processed 0
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_5_traffic_in_222.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_7_traffic_in_324.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_server_switch_traffic_in_153.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\moe_load_1min_336.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_5_traffic_in_221.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\moe_load_15min_337.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\moe_load_5min_338.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_5_traffic_in_234.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_5_traffic_in_235.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_5_traffic_in_236.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_5_traffic_in_237.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_5_traffic_in_238.rrd --template N:
08/04/2005 10:38:24 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_5_traffic_in_233.rrd --template N:
...

08/04/2005 10:38:22 AM - CMDPHP: Poller[0] Host[24] DS[243] SNMP: v2: 192.168.1.14, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.24, output: 2350976099
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_1_traffic_in_52.rrd --template N:
08/04/2005 10:38:21 AM - CMDPHP: Poller[0] Host[24] DS[243] SNMP: v2: 192.168.1.14, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.24, output: 488636350
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_business_development_traffic_in_167.rrd --template N:
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_2_traffic_in_88.rrd --template N:
08/04/2005 10:38:21 AM - CMDPHP: Poller[0] Host[24] DS[242] SNMP: v2: 192.168.1.14, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.23, output: 2546767940
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_1_traffic_in_53.rrd --template N:
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_business_development_traffic_in_168.rrd --template N:
08/04/2005 10:38:21 AM - CMDPHP: Poller[0] Host[24] DS[242] SNMP: v2: 192.168.1.14, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.23, output: 498043481
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_2_traffic_in_89.rrd --template N:
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_1_traffic_in_54.rrd --template N:
08/04/2005 10:38:21 AM - CMDPHP: Poller[0] Host[24] DS[241] SNMP: v2: 192.168.1.14, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.22, output: 1496877873
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_business_development_traffic_in_169.rrd --template N:
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_2_traffic_in_90.rrd --template N:
08/04/2005 10:38:21 AM - CMDPHP: Poller[0] Host[24] DS[241] SNMP: v2: 192.168.1.14, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.22, output: 338212589
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_2_traffic_in_84.rrd --template N:
08/04/2005 10:38:21 AM - CMDPHP: Poller[0] Host[24] DS[240] SNMP: v2: 192.168.1.14, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.21, output: 103471643
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_1_traffic_in_50.rrd --template N:
08/04/2005 10:38:21 AM - POLLER: Poller[0] RRD: c:\cacti\rrdtool\rrdtool.exe update C:\cacti\cacti-0.8.6f\rra\2950_client_services_2_traffic_in_85.rrd --template N:
08/04/2005 10:38:21 AM - CMDPHP: Poller[0] Host[24] DS[240] SNMP: v2: 192.168.1.14, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.21, output: 6099999

RRDTool Graph Debugging
RRDTool Says:

Warning: popen(c:\cacti\rrdtool\rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="Powerware 9170+ UPS - Powerware EMP" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="Celsius / %Humidity" DEF:a="C\:\cacti\cacti-0.8.6f/rra/powerware_9170_ups_emp_humidity_339.rrd":EMP_Humidity:AVERAGE DEF:b="C\:\cacti\cacti-0.8.6f/rra/powerware_9170_ups_emp_temp_340.rrd":EMP_temp:AVERAGE DEF:c="C\:\cacti\cacti-0.8.6f/rra/powerware_9170_ups_emp_humidity_339.rrd":EMP_Humidity:AVERAGE DEF:d="C\:\cacti\cacti-0.8.6f/rra/powerware_9170_ups_emp_temp_340.rrd":EMP_temp:AVERAGE AREA:c#4444FF:"Humidity" GPRINT:c:LAST:" Current\:%8.2lf %s" GPRINT:c:AVERAGE:"Average\:%8.2lf %s" GPRINT:c:MAX:"Maximum\:%8.2lf %s\n" AREA:d#FF0000:"Temperature" GPRINT:d:LAST:" Current\:%8.2lf %s" GPRINT:d:AVERAGE:"Average\:%8.2lf %s" GPRINT:d:MAX:"Maximum\:%8.2lf %s\n" LINE2:c#000000:"" LINE2:d#000000:"" 2>&1,rb): No error in C:\cacti\cacti-0.8.6f\lib\rrd.php on line 116

Warning: fgets(): supplied argument is not a valid stream resource in C:\cacti\cacti-0.8.6f\lib\rrd.php on line 149

GRAPH Properties
c:\cacti\rrdtool\rrdtool.exe graph - \
--imgformat=PNG \
--start=1123083899 \
--end=1123170299 \
--title="Powerware 9170+ UPS - Powerware EMP" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2005/08/03 10:44:59 To 2005/08/04 10:44:59\c" \
COMMENT:"\n" \
--vertical-label="Celsius / %Humidity" \
DEF:a="C\:\cacti\cacti-0.8.6f/rra/powerware_9170_ups_emp_humidity_339.rrd":EMP_Humidity:AVERAGE \
DEF:b="C\:\cacti\cacti-0.8.6f/rra/powerware_9170_ups_emp_temp_340.rrd":EMP_temp:AVERAGE \
DEF:c="C\:\cacti\cacti-0.8.6f/rra/powerware_9170_ups_emp_humidity_339.rrd":EMP_Humidity:AVERAGE \
DEF:d="C\:\cacti\cacti-0.8.6f/rra/powerware_9170_ups_emp_temp_340.rrd":EMP_temp:AVERAGE \
AREA:c#4444FF:"Humidity" \
GPRINT:c:LAST:" Current\:%8.2lf %s" \
GPRINT:c:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:c:MAX:"Maximum\:%8.2lf %s\n" \
AREA:d#FF0000:"Temperature" \
GPRINT:d:LAST:" Current\:%8.2lf %s" \
GPRINT:d:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:d:MAX:"Maximum\:%8.2lf %s\n" \
LINE2:c#000000:"" \
LINE2:d#000000:""

[BSOD2600]

1) Did you snip the part of your logs which contain the CACTI2RRD sections? If not, thats part of the reason why your rrd files are not getting updated (and I'm not sure how to make it start again).

2) Sure the security permissions on the folders are properly set?

3) Goto Settings->General and set Logging Level to DEBUG. Then open a command line and run the following one at a time.

"php <path_cacti>/cmd.php" -> post output
"php poller.php" -> post output

[Phobos182]

I feel like a tool. The RRDTOOL properities problem was caused by IIS LOCK DOWN utility removing execute / read permissions from cmd.exe. I removed those, and now RRDTOOL can graph. I had a lot of funky / glitchy graphs with RRDTOOL 1.2.11, so I went back to RRDTOOL 1.0.49, and that works fine.

Right now as I see it, no RRD files are being updated. Everything is blank. You can see the attached screenshot.

I have attached the output from cmd.php, and poller.php. There are many errors / warnings in poller.php.

[Phobos182]

typing for bump.

[BSOD2600]

Heh, now you really broke something

Which php.ini file did you initially use? It's either that, or the IIS lockdown tool which has changed security settings causing the cacti poller to break.

[Phobos182]

The one that came with it (php-dist.ini). I modified it to add the snmp / sockets line. I will attach it as follows.

[BSOD2600]

All pretty much looks the exact same as mine except, I've got fastcgi.impersonate = 1;

Did you properly set up the PHP ISAPI in IIS?

Double checked other security permissions on the cacti, php, rrdtool folders?

[TheWitness]

Hey BSOD!

Is PHP 4.4 working then?

TheWitness

[BSOD2600]

He cautiously says Yes.

After I weed out my issues with switching to rrdtool 1.2.11, then I will be sure.

[Phobos182]

Using another server in the organization, I started with an absoutly fresh copy of Cacti, with a new MySql DB. First off, with PHP 5.0.4 I was using, the MIBSDIR environment variable pointed to the MIBS directory of PHP. This caused many problems. The final solution was to point the MIBSDIR environment variable to NET-SNMP's mib directory (In my case, c:\net-snmp\share\mibs). I experienced a problem with cmd.php, and switched to CACTID. It started polling fine, and working fine. I created a few graphs. Waited a few poller intevals, and everything was working.

Because I verifyied functionality, I switched the config.php parameters over to my old database, as well as cactid.conf, and copied the old RRD files to the RRA folder on the new cacti installation. It immediatly starts crashing on the poller like before.

I deleted all of my RRD files, and it's working. It looks like a rrd database problem with the upgrade. This really sucks since I have a year and a half worth of data in the RRD files. I'll see what I can do to get it working, but it's weird that after I delete the RRD files, it's back up and running.

[TheWitness]

What version of rrdtool?

[Phobos182]

I am now using 1.2.9 (works great). The 1.2.10+ was not working for me. Showing broken graphs (No text, no lines, etc..)

The version I was getting the errors with was 1.0.49

[TheWitness]

Yes, reverting to 1.0.49 will not work for any RRD files created with 1.2.x. They are not compatible.

TheWitness