Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Wed Mar 20, 2019 9:02 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: THOLD 1.0.5 Not Creating Thresholds
PostPosted: Thu Apr 05, 2018 10:39 am 
Offline
Cacti User

Joined: Mon Mar 03, 2008 2:07 pm
Posts: 85
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


Top
 Profile  
 
 Post subject: Re: THOLD 1.0.5 Not Creating Thresholds
PostPosted: Thu Apr 05, 2018 11:50 am 
Offline
Cacti User

Joined: Mon Mar 03, 2008 2:07 pm
Posts: 85
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group