thold plugin 0.4.6 screenshots

[sukanta]

Are you using either RPN Expressions or Baseline alarms in 0.4.7? Please let us know.

You catch it..RPN is killing the time:

This is very useful for taking Cisco memory Utilization which can't feed through CDEF. But unfortunately not able to use...

Can you pl investigate

# Query_time: 5 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
INSERT INTO thold_data (name,host_id,rra_id,graph_id,data_template,graph_template,thold_warning_hi,thold_warning_low,thold_warning_fail_trigger,thold_hi,thol
d_low,thold_fail_trigger,thold_enabled,bl_ref_time_range,bl_pct_down,bl_pct_up,bl_fail_trigger,bl_alert,repeat_alert,notify_extra,notify_warning_extra,notify
_warning,notify_alert,cdef,template,template_enabled,data_id) VALUES ("xxxxxxxxxxx - Memory Usage (Processor) [poolUsed]","648","3725","3722","49","35
","","","1","90","","3","on","1800","20","20","3","0","12","","","0","0","0","6","on","8275");

[TheWitness]

That's odd. Do this:

Code: Select all

show create table thold_data

Are you using DSSTats?

TheWitness

[sukanta]

That's odd. Do this:

Code: Select all

show create table thold_data

Are you using DSSTats?

TheWitness

No DSSTats:


mysql> show create table thold_data;

+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| thold_data | CREATE TABLE `thold_data` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) default NULL,
`rra_id` int(11) NOT NULL default '0',
`data_id` int(11) NOT NULL default '0',
`graph_id` int(11) NOT NULL default '0',
`graph_template` int(11) NOT NULL default '0',
`data_template` int(11) NOT NULL default '0',
`thold_hi` varchar(100) default NULL,
`thold_low` varchar(100) default NULL,
`thold_fail_trigger` int(10) unsigned default NULL,
`thold_fail_count` int(11) NOT NULL default '0',
`time_hi` varchar(100) default NULL,
`time_low` varchar(100) default NULL,
`time_fail_trigger` int(12) NOT NULL default '1',
`time_fail_length` int(12) NOT NULL default '1',
`thold_warning_hi` varchar(100) default NULL,
`thold_warning_low` varchar(100) default NULL,
`thold_warning_fail_trigger` int(10) unsigned default NULL,
`thold_warning_fail_count` int(11) NOT NULL default '0',
`time_warning_hi` varchar(100) default NULL,
`time_warning_low` varchar(100) default NULL,
`time_warning_fail_trigger` int(12) NOT NULL default '1',
`time_warning_fail_length` int(12) NOT NULL default '1',
`thold_alert` int(1) NOT NULL default '0',
`thold_enabled` enum('on','off') NOT NULL default 'on',
`thold_type` int(3) NOT NULL default '0',
`bl_ref_time_range` int(10) unsigned default NULL,
`bl_pct_down` varchar(100) default NULL,
`bl_pct_up` varchar(100) default NULL,
`bl_fail_trigger` int(10) unsigned default NULL,
`bl_fail_count` int(11) unsigned default NULL,
`bl_alert` int(2) NOT NULL default '0',
`lastread` varchar(100) default NULL,
`lasttime` timestamp NOT NULL default '0000-00-00 00:00:00',
`oldvalue` varchar(100) default NULL,
`repeat_alert` int(10) unsigned default NULL,
`notify_default` enum('on','off') default NULL,
`notify_extra` varchar(512) default NULL,
`notify_warning_extra` varchar(512) default NULL,
`notify_warning` int(10) unsigned default NULL,
`notify_alert` int(10) unsigned default NULL,
`host_id` int(10) default NULL,
`syslog_priority` int(2) NOT NULL default '3',
`data_type` int(12) NOT NULL default '0',
`cdef` int(11) NOT NULL default '0',
`percent_ds` varchar(64) NOT NULL default '',
`expression` varchar(70) NOT NULL default '',
`template` int(11) NOT NULL default '0',
`template_enabled` char(3) NOT NULL default '',
`tcheck` int(1) NOT NULL default '0',
`exempt` char(3) NOT NULL default 'off',
`restored_alert` char(3) NOT NULL default 'off',
`bl_thold_valid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `host_id` (`host_id`),
KEY `rra_id` (`rra_id`),
KEY `data_id` (`data_id`),
KEY `graph_id` (`graph_id`),
KEY `template` (`template`),
KEY `thold_enabled` (`thold_enabled`),
KEY `template_enabled` (`template_enabled`),
KEY `tcheck` (`tcheck`)
) ENGINE=MyISAM AUTO_INCREMENT=18500 DEFAULT CHARSET=latin1 COMMENT='Threshold data' |
+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[TheWitness]

The RPN Issues has something to do with polling the host_snmp_cache. Please do the following:

Code: Select all

show create table host_snmp_cache;

Also, I've fixed the Alert/Realert logic. Please test SVN#1873.

TheWitness

[sukanta]

The RPN Issues has something to do with polling the host_snmp_cache. Please do the following:

Code: Select all

show create table host_snmp_cache;

Also, I've fixed the Alert/Realert logic. Please test SVN#1873.

TheWitness

Followings are the output:

Also I will try new SVN & update:


mysql> show create table host_snmp_cache;
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| host_snmp_cache | CREATE TABLE `host_snmp_cache` (
`host_id` mediumint(8) unsigned NOT NULL default '0',
`snmp_query_id` mediumint(8) unsigned NOT NULL default '0',
`field_name` varchar(50) NOT NULL default '',
`field_value` varchar(255) default NULL,
`snmp_index` varchar(255) NOT NULL default '',
`oid` text NOT NULL,
`present` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`host_id`,`snmp_query_id`,`field_name`,`snmp_index`),
KEY `host_id` (`host_id`,`field_name`),
KEY `snmp_index` (`snmp_index`),
KEY `field_name` (`field_name`),
KEY `field_value` (`field_value`),
KEY `snmp_query_id` (`snmp_query_id`),
KEY `present` USING BTREE (`present`),
KEY `host_id_snmp_query_id_snmp_index` (`host_id`,`snmp_query_id`,`snmp_index`),
KEY `host_id_snmp_query_id` (`host_id`,`snmp_query_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[uhtred]

it would be nice, if email notification would wait for trigger time with Restored / went above
(doesn't work with svn 1906)
thx

[TheWitness]

You mean that if the object is restored to normal, you would wait for the trigger time to elapse prior to sending the restoral. I'm not sure that makes sense.

[uhtred]

yes, u are right.
the problem i.e.:
if cacti gets no response from a host (cause of timeout), the result of a value is 0 --> restore event
if cacti gets response again --> went above event

[TheWitness]

Sounds like you need maybe to have a Time Based thold instead. Am I right?

[skatter]

Installed Settings 0.71, thold 0.4.7, and when I click on the thold tab I get the following error:

"Table 'cacti.thold_template' doesn't exist"

I tried to run upgrade.php, but got the following error messages:
# php upgrade.php
Faking Low Thold Version
Running Thold Upgrade
PHP Notice: Undefined index: keys in /usr/local/share/cacti/lib/plugins.php on line 174
PHP Notice: Undefined index: keys in /usr/local/share/cacti/lib/plugins.php on line 174

Trying to import thold.sql manually:
# mysql -u root cacti -p < thold.sql
Enter password:
ERROR 1064 (42000) at line 111: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Table of Tholds Template Contacts'' at line 6

[TheWitness]

The first set of warnings can be ignored. However, the second is due to a problem with the SQL designed for MySQL 5.0 and less. I've correct the second issue in SVN. However, you should neither have to run neither. You should simply install from plugin management. This is PIA 2.x, which makes the SQL files obsolete.

[uhtred]

Sounds like you need maybe to have a Time Based thold instead. Am I right?

i will try it.
i did change the template from high/low to time based, but there seems to be a little bug in the mail notification.
my warning is 80
my alert is 90

alert mails are ok (i.e. ALERT .... went above threshold of 90 with 91.6663)
but warning mails are nok (i.e. WARNING .... went above threshold of 90 with 87.9312)
so warning mails use the alert value in mail

(svn1906)

[TheWitness]

I found this, but only for 'Time Based' alarms. Can you confirm in svn1910.

TheWitness

[skatter]

The first set of warnings can be ignored. However, the second is due to a problem with the SQL designed for MySQL 5.0 and less. I've correct the second issue in SVN. However, you should neither have to run neither. You should simply install from plugin management. This is PIA 2.x, which makes the SQL files obsolete.

How can I check to see if it installed properly? The first method I used was simply via PIA through the GUI, which is when I ran into the referenced error. Now, when I try to create a thold template I get the following error:
Error: Save Failed.

How can I run a sanity check against thold to find out if it is fully/properly installed? I suspect that the SQL portion is what's missing here.

Here are the tables in Cacti after installing/enabling thold:

Code: Select all

mysql> show tables;
+----------------------------+
| Tables_in_cacti            |
+----------------------------+
| cdef                       |
| cdef_items                 |
| colors                     |
| data_input                 |
| data_input_data            |
| data_input_fields          |
| data_local                 |
| data_template              |
| data_template_data         |
| data_template_data_rra     |
| data_template_rrd          |
| graph_local                |
| graph_template_input       |
| graph_template_input_defs  |
| graph_templates            |
| graph_templates_gprint     |
| graph_templates_graph      |
| graph_templates_item       |
| graph_tree                 |
| graph_tree_items           |
| host                       |
| host_graph                 |
| host_snmp_cache            |
| host_snmp_query            |
| host_template              |
| host_template_graph        |
| host_template_snmp_query   |
| mac_track_interface_graphs |
| plugin_config              |
| plugin_db_changes          |
| plugin_hooks               |
| plugin_realms              |
| poller                     |
| poller_command             |
| poller_item                |
| poller_output              |
| poller_reindex             |
| poller_time                |
| rra                        |
| rra_cf                     |
| settings                   |
| settings_graphs            |
| settings_tree              |
| snmp_query                 |
| snmp_query_graph           |
| snmp_query_graph_rrd       |
| snmp_query_graph_rrd_sv    |
| snmp_query_graph_sv        |
| user_auth                  |
| user_auth_perms            |
| user_auth_realm            |
| user_log                   |
| version                    |
+----------------------------+
53 rows in set (0.00 sec)

[TheWitness]

Please disable STRICT for the SQL_MODE setting in MySQL (/etc/my.cnf) and then restart MySQL. It looks like quite a bit failed with the default, which Cacti is not compatible with. After which, you should consider starting over if you are not too far along.