Cacti SQL Query Problem

[BrandonT]

I've got the netapp template (http://forums.cacti.net/viewtopic.php?t=11446) installed and a netapp device configured. I created the graphs for the device based on the templates, but the data sources were never created and the graphs were never drawn. I created the data sources manually by copying and pasting the data source debug info for the netapp data sources into the command line. Now the graphs are drawn, but there is no data. The message below and several similar ones are logged.

CMDPHP: 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=92 and data_template_rrd.local_data_id=634"

Notice the blank value after "snmp_query_graph_rrd.snmp_query_graph_id=". If I connect to the cacti DB and run the above SQL with '38' as the snmp_query_graph_id, I get results. 38 is the value for that particular snmp_query_graph_rrd.snmp_query_graph_id in my DB.

Why isn't that value making it into the SQL statement? Is there something missing from the template or did the import process not work?

Fedora Core 5
Cacti 0.8.6h
mysql 5.0.22
RRD 1.2.15
Net-SNMP 5.3
Poller cmd.php


Thanks

Brandon

[fmangeant]

Hi

have you installed the patches for 0.8.6h ?

This one seems to fix it :

Invalid SQL When Creating Graphs 2006/01/07
This patch fixes an problem where an invalid SQL statement would be executed when generating graphs.

[BrandonT]

I used yum to install cacti, but forgot the patches. I tried applying them, but they all returned similar errors to the one below.

>patch -p1 -N < fix_sql_syntax_related_to_default_rra_id.patch
patching file graph.php
Reversed (or previously applied) patch detected! Skipping patch.
1 out of 1 hunk ignored -- saving rejects to file graph.php.rej

I'm guessing the yum version is already patched. Below is the graph.php.rej output.

***************
*** 130,142 ****
$timespan = -($rra["timespan"]);

/* find the step and how often this graph is updated with new data */
- $ds_step = db_fetch_cell("select
data_template_data.rrd_step
- from (data_template_data,data_template_rrd,graph_templates_item)
- where graph_templates_item.task_item_id=data_template_rrd.id
- and data_template_rrd.local_data_id=data_template_data.local_data_id
- and graph_templates_item.local_graph_id=" . $_GET["local_graph_id"] .
- "limit 0,1");
$ds_step = empty($ds_step) ? 300 : $ds_step;
$seconds_between_graph_updates = ($ds_step * $rra["steps"]);

--- 130,142 ----
$timespan = -($rra["timespan"]);

/* find the step and how often this graph is updated with new data */
+ $ds_step = db_fetch_cell("SELECT
data_template_data.rrd_step
+ FROM (data_template_data,data_template_rrd,graph_templates_item)
+ WHERE graph_templates_item.task_item_id=data_template_rrd.id
+ AND data_template_rrd.local_data_id=data_template_data.local_data_id
+ AND graph_templates_item.local_graph_id=" . $_GET["local_graph_id"] .
+ " LIMIT 0,1");
$ds_step = empty($ds_step) ? 300 : $ds_step;
$seconds_between_graph_updates = ($ds_step * $rra["steps"]);



Thanks

[fmangeant]

Try to use the pre-patched files : http://www.cacti.net/downloads/patches/ ... e-patched/

You just have to replace the files (make backups first, and check file permissions after overwritting them).

[BrandonT]

Patched or un-patched doesn't seem to make a difference.

[rony]

Have you tried refreshing the that data query?

[BrandonT]

If I run the verbose query from the 'Associated Data Queries' portion of the device page, it runs fine and returns data. I click the green circle and no errors are returned.

How else can I refresh the data query?

Thanks

[BrandonT]

I'm not sure, but I think the data query refresh did the trick. I deleted all of the old (empty) data sources and graphs, then created new ones.

Thanks for your help.

[rony]

I was waiting for that response..