ASNMTAP
view release on metacpan or search on metacpan
- `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
#<DATABASE_ACCOUNT>
# <SERVER>
# VERSION 5.0.x # '5.0.x' or '5.1.x'
# ...
# </SERVER>
- Applications.pm
- init_email_report()
- ADDED select((select($EMAILREPORT), $| = 1)[0]); # autoflush
- archive.pl
- NEW function CSV_import_from_table
- collector.pl
- NEW function CSV_prepare_table
- NEW function CSV_insert_into_table
- NEW function CSV_cleanup_table
- NEW TIMING OUT SLOW PLUGIN
- 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
- 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 <script language="JavaScript..."> with <script language="JavaScript..." type="text/javascript">
- UPDATE Mozilla/5.0 compatible
- UPDATE CSE HTML Validator version 1.2.3 compatible
- UPDATE CSS Level 2.1 compatible
- UPDATE MySQL 5.0.x compatible
Makefile.PL
- version update Bundle::DBD::mysql 4.001
- version update CGI::Session 4.20
- version update Compress::Zlib 2.003
- version update Crypt::OpenSSL::X509 0.4
- version update Crypt::SSLeay 0.53
- version update Cwd 3.24
- version update DateTime 0.36
- version update Email::Simple 1.996
- NEW ExtUtils::Autoconf 0.02
- version update Getopt::Long 2.36
- version update IO::Socket::SSL 1.02
- version update Net::IMAP::Simple 1.16
- version update Time::HiRes 1.9704
- version update Time::Local 1.17
- version update WSRF::Lite 0.8.1
- version update XML::LibXML 1.62
MANIFEST
- NEW applications/sbin/bash_stop_root.sh
- UPDATE move plugins/check_file-counter.pl to plugins/templates/check_file-counter.pl
- UPDATE move plugins/check_sendAndReceiveMail.pl to plugins/templates/check_sendAndReceiveMail.pl
ATTENTION --> asnmtap-3.000.013.sql
- NEW table `timeperiods`
asnmtap-3.000.013-distributed.sql
- NEW example for distributed monitoring
- add `timeperiodID` int(11) NOT NULL default '1' at table reports
- add KEY `timeperiodID` (`timeperiodID`), at table reports
- add CONSTRAINT `reports_ibfk_2` FOREIGN KEY (`timeperiodID`) REFERENCES `timeperiods` (`timeperiodID`) at table reports
- UPDATE replace 'KEY `pagedir` (`pagedir`),' with 'UNIQUE KEY `pagedir` (`pagedir`),' at table displayDaemons
comments.pl
- FIX regarding 'Please re-enter entry date/time: Date/Time are into the future!'
- FIX regarding 'Please re-enter solved date/time: Date/Time are into the future!'
crontab verify disable email when ...
- By default cron jobs sends a email to the user account executing the cronjob.
Because this is not needed we put the following command At the end of the cron job line.
'> /dev/null (default)' or '> /dev/null 2>&1'
detailedStatisticsReportGenerationAndCompareResponsetimeTrends.pl, generateChart.pl & htmlToPdf.pl
- add my $timeperiodID = (defined $cgi->param('timeperiodID')) ? $cgi->param('timeperiodID') : 'none';
display.pl
- add -c, --creationTime=<YYYY-MM-DD HH:MM:SS>, YYYY-MM-DD HH:MM:SS: year, month, day, hours, minutes and seconds to use instead of the current time when --loop = F
- add sort results by status, group, comments and then by time
- FIX <\\/embed> added
- FIX stop caching sound during refresh when sound off
- FIX when downtime into the future, problem with the 'Condended View'
- UPDATE replace '$TcommentData =~ s/<br><br>/<br>/g;' with '$TcommentData =~ s/(?:<br>)+/<br>/g;'
display.pl and plugins.pl
- FIX interval/step must be greather then 0!
getArchivedDisplays.pl
- NEW Archived Displays
generateConfig.pl
- FIX all SQL select statements regarding *.activated = 1 and add when needed
- added print text to fix rights regarding chmod 755 for new CollectorCT-.*sh or DisplayCT-.*sh script
- added edit, delete, duplicate and maintenance button for 'Plugin' and 'Help Plugin Filename'
holidayBundleSetDowntimes.pl
- FIX Global symbol "$SERVERTABLENVIRONMENT" requires explicit package name at ./holidayBundleSetDowntimes.pl line 152.
plugins.pl
- making it possible to edit 'Help Plugin Filename' manual or by uploading and to clear with '<NIHIL>'
runStatusOnDemand.pl
- UPDATE doRequestedActions: added -o 'StrictHostKeyChecking=no' -o 'UserKnownHostsFile=$WWWKEYPATH/.ssh/known_hosts'
rsync-wrapper-*.sh
- UPDATE advanced debug information
- UPDATE making rsync version 2.6.7
/applications/bin/
- UPDATE generateCollectorDaemonSchedulingReports.sh
- UPDATE generateReports.sh
- UPDATE holidayBundleSetDowntimes.sh
/applications/sbin/
- NEW bash_stop_root.sh
- UPDATE perfparse_crontab.sh
/plugins/templates/
- UPDATE check_MySQL-database-replication.pl
ASNMTAP::Asnmtap
- replace '#!/usr/bin perl' with '#!/usr/local/bin/perl'
ASNMTAP::Asnmtap::Applications
- FIX <\\/embed> added
- FIX verify empty cgisess file at get_session_param () used by archive.pl
- added Birthday, Firework, Halloween, Snowflake, Valentine, ... for view '/asnmtap/nav/index' or '/asnmtap/nav/test'
NEW applications/htmlroot/JSFX_Browser.js
NEW applications/htmlroot/JSFX_Falling.js
NEW applications/htmlroot/JSFX_Fireworks.js
NEW applications/htmlroot/JSFX_Fireworks2.js
NEW applications/htmlroot/JSFX_Halloween.js
NEW applications/htmlroot/JSFX_Layer.js
ASNMTAP::Asnmtap::Applications::CGI
- NEW timeperiods.pl
ASNMTAP::Asnmtap::Plugins and ASNMTAP::Asnmtap::Plugins::WebTransact
- FIX debug information must be into the debug file '*.html' or '*.html-KnownError' but never into both
- added info regarding keep_alive and SSL session resume
- added do not proxy requests to the given domains. Calling no_proxy without any domains clears the list of domains.
ASNMTAP::Asnmtap::Plugins::Nagios
- NEW check_fs-stat.pl
ASNMTAP::Asnmtap::Plugins::SOAP
- add TYPE_ERROR_RETURN
ASNMTAP::Asnmtap::Plugins::WebTransact & runCmdOnDemand.pl
- ADDED remove password from Basic Authentication URL before putting into database!
Version 3.000.012, 2006/12/20, Central and Distributed support
- added common variable TYPEMONITORING to Asnmtap.cnf
fixRights.sh
- updated: script om rechten (chmod en chown) te zetten
Makefile.PL
- version update CPAN 1.8802 & CPANPLUS 0.076
- version update ExtUtils::MakeMaker 6.31
- version update Module::AutoInstall 1.03
- version update Bundle::DBI 1.53
- version update CGI 3.25
- version update Compress::Zlib 2.003
- version update Config::General 2.31
- version update Config::General::Interpolated 2.07
- version update Crypt::OpenSSL::RSA 0.24
- version update Cwd 3.23
- version update Data::Dumper 2.121
- version update DateTime 0.35
- version update DateTime::Format::W3CDTF 0.04
- version update Device::Modem 1.47
- version update Digest::MD5 2.36
- version update Email::Simple 1.995
- version update Getopt::Long 2.35
- version update IO 1.23
- NEW IO::Socket::SSL 1.01
- version update MIME::Tools 5.420
- version update NetAddr::IP 4.004
- version update Net::FTP 2.75
- version update Net::Ifconfig::Wrapper 0.09
- NEW Net::SSLeay 1.30
- version update Proc::ProcessTable 0.41
- version update Sys::Hostname::Long 1.4
- NEW Test::Pod::Coverage 1.08
- version update Test::Simple 0.47
- version update Time::HiRes 1.94
- version update Time::Local 1.13
- version update XML::LibXML 1.61
- version update XML::Simple 2.16
- install 'ASNMTAP' with make install
PM - This hash will contain a list of all ASNMTAP files
ASNMTAP::Asnmtap::Plugins
- FIX replace: _programGetOptions => [..., 'password|passwd|p=s', ...],
with : _programGetOptions => [..., 'password|p|passwd=s', ...],
- FIX replace: push ( @{ $_[0]->{_programGetOptions} }, 'status|S:s', 'asnmtapEnv|A:s', 'onDemand|O:s', 'logging|L:s', 'debugfile|dumphttp|httpdump|D:s', 'debug|d:s' );
with : push ( @{ $_[0]->{_programGetOptions} }, 'status|S:s', 'asnmtapEnv|A:s', 'onDemand|O:s', 'logging|L:s', 'debugfile|D|dumphttp|httpdump:s', 'debug|d:s' );
- check_memory-top.pl, now also Solaris 10 compatible
- FIX '<environment>PROD</environment>' into check_template-mail-xml.pl & check_template-mail-xml-fingerprint-xml.pl
- replaced 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; ASNMTAP; U;' with 'Mozilla/4.7 (compatible; ASNMTAP; U;'
- NEW $ENV{HTTPS_VERSION} for v2, v3 and v23
ASNMTAP::Asnmtap::Plugins::Nagios
- NEW check_nagios-comments-cleanup.pl
- NEW EPN (Embedded Perl Nagios) compatible
ASNMTAP::Asnmtap::Plugins::NPTest
- upgrade van version NPTest v1.11 to v1.13
- replace NPTest->testCmd with ASNMTAP::Asnmtap::Plugins::NPTest->testCmd
ASNMTAP::Asnmtap::Plugins::SOAP
- add $SOAP::Constants::PATCH_HTTP_KEEPALIVE
- add ws-security through WSRF::Lite
ASNMTAP::Asnmtap::Plugins::WebTransact
- based on 'Nagios::WebTransact' v0.14.1 & v0.16 from Stanley Hopcroft [Stanley.Hopcroft@IPAustralia.Gov.AU]
ATTENTION --> asnmtap-3.000.012.sql
- NEW table `environment`
- add `userPassword` varchar(15) NOT NULL default '' at table reports
- remove `reportTitle` varchar(100) NOT NULL default '' from table reports
- add `downtimeScheduling` tinyint(1) NOT NULL default '1' and `generatedReports` tinyint(1) NOT NULL default '0' at table users
FIX Popup Calendar
- replace document.forms[0].endDate with document.forms[1].endDate
collector.pl
- add automatically the environment at the end off the title
collector.pl & display.pl
- update atime and mtime from the PID file every timeslot
- email message for started, stopped & reloaded
collectorCrontabSchedulingReports.pl & collectorDaemonSchedulingReports.pl
- show only the Plugins regarding correspondending server
comments.pl & holidayBundleSetDowntimes.pl
- Sending email for: Downtime Scheduling
detailedStatisticsReportGenerationAndCompareResponsetimeTrends.pl
- Problem details: link to the correspondending 'Debug Report' when 'Format Output' equals 'HTML'
detailedStatisticsReportGenerationAndCompareResponsetimeTrends.pl, generateChart.pl & trendlineCorrectionReports.pl
- replace round(avg(duration), 2) with round(avg(time_to_sec(duration)), 2) because of wrong averages
display.pl
- possibility for sound on/off
- onderdrukking ledige groepen in full view
- vermelden op welke probe een test wordt uitgevoerd
- onderdrukken niet persistent downtimes in condenced view
- mask password for '--dnPass=', used by check_template-ldap.pl
- environment icons, exclaim popup window for plugins and comments
- 'In Progress'-animated icon replaced with 'In Progress'-static icon for faster display!
- de debugrapporten onderaan de view enkel aanklikbaar maken als de file via rsync al aanwezig is op het moment van de display generatie, ter voorkoming van 404 errors.
- add console messages: 'No Monitored Applications', 'All Monitored Applications are OK', '..., probably collector/config problems!' & , '..., probably database problems!'
displayDaemons.pl
- add 'ServerID' into general view
detailedStatisticsReportGenerationAndCompareResponsetimeTrends.pl
- add a checkbox, to choose output destination: HTML/PDF
getArchivedReport.pl & getArchivedResults.pl
- YYYY/MM/DD notatie met voorloopnullen voor maand en dag
generateConfig.pl
- check for 'help plugin filenames' without plugin reference
- check for plugins without or with missing 'help plugin filename'
- looking after existing plugins that are not defined into the database plugins
- verify that the defined plugins into the table plugins, exists and are executable
- generate automatic the Rsync Mirror Distributed & Failover Scripts / Collector Daemon
generateReports.pl
ATTENTION --> - tested with HTMLDOC v1.8.27 and added --user-password password support
- een plugin die disabled is waarvoor een rapport gevraagd wordt niet uitvoeren
- specify F for --daysAfter means that the specified date will be used as the reportdate
generateReports.pl & generateCollectorDaemonSchedulingReports.pl
- ... already generated / will be generated
- ... generated / generation failed
generatedReports.pl, plugins & reports.pl
- remove 'reportTitle'
get_ArchivedReport.pl & get_ArchivedResults.pl
- replace 'Week #' with 'Week # from monday off week until sunday off week'
plugins.pl
- upload for Help Plugin Filename (PDF)
- controle op '{}' bij ingeven van de value voor het veld 'Title:'
pluginCrontabSchedulingReports.pl
- show only the Plugins regarding correspondending server
removeModulePerl.pl
- NEW
rsync-mirror-*.sh
- replace: rsync -e "ssh -i $KeyRsync" -a $Delete $AdditionalParams $Source $Target
with: ssh=<sshpath>; $Rsync -e "$ssh -i $KeyRsync" -a $Delete $AdditionalParams $Source $Target
runCmdOnDemand.pl
- mask password for '--dnPass=', used by check_template-ldap.pl
runStatusOnDemand.pl
- FIX 'Command: not found.' must be 'No Display|Collector daemons defined'
trendlineCorrectionReports.pl
- show only the Plugins regarding correspondending server and order by Title
user.pl
- Sending email for: Downtime Scheduling & Generated Reports
Version 3.000.011, 2006/09/16, ASNMTAP::Asnmtap::Applications
- add `environment` char(1) NOT NULL default 'L' to TABLE `plugins`
display.pl, plugins.pl & generateConfig.pl
- add environment
collector.pl
- add $perfParseMethode
- NEW perfparse_asnmtap_pulp_command.pl
- NEW perfparse_crontab.sh
generateConfig.pl
- FIX added activated = 1 to all sql queries
Makefile.pl
- update SOAP::Lite to version 0.69
- update MIME::Base64 to version 3.07
ASNMTAP::Asnmtap::Plugins::SOAP
- FIX replaced 'defined $som->fault' with 'defined $som and defined $som->fault'
ASNMTAP::Asnmtap::Plugins::Nagios
- NEW check_iowait.pl
- NEW check_snmptt_traps.pl
Version 3.000.010, 2006/07/15, Trendline Correction Reports (for the Collector)
- add /cgi-bin/moderator/trendlineCorrectionReports.pl
Application.pod
- using CPAN with a non-root account for ASNMTAP
- install procedure updated for Linux and Solaris
- perl cpan module version and install procedure updates
archiver.pl
- FIX regarding debug mode and wrong use of EMAILREPORT
( run in 1.086 second using v1.01-cache-2.11-cpan-39bf76dae61 )