# -----------------------------------------------------------------------
# © Copyright 2003-2008 by Alex Peeters [alex.peeters@citap.be]
# -----------------------------------------------------------------------
# General - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Author : Alex Peeters [alex.peeters@citap.be]
Latest update: 13 Februari 2007
Version : 3.000.016
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
# general - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Version 3.000.016, 2007/xx/yy, by Alex Peeters with contributions from Yves Van den Hove.
ASNMTAP
- UPDATE fixRights.sh
- UPDATE '#!/usr/bin perl' or '#!/usr/local/bin/perl' with '#!/bin/env perl'
to use the perl version found by the environment variable PATH
http://www.cyberciti.biz/tips/finding-bash-perl-python-portably-using-env.html
ASNMTAP::Applications
- archive.pl
- FIXED (1863109) createCommentsAndEventsArchiveTables at the end of the year
- holidayBundleSetDowntimes.pl
- NEW (1725445) Groeperen Mails
ASNMTAP::Asnmtap::Applications.pod
- FIXED MySQL GRANT configuration part
ASNMTAP::Asnmtap::Applications::CGI
- /applications/htmlroot/snmptraps/include/classes/class.mysqlDB.php
- UPDATE class.mysqlDB.php
- generateConfig.pl
- FIX (1822759) A first time config generate/install doesn't say what actions need to be done on a server
- reports.pl
- FIX (1827421) Added reportTitle
ASNMTAP::Asnmtap::Plugins
- /plugins/nagios/check_network_interface_traffic.pl
- UPDATE making Solaris 10 compatible
- /plugins/jUnit/
- UPDATE create_ASNMTAP_jUnit_configuration_for_jUnit.pl
- /plugins/snmptt/
- UPDATE check_snmptt_traps.pl
- NEW check_snmptt_traps.plN
- /plugins/templates/
- UPDATE check_template-WebTransact.pl
- /plugins/templates/jUnit/
- NEW create_ASNMTAP_jUnit_configuration_for_jUnit-3.000.016_mysql.SQL
- NEW create_ASNMTAP_jUnit_configuration_for_jUnit-3.000.016_mysql-v5.0.x.SQL
- /plugins/templates/snmptt/
- NEW check_SNMPTT_probe.pl
- UPDATE check_SNMPTT_weblogic.pl
- NEW snmptt-3.000.016-v5.0.x.sql
- UPDATE TABLE `snmmptt` for MySQL' version 5.x
- ALTER TABLE `snmptt` CHANGE COLUMN `formatline` `formatline` varchar(1024) default NULL;
- ALTER TABLE `snmptt_archive` CHANGE COLUMN `formatline` `formatline` varchar(1024) default NULL;
- ALTER TABLE `snmptt_unknown` CHANGE COLUMN `formatline` `formatline` varchar(1024) default NULL;
- ALTER TABLE `snmptt_unknown_archive` CHANGE COLUMN `formatline` `formatline` varchar(1024) default NULL;
- UPDATE TABLE `wls_snmptt_CONFIG`
- ALTER TABLE `wls_snmptt_CONFIG` CHANGE COLUMN `trapMBeanType` `trapMBeanType` varchar(128) NOT NULL default '';
- ALTER TABLE `wls_snmptt_CONFIG` CHANGE COLUMN `trapAttributeName` `trapAttributeName` varchar(128) NOT NULL default '';
- ALTER TABLE `wls_snmptt_CONFIG` CHANGE COLUMN `trapMonitorType` `trapMonitorType` varchar(128) NOT NULL default '';
- ALTER TABLE `wls_snmptt_CONFIG` ADD COLUMN `trapLogSeverity` varchar(128) NOT NULL default '' AFTER `trapMonitorType_MATCH`, ADD COLUMN `trapLogSeverity_MATCH` char(2) default NULL AFTER `trapLogSeverity`, ADD COLUMN `trapLogMessage` varchar(128) NOT NULL default '' AFTER `trapLogSeverity_MATCH`, ADD COLUMN `trapLogMessage_MATCH` char(3) default NULL AFTER `trapLogMessage`;
- ALTER TABLE `wls_snmptt_CONFIG` DROP PRIMARY KEY, ADD PRIMARY KEY (`trapMBeanType`,`trapAttributeName`,`trapMonitorType`, `trapLogSeverity`, `trapLogMessage`, `event_name`,`category`,`sources_list`,`mode`);
- UPDATE snmptt-bea-weblogic.conf
- UPDATE create_weblogic_configuration_database_with_SNMP-3.000.016.SQL
- UPDATE create_weblogic_configuration_database_with_SNMP-3.000.016_mysql-v5.0.x.SQL
ASNMTAP::Asnmtap::Plugins::Mail.pm
- FIX regarding MIME-Encoding 'quoted-printable' into MIME-tools-5.425
ASNMTAP::Asnmtap::Plugins::Nagios
- NEW Makefile.PL Net::Ifconfig::Wrapper
ASNMTAP::Asnmtap::Plugins::WebTransact
- UPDATE POD with 'Qs_var => [..., submain => RET_SUBMAIN, title1 => RET_TITLE1]'
Version 3.000.015, 2007/10/21, by Alex Peeters with contributions from Yves Van den Hove.
Makefile.PL
- version update CPAN 1.9102
- version update CGI 3.29
- version update Compress::Zlib 2.004
- version update Config::General 2.33
- version update Crypt::OpenSSL::RSA 0.25
- version update Crypt::OpenSSL::X509 0.5
- version update Crypt::SSLeay 0.56
- version update Cwd 3.25
- version update Bundle::DBD::mysql 4.005
- version update IO::Socket::SSL 1.07
- version update NetAddr::IP 4.007
- version update WSRF::Lite 0.8.2.2
- version update XML::LibXML 1.63
ASNMTAP CPAN module perl 5.8.0, 5.8.5 and 5.8.6 compatible
- Making perl 5.8.8 compatible
ASNMTAP::Asnmtap
- NEW environment variable ASNMTAP_PATH used into the bash scripts
- NEW making MySQL 5.0.x compatible
- NEW asnmtap-3.000.015_mysql-v5.0.x.sql
- NEW applications/tools/mysql/asnmtap-3.000.015-distributed_mysql-v5.0.x.sql
- FIX OnDemand versus Display with 254 character limitation for MySQL >= v5.0.3 and yyyymmdd-test-ukey.sql-LOAD-DATA-FAILED
Values in VARCHAR columns are variable-length strings.
The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions.
TEXT A string with a maximum length of 65535 characters, from a variable length types that store large amounts of data.
Is similar to a larger version of VARCHAR. These types can store a large piece of data information, but is also processed much slower.
- OnDemand
CRITICAL - WebService ... (Production): 500 read timeout - 200 OK - getVersion (...:9108): 4.20063.13 - 200 OK - ping (...:9110): OK - 200 OK - monitorControls (...:9110): OK - 200 OK - getVersion (...:9110): 4.20063.13 - ...: WARNING|'ping (...:8080)'=172ms;;;; 'monitorControls (...:8080)'=29682ms;;;; 'getVersion (...:8080)'=25ms;;;; 'ping (...:9108)'=25ms;;;; 'monitorControls (...:9108)'=30022ms;;;; 'getVersion (...:9108)'=24ms;;;; 'ping (...:9110)'=24ms;;;; 'monitorControls (...:9110)'=18898ms;;;; 'getVersion (...:9110)'=23ms;;;; Status=2;1;2;0;3 Compilation=1523ms;;;0; Trendline=79.039s;;;; Execution=80579ms;;;0;
- Display: afkapping op 254 characters
CRITICAL - WebService ... (Production): 500 read timeout - 200 OK - getVersion (...:9108): 4.20063.13 - 200 OK - ping (...:9110): OK - 200 OK - monitorControls (...:9110): OK - 200 OK - getVersion (...:9110): 4.20063.13 - ...
- v4.x : `statusMessage` varchar(254) NOT NULL default '',
- v5.0.x : `statusMessage` varchar(1024) NOT NULL default '',
alter table events_yyyy_mm change statusMessage statusMessage varchar(1024);
- IMPROVED perfparse_crontab.sh
- NEW perfparse_crontab_failed.sh (Yves Van den Hove)
- NEW perfparse_debug.sh by (Yves Van den Hove)
ASNMTAP::Asnmtap::Applications
- Applications.cnf
...
#
# LIB /opt/ChartDirector/lib/.
#
...
replace
#
#
with
#
#
add
...
#
# BIN /opt/asnmtap-3.000.xxx/perfparse/bin
# ETC /opt/asnmtap-3.000.xxx/perfparse/etc
# LIB /opt/asnmtap-3.000.xxx/perfparse/lib
# SHARE /opt/asnmtap-3.000.xxx/perfparse/share
# CGI /cgi-bin/perfparse.cgi
# ENABLED 0 # '0' or '1'
# DATABASE ~
# HOST ~
# PORT ~
# USERNAME ~
# PASSWORD ~
#
...
replace
#
...
# REPORTS reports
...
#
with
#
...
# REPORTS reports
# REPORTSPERFDATA reports_perfdata
...
#
- NEW $SERVERTABLREPORTSPRFDT into CGI.pm
- NEW $CHARTDIRECTORLIB and $SERVERTABLREPORTSPRFDT into Applications.pm
- NEW $PERFPARSEBIN $PERFPARSEETC $PERFPARSELIB $PERFPARSESHARE $PERFPARSECGI $PERFPARSEENABLED into CGI.pm & Applications.pm
ASNMTAP::Asnmtap::Applications::Collector
- NEW $CHARTDIRECTORLIB into collector.pl
ASNMTAP::Asnmtap::Applications::CGI
- NEW $CHARTDIRECTORLIB into generateChart.pl , generateCollectorCrontabSchedulingReport.pl, generateCollectorDaemonSchedulingReport.pl & generatePluginCrontabSchedulingReport.pl
ASNMTAP::Asnmtap::Plugins
- NEW check_template-SNMPTT.pl
ASNMTAP::Asnmtap::Plugins::Nagios
- NEW check_network_interface_traffic.pl
display.pl
- IMPROVED Status Message Error Displaying
/bin/generateReports.pl
- ADD show comments
/sbin/purge_table.pl
- FIX regarding: Can't create emailReport
- FIX snmptt-3.000.015.sql: Cannot dbh->do: DELETE FROM `snmptt_unknown_archive` WHERE archivetime < "1161727200"
/detailedStatisticsReportGenerationAndCompareResponsetimeTrends.pl
- ADD show comments
- ADD short description
- FIX Use of uninitialized value in concatenation (.) or string at line 333
/moderator/collectorDaemonSchedulingReports.pl
- FIX Use of uninitialized value in split at line 79.
/moderator/plugins.pl
- NEW Plugins (to edit short description, trendline, holiday bundle and uploading plugindoc)
/moderator/trendlineCorrectionReports.pl
- FIX Use of uninitialized value in split at line 93.
- FIX Possible precedence problem on bitwise & operator at line 117.
- FIX switch startdate with enddate
/admin/reports.pl
- ADD show comments
- NEW Select 'Reports Perfdata'
/admin/reports_perfdata.pl
- NEW Reports Perfdata (to define the 'Performance Times' that are used by the automatically generated Reports)
/sadmin/crontabs.pl
- FIX 'select SQL_NO_CACHE count(id) from crontabs' with 'select SQL_NO_CACHE count(lineNumber) from crontabs'
/sadmin/plugins.pl
- ADD short desription
- FIX $notActivated = ($Cactivated) ? '' : ' not'; with $notActivated = ($CTactivated) ? '' : ' not';
integration with jUnit
- NEW /plugins/jUnit/
- NEW check_jUnit.pl
- NEW create_ASNMTAP_jUnit_configuration_for_jUnit.pl
integration with SNMPTT
- NEW /plugins/snmptt/
- NEW check_SNMPTT_weblogic.pl
- NEW create_ASNMTAP_weblogic_configuration_for_SNMP.pl
- NEW create_weblogic_configuration_for_SNMPTT.pl
- FIX snmptt_traps_remove_pending_and_duplicated.pl
- NEW /plugins/templates/snmptt/
- UPDATE create_weblogic_configuration_database_with_SNMP-3.000.015.SQL
- NEW create_weblogic_configuration_database_with_SNMP-3.000.015_mysql-v5.0.x.SQL
- NEW snmptt-bea-weblogic.conf
- NEW snmptt-3.000.015.sql
- NEW snmptt.ini
integration with NagTrap
- NEW /applications/htmlroot/snmptraps
table plugins
- ADD `shortDesription` text,
table reports
- ADD `showComments` tinyint(1) NOT NULL default '0',
- ADD `showPerfdata` tinyint(1) NOT NULL default '0',
table reports_perfdata
- NEW table reports_perfdata
Version 3.000.014, 2007/06/10, Makefile.PL
- version update CPAN 1.9101
- version update CPANPLUS 0.78
- version update Config::General 2.32
- version update DateTime 0.37
- version update Email::Simple 1.999
- version update ExtUtils::MakeMaker 6.32
- version update IO::Socket::SSL 1.040
- version update Net::LDAP 0.34
- version update Time::HiRes 1.9705
- version update WSRF::Lite 0.8.2.1
MANIFEST
- NEW check_template-WebTransact-XML-Monitoring.pl
- NEW check_template-WebTransact-XML-Monitoring.t
- NEW check_template-WebTransact-with-client-authorization.pl
- NEW check_template-WebTransact-with-client-authorization.t
README
- updated INSTALLATION procedure
Applications.cnf
#
#
# VERSION 4.x # '4.x' or '5.0.x'
# MERGE 0 # '0' or '1'
#
ASNMTAP::Asnmtap::*
- optimalisation for MySQL queries
ASNMTAP::Asnmtap::Applications.pm & display.pl
- FIX sound sanity .innerHTML bug with FireFox
- UPDATE sound default set to 'off' when FireFox, otherwise default set to 'on'
- UPDATE $TcommentData =~ s/[\n\r]+(Updated|Edited|Closed) by: (?:.+), (?:.+) \((?:.+)\) on (\d{4}-\d\d-\d\d) (\d\d:\d\d:\d\d)/\n\r$1 on $2 $3/g;
ASNMTAP::Asnmtap::Applications::CGI.pm & archiver.pl
- NEW $SERVERMYSQLVERSION = '4.x # '4.x' or '5.0.x'
- NEW $SERVERMYSQLMERGE = '0' # '0' or '1'
- UPDATE create_sql_query_events_from_range_year_month with MERGE when $SERVERMYSQLMERGE = 1 for much faster year and quarter statistics
ASNMTAP::Asnmtap::Plugins
- NEW create_NCPL_weblogic_configuration_for_SNMP.pl
- NEW create_weblogic_configuration_database_with_SNMP.pl
- NEW create_weblogic_configuration_database_with_SNMP.SQL
ASNMTAP::Asnmtap::Plugins::Mail.pm
- FIX regarding MIME-Encoding '7bit' and code optimalisation
- NEW MIME-Encoding: '8bit', 'binhex', 'binary', 'x-gzip64', 'x-uu' & 'x-uuencode'
- overview MIME-Encoding: '7bit', '8bit', 'quoted-printable', 'base64', 'binhex', 'binary', 'x-gzip64', 'x-uu' & 'x-uuencode'
ASNMTAP::Asnmtap::Plugins::Nagios
- NEW check_network_interface_status.pl
- NEW snmptt_traps_remove_pending_and_duplicated.pl
ASNMTAP::Asnmtap::SOAP.pm
- NEW added basic authentication and credentials
- NEW added soapaction and readable
ASNMTAP::Asnmtap::Plugins::WebTransact.pm
- NEW Inherited LWP user agent object: $objectWebTransact->ua = LWP::UserAgent->new;
check_template-WebTransact-XML-Monitoring.pl & check_template-WebTransact-XML-Monitoring.t
- NEW WebTransact plugin template for XML Monitoring
check_template-WebTransact-with-client-authorization.pl & check_template-WebTransact-with-client-authorization.t
- NEW WebTransact plugin template with client authorization
detailedStatisticsReportGenerationAndCompareResponsetimeTrends.pl
- add corresponding comments to the report
generateReports.pl & getArchivedReport.pl
- add support for timeperiod
Version 3.000.013, 2007/02/25, ASNMTAP
- add BEGIN { if ( $ENV{ASNMTAP_PERL5LIB} ) { eval 'use lib ( "$ENV{ASNMTAP_PERL5LIB}" )'; } }
- FIX replace