thold plugin 0.4.6 screenshots

[noname]

Some screenshots of new thold plugin for users and thold contributors before 0.4.6:

thold-0.4.6:
- http://docs.cacti.net/plugin:thold

Default settings in "Cacti Settings (Thresholds)"


Notification can be selectable per device


Console -> Notification Lists (sample)


Console -> Notification Lists -> General


Console -> Notification Lists -> Hosts


Sorry, no screenshot for "Thresholds" tab.

Console -> Notification Lists -> Templates


Per threshold settings -- "Warning" notification is available (for High/Low and Time Based threshold)


Per threshold settings -- "RPN Expression" (sample)

This is sample.
I tried to calculate traffics as percentages.

• Ordinary expression: (|ds:traffic_in| * 8) / |query_ifSpeed| * 100
• RPN expression: |ds:traffic_in|,8,*,|query_ifSpeed|,/,100,*

Result:

EDIT: "Trigger = Never" means "don't alert", so the above settings are not correct..

Graph for Fa0/1 (100Mbits interface):

6.32k / 100M = 0.0000632 (0.00632%)
18.49k / 100M = 0.0001849 (0.01849%)

Graph for Gi0/1 (1Gbits interface):

19.48k / 1G = 0.00001948 (0.001948%)
7.19k / 1G = 0.00000719 (0.000719%)

'thold' tab view at that moment

Alert history during last 30 days can be seen in 'Log' tab.

[TheWitness]

Trigger 'Never' means don't Alert. Also, for 1Gb interfaces, you should use |query_ifHighSpeed|, which is reported in units of MegaBits. For example, a 1Gb interface reports 1000, 1Gb. So, the percentage works a bit differently:

traffic_in and traffic_out are represented in 'octets' or 'bytes'. Therefore percentage becomes:

traffic_in (octets/second) / (ifHighSpeed (10-e6 bits) * 1000000 (10e6) / 8 (bytes/bit)) * 100

Or (I think):

Code: Select all

|ds:traffic_in|,|query_ifHighSpeed|,1000000,*,8,/,/,100,*

We need to add ifHighSpeed to the XML file. To be done shortly. No reason anyone should have to customize to do this.

TheWitness

[noname]

Trigger 'Never' means don't Alert.

Oops, I've misunderstood.. I'll correct my original post.

Also, for 1Gb interfaces, you should use |query_ifHighSpeed|, which is reported in units of MegaBits. For example, a 1Gb interface reports 1000, 1Gb.

Hmm, that's indeed.

On gigabit interfaces, ifSpeed returns 1,000,000,000 and ifHighSpeed returns 1,000.
It's better to use ifHighSpeed than ifSpeed for calculating utilization?

[sukanta]

Great Improvement::

Following problem face during upgradation from 0.4.3

After running : upgrade.php
PHP Fatal error: Call to undefined function get_hash_thold_template() in /var/www/html/cacti/plugins/thold/includes/database.php on line 201

Also It is taking too much time (Not Finishing) ehen trying to create thresholdl for traffic_in

In MySQL Found:


Copying to tmp table SELECT DISTINCT field_name FROM data_local AS dl INNER JOIN host_snmp_cache AS hsc ON

10/08/2011 12:06:31 AM - THOLD: Poller[0] WARNING: Unsupported Field '|QUERY_IFHIGHSPEED|'



Cacti Version : 0.8.7g
OS: Centos 5.6
Settings: 0.7.1

===================

It will be great helpful if we got the down report with duration of each events in log.

[TheWitness]

Thanks for reporting the database.php issue. It's minor. However, you might want to save your templates once to provide them a hash prior to exporting. 0.4.6-2 has been released to address that.

TheWitness

[sukanta]

Thanks for resolving upgrade issue..

Still followings two exists:

1) It is taking too much time (Not Finishing) when trying to create threshold for traffic_in/out. for cpu ok.

In MySQL Found:

Copying to tmp table SELECT DISTINCT field_name FROM data_local AS dl INNER JOIN host_snmp_cache AS hsc ON dl.snmp_query_id=hsc.snmp_query_id WHERE dl.data_template_id=41


2) high speed not supported

10/08/2011 12:06:31 AM - THOLD: Poller[0] WARNING: Unsupported Field '|QUERY_IFHIGHSPEED|'

[TheWitness]

Run two commands for me:

Code: Select all

explain SELECT DISTINCT field_name FROM data_local AS dl INNER JOIN host_snmp_cache AS hsc ON dl.snmp_query_id=hsc.snmp_query_id WHERE dl.data_template_id=41

Code: Select all

show create table data_local

Code: Select all

show create table host_snmp_cache

For the second issue, here is a patch that we will be releasing soon. You will have to reindex your hosts though:

Code: Select all

php -q poller_reindex_hosts.php

[TheWitness]

If you are using boost, you also need boost-5.1-1.tgz from the Cacti Doc's site.

[TheWitness]

I can get this a bit more optimized. I'll release as 0.4.7 with some enhancements for Down Host detection.

TheWitness

[sukanta]

Run two commands for me:

Code: Select all

explain SELECT DISTINCT field_name FROM data_local AS dl INNER JOIN host_snmp_cache AS hsc ON dl.snmp_query_id=hsc.snmp_query_id WHERE dl.data_template_id=41

Hanging the Mysql Process where snmp_cache is large. For new installation working fine .But why u need this.Old thold working fine on same setup..

Code: Select all

show create table data_local

mysql> show create table data_local;
+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| data_local | CREATE TABLE `data_local` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`data_template_id` mediumint(8) unsigned NOT NULL default '0',
`host_id` mediumint(8) unsigned NOT NULL default '0',
`snmp_query_id` mediumint(8) NOT NULL default '0',
`snmp_index` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19028 DEFAULT CHARSET=latin1 |
+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Code: Select all

show create table host_snmp_cache

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,
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)


For the second issue, here is a patch that we will be releasing soon. You will have to reindex your hosts though:

Code: Select all

php -q poller_reindex_hosts.php

[TheWitness]

Not much of an update. Test SVN#1816. I need your feedback prior to releasing 0.4.7.

[sukanta]

Not much of an update. Test SVN#1816. I need your feedback prior to releasing 0.4.7.

No Luck with that SVN also.Still MYSQL hanging on that query when number of entry against that template (like traffic_out) is high.

This is causing due to following function which is part of RPN:

As a workaround disabled that function in thold_templates.php & everything running smoothly.



$replacements = db_fetch_assoc("SELECT DISTINCT field_name
FROM data_local AS dl
INNER JOIN host_snmp_cache AS hsc
ON dl.snmp_query_id=hsc.snmp_query_id
WHERE dl.data_template_id=" . $thold_item_data['data_template_id']);

Thanks to providing modified rrd.php which solve IfHighSpeed issue..

Pl issue patch for new cacti as there are some modification/correction found in SVN/forum...

[TheWitness]

Oh, I see. I patched for thold.php and thold_template.php. Let me get thold_template.php fixed as well.

TheWitness

[TheWitness]

Run these three commands as let me know if the performance is a bit better:

Code: Select all

ALTER TABLE data_local ADD INDEX data_template_id(data_template_id);
ALTER TABLE data_local ADD INDEX snmp_query_id(snmp_query_id);
ALTER TABLE host_snmp_cache ADD INDEX snmp_query_id(snmp_query_id);

TheWitness

[sukanta]

Run these three commands as let me know if the performance is a bit better:

Code: Select all

ALTER TABLE data_local ADD INDEX data_template_id(data_template_id);
ALTER TABLE data_local ADD INDEX snmp_query_id(snmp_query_id);
ALTER TABLE host_snmp_cache ADD INDEX snmp_query_id(snmp_query_id);

TheWitness

Same problem.

Also another major issue found that template Filtering not working when selecting Status either Breached/Triggered..Till 0.4.4 it was fine.