Can't modify thold

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
bdptcob
Posts: 16
Joined: Fri Feb 22, 2008 4:21 pm

Can't modify thold

Post by bdptcob »

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 »

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 »

Finally got it to work but I have to rebuild my thresholds. Oh well
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests