THOLD 1.0.5 Not Creating Thresholds

[Lalbee99]

I recently upgraded my cacti installation from 0.8.7i to 1.1.37 without any issues. When I attempt to hit the link "*Auto-create Thresholds" in the device I get the following message:

The Operation was successful. Details are below.
Either no Templates or Threshold(s) Already Exists - No Thresholds were created.


When I turn on debugging for errors in the cacti log I get the following with no errors:

2018/04/05 11:35:27 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'plugin_hooks'"
2018/04/05 11:35:27 - DBCALL DEVEL: SQL Assoc: "SELECT ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = ? ORDER BY pc.id ASC"
2018/04/05 11:35:27 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'plugin_hooks'"
2018/04/05 11:35:27 - DBCALL DEVEL: SQL Assoc: "SELECT ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = ? ORDER BY pc.id ASC"
2018/04/05 11:35:27 - DBCALL DEVEL: SQL Cell: "SELECT id FROM user_auth WHERE username = ?"
2018/04/05 11:35:27 - DBCALL DEVEL: SQL Cell: "SELECT COUNT(*) FROM ( SELECT realm_id FROM user_auth_realm AS uar WHERE uar.user_id = ? AND uar.realm_id = ? UNION SELECT realm_id FROM user_auth_group_re AS uagr INNER JOIN user_auth_group_members AS uagm ON uagr.group_id=uagm.group_id INNER JOIN user_auth_group AS uag ON uag.id=uagr.group_id WHERE uag.enabled="on" AND uagm.user_id = ? AND uagr.realm_id = ) AS authorized"
2018/04/05 11:35:27 - DBCALL DEVEL: SQL Row: "SELECT * FROM user_auth WHERE id = ?"
2018/04/05 11:35:27 - DBCALL DEVEL: SQL Cell: "SELECT version FROM plugin_config WHERE directory="thold""
2018/04/05 11:35:27 - DBCALL DEVEL: SQL Cell: "SELECT host_template_id FROM host WHERE id = ?"
2018/04/05 11:35:27 - DBCALL DEVEL: SQL Assoc: "SELECT tt.data_template_id, tt.id FROM thold_template AS tt INNER JOIN plugin_thold_host_template AS ptht ON tt.id=ptht.thold_template_id WHERE ptht.host_template_id = ?"
2018-04-05 11:37:21 - DBCALL DEVEL: SQL Cell: "SELECT @@sql_mode"
2018-04-05 11:37:21 - DBCALL DEVEL: SQL Exec: "SET SESSION sql_mode = """
2018-04-05 11:37:21 - DBCALL DEVEL: SQL Cell: "SELECT cacti FROM version LIMIT 1"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'settings_user'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Row: "SELECT value FROM settings_user WHERE name = ? AND user_id = ?"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'external_links'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT id, title, extendedstyle FROM external_links WHERE style="CONSOLE" AND enabled="on" ORDER BY extendedstyle, sortorder, id"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SELECT reset_perms FROM user_auth WHERE id = ?"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'plugin_hooks'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = ? ORDER BY pc.id ASC"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT * FROM plugin_realms ORDER BY plugin, display"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT DISTINCT gt.id, gt.name FROM graph_templates AS gt INNER JOIN graph_templates_item AS gti ON gt.id=gti.graph_template_id INNER JOIN data_template_rrd AS dtr ON gti.task_item_id=did WHERE gti.local_graph_id=0 AND data_source_type_id IN (3,2) ORDER BY name"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'plugin_config'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT directory AS id, name FROM plugin_config WHERE status=1"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SELECT realm_id FROM user_auth_realm WHERE user_id = ? AND realm_id = ? UNION SELECT realm_id FROM user_auth_group_realm AS uagr INNER JOIN user_auth_group ASg ON uag.id = uagr.group_id INNER JOIN user_auth_group_members AS uagm ON uag.id = uagm.group_id WHERE uag.enabled = 'on' AND uagr.realm_id = ? AND uagm.user_id = ?"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'plugin_hooks'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = ? ORDER BY pc.id ASC"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'plugin_hooks'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = ? ORDER BY pc.id ASC"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'data_source_profiles'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SELECT id FROM data_source_profiles ORDER BY `default` DESC LIMIT 1"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'plugin_hooks'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = ? ORDER BY pc.id ASC"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'plugin_hooks'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = ? ORDER BY pc.id ASC"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SHOW TABLES LIKE 'plugin_hooks'"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory = ph.name WHERE ph.status = 1 AND hook = ? ORDER BY pc.id ASC"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SELECT id FROM user_auth WHERE username = ?"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SELECT COUNT(*) FROM ( SELECT realm_id FROM user_auth_realm AS uar WHERE uar.user_id = ? AND uar.realm_id = ? UNION SELECT realm_id FROM user_auth_group_re AS uagr INNER JOIN user_auth_group_members AS uagm ON uagr.group_id=uagm.group_id INNER JOIN user_auth_group AS uag ON uag.id=uagr.group_id WHERE uag.enabled="on" AND uagm.user_id = ? AND uagr.realm_id = ) AS authorized"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Row: "SELECT * FROM user_auth WHERE id = ?"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SELECT version FROM plugin_config WHERE directory="thold""
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Cell: "SELECT host_template_id FROM host WHERE id = ?"
2018/04/05 11:37:21 - DBCALL DEVEL: SQL Assoc: "SELECT tt.data_template_id, tt.id FROM thold_template AS tt INNER JOIN plugin_thold_host_template AS ptht ON tt.id=ptht.thold_template_id WHERE ptht.host_template_id = ?"


I have nothing to go on to correct this.

-Leo

[Lalbee99]

I figured it out sorry for posting. It seems after an upgrade you have to associate threshold templates with the device template. When this is completed everything works fine.