Thold not showing/creating any items

[ComtecOps]

We have just installed a fresh install of Cacti with the thold plugin and we are unable to create any thresholds. We have been through the settings int the console and can't see anything amiss. When we create a threshold either from the graph or from the console, nothing shows up when we go to the thold tab -> thresholds. the Host status tab shows all our devices as green, and we get graphs from the devices.

I have enbaled the debug option within the thold settings, and the cacti log shows the following:

07/02/2012 04:42:58 PM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'thold_data'. Error was 'Unknown column 'template' in 'field list''
07/02/2012 04:35:17 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT * FROM thold_data LEFT JOIN user_auth_perms ON ((thold_data.graph_id=user_auth_perms.item_id AND user_auth_perms.type=1 AND user_auth_perms.user_id=1) OR (thold_data.host_id=user_auth_perms.item_id AND user_auth_perms.type=3 AND user_auth_perms.user_id=1) OR (thold_data.graph_template=user_auth_perms.item_id AND user_auth_perms.type=4 AND user_auth_perms.user_id=1)) WHERE ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) ORDER BY thold_alert DESC LIMIT 0,100"
07/02/2012 04:35:17 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT * FROM thold_data LEFT JOIN user_auth_perms ON ((thold_data.graph_id=user_auth_perms.item_id AND user_auth_perms.type=1 AND user_auth_perms.user_id=1) OR (thold_data.host_id=user_auth_perms.item_id AND user_auth_perms.type=3 AND user_auth_perms.user_id=1) OR (thold_data.graph_template=user_auth_perms.item_id AND user_auth_perms.type=4 AND user_auth_perms.user_id=1)) WHERE ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null)))"
07/02/2012 04:35:17 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISTINCT host.id, host.description FROM host INNER JOIN thold_data ON host.id=thold_data.host_id LEFT JOIN data_template ON thold_data.data_template=data_template.id ORDER by data_template.name"
07/02/2012 04:35:17 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISTINCT data_template.id, data_template.name FROM thold_data LEFT JOIN data_template ON thold_data.data_template=data_template.id ORDER by data_template.name"

We installed thold by placing it in the plugins folder and installing via the Plugin management under console.

OS - Centos 6.2
Cacti - v0.8.8a
thold - 0.4.9
settings - 0.71

Thanks for the help in advance.

[artagel]

It looks like the tables didn't get created.
You can manually check in mysql
mysql -u mysqluser -p cacti
Type your password for mysqluser
type show tables;
Check for any thold tables in there. If not, then you can try disabling, uninstalling, then installing and enabling Thold in PIA again. Check your logs after to see if you get any new SQL errors for the table creation.
-Dan

[ComtecOps]

Thanks artagel for the pointers.

Even after the uninstalling the plugin via the plugin manager and removing the thold folder from the plugin folder, the sql database still showed some tables. I had to manually remove these tables and then reinstall the thold plugin.

I know have thresholds showing up and they alert and warn.

now I just have to figure out why it is not sending out an email on a warning/alerting event.

Thanks Again..

[ComtecOps]

This is now all fixed. the Mail problem was my mail server.