Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
General discussion about Plugins for Cacti
Moderators: Developers , Moderators
bdptcob
Posts: 16 Joined: Fri Feb 22, 2008 4:21 pm
Post
by bdptcob » Tue Feb 23, 2010 9:18 am
I upgraded from an older version of thold after a cacti ugprade. I can't modify thresholds. It acts like it saves, but it just reverts whatever change I made (ie. I uncheck Threshold Enabled, hit save, says Record Updated, but it just re-checks Threshold Enabled). I've deleted the snmp data query and the graph associated with it, added it back and I still have the same issue. I'm not getting any errors. Here's my thold_data and thold_template table description:
mysql> describe thold_data;
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(100) | NO | | | |
| rra_id | int(11) | NO | MUL | 0 | |
| data_id | int(11) | NO | | 0 | |
| graph_id | int(11) | NO | MUL | 0 | |
| graph_template | int(11) | NO | MUL | 0 | |
| data_template | int(11) | NO | MUL | 0 | |
| thold_hi | varchar(100) | YES | | NULL | |
| thold_low | varchar(100) | YES | | NULL | |
| thold_fail_trigger | int(10) unsigned | YES | | NULL | |
| time_hi | varchar(100) | YES | | NULL | |
| time_low | varchar(100) | YES | | NULL | |
| time_fail_trigger | int(12) | NO | | 1 | |
| time_fail_length | int(12) | NO | | 1 | |
| thold_fail_count | int(11) | NO | | 0 | |
| thold_alert | int(1) | NO | | 0 | |
| thold_enabled | enum('on','off') | NO | | on | |
| thold_type | int(3) | NO | | 0 | |
| bl_enabled | enum('on','off') | NO | | off | |
| bl_ref_time | int(50) unsigned | YES | | NULL | |
| bl_ref_time_range | int(10) unsigned | YES | | NULL | |
| bl_pct_down | int(10) unsigned | YES | | NULL | |
| bl_pct_up | int(10) unsigned | YES | | NULL | |
| bl_fail_trigger | int(10) unsigned | YES | | NULL | |
| bl_fail_count | int(11) unsigned | YES | | NULL | |
| bl_alert | int(2) | NO | | 0 | |
| lastread | varchar(100) | YES | | NULL | |
| oldvalue | varchar(100) | NO | | | |
| repeat_alert | int(10) unsigned | YES | | NULL | |
| notify_default | enum('on','off') | YES | | NULL | |
| notify_extra | varchar(255) | YES | | NULL | |
| data_type | int(3) | NO | | 0 | |
| host_id | int(10) | YES | | NULL | |
| syslog_priority | int(2) | YES | | 3 | |
| cdef | int(11) | NO | | 0 | |
| percent_ds | varchar(64) | NO | | 0 | |
| tcheck | int(1) | NO | MUL | 0 | |
| exempt | char(3) | NO | | off | |
| restored_alert | char(3) | NO | | off | |
+--------------------+------------------+------+-----+---------+----------------+
39 rows in set (0.00 sec)
mysql> describe thold_template;
+----------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+------------------+------+-----+---------+----------------+
| id | int(11) | NO | MUL | NULL | auto_increment |
| name | varchar(100) | NO | | | |
| data_template_id | int(32) | NO | | 0 | |
| data_template_name | varchar(100) | NO | | | |
| data_source_id | int(10) | NO | PRI | 0 | |
| data_source_name | varchar(100) | NO | | | |
| data_source_friendly | varchar(100) | NO | | | |
| thold_hi | varchar(100) | YES | | NULL | |
| thold_low | varchar(100) | YES | | NULL | |
| thold_fail_trigger | int(10) | YES | | 1 | |
| time_hi | varchar(100) | YES | | NULL | |
| time_low | varchar(100) | YES | | NULL | |
| time_fail_trigger | int(12) | NO | | 1 | |
| time_fail_length | int(12) | NO | | 1 | |
| thold_enabled | enum('on','off') | NO | | on | |
| thold_type | int(3) | NO | | 0 | |
| bl_enabled | enum('on','off') | NO | | off | |
| bl_ref_time | int(50) | YES | | NULL | |
| bl_ref_time_range | int(10) | YES | | NULL | |
| bl_pct_down | int(10) | YES | | NULL | |
| bl_pct_up | int(10) | YES | | NULL | |
| bl_fail_trigger | int(10) | YES | | NULL | |
| bl_alert | int(2) | YES | | NULL | |
| repeat_alert | int(10) | NO | | 12 | |
| notify_default | enum('on','off') | YES | | NULL | |
| notify_extra | varchar(255) | NO | | | |
| data_type | int(3) | NO | | 0 | |
| cdef | int(11) | NO | | 0 | |
| percent_ds | varchar(64) | NO | | 0 | |
| exempt | char(3) | NO | | off | |
| restored_alert | char(3) | NO | | off | |
+----------------------+------------------+------+-----+---------+----------------+
31 rows in set (0.00 sec)
I added thold_template.data_type based on another thread I found.
bdptcob
Posts: 16 Joined: Fri Feb 22, 2008 4:21 pm
Post
by bdptcob » Wed Feb 24, 2010 10:48 am
I've dropped thold_data, thold_template, plugin_thold_* and ran thold.sql and it still won't let me modify tholds. Any ideas?
bdptcob
Posts: 16 Joined: Fri Feb 22, 2008 4:21 pm
Post
by bdptcob » Wed Feb 24, 2010 12:49 pm
Finally got it to work but I have to rebuild my thresholds. Oh well
Users browsing this forum: No registered users and 3 guests