No Graphs after upgrading to 0.8.6i

[NetAdmin]

Cacti Version 0.8.6i
Plugin Architecture 1.0
Poller Type CMD.php
Server Info Windows NT 5.2
Web Server Microsoft-IIS/6.0
PHP Version 4.4.3
PHP Extensions standard, bcmath, calendar, ctype, com, ftp, mysql, odbc, overload, pcre, session, tokenizer, xml, wddx, zlib, ISAPI, gd, snmp, sockets
MySQL Version 4.1.21-community-nt
RRDTool Version 1.0.49

Recently upgraded from 0.8.6h. The .rrd files are being updated, however graph images are not displayed since the upgrade. I verified all of the folder/file permissions are correct. Poller is running with no errors. Set logging level to debug and did not see any errors.

NetAdmin

[BSOD2600]

Enable graph debugging, what is the error?

Check your system for multiple copies of cygwin1.dll and remove them.

[NetAdmin]

When I attempt to turn on graph debug, the browser just hangs waiting for a response from the server. I've tried this with both IE and Firefox. Is there a command line graph debug that I can run to see the error?

I currently don't have Cygwin installed, so there is no .dll file anywhere.

NetAdmin

[NetAdmin]

Well, I managed to fix this by upgrading the RRD tool to the cygwin build (rrdtool-1.2.15-cygwin-1.5.20) that you had recommended in your "Installing under Windows" section of the Cacti manual - very nice by the way!

I then installed the cygwin tool and followed your instructions and voila - after a few polling cycles the graphs appeared. The graphs are much nicer in this new version.

[NetAdmin]

Ok, so perhaps I spoke a little bit too soon. While all of my previous graphs are displaying just fine, I am unable to view any newly created graphs. The .rrd files are created and updated after each polling cycle, and when viewing them I just get the red X for the graph image.

I am still unable to do a graph debug (the browser just hangs - both I.E. and Firefox). I've verified that I only have on cygwin1.dll file on my system. The debug log isn't very helpful, but I would be happy to post it.

NetAdmin

[BSOD2600]

Hmm, interesting. Fire up Sysinternals FileMon and see if anything is getting denied.

Another alternative is to enable debugging in php.ini. Don't have it in front of me, but there are some options in there to log all errors to a file you specify. That can also reveal a problem.

[NetAdmin]

I've attached the output of the FileMon (zipped file contains the .log file). There are quite a bit of "FILE NOT FOUND" and "INVALID PARAMETER" results. Not sure whether or not that means much.. When I attempt to view one of the newer graphs (ny_1750_router_traffic_in_194.rrd) the read request does have a "SUCCESS" result.

Sorry about the length of the log. Hope this helps though.

Thanks for looking into this.

NetAdmin

[NetAdmin]

I was somehow able to run the graph debug, which contains:

RRDTool Command:

C:\rrdtool\rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="NY 1750 Router - Dual T1 Links to DC" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="c\:/cacti/rra/ny_1750_router_traffic_in_194.rrd":traffic_in:AVERAGE \
DEF:b="c\:/cacti/rra/ny_1750_router_traffic_in_194.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdeff=b,8,* \
CDEF:cdefbe=a,UN,INF,UNKN,IF \
CDEF:cdefbh=TIME,1166145605,GT,a,a,UN,0,a,IF,IF,TIME,1166145605,GT,b,b,UN,0,b,IF,IF,+ \
AREA:cdefa#00CF00:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
COMMENT:"Transfer\: 362.36 KB" \
LINE1:cdeff#002A97:"Outbound" \
GPRINT:cdeff:LAST:"Current\:%8.2lf %s" \
HRULE:|95\:bits\:0\:current|#00FF00:"95%\:" \
COMMENT:"|95\:bits\:6\:current| mbit\n" \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s\n" \
COMMENT:"\n" \
HRULE:112.96#FF0000:"95th Percentile" \
COMMENT:"(0 mbit in+out)" \
AREA:cdefbe#8F9286:"" \
COMMENT:"Transfer\: 350.91 KB" \
HRULE:|95\:bits\:0\:current|#0000FF:"95%\:" \
COMMENT:"0 mbit" \
COMMENT:"Total Transfer\: 713.27 KB\n"
RRDTool Says:

[BSOD2600]

That lack of any error message typically means its a problem with the graph creation and/or Cygwin. I'm not on my computer (power still out) so can't analyze your FileMon logs.

Manually copy/paste that rrdtool graph command and try it at the commandline. What error does it spit out?

[NetAdmin]

When I attempt to run the code manually from a prompt, it doesn't like the format.

C:\rrdtool>rrdtool.exe graph --imgformat=PNG --start=-86400 --end=-300 --title="
NY 1750 Router - Dual T1 Links to DC" --rigid --base=1000 --height=120 --width=5
00 --alt-autoscale-max --lower-limit=0 --vertical-label="bits per second" --slop
e-mode DEF:a="c\:/cacti/rra/ny_1750_router_traffic_in_194.rrd":traffic_in:AVERAG
E DEF:b="c\:/cacti/rra/ny_1750_router_traffic_in_194.rrd":traffic_out:AVERAGE CD
EF:cdefa=a,8,* CDEF:cdeff=b,8,* CDEF:cdefbe=a,UN,INF,UNKN,IF CDEF:cdefbh=TIME,11
66145605,GT,a,a,UN,0,a,IF,IF,TIME,1166145605,GT,b,b,UN,0,b,IF,IF,+ AREA:cdefa#00
CF00:"Inbound" GPRINT:cdefa:LAST:" Current\:%8.2lf %s" GPRINT:cdefa:AVERAGE:"Ave
rage\:%8.2lf %s" GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" COMMENT:"Transfer\: 362
.36 KB" LINE1:cdeff#002A97:"Outbound" GPRINT:cdeff:LAST:"Current\:%8.2lf %s" HRU
LE:|95\:bits\:0\:current|#00FF00:"95%\:" COMMENT:"|95\:bits\:6\:current| mbit\n"
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s\
n" COMMENT:"\n" HRULE:112.96#FF0000:"95th Percentile" COMMENT:"(0 mbit in+out)"
AREA:cdefbe#8F9286:"" COMMENT:"Transfer\: 350.91 KB" HRULE:|95\:bits\:0\:current
|#0000FF:"95%\:" COMMENT:"0 mbit" COMMENT:"Total Transfer\: 713.27 KB\n"
The filename, directory name, or volume label syntax is incorrect.

C:\rrdtool>

I've tried it several different ways, including copying and pasting the RRDTool Command script from the graph debug, all with the same results.

NetAdmin

[BSOD2600]

I'm assuming the reason the text is wrapped in the forum is because you copy/pasted it from the command window? If not, you need to remove all line breaks before pasting that rrdtool graph command tot he command prompt.

Does c:\cacti\rra\ny_1750_router_traffic_in_194.rrd exist? If not, then you likely have a NTFS permission issue (which FileMon should've revealed -- sorry still don't have power ).

[NetAdmin]

Yes, that file definitely exists and it is being modified each time the poller runs. I've also verified the permissions on this file. I also tried creating other new graphs with the same results. Could this have anything to do with the upgrade of the RRD tool to the cygwin version? I'll try running that command again and post the results.

[BSOD2600]

Could this have anything to do with the upgrade of the RRD tool to the cygwin version?

Most likely. Could try reverting back to an older version of rrdtool+cygwin to see if that fixes it. Stick with rrdtool 1.2.x though, otherwise your new graphs WILL be broken.

Another alternative is to update Cygwin. Since I'm not aware of the files being able to be downloaded singely, you'll have to do a base install of Cygwin (guide in my installation guide). Once thats done, remove all .dll files from your rrdtool/cactid directories.

[NetAdmin]

Ok, well I've tried three different previous versions (1.2.13, 1.2.10, and 1.2.4) of RRD/cygwin build, all with the same results. I am able to view all of the graphs that were created prior to upgrading to RRD 1.2/cygwin build (from 1.0.49 win32-bin). None of the new graphs are visible and the graph debug doesn't show any errors, yet the graphs are being updated each time the poller runs.

I'm at a loss.

[NetAdmin]

Ahh.. Ok, so this has nothing to do with the RRD upgrade, and everything to do with the Cacti upgrade, specifically when using Interface graphs with 95th percentile.

This post explains exerthing:

http://forums.cacti.net/viewtopic.php?t=16731

I guess there was a silent change made in 0.8.6i that screwed up this particular graph template. It never affected my original graphs, so that tells me that the graph template is only used when the graph is initially created. This would explain why it only affected new graphs. Is this correct?

NetAdmin