Graph crash .. missing def ?

[pdeg]

Newbie .. please help....

Latest rev (j) and patches applied. New - clean install

Set up a generic snmp query (via the supplied templates) to count the number of pages from a printer and it a seems to poll o.k. A dump of the database shows the latest value.

BUT when I try to graph the data RRDTool crashes with following.


RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Hub Photocopier - test" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="Pages" \
AREA:#FFF200:"teestdsadasd" \
GPRINT::LAST:"Current\:%8.2lf %s" \
GPRINT::AVERAGE:"Average\:%8.2lf %s" \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:

ERROR: parameter '#FFF200' does not represent a number in line AREA:#FFF200:teestdsadasd

I then tried a localhost - logged in users .. It graphed ok initially but when I changed the legend colour it crashed with a similar error. ....


RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Localhost - Logged in Users" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="users" \
AREA:#F51D30:"Users" \
GPRINT::LAST:"Current\:%8.0lf" \
GPRINT::AVERAGE:"Average\:%8.0lf" \
GPRINT::MAX:"Maximum\:%8.0lf"

RRDTool Says:

ERROR: parameter '#F51D30' does not represent a number in line AREA:#F51D30:Users


It seems to be related to the legend colour setting in the template ????

Please help ... I am so close .....

[gandalf]

It's a missing DEF statement, as the title suggests. So either the Graph Template is broken (not referring to the correct data source) or the Graph itself is broken (visit the correspnding data source/graph)
Reinhard

[pdeg]

What bothers me is that this a clean install ... ie. I am using the latest rpm from the cacti web site and using the built in templates... and I installed it on a totally clean machine...

.... so either the supplied templates are broken ... highly unlikely.... the problem must come from something else ... the graphs work fine.. until I do nothing else except change the template colour....

Do you have any other suggestions ??

[pdeg]

... digging deeper ... it appears that when I select a graph, I am
getting errors in the log file .. regardless if it works fails.
RRDTool Command:

This one works ......

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Localhost - Load Average" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--units-exponent=0 \
--vertical-label="processes in the run queue" \
DEF:a="/var/www/html/cacti/rra/localhost_load_1min_5.rrd":load_1min:AVERAGE \
DEF:b="/var/www/html/cacti/rra/localhost_load_1min_5.rrd":load_5min:AVERAGE \
DEF:c="/var/www/html/cacti/rra/localhost_load_1min_5.rrd":load_15min:AVERAGE \
CDEF:cdefg=TIME,1176775040,GT,a,a,UN,0,a,IF,IF,TIME,1176775040,GT,b,b,UN,0,b,IF,IF,TIME,1176775040,GT,c,c,UN,0,c,IF,IF,+,+ \
AREA:a#EACC00:"1 Minute Average" \
GPRINTLAST:" Current\:%8.2lf\n" \
STACK:b#EA8F00:"5 Minute Average" \
GPRINTLAST:" Current\:%8.2lf\n" \
STACK:c#FF0000:"15 Minute Average" \
GPRINT:c:LAST:"Current\:%8.2lf\n" \
LINE1:cdefg#000000:""

RRDTool Says:

OK

BUT ....................


Gives me the following in the log file ..


04/17/2007 10:02:20 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=1 order by name"
04/17/2007 10:02:20 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=1 order by name"
04/17/2007 10:02:20 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=1 order by name"
04/17/2007 10:02:04 AM - WEBUI: Cacti Log Cleared from Web Management Interface


But this one that fails ..............

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Localhost - Logged in Users" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="users" \
AREA:#00A0C1:"Users" \
GPRINT::LAST:"Current\:%8.0lf" \
GPRINT::AVERAGE:"Average\:%8.0lf" \
GPRINT::MAX:"Maximum\:%8.0lf"

RRDTool Says:

ERROR: parameter '#00A0C1' does not represent a number in line AREA:#00A0C1:Users


Cancel

Gives the following in the log .............


04/17/2007 10:04:29 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=1 order by name"

[gandalf]

This looks like a corrupted database to me. There has not been an error of this kind lately. So it's a new bug or a corrupted database. Both are beyond my personal capabilities, sorry
Reinhard

[srd]

I seem to be having the exact same problem. I initially had trouble installing the arch. plugin and i am wondering if this has caused some corruption.