Realy need help on this urgently, looks like Host MOB- Processes some how got broken and I am not able to get a graphs. See the cacti log below showing SQL error's.
04/10/2006 02:23:54 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=45 and data_template_rrd.local_data_id=158"
Graph Error
RRDTool Command:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Madonna - Processes" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="processes" \
--slope-mode \
DEF:a="/var/www/html/monitor/rra/madonna_proc_158.rrd":proc:AVERAGE \
AREA:a#F51D30:"Running Processes" \
GPRINT
LAST:"Current\:%8.0lf" \GPRINT
AVERAGE:"Average\:%8.0lf" \GPRINT
MAX:"Maximum\:%8.0lf" RRDTool Says:
ERROR: opening '/var/www/html/monitor/rra/madonna_proc_158.rrd': No such file or directory
will be great if somebody can pin point where is the mistake.
Thank you,
Indee