ASNMTAP
view release on metacpan or search on metacpan
BUGFIX: DESTROY created new reference to dead object 'ASNMTAP::Asnmtap::Plugins::Nagios' during global destruction.
- WebTransact.pm
UPDATE: added Content_Type: 'multipart/form-data' for qs-fixed
- change code to use 'perfdata'
- UPDATE: asnmtap-3.002.003_mysql-v5.0.x-trigger-events.sql
- UPDATE: asnmtap-3.002.003_mysql-v5.0.x-trigger-eventsUpdate.sql
- runCmdOnDemand.pl & WebTransact.pm
- replace <BODY onload="..."> with <BODY>
- SOAP.pm
NEW: encodingStyle
NEW: error 'Missing SOAP Envelope or Body'
UPDATE: soapaction
- create_ASNMTAP_weblogic_configuration_for_SNMP.pl
UPDATE: added status to e-mail subject
- NEW: supportRequest template (applications/custom/supportRequest.pm-orig) integrated into comments.pl
- NEW: integration for SDE (applications/custom/sde-supportRequest.pm-orig) into comments.pl
- NEW: check_xml-monitoring-1.2.pl
- UPDATE: coments.pl with integration for applications/custom/supportRequest.pm
ASNMTAP::Asnmtap::Applications
- Applications.cnf
<COMMON>
...
# <PERFPARSE>
# ...
# VERSION 20 # '19' or '20'
# CONFIG perfparse20.cfg # 'perfparse.cfg' or 'perfparse20.cfg'
# </PERFPARSE>
</COMMON>
Version 3.002.002, 2010/09/22, by Alex Peeters
ASNMTAP
- UPDATE asnmtap-3.002.002_mysql-v5.0.x-trigger-events.sql
- optimalisatie DBI connection problems
- NEW /cgi-bin/moderator/comments.pl
Set multiple comments by drag and drop list
Database schema v3.002.002
- UPDATE /applications/tools/mysql/asnmtap-3.002.002_mysql-v5.0.x.sql
- UPDATE /applications/tools/mysql/asnmtap-3.002.002-distributed_mysql-v5.0.x.sql
- ALTER TABLE `events` ADD COLUMN `perfdata` text AFTER `statusMessage`;
- ALTER TABLE `eventsDisplayData` ADD COLUMN `perfdata` text AFTER `statusMessage`;
- ALTER TABLE `views` ADD COLUMN `timeperiodID` INT(11) NOT NULL DEFAULT '1' AFTER `displayGroupID`;
- ALTER TABLE `views` ADD INDEX `timeperiodID` (`timeperiodID`);
- ALTER TABLE `views` ADD INDEX `views_ibfk_4` (`catalogID`, `timeperiodID`);
- ALTER TABLE `views` ADD CONSTRAINT `views_ibfk_4` FOREIGN KEY (`catalogID`,`timeperiodID`) REFERENCES `timeperiods` (`catalogID`,`timeperiodID`);
Help Plugin docs
- update new help plugin doc file type 'http(s)://'
SNMPTraps-Frontend for Nagios & ASNMTAP
- UPDATE class.mysqlDB.php: replace 'INSERT INTO' with 'REPLACE INTO'
XML plugin templates
- UPDATE new command line option 'uKey'
ASNMTAP::Asnmtap::Applications::CSV VARIABLES
- UPDATE our @EVENTS = ('catalogID', 'id', 'uKey', 'replicationStatus', 'test', 'title', 'status', 'startDate', 'startTime', 'endDate', 'endTime', 'duration', 'statusMessage', 'perfdata', 'step', 'timeslot', 'instabilit...
views.pl
- added 'Incident Monitoring Window'
Version 3.002.001, 2010/07/28, by Alex Peeters
ASNMTAP
- NEW 'filter-option' to search
- UPDATE cpan module SOAP::Lite to 0.710.08 (reported problems with 0.710.09 and later)
- UPDATE cpan module WSRF::Lite to 0.8.2.7
- UPDATE /applications/tools/mysql/asnmtap-3.002.001-database-schema.png
- UPDATE create_ASNMTAP_jUnit_configuration_for_jUnit.pl
- NEW autoinstall.sh
- UPDATE Applications.cfg
- NEW 'EVENTSDISPLAYDATA eventsDisplayData' between <TABLES>...</TABLES>
- NEW module ASNMTAP::PseudoHash for making perl 5.10 compatibility
replace 'use fields' with 'use ASNMTAP::PseudoHash'
replace 'fields::phash' with 'ASNMTAP::PseudoHash'
- UPDATE comments.pl -> html code optimalisation
- UPDATE display.pl -> debug: toggleDiv(), pop-up: overlib() & pop-down: nd()
- NEW $trigger, to speedup the display generation: fase I
- UPDATE trendlineCorrectionReports.pl -> faster SQL queries
- UPDATE TABLE `displayDaemons` for MySQL'
- ALTER TABLE `displayDaemons` ADD COLUMN `trigger` char(1) NOT NULL default 'F' AFTER `loop`;
- UPDATE TABLE `eventsChangesLogData` for MySQL'
- ALTER TABLE `eventsChangesLogData` ADD COLUMN `posTimeslot` INT(11) NOT NULL default '9' AFTER prevTimeslot;
- NEW TABLE `eventsDisplayData` for MySQL'
- CREATE TABLE `eventsDisplayData` (
- `catalogID` varchar(5) NOT NULL default 'CID',
- `posTimeslot` int(11) NOT NULL DEFAULT '0',
- `uKey` varchar(11) NOT NULL default '',
- `replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I',
- `test` varchar(512) NOT NULL default '',
- `title` varchar(75) NOT NULL default '',
- `status` varchar(9) NOT NULL default '',
- `startDate` date NOT NULL default '0000-00-00',
- `startTime` time NOT NULL default '00:00:00',
- `endDate` date NOT NULL default '0000-00-00',
- `endTime` time NOT NULL default '00:00:00',
- `duration` time NOT NULL default '00:00:00',
- `statusMessage` varchar(1024) NOT NULL default '',
- `step` smallint(6) NOT NULL default '0',
- `timeslot` varchar(10) NOT NULL default '',
- `instability` tinyint(1) NOT NULL default '9',
- `persistent` tinyint(1) NOT NULL default '9',
- `downtime` tinyint(1) NOT NULL default '9',
- `filename` varchar(254) default '',
- PRIMARY KEY (`catalogID`,`uKey`,`posTimeslot`),
- KEY `catalogID` (`catalogID`),
- KEY `uKey` (`uKey`),
- KEY `posTimeslot` (`posTimeslot`),
- KEY `replicationStatus` (`replicationStatus`),
- KEY `eventsDisplayData_ibfk_1` (`catalogID`,`uKey`),
- CONSTRAINT `eventsDisplayData_ibfk_1` FOREIGN KEY (`catalogID`,`uKey`) REFERENCES `plugins` (`catalogID`,`uKey`)
- ) ENGINE=InnoDB;
- NEW TRIGGER `eventsDisplayData` for MySQL: asnmtap-3.002.001_mysql-v5.0.x-trigger-eventsDisplayData.sql
Version 3.001.003, 2010/03/10, by Alex Peeters
- NEW applications/log4perl.cnf
- NEW CPAN module DBD::CSV & Text::CSV added to Makefile.PL
- NEW CPAN module Log::Dispatch, Log::Dispatch::FileRotate, Log::Log4perl & DBIx::Log4perl added to Makefile.PL
- tar -P -cvzf cpan-20100211.tgz /opt/monitoring/bin /opt/monitoring/lib /opt/monitoring/man
- NEW applications/log4perl.cnf config file for Log::Log4perl
- NEW integration for Cartography (applications/custom/cartography.pm-orig) into display.pl
ASNMTAP::Asnmtap::Plugins::Nagios
- NEW check_pargs.pl
ASNMTAP::Asnmtap::Pluggins::WebTransact.pm
- NEW option for check () keepAlive = [01]
ASNMTAP::Asnmtap::Applications::CGI.pm & archiver.pl
- DEPRECATED $SERVERMYSQLVERSION = '4.x'
- Applications.cnf
- NEW ERROR NOT DEFINED - contact server administrators
- PLUGIN '$msgCommand.pl' doesn't exist - contact administrators
- archive.pl collector.pl, importDataThroughCatalog.pl, generateReports.pl & holidayBundleSetDowntimes.pl
- NEW function LOG_init_log4perl
- collector.pl & importDataThroughCatalog.pl
- NEW functions DBI_connect, DBI_do and DBI_execute
- display.pl
- ADDED CLOSECLICK & STICKY to force users to click on "Close" to close sticky popups
- RSYNC
TODO --exclude=*-status.txt
Version 3.001.002, 2010/01/05, by Alex Peeters
- NEW record_navigation_bar_alpha
- change all record id > 0 for the 'auto_increment'
'1' into this example, verify first and if needed replace '1' with correct value
at 'displayGroups, holidaysBundle, reports & timeperiods'
holidaysBundle:
---------------
ALTER TABLE `plugins` CHANGE COLUMN `holidayBundleID` `holidayBundleID` int(11) default '1'
SET FOREIGN_KEY_CHECKS=0
UPDATE `holidaysBundle` SET `holidayBundleID` = '1' where `holidayBundleID` = '0'
UPDATE `plugins` SET `holidayBundleID` = '1' where `holidayBundleID` = '0'
SET FOREIGN_KEY_CHECKS=1
displayGroups:
--------------
ALTER TABLE `views` CHANGE COLUMN `displayGroupID` `displayGroupID` int(11) NOT NULL default '1'
UPDATE `views` SET `displayGroupID` = '1' where `displayGroupID` = '0'
UPDATE `displayGroups` SET `displayGroupID` = '1' where `displayGroupID` = '0'
- create new index
ALTER TABLE `catalog` ADD INDEX `catalogName` (`catalogName`)
ALTER TABLE `collectorDaemons` ADD INDEX `collectorDaemon` (`collectorDaemon`)
ALTER TABLE `countries` ADD INDEX `countryName` (`countryName`)
ALTER TABLE `displayDaemons` ADD INDEX `displayDaemon` (`displayDaemon`)
ALTER TABLE `displayGroups` ADD INDEX `groupTitle` (`groupTitle`)
ALTER TABLE `holidays` ADD INDEX `holiday` (`holiday`)
ALTER TABLE `holidaysBundle` ADD INDEX `holidayBundleName` (`holidayBundleName`)
ALTER TABLE `language` ADD INDEX `languageName` (`languageName`)
ALTER TABLE `pagedirs` ADD INDEX `pagedir` (`pagedir`)
ALTER TABLE `reports` ADD INDEX `reportTitle` (`reportTitle`)
ALTER TABLE `resultsdir` ADD INDEX `groupName` (`groupName`)
ALTER TABLE `servers` ADD INDEX `serverTitle` (`serverTitle`)
ALTER TABLE `timeperiods` ADD INDEX `timeperiodName` (`timeperiodName`)
ALTER TABLE `users` ADD INDEX `remoteUser` (`remoteUser`)
- NEW importDataThroughCatalog.sh and importDataThroughCatalog.pl
ALTER TABLE `displayGroups` DROP INDEX `displayGroupID`, ADD INDEX `displayGroupID` (`displayGroupID`)
ALTER TABLE `holidaysBundle` DROP INDEX `holidayBundleID`, ADD INDEX `holidayBundleID` (`holidayBundleID`)
ALTER TABLE `reports` DROP INDEX `id`, ADD INDEX `id` (`id`)
ALTER TABLE `timeperiods` DROP INDEX `timeperiodID`, ADD INDEX `timeperiodID` (`timeperiodID`)
- NEW asnmtap-importDataThroughCatalog.sh and root-importDataThroughCatalog.sh
- NEW integration for SDE (applications/custom/sde.pm-orig) into display.pl
- NEW catalog.pl
- UPDATE rsync 3.06 compatible
- UPDATE autogenerated rsync *.conf with --exclude *.sql
- UPDATE autogenerated 'Collector Start/Stop scripts' optimalisation
- UPDATE runStatusOnDemand.pl with follow up for importDataThroughCatalog.pid
- UPDATE optimalisation display.pl regarding encode html entities for the 'statusMessage'
- UPDATE archive.pl, check_SNMPTT_probe.pl, check_snmptt_traps.pl, check_jUnit.pl & snmptt_traps_remove_pending_and_duplicated.pl
'INSERT INTO' with 'REPLACE INTO' before 'DELETE'
Version 3.001.001, 2009/10/23, by Alex Peeters
- UPDATE /applications/tools/mysql/asnmtap-3.001.001-database-schema.png
- UPDATE TABLE `events` for MySQL
- MySQL 4.x
- SELECT CONCAT('alter table ', TABLE_SCHEMA , '.', table_name, ' MODIFY `test` varchar(254) NOT NULL default \'\';') FROM INFORMATION_SCHEMA.tables WHERE ENGINE = 'MYISAM' AND table_type='BASE TABLE' AND table_name...
- TO GENERATE THE NEXT CODE FOR ALL YEARS
- ALTER TABLE `events_yyyy_01` MODIFY `test` varchar(254) NOT NULL default '';
...
- ALTER TABLE `events_yyyy_12` MODIFY `test` varchar(254) NOT NULL default '';
- MySQL 5.0.x
- SELECT CONCAT('alter table ', TABLE_SCHEMA , '.', table_name, ' MODIFY `test` varchar(512) NOT NULL default \'\';') FROM INFORMATION_SCHEMA.tables WHERE ENGINE = 'MYISAM' AND table_type='BASE TABLE' AND table_name...
- TO GENERATE THE NEXT CODE FOR ALL YEARS
- ALTER TABLE `events_yyyy_01` MODIFY `test` varchar(512) NOT NULL default '';
...
- ALTER TABLE `events_yyyy_12` MODIFY `test` varchar(512) NOT NULL default '';
- MySQL 4.x & MySQL 5.0.x
- DROP TABLE `events_yyyy`;
- CREATE TABLE IF NOT EXISTS `events_yyyy` LIKE `events_yyyy_01`;
- ALTER TABLE `events_yyyy` ENGINE=MERGE UNION=(`events_yyyy_01`, `events_yyyy_02`, `events_yyyy_03`, `events_yyyy_04`, `events_yyyy_05`, `events_yyyy_06`, `events_yyyy_07`, `events_yyyy_08`, `events_yyyy_09`, `even...
- DROP TABLE `events_yyyy_Q1`;
- CREATE TABLE IF NOT EXISTS `events_yyyy_Q1` LIKE `events_yyyy_01`;
- ALTER TABLE `events_yyyy_Q1` ENGINE=MERGE UNION=(`events_yyyy_01`, `events_yyyy_02`, `events_yyyy_03`) INSERT_METHOD=LAST;
- DROP TABLE `events_yyyy_Q2`;
- CREATE TABLE IF NOT EXISTS `events_yyyy_Q2` LIKE `events_yyyy_04`;
- ALTER TABLE `events_yyyy_Q2` ENGINE=MERGE UNION=(`events_yyyy_04`, `events_yyyy_05`, `events_yyyy_06`) INSERT_METHOD=LAST;
- DROP TABLE `events_yyyy_Q3`;
- CREATE TABLE IF NOT EXISTS `events_yyyy_Q3` LIKE `events_yyyy_07`;
- ALTER TABLE `events_yyyy_Q3` ENGINE=MERGE UNION=(`events_yyyy_07`, `events_yyyy_08`, `events_yyyy_09`) INSERT_METHOD=LAST;
- DROP TABLE `events_yyyy_Q4`;
- CREATE TABLE IF NOT EXISTS `events_yyyy_Q4` LIKE `events_yyyy_10`;
- ALTER TABLE `events_yyyy_Q4` ENGINE=MERGE UNION=(`events_yyyy_10`, `events_yyyy_11`, `events_yyyy_12`) INSERT_METHOD=LAST;
- UPDATE generateConfig.pl for the autogeneration from: asnmtap-collector.sh
- when there are servers configurated in failover
- onto the active server: only the file 'Display-<pagedir>.sh' and 'Collector-<deamon>.sh' are included
- onto both servers: are both files 'CollectorCT-<deamon>.sh' included when <deamon> eq <hostname>
- UPDATE generateConfig.pl for the autogeneration from: rsync-wrapper-failover-<hostname>.sh & rsync-mirror-failover-<admin collector>.sh
Version 3.001.000, 2009/10/03, by Alex Peeters
- ASNMTAP: CATALOG databaseschema implementation
# `catalogID` =~ 'CID', aanpassen AUB
- UPDATE /applications/Applications.cfg
#<DATABASE>
...
# CATALOGID CID
#</DATABASE>
- UPDATE /applications/tools/mysql/asnmtap-3.001.000.sql
- UPDATE /applications/tools/mysql/asnmtap-3.001.000_mysql-v5.0.x.sql
- UPDATE /applications/tools/mysql/asnmtap-3.001.000-distributed.sql
- UPDATE /applications/tools/mysql/asnmtap-3.001.000-distributed_mysql-v5.0.x.sql
- insert into `holidaysBundle` (`holidayBundleID`,`holidayBundleName`,`holidayID`,`countryID`,`activated`) values (0,'ASNMTAP','/0-0-0-0-00/','BE',0);
- manualy update holidayBundleID to '?' for holidayBundleName = 'ASNMTAP' and holidayID = '/0-0-0-0-00/' !
where '?' is a not used holidayBundleID <> '0'
- NEW TABLE `catalog` for MySQL'
CREATE TABLE `catalog` (
`catalogID` varchar(5) NOT NULL default 'CID',
`catalogName` varchar(64) NOT NULL default '',
`catalogType` ENUM('central','federated','probe','distributed') NOT NULL DEFAULT 'probe',
( run in 0.635 second using v1.01-cache-2.11-cpan-df04353d9ac )