Need help finding, importing, or re-creating graph templates

[Stuewe]

I inherited an existing older (unknown) version of Cacti. I have been maintaining it i.e. adding graphs for devices using existing templates.

Now, I have to abandon that installation and move to a new server and I want to be able to generate the same types of graphs on the new instance of Cacti that I have just installed (0.8.7g). The problem is that apparently, some of the graph templates that I THOUGHT were built in Cacti defaults, either my predecessor had built himself or imported from somewhere. I am unable to find them online anywhere. I have tried exporting the graph template and importing it into the new instance, but I am not having any luck.

The graphs I am trying to re-create are circuit utilization graphs like the attached picture.

I'll attach the exported graph template as well in case that's helpful.

Thanks!

Technical support information:
General Information
Date Tue, 05 Apr 2011 14:36:05 -0500
Cacti Version 0.8.7g
Cacti OS win32
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.2.x
Hosts 3
Graphs 2
Data Sources Script/Command: 5
SNMP Query: 2
Total: 7

[Stuewe]

Okay, so I tried to re-create the graph template manually on the new Cacti installation.
I copied the entries from the old graph template exactly and left the defaults where there were new options that didn't exist in the old Cacti version. When I built a graph, all I get is the red X where the graph should be. I clicked Turn on graph debug mode and I get the following output:

RRDTool Command:

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Wichita1 Router - Se4/0 - Circuit Utilization" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--upper-limit="100" \
--lower-limit="-100" \
--vertical-label="%utilization" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="C\:/Apache2/htdocs/cacti/rra/3/14.rrd":traffic_in:AVERAGE \
DEF:b="C\:/Apache2/htdocs/cacti/rra/3/14.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,*,1024,/,1000,*,8100000,/,100,* \
CDEF:cdefb=a,1024,/,0,100,LIMIT,UN,UNKN,INF,IF \
CDEF:cdeff=b,1024,/,-1,* \
CDEF:cdefg=b,8,*,1024,/,1000,*,8100000,/,100,*,100,10000,LIMIT,-1,* \
CDEF:cdefh=b,8,*,1024,/,1000,*,8100000,/,100,* \
CDEF:cdefbc=a,8,*,1024,/,1000,*,8100000,/,100,*,80,100,LIMIT \
CDEF:cdefbd=a,8,*,1024,/,1000,*,8100000,/,100,*,90,100,LIMIT \
CDEF:cdefbe=a,8,*,1024,/,1000,*,8100000,/,100,*,100,10000,LIMIT \
CDEF:cdefbf=,-1,* \
CDEF:cdefbg=,-1,* \
CDEF:cdefbh=,-1,* \
AREA:cdefa#00BF47FF:"Inbound" \
AREA:cdefb#96E78AFF:"" \
GPRINT:cdefa:LAST:" Current%6.2lf%%" \
GPRINT:cdefa:AVERAGE:"Average%6.2lf%%" \
GPRINT:cdefa:MAX:"Maximum%6.2lf%%\n" \
AREA:cdeff#005D57FF:"Outbound" \
AREA:cdefg#96E78AFF:"":STACK \
GPRINT:cdefh:LAST:" Current%6.2lf%%" \
GPRINT:cdefh:AVERAGE:"Average%6.2lf%%" \
GPRINT:cdefh:MAX:"Maximum%6.2lf%%\n" \
COMMENT:" \n" \
COMMENT:"Circuit Bandwidth 8100000 bps" \
AREA:cdefbc#7EE600FF:"80%" \
AREA:cdefbd#FFC73BFF:"90%" \
AREA:cdefbe#FF4105FF:"100%" \
AREA:cdefbf#7EE600FF:"" \
AREA:cdefbg#FFC73BFF:"" \
AREA:cdefbh:""

RRDTool Says:
ERROR: invalid rpn expression in: ,-1,*

I see that it IS getting SNMP data in because it is getting the bps for the interface.

Any idea what's wrong?

[Stuewe]

Ok. So, I found the CDEF tutorial on the RRDtool site. That helped me figure out that I needed to edit my CDEFs. So, I copied the CDEFs from the old installation to the new. I'm STILL not getting graphs. Now when I enter graph debug mode, I get the following:

RRDTool Command:

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Wichita1 Router - Se4/0.104 - Circuit Utilization" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--upper-limit="100" \
--lower-limit="-100" \
--vertical-label="utilization" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="C\:/Apache2/htdocs/cacti/rra/3/18.rrd":traffic_in:AVERAGE \
DEF:b="C\:/Apache2/htdocs/cacti/rra/3/18.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,*,1024,/,1000,*,8100000,/,100,* \
CDEF:cdefb=a,8,*,1024,/,1000,*,8100000,/,100,*,0,100,LIMIT,UN,UNKN,INF,IF \
CDEF:cdeff=b,8,*,1024,/,1000,*,8100000,/,100,*,-1,* \
CDEF:cdefg=b,8,*,1024,/,1000,*,8100000,/,100,*,0,100,LIMIT,UN,UNKN,INF,IF,-1,* \
CDEF:cdefh=b,8,*,1024,/,1000,*,8100000,/,100,* \
CDEF:cdefbc=a,8,*,1024,/,1000,*,8100000,/,100,*,80,100,LIMIT \
CDEF:cdefbd=a,8,*,1024,/,1000,*,8100000,/,100,*,90,100,LIMIT \
CDEF:cdefbe=a,8,*,1024,/,1000,*,8100000,/,100,*,100,10000,LIMIT \
CDEF:cdefbf=b,8,*,1024,/,1000,*,8100000,/,100,*,80,100,LIMIT,-1,* \
CDEF:cdefbg=b,8,*,1024,/,1000,*,8100000,/,100,*,90,100,LIMIT,-1,* \
CDEF:cdefbh=b,8,*,1024,/,1000,*,8100000,/,100,*,100,10000,LIMIT,-1,* \
AREA:cdefa#00BF47FF:"Inbound" \
AREA:cdefb#96E78AFF:"" \
GPRINT:cdefa:LAST:" Current%6.2lf%%" \
GPRINT:cdefa:AVERAGE:"Average%6.2lf%%" \
GPRINT:cdefa:MAX:"Maximum%6.2lf%%\n" \
AREA:cdeff#005D57FF:"Outbound" \
AREA:cdefg#96E78AFF:"":STACK \
GPRINT:cdefh:LAST:" Current%6.2lf%%" \
GPRINT:cdefh:AVERAGE:"Average%6.2lf%%" \
GPRINT:cdefh:MAX:"Maximum%6.2lf%%\n" \
COMMENT:" \n" \
COMMENT:"Circuit Bandwidth 8100000 bps" \
AREA:cdefbc#7EE600FF:"80%" \
AREA:cdefbd#FFC73BFF:"90%" \
AREA:cdefbe#FF4105FF:"100%" \
AREA:cdefbf#7EE600FF:"" \
AREA:cdefbg#FFC73BFF:"" \
AREA:cdefbh:""

RRDTool Says:
ERROR: opening 'C:/Apache2/htdocs/cacti/rra/3/18.rrd': No such file or directory

So, it looks like my CDEFs are good now, but there's no rrd file. I have looked in C:/Apache2/htdocs/cacti/rra/3/ and there is no 18.rrd file. RRDtool is not creating it for some reason. Now I'm totally stumped.

Any help with this would be appreciated.

[gandalf]

Please start using 2nd link of my sig
R.

[Stuewe]

I got it working. Thanks!