/*******************************************************************************
Author ......... Jimmy Conner
Contact ........ jimmy@sqmail.org
Home Site ...... http://cactiusers.org
Program ........ Thold for Cacti
Purpose ........ Threshold Alert module
*******************************************************************************/
----[ Purpose
This plugin is for the alerting of data found within any graph within Cacti.
----[ Installation
To install the plugin, please refer to the Plugin Installation Documentation
Thold requires the Settings plugin to be installed.
----[ Possible Bugs?
If you find a problem, let me know!!! http://bugs.cacti.net
----[ Future Changes
Threshold Escalation
Add feature to run scripts or do other things besides email
Got any ideas or complaints, please e-mail me!
----[ Changelog
--- 0.5.0.1 ---
autor: Usuychik
contact: https://github.com/Usuychik/thold/
feature: add support of sms sending on treshold
feature: add support of custom script execution on treshold
--- 0.5 ---
feature: Allow threshold log retention to be configurable
bug: Thold Suggested Names not applied in all cases
bug: Use of Aggregate breaks Thold edit UI and new Tholds
bug: #0002247 - SQL Injection in thold.php (must be authenticated first) Thanks Primož!!
--- 0.4.9 ---
feature: Allow HRULES based upon HI/LOW Value portions courtesy of Barnaby Puttick
bug: Restoral Emails not working in all cases
bug: When polling returns non-numeric data, don't return false LOW alarms
bug: Fix time based Warnings
bug: More issues with Realert for Time Based and Hi/Low
bug: Be more specific about what 'Hosts:' means when generating stats
--- 0.4.8 ---
feature: Support for Ugroup Plugin
bug: Speed of |query_*| replacements in RPN Expressions
bug: Correct name space collision with Weathermap
bug: <THRESHOLDNAME> replacement using Data Source name and not Threshold Name
bug: Notification List Disassociate Global List not functional
--- 0.4.7 ---
feature: Add index to optimize page loads
feature: Allow more hosts to be reported as down
--- 0.4.6 ---
Add Warning Support Curtesy (Thomas Urban)
Improve display of Baseline Alarms
Add Log Tab and new Events for Readablilty
Allow a variable replacements in Threshold names
Fix several GUI and polling issues
Don't alarm on blank data output
Remove old ununsed variables
Fix thold messages on restorals
Reapply Suggested Name for Tholds
Add Email Priority per 'dragossto'
Add Email Notification Lists for Thresholds, Templates and Dead Hosts
Add Ability to Disable Legacy Alerting
Add Ability to use |ds:dsname| and |query_ifSpeed| in RPN Expression
Add RPN Expressions 'AND' and 'OR'
Add Support for Boost to Baseline Tholds
Add Template Export/Import Functionality
Add DSStats functionality to RPN Expressions save on Disk I/O
--- 0.4.4 ---
Fix emailing of alerts when PHP-GD is not available
Add Debug logging
Sort Threshold drop down list by Description
Add missing column to upgrade script
Update baseline description
Multiple fixes posted by our hard working forum users!!!
--- 0.4.3 ---
Add support for maint plugin
Fix to allow Add Wizard to show all datasources belonging to a graph (even when in separate data templates)
Re-apply SQL speed up when polling
Several fixes to Baselining
Several fixes to CDEFs
Add customizable subjects and message body for down host alerts
--- 0.4.2 ---
Fixed Cacti 0.8.7g compatibility
Bug#0001753: Lotus Notes are unable to render inline png pictures
Bug#0001810: Thold: RRDTool 1.4.x error while determining last RRD value
Bug: Fix for compatibility with other plugins using datasource action hook
Bug: Re-add syslog messages for down hosts
Bug: Fixed a few minor issues
Bug: Allow the use of query_XYZ in CDEFs
Bug: Fix host status page to only allow users to see hosts they have access to
Bug: Fix ru_nswap errors on Windows
--- 0.4.1 ---
Feature: Add thold statistics to settings table to allow graphing the results
Bug: Return False from host status check function if it is disabled
Bug: Speed up Datasource Query on Told Tab
Bug: Fix CDEF usage
Bug: Fix Thold Add Wizard Bug with IE6/7
Bug: Fix HTTP_REFERER error
Bug: Fix duplicate function names (when improperly installing plugin)
--- 0.4.0 ---
Bug: Fix for multiple poller intervals, use RRD Step of Data Source instead of Polling Interval
Bug: Fix for down host alerting on disabled hosts
Feature: Add filtering to listthold.php
Feature: Use time periods instead of number of pollings when specifying Repeat Alerts and Fail Triggers
Feature: Time Based Threshold Checking
Feature: Percentage Calculation
Feature: Add Threshold Sub Tabs with Both Threshold and Host Status
Feature: Allow Naming of Threshold Templates and Thresholds
Feature: Allow Thresholds to be added in mass via a Data Sources dropdown
Feature: Allow Thresholds to be added in mass via a Graph Management dropdown
Feature: Added Background Color Legend for Multiple Interfaces
Feature: Add Threshold creation Wizard
Feature: Make Wizard Design Consistent
Feature: Add Filtering to User Threshold View and Host Status View
Feature: Allow Disable/Enable/Edit/View Graph Actions from Main Page
Feature: Allow Edit Host from Host Status
Feature: Enable Toggle VRULE On/Off to show breached Thresholds on the graph images
Feature: Allow Adding Thresholds from Graphs Page
Feature: Use Cacti User Permissions when viewing and editing Thresholds
Feature: Allow Weekend Exemptions per Threshold
Feature: Allow the disabling of the Restoration Email per Threshold
Feature: Allow logging of all Threshold Breaches to Cacti Log File
Feature: Allow logging of all Threshold creations / changing / deletions to Cacti Log File
Feature: Allow global disabling of all Thresholds
Feature: Allow setting of Syslog Facility for Syslog Logging
--- 0.3.9 ---
Major poller speed increase when using large numbers of thresholds
--- 0.3.8 ---
Fix undefined variable error on thold.php
--- 0.3.7 ---
Fix issue with thold.php not correctly saving the host id
Fix issue with Setting plugin having to be before thold in the plugins array
--- 0.3.6 ---
Compatible with Cacti v0.8.7 (not backwards compatible with previous versions)
Fixed issue with saving user email addresses
Fixed issue with tab images
--- 0.3.5.2 ---
Fix issues for users not using latest SVN of the Plugin Architecture
--- 0.3.5.1 ---
Fix for latest Cacti v0.8.6k SVN (requires latest SVN of Plugin Architecture)
--- 0.3.5 ---
Update plugin to use the Settings plugin for mail functionality
Fix for thold values being off when using different polling intervals
Use new "api_user_realm_auth" from Plugin Architecture
Fix for creating multiple thresholds via templates from the same DataSource
Fix for threshold template data propagating to an incorrect threshold
Added Email Address field to User's Profiles
Added ability to select a user to alert for a threshold instead of having to type in their email address
Change to using the Settings plugin for mail functionality
--- 0.3.4 ---
Allow text only threshold alerts (aka no graph!)
Add some text to the alerts, including the hostname
Change the email to be sent as "Cacti" instead of PHPMailer
Fix issue with host alerts still being sent as multipart messages
Add the ability to completely customize the threshold alert (allow descriptors)
Re-arrange the Settings page to group like options
Fix an issue when applying thresholds to a device with no datasources / dataqueries
Add the ability for template changes to propagate back to the thresholds (with the ability to disable per threshold)
--- 0.3.3 ---
#0000076 - Fix to speed up processing of thresholds (thanks mikv!)
#0000079 - Bug causing thold to not respect the others plugins device page actions
Fix an issue with re-alert set to 0 still alerting
Fix the host down messages, this will work with cactid also
Host Down messages are now sent as text only emails
--- 0.3.2 ---
Fix an index error message displayed when clicking the auto-creation link
Fix an issue with thresholds not switching into "is still down" mode when alerting
Fix a rare error where under certain conditions no data is passed back to threshold during polling
--- 0.3.1 ---
Patch from William Riley to allow the threshold management page to be split into separate pages
Fix a php short tag issue on graph_thold.php
Major rewrite of thold processing, now we pull from the poller output table instead of directly from the rrd files
Major code cleanup in a few files
Remove the tholdset table
Remove the thold table
Add an option for the priority level used when syslogging
Add the option allow applying thresholds to multiple hosts at once through the Devices page
#0000035 - Does not handle INDEXED data sources correctly
#0000038 - Thresholding non-integer does not seem to work
#0000041 - Subject of mail message now reflects the data source item (also #0000066)
#0000059 - Thold always displays and assigns only one associated graph with the lowest graph_id
#0000060 - Issue with "nan" values in the RRD File
#0000062 - Step value of the rra is not considered for fetching rrd values
#0000063 - CDEF function error (100 -DS)
--- 0.3.0 ---
#0000040 - Fix issue with invalid link in Navigation panel under certain circumstances
#0000048 - Fix improper notification of global address when Threshold set to "Force: Off"
#0000042 - Add ability to apply a CDEF to the threshold before using the data
#0000054 - Fix issue with CDEFs on manual threshold creating page
--- 0.2.9 ---
#0000021 - Fix for rare SQL errors when auto-creating Thresholds when no Graph is associated with a Datasource
#0000024 - Thold Templates not allowing for NULL Upper or Lower Baselines
#0000031 - When creating Thresholds and Templates, default values were not provided
#0000032 - Validation Error on listthold.php when selecting "Show All"
Added some more POST validation to Threshold Templates
Fix for Undefined offset in thold.php
Changed the font size for the Auto-Create Thold Messages
--- 0.2.8 ---
#0000013 - Fix issues with database names with uncommon characters by enclosing in back-ticks.
#0000030 - Allow use of decimal values in thresholds up to 4 decimal places
#0000005 - Fix for threshold values not matching the graph values
Change "Thresholds" to "Threshold Templates"
--- 0.2.7 ---
Fixes for "are you sure you meant month 899" errors
Fixes for table tholdset being empty causes poller to not function
Resolved issue with Base URL auto generation pointing to the plugin directory
Code Cleanup of Threshold Management Page
"Instructions" rewording on Threshold Management Page
Can now select multiple Thresholds to delete
Orphan thresholds are now cleaned up automatically
Fixed Guest account access to View Thresholds
--- 0.2.6 ---
Fixes for HI and Low thresholds limiting the max characters
Fixed wrong data reported to thold.log
Fix for the error: "sh: line 1: -e: command not found" during thold checks
Added command line switch /show for check-thold.php, which will show the output of all thresholds
Added command line switch /debug to allow it to log to file (to make it permanent, just set debug=1 in the file)
Fixed the Test Email link for IE
--- 0.2.5 ---
Test Link Created to help debug mail sending issues
Several fixes to the Threshold Mailing (SMTP especially was broken)
Several fixes to the Down Host Notification
--- 0.2.4 ---
Added Threshold Templates
A few other minor interface fixes
--- 0.2.3 ---
Emails now use embedded PNG images (instead of links)
Option to send mail via PHP Mail function, Sendmail, or SMTP (even authenicated)
Set the from email address and name
Fixed the Host Down Notification
--- 0.2.0 ---
Auto-create the database if it doesn't exist
Better sorting on threshold tables
Does not require its own cron job anymore
Lots of bug fixes for issues in the original threshold module