Autom8 creating duplicate graphs

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
pmona2000
Posts: 5
Joined: Wed Dec 23, 2015 10:02 am

Autom8 creating duplicate graphs

Post by pmona2000 »

autom8 is creating duplicate graphs for my hosts each time they are re scanned. These are not duplicates of pre-existing graphs, but duplicates of graphs originally created by autom8.
I am running cacti 8.7h with plugin arch. 3.0 From what I could tell in the documentation, no patching is required when using plugin arch. 2.9 or higher. The included patch versions were only for 8.7d and 8.7e and the dry run tests with each failed, so I assumed they were not needed.

In the logs I see the following error when adding graphs:

12/23/2015 10:30:27 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT DISTINCT data_local.id FROM data_local LEFT JOIN data_template_data ON (data_local.id=data_template_data.local_data_id) LEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id) LEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id) LEFT JOIN snmp_query_graph ON (data_input_data.value=snmp_query_graph.id) WHERE data_input_fields.type_code=output_type AND snmp_query_graph.id=14 AND data_local.host_id=314 AND data_local.snmp_query_id=1 AND data_local.snmp_index='16'"

When I run that query I get:
Unknown column 'output_type' in 'where clause'
pmona2000
Posts: 5
Joined: Wed Dec 23, 2015 10:02 am

Re: Autom8 creating duplicate graphs

Post by pmona2000 »

Resolved by installing the latest version of autom8.
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests