help with one graph template - shows red x with any device

[spark123]

hi,

I appeared to have a problem with time and date on my system and it caused the poller to stop running for a period of time.
I was able to get this to re-run using the poller.php -force command and now most of my graphs are showing fresh data.
I have however one graph type that shows a red X instead of the graph.
This one is based on the CatOS Interface template. Traffic (bits/sec, 95th Percentile) to be precise. all the other graphs that came with this template are working.
I have checked the settings in the graph template and the data queries section and it does list this graph template.

I've also checked to make sure that the rra directory shows the rrd file relating to the graph and these are here and they show the current date and time so it looks they are getting updated.
I've looked through the debug manual and many posts to do with 'red x' but i cannot find anything to help me solve this issue.

Where can i turn to solve this?

regards
Spark

[gandalf]

Please see 2nd link of my sig as a start
R.

[spark123]

hi,

i've went through the debug information and the only thing that i can find is when looking at the graph debug mode that the graphs that are working state 'rrdtool says -ok'

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title="cr-b9-1-1.net - Traffic - Gi3/14" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/var/www/html/rra/cr-b9-1-1_net_traffic_in_315.rrd":traffic_in:AVERAGE \
DEF:b="/var/www/html/rra/cr-b9-1-1_net_traffic_in_315.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#002A97FF:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s\n" \
COMMENT:" \n" \
HRULE:1311666.14#FF0000FF:"95th Percentile" \
COMMENT:"(1.31 mbit in+out)"

the ones that do not work and this is certainly the case for any that are added new even to an existing host that may have some working graphs is the rrdtool says - [blank]

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title="cr-b9-1-1.net - Traffic - Gi4/22" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/var/www/html/rra/cr-b9-1-1_net_traffic_in_483.rrd":traffic_in:AVERAGE \
DEF:b="/var/www/html/rra/cr-b9-1-1_net_traffic_in_483.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdeff=b,8,* \
CDEF:cdefbe=a,UN,INF,UNKN,IF \
CDEF:cdefbh=TIME,1306231053,GT,a,a,UN,0,a,IF,IF,TIME,1306231053,GT,b,b,UN,0,b,IF,IF,+ \
AREA:cdefa#00CF00FF:"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\: 66.94 KB" \
LINE1:cdeff#002A97FF:"Outbound" \
GPRINT:cdeff:LAST:"Current\:%8.2lf %s" \
HRULE:|95\:bits\:0\:current|#00FF00FF:"95%\:" \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" \
COMMENT:"|95\:bits\:6\:current| mbit\n" \
GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s\n" \
\
HRULE:2552.89#FF0000FF:"95th Percentile" \
COMMENT:"(0 mbit in+out)\n" \
AREA:cdefbe#8F9286FF:"" \
COMMENT:"Transfer\: 331.38 KB" \
HRULE:|95\:bits\:0\:current|#0000FFFF:"95%\:" \
COMMENT:"0 mbit" \
COMMENT:"Total Transfer\: 398.32 KB\n"

the output i notice is a bit longer but i don't know what all this means!

there's no problem with the files writing to the rra directory and they do look to get updated going by the time stamps.

Going back on my notes i had done an import of this template (http://docs.cacti.net/usertemplate:host:linux:generic) back in March and this seems to have been when all the problems started.
I had saved the import results and it did update those 'interface' graph templates.
I have tried re-importing this (http://docs.cacti.net/template:host:gen ... abled_host) as i'm running Cacti 0.8.7e (originall upgraded from Cacti 0.8.7c). To be on the safe side i took a snapshot of the Cacti VM before i done this.
There's no difference though.

Would it be better to delete these templates and add them in again or is there anything else i can look at it?

This has been working so well for a couple of years now. I really don't want to have to delete and start again!

I'd appreciate any pointers from anyone.

regards
spark

[gandalf]

Please run the "failing" rrd command and pipe output to foo.png. Any errors? Is foo.png a valid png file?
R.

[spark123]

hi,

i've ran this and it doe not return a valid PNG file. On the debug for the graph in the Cacti GUI it shows a red x and under where it says 'rrdtool says' there is no value (i.e. blank)

Is there any way to check the template and associated scripts do not have any missing files?

thanks

[gandalf]

GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s\n" \
\
HRULE:2552.89#FF0000FF:"95th Percentile" \

This part makes me wonder. It looks like some data is expected, where the backslash is printed. So perhaps a screenshot of the template might help.
Deleting the template is not a good idea. All existing graphs will loose their graph template "connection". A better idea would be to replace the given template by a correct one (assuming that this is the root cause).
You might try to export that template and attach it. But that might fail as well as neither of us does know, what export will spit out running against a broken template ...
R.

[spark123]

i've added screenshots and an export of the template. maybe you could see if the template xml matches this or if you have a copy known to be working i can check it with a comparison tool.
I see that there is slightly modded 95th percentile traffic template on the templates page - http://docs.cacti.net/usertemplate:grap ... raffic95th

I was considering importing this in but i don't want to make the situation worse. at least all the other graph templates are working!

thanks!

[spark123]

adding graph template attachment from previous post.

[gandalf]

HRULE:|95\:bits\:0\:current|#00FF00FF:"95%\:" \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" \
COMMENT:"|95\:bits\:6\:current| mbit\n" \
GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s\n" \

I fear I was mislead. I now see, that the HRULE statements are not replaced by numbers as required. Is this the only template that uses such a statement?
R.

[spark123]

yes.

[gandalf]

Which rrdtool utility version is shown under Settings, then?

And what is the output of "rrdtool --version"?
R.

[spark123]

from the host info page its:
RRDTool[/b] - 1.2.23

i'll hop onto the console through remote access to run the version output and post shortly.

[spark123]

hi,

this is the output from CLI:

[root@cr ~]# rrdtool --version
RRDtool 1.2.23 Copyright 1997-2007 by Tobias Oetiker <tobi@oetiker.ch>
Compiled Jun 7 2007 00:19:10

thanks

[gandalf]

And what do you find at "Settings -> RRDTool utility version"?
R.

[spark123]

rrdtool 1.2.x

from the drop down list it has 1.0.x and 1.3.x available but 1.2.x is the one that is set.