Unable to create thold threshold templates

[skatter]

Running FreeBSD 8.2 w/ Cacti 0.8.7g & PIA 2.9

I've installed the plugin architecture, along with thold, but I am unable to create any threshold templates, and when I examine the cacti DB I don't see any tables referencing thold.

Code: Select all

mysql> show tables;
+----------------------------+
| Tables_in_cacti            |
+----------------------------+
| cdef                       |
| cdef_items                 |
| colors                     |
| data_input                 |
| data_input_data            |
| data_input_fields          |
| data_local                 |
| data_template              |
| data_template_data         |
| data_template_data_rra     |
| data_template_rrd          |
| graph_local                |
| graph_template_input       |
| graph_template_input_defs  |
| graph_templates            |
| graph_templates_gprint     |
| graph_templates_graph      |
| graph_templates_item       |
| graph_tree                 |
| graph_tree_items           |
| host                       |
| host_graph                 |
| host_snmp_cache            |
| host_snmp_query            |
| host_template              |
| host_template_graph        |
| host_template_snmp_query   |
| mac_track_interface_graphs |
| plugin_config              |
| plugin_db_changes          |
| plugin_hooks               |
| plugin_realms              |
| poller                     |
| poller_command             |
| poller_item                |
| poller_output              |
| poller_reindex             |
| poller_time                |
| rra                        |
| rra_cf                     |
| settings                   |
| settings_graphs            |
| settings_tree              |
| snmp_query                 |
| snmp_query_graph           |
| snmp_query_graph_rrd       |
| snmp_query_graph_rrd_sv    |
| snmp_query_graph_sv        |
| user_auth                  |
| user_auth_perms            |
| user_auth_realm            |
| user_log                   |
| version                    |
+----------------------------+
53 rows in set (0.00 sec)

mysql>

When I try to create a threshold template I get the error message:
"Error: A template with that Data Source already exists!"

No threshold templates currently exist, so I don't see how an existing template could conflict.

I'm also seeing these messages in the cacti.log file:

Code: Select all

08/07/2011 02:22:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"UPDATE thold_data SET tcheck = 0'
08/07/2011 02:22:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM plugin_thold_log WHERE time < 1310030522'
08/07/2011 02:23:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM thold_data WHERE thold_enabled = 'on' AND tcheck = 1"

I've attached a screenshot of the Plugin Management portion of Cacti, showing Settings and Thold as installed.

[noname]

Try importing 'plugins/thold/thold.sql' manually.

[zhushazang]

Hey, what the version of your mysql-server?

[skatter]

mysql-server-5.5.14 Multithreaded SQL database (server)

[guilou0875]

did you import the thold.sql to your cacti db?

mysql -u cactiuser -p cacti < mysql.sql

let me kmow thanks

ps what OS and version of thold, plugin and cacti you're running?

thanks