ERROR: SQL Exec Failed

grodno5 · Post by **grodno5** » Fri Jul 14, 2006 12:08 pm

does anyone can tell me why i'm getting this errors?
thanks in advance.
CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (758,'traffic_in','2006-07-14 12:15:24','3436189013')"
and
CMDPHP: Poller[0] Host[137] DS[1088] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur

grodno5 · Post by **grodno5** » Fri Jul 14, 2006 12:50 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=78 and data_template_rrd.local_data_id=352"

grantdv · Post by **grantdv** » Wed Jul 19, 2006 6:32 am

I see this post is rather old, but I am having the same problem and I have not found any solutions yet. Are there any??

-Grant

Post by **TheWitness** » Wed Jul 19, 2006 7:47 am

You need to apply the Cacti patches.

TheWitness

Post by **rony** » Wed Jul 19, 2006 7:56 am

Moved to General

grodno5 · Post by **grodno5** » Wed Jul 19, 2006 8:33 am

i wish you can specify which patches i need to apply to fix this problem.
I already applied many of them, so if you can be more specific it will help a lot.
thanks in advance

Post by **TheWitness** » Wed Jul 19, 2006 9:05 am

This is a database issue spawned by the movement of ADODB by some distributions. When did you last update your RPM?

TheWitness

grodno5 · Post by **grodno5** » Wed Jul 19, 2006 9:58 am

which rpm? DB? cacti? php?

BSOD2600 · Post by **BSOD2600** » Wed Jul 19, 2006 10:53 am

Cacti.

Just apply all patches here: http://www.cacti.net/download_patches.php

grodno5 · Post by **grodno5** » Wed Jul 19, 2006 1:16 pm

before i applied patches, my mactrack was working fine, after patches, i'm getting even more errors
07/19/2006 01:43:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT site_name, description, hostname, mac_address, ip_address, dns_hostname, port_number, port_name, vlan_id, vlan_name, MAX(scan_date) as max_scan_date FROM mac_track_ports LEFT JOIN mac_track_sites ON (mac_track_ports.site_id = mac_track_sites.site_id) WHERE mac_track_ports.device_id= 2 GROUP BY device_id, mac_address, port_number, ip_address ORDER BY mac_track_ports.hostname, mac_track_ports.port_number, mac_track_ports.ip_address LIMIT 0,30"
07/19/2006 01:43:08 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(DISTINCT device_id, mac_address, port_number, ip_address) FROM mac_track_ports WHERE mac_track_ports.device_id= 2"
07/19/2006 01:43:25 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT site_name, description, hostname, mac_address, ip_address, dns_hostname, port_number, port_name, vlan_id, vlan_name, scan_date FROM mac_track_ports LEFT JOIN mac_track_sites ON (mac_track_ports.site_id = mac_track_sites.site_id) WHERE mac_track_ports.device_id= 2 ORDER BY mac_track_ports.hostname, mac_track_ports.port_number, mac_track_ports.ip_address LIMIT 0,30"
07/19/2006 01:43:25 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(mac_track_ports.device_id) FROM mac_track_ports WHERE mac_track_ports.device_id= 2"

BSOD2600 · Post by **BSOD2600** » Wed Jul 19, 2006 2:20 pm

Right, because the plugin architecture is an unofficial addon, which the patches broke. Re-apply the plugin architecture patch.

grodno5 · Post by **grodno5** » Thu Jul 20, 2006 8:59 am

would you please point me to that plugin architecture patch.
thanks in advance

BSOD2600 · Post by **BSOD2600** » Thu Jul 20, 2006 10:45 am

The same method you previously got the plugin architecture installed... http://cactiusers.org/

Post by **TheWitness** » Thu Jul 20, 2006 8:29 pm

Goto MacTrack Devices and edit a device, replace the device_id in the address bar by "2" to edit that Device. Is it found? Please provide feedback.

TheWitness

Cacti

ERROR: SQL Exec Failed

ERROR: SQL Exec Failed

another error

SQL Exec Failed

patches

which RPM

more errors

thanks for advise

Who is online