ASNMTAP
view release on metacpan or search on metacpan
- 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
- 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`)
- 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`;
- 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',
`databaseFQDN` varchar(64) NOT NULL default 'localhost',
`databasePort` varchar(4) NOT NULL default '3306',
`lastEventsID` int(11) NOT NULL default '0',
`lastCommentsID` int(11) NOT NULL default '0',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`)
) ENGINE=InnoDB;
- insert into `catalog` (`catalogID`,`catalogName`,`catalogType`,`databaseFQDN`,`databasePort`,`lastEventsID`,`lastCommentsID`,`activated`) values ('CID','Central System Enterprise','central','localhost','3306',0,...
- UPDATE TABLE `servers` for MySQL'
- ALTER TABLE `servers` ADD COLUMN `typeActiveServer` char(1) NOT NULL DEFAULT 'M' AFTER `typeMonitoring`;
# ------------------------------------
- ALTER TABLE `collectorDaemons` DROP FOREIGN KEY `collectorDaemons_ibfk_2`;
- ALTER TABLE `reports` DROP FOREIGN KEY `reports_ibfk_1`;
- ALTER TABLE `reports` DROP FOREIGN KEY `reports_ibfk_2`;
- ALTER TABLE `users` DROP FOREIGN KEY `users_ibfk_1`;
- ALTER TABLE `views` DROP FOREIGN KEY `views_ibfk_1`;
- ALTER TABLE `views` DROP FOREIGN KEY `views_ibfk_2`;
- ALTER TABLE `views` DROP FOREIGN KEY `views_ibfk_3`;
# ------------------------------------
- ALTER TABLE `collectorDaemons` DROP PRIMARY KEY;
- ALTER TABLE `collectorDaemons` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `collectorDaemons` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `collectorDaemons` ADD PRIMARY KEY (`catalogID`,`collectorDaemon`);
- ALTER TABLE `comments` ADD UNIQUE KEY `id` (`id`);
- ALTER TABLE `comments` DROP PRIMARY KEY;
- ALTER TABLE `comments` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `comments` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `comments` ADD PRIMARY KEY (`catalogID`,`id`);
- ALTER TABLE `comments` ADD COLUMN `replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I' AFTER `uKey`;
- ALTER TABLE `comments` ADD INDEX `replicationStatus` (`replicationStatus`);
- ALTER TABLE `comments_yyyy` ADD UNIQUE KEY `id` (`id`);
- ALTER TABLE `comments_yyyy` DROP PRIMARY KEY;
- ALTER TABLE `comments_yyyy` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `comments_yyyy` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `comments_yyyy` ADD PRIMARY KEY (`catalogID`,`id`);
- ALTER TABLE `comments_yyyy` ADD COLUMN `replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I' AFTER `uKey`;
- ALTER TABLE `comments_yyyy` ADD INDEX `replicationStatus` (`replicationStatus`);
- ALTER TABLE `crontabs` DROP PRIMARY KEY;
- ALTER TABLE `crontabs` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `crontabs` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `crontabs` ADD PRIMARY KEY (`catalogID`,`lineNumber`,`uKey`);
- ALTER TABLE `displayDaemons` DROP PRIMARY KEY;
- ALTER TABLE `displayDaemons` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `displayDaemons` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `displayDaemons` ADD PRIMARY KEY (`catalogID`,`displayDaemon`);
- ALTER TABLE `displayDaemons` DROP KEY `pagedir`;
- ALTER TABLE `displayDaemons` ADD UNIQUE KEY `pagedir` (`catalogID`,`pagedir`);
- ALTER TABLE `displayGroups` ADD UNIQUE KEY `displayGroupID` (`displayGroupID`);
- ALTER TABLE `displayGroups` DROP PRIMARY KEY;
- ALTER TABLE `displayGroups` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `displayGroups` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `displayGroups` ADD PRIMARY KEY (`catalogID`,`displayGroupID`);
- ALTER TABLE `eventsChangesLogData` DROP PRIMARY KEY;
- ALTER TABLE `eventsChangesLogData` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `eventsChangesLogData` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `eventsChangesLogData` ADD INDEX `uKey` (`uKey`);
- ALTER TABLE `eventsChangesLogData` ADD PRIMARY KEY (`catalogID`,`uKey`);
- ALTER TABLE `eventsChangesLogData` ADD COLUMN `replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I' AFTER `uKey`;
- ALTER TABLE `eventsChangesLogData` ADD INDEX `replicationStatus` (`replicationStatus`);
- ALTER TABLE `holidays` DROP PRIMARY KEY;
- ALTER TABLE `holidays` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `holidays` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `holidays` ADD PRIMARY KEY (`catalogID`,`holidayID`);
- ALTER TABLE `holidaysBundle` ADD UNIQUE KEY `holidayBundleID` (`holidayBundleID`);
- ALTER TABLE `holidaysBundle` DROP PRIMARY KEY;
- ALTER TABLE `holidaysBundle` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `holidaysBundle` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `holidaysBundle` ADD PRIMARY KEY (`catalogID`,`holidayBundleID`);
- ALTER TABLE `pagedirs` DROP PRIMARY KEY;
- ALTER TABLE `pagedirs` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `pagedirs` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `pagedirs` ADD PRIMARY KEY (`catalogID`,`pagedir`);
- ALTER TABLE `plugins` DROP PRIMARY KEY;
- ALTER TABLE `plugins` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `plugins` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `plugins` ADD INDEX `uKey` (`uKey`);
- ALTER TABLE `plugins` ADD PRIMARY KEY (`catalogID`,`uKey`);
- ALTER TABLE `reports` ADD UNIQUE KEY `id` (`id`);
- ALTER TABLE `reports` DROP PRIMARY KEY;
- ALTER TABLE `reports` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `reports` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `reports` ADD PRIMARY KEY (`catalogID`,`id`);
- ALTER TABLE `reports_perfdata` DROP PRIMARY KEY;
- ALTER TABLE `reports_perfdata` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `reports_perfdata` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `reports_perfdata` ADD PRIMARY KEY (`catalogID`,`uKey`,`metric_id`);
- ALTER TABLE `resultsdir` DROP PRIMARY KEY;
- ALTER TABLE `resultsdir` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `resultsdir` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `resultsdir` ADD PRIMARY KEY (`catalogID`,`resultsdir`);
- ALTER TABLE `servers` DROP PRIMARY KEY;
- ALTER TABLE `servers` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `servers` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `servers` ADD PRIMARY KEY (`catalogID`,`serverID`);
- ALTER TABLE `timeperiods` ADD UNIQUE KEY `timeperiodID` (`timeperiodID`);
- ALTER TABLE `timeperiods` DROP PRIMARY KEY;
- ALTER TABLE `timeperiods` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `timeperiods` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `timeperiods` ADD PRIMARY KEY (`catalogID`,`timeperiodID`);
- ALTER TABLE `users` DROP PRIMARY KEY;
- ALTER TABLE `users` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `users` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `users` ADD PRIMARY KEY (`catalogID`,`remoteUser`);
- ALTER TABLE `views` DROP PRIMARY KEY;
- ALTER TABLE `views` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `views` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `views` ADD PRIMARY KEY (`catalogID`,`uKey`,`displayDaemon`);
# ------------------------------------
- ALTER TABLE `collectorDaemons` ADD CONSTRAINT `collectorDaemons_ibfk_1` FOREIGN KEY (`catalogID`,`serverID`) REFERENCES `servers` (`catalogID`,`serverID`);
- ALTER TABLE `comments` ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`catalogID`,`uKey`) REFERENCES `plugins` (`catalogID`,`uKey`);
- ALTER TABLE `comments` ADD CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`catalogID`,`remoteUser`) REFERENCES `users` (`catalogID`,`remoteUser`);
- ALTER TABLE `crontabs` ADD CONSTRAINT `crontabs_ibfk_1` FOREIGN KEY (`catalogID`,`collectorDaemon`) REFERENCES `collectorDaemons` (`catalogID`,`collectorDaemon`);
- ALTER TABLE `crontabs` ADD CONSTRAINT `crontabs_ibfk_2` FOREIGN KEY (`catalogID`,`uKey`) REFERENCES `plugins` (`catalogID`,`uKey`);
- ALTER TABLE `views` ADD CONSTRAINT `views_ibfk_1` FOREIGN KEY (`catalogID`,`displayDaemon`) REFERENCES `displayDaemons` (`catalogID`,`displayDaemon`);
- ALTER TABLE `views` ADD CONSTRAINT `views_ibfk_2` FOREIGN KEY (`catalogID`,`displayGroupID`) REFERENCES `displayGroups` (`catalogID`,`displayGroupID`);
- ALTER TABLE `views` ADD CONSTRAINT `views_ibfk_3` FOREIGN KEY (`catalogID`,`uKey`) REFERENCES `plugins` (`catalogID`,`uKey`);
# ------------------------------------
# START HIGH IMPACT !
# ------------------------------------
- ALTER TABLE `events` ADD UNIQUE KEY `id` (`id`);
- ALTER TABLE `events` DROP PRIMARY KEY;
- ALTER TABLE `events` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `events` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `events` ADD PRIMARY KEY (`catalogID`,`id`);
- ALTER TABLE `events` ADD COLUMN `replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I' AFTER `uKey`;
- ALTER TABLE `events` ADD INDEX `replicationStatus` (`replicationStatus`);
- ALTER TABLE `events` ADD INDEX `events_ibfk_1` (`catalogID`,`uKey`);
- ALTER TABLE `events` ADD CONSTRAINT `events_ibfk_2` FOREIGN KEY (`catalogID`,`uKey`) REFERENCES `plugins` (`catalogID`,`uKey`);
# ------------------------------------
# END HIGH IMPACT !
# ------------------------------------
- SELECT CONCAT('alter table ', TABLE_SCHEMA , '.', table_name, ' ADD UNIQUE INDEX `id` (`id`), DROP PRIMARY KEY, ADD COLUMN `catalogID` varchar(5) NOT NULL default \'CID\' FIRST, ADD INDEX `catalogID` (`catalogID`)...
- TO GENERATE THE NEXT CODE FOR ALL YEARS
- ALTER TABLE `events_yyyy_01` ADD UNIQUE INDEX `id` (`id`);
- ALTER TABLE `events_yyyy_01` DROP PRIMARY KEY;
- ALTER TABLE `events_yyyy_01` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `events_yyyy_01` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `events_yyyy_01` ADD COLUMN `replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I' AFTER `uKey`;
- ALTER TABLE `events_yyyy_01` ADD INDEX `replicationStatus` (`replicationStatus`);
- ALTER TABLE `events_yyyy_01` ADD PRIMARY KEY (`catalogID`,`id`);
- ALTER TABLE `events_yyyy_01` ADD INDEX `events_ibfk_1` (`catalogID`,`uKey`);
...
- ALTER TABLE `events_yyyy_12` ADD UNIQUE INDEX `id` (`id`);
- ALTER TABLE `events_yyyy_12` DROP PRIMARY KEY;
- ALTER TABLE `events_yyyy_12` ADD COLUMN `catalogID` varchar(5) NOT NULL default 'CID' FIRST;
- ALTER TABLE `events_yyyy_12` ADD INDEX `catalogID` (`catalogID`);
- ALTER TABLE `events_yyyy_12` ADD COLUMN `replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I' AFTER `uKey`;
- ALTER TABLE `events_yyyy_12` ADD INDEX `replicationStatus` (`replicationStatus`);
- ALTER TABLE `events_yyyy_12` ADD PRIMARY KEY (`catalogID`,`id`);
- ALTER TABLE `events_yyyy_12` ADD INDEX `events_ibfk_1` (`catalogID`,`uKey`);
- 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...
- UPDATE /plugins/templates/snmptt/
- NEW check_SNMPTT_oracle.pl
- NEW snmptt-oracle.conf
- NEW %ICONSUNSTABLE = ('OK'=>'green-unstable.gif','WARNING'=>'yellow-unstable.gif','CRITICAL'=>'red-unstable.gif','UNKNOWN'=>'clear-unstable.gif','DEPENDENT'=>'','OFFLINE'=>'blue-unstable.gif','NO DATA'=>'purple-unst...
- UPDATE /applications/tools/mysql/asnmtap-3.000.020.sql
- UPDATE /applications/tools/mysql/asnmtap-3.000.020_mysql-v5.0.x.sql
- UPDATE /applications/tools/mysql/asnmtap-3.000.020-distributed.sql
- UPDATE /applications/tools/mysql/asnmtap-3.000.020-distributed_mysql-v5.0.x.sql
- NEW TABLE `eventsChangesLogData` for MySQL'
CREATE TABLE `eventsChangesLogData` (
`uKey` varchar(11) NOT NULL default '',
`lastStatus` varchar(9) NOT NULL default '',
`lastTimeslot` varchar(10) NOT NULL default '',
`prevStatus` varchar(9) NOT NULL default '',
`prevTimeslot` varchar(10) NOT NULL default '',
PRIMARY KEY (`uKey`)
) ENGINE=InnoDB;
- UPDATE create_weblogic_configuration_database_with_SNMP-3.000.020.SQL
- UPDATE create_weblogic_configuration_database_with_SNMP-3.000.020_mysql-v5.0.x.SQL
- NEW TABLE `QUEUES` for MySQL'
CREATE TABLE `QUEUES` (
`QUEUE_NAME` varchar(64) NOT NULL default '',
`QUEUE_OID` varchar(254) default NULL,
`ENV` varchar(4) default NULL,
`ACTIVATED` tinyint(1) unsigned default '1',
`CURRENT_TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`VIRTUAL_CLUSTER_ID` int(11) unsigned NOT NULL default '0',
`UKEY` varchar(11) default NULL,
PRIMARY KEY (`QUEUE_OID`,`QUEUE_NAME`),
KEY `VIRTUAL_CLUSTER_ID` (`VIRTUAL_CLUSTER_ID`),
KEY `QUEUE_NAME` (`QUEUE_NAME`),
KEY `UKEY` (`UKEY`)
) ENGINE=MyISAM
- UPDATE /applications/Applications.cfg
#<TABLES>
...
# EVENTSCHANGESLOGDATA eventsChangesLogData
...
- /cgi-bin/runCmdOnDemand.pl
On Demand test now launched on the same probe as the collector that runs the test
- check_MySQL-database-replication.pl
- Added Slave IO detection
- /plugins/junit, making weblogic 10 compatible
- UPDATE check_jUnit.pl
- UPDATE create_ASNMTAP_jUnit_configuration_for_jUnit.pl
- UPDATE create_ASNMTAP_jUnit_configuration_for_jUnit-3.000.019_mysql.SQL
- UPDATE create_ASNMTAP_jUnit_configuration_for_jUnit-3.000.019_mysql-v5.0.x.SQL
- UPDATE TABLE `BASE_SERVICES` for 'MySQL'
- ALTER TABLE `BASE_SERVICES` CHANGE COLUMN `STATUS` `STATUS` enum('ASNMTAP','NEW','MAINTENANCE','EOL') NOT NULL default 'NEW';
- UPDATE TABLE `SERVER` for 'MySQL'
- ALTER TABLE `SERVER` ADD COLUMN `WEBLOGIC_VERSION` enum('8','10') default '10' AFTER `ENV`;
- /plugins/snmptt
- UPDATE snmptt-3.000.019.sql
- UPDATE snmptt-3.000.019-v5.0.x.sql
- UPDATE TABLE `snmptt` for MySQL'
- ALTER TABLE `snmptt` ADD COLUMN `archivetime` timestamp(14) NOT NULL AFTER `uniqueProblem`;
- UPDATE TABLE `snmptt_unknown` for MySQL'
- ALTER TABLE `snmptt_unknown` ADD COLUMN `archivetime` timestamp(14) NOT NULL AFTER `trapread`;
- UPDATE TABLE `snmptt_unknown_archive` for MySQL'
- ALTER TABLE `snmptt_unknown_archive` ADD COLUMN `archivetime` timestamp(14) NOT NULL AFTER `trapread`;
- UPDATE TABLE `snmptt_archive` for MySQL'
- ALTER TABLE `snmptt_archive` ADD COLUMN `archivetime` timestamp(14) NOT NULL AFTER `uniqueProblem`;
- added comment type 'masterASNMTAP_PATH' & 'slaveASNMTAP_PATH' to servers.pl
- UPDATE /applications/tools/mysql/asnmtap-3.000.019.sql
- UPDATE /applications/tools/mysql/asnmtap-3.000.019_mysql-v5.0.x.sql
- UPDATE /applications/tools/mysql/asnmtap-3.000.019-distributed.sql
- UPDATE /applications/tools/mysql/asnmtap-3.000.019-distributed_mysql-v5.0.x.sql
- UPDATE TABLE `servers` for MySQL'
- ALTER TABLE `servers` ADD COLUMN `masterASNMTAP_PATH` varchar(64) NOT NULL default '/opt/asnmtap' AFTER `masterFQDN`, ADD COLUMN `slaveASNMTAP_PATH` varchar(64) NOT NULL default '/opt/asnmtap' AFTER `slaveFQDN`;
- ALTER TABLE `servers` ADD COLUMN `masterSSH_PATH` varchar(64) NOT NULL default '/usr/bin' AFTER `masterASNMTAP_PATH`, ADD COLUMN `slaveSSH_PATH` varchar(64) NOT NULL default '/usr/bin' AFTER `slaveASNMTAP_PATH`;
- ALTER TABLE `servers` ADD COLUMN `masterRSYNC_PATH` varchar(64) NOT NULL default '/usr/local/bin' AFTER `masterASNMTAP_PATH`, ADD COLUMN `slaveRSYNC_PATH` varchar(64) NOT NULL default '/usr/local/bin' AFTER `slave...
- added comment type 'instability' to archiver.pl, display.pl, collector.pl, comments.pl & detailedStatisticsReportGenerationAndCompareResponsetimeTrends.pl
- UPDATE /applications/tools/mysql/asnmtap-3.000.019.sql
- UPDATE /applications/tools/mysql/asnmtap-3.000.019_mysql-v5.0.x.sql
- UPDATE /applications/tools/mysql/asnmtap-3.000.019-distributed.sql
- UPDATE /applications/tools/mysql/asnmtap-3.000.019-distributed_mysql-v5.0.x.sql
- UPDATE TABLE `events`, `events_yyyy_mm` & `events_Qx` for MySQL'
- ALTER TABLE `events` ADD COLUMN `instability` tinyint(1) NOT NULL default '9' AFTER `timeslot`;
- ALTER TABLE `events_2008_01` ADD COLUMN `instability` tinyint(1) NOT NULL default '9' AFTER `timeslot`;
...
- ALTER TABLE `events_2008_12` ADD COLUMN `instability` tinyint(1) NOT NULL default '9' AFTER `timeslot`;
- DROP TABLE `events_2008`;
- CREATE TABLE IF NOT EXISTS `events_2008` LIKE `events_2008_01`;
- ALTER TABLE `events_2008` ENGINE=MERGE UNION=(`events_2008_01`, `events_2008_02`, `events_2008_03`, `events_2008_04`, `events_2008_05`, `events_2008_06`, `events_2008_07`, `events_2008_08`, `events_2008_09`, `even...
- DROP TABLE `events_2008_Q1`;
- CREATE TABLE IF NOT EXISTS `events_2008_Q1` LIKE `events_2008_01`;
- ALTER TABLE `events_2008_Q1` ENGINE=MERGE UNION=(`events_2008_01`, `events_2008_02`, `events_2008_03`) INSERT_METHOD=LAST;
- DROP TABLE `events_2008_Q2`;
- ALTER TABLE `events_2008_Q2` ENGINE=MERGE UNION=(`events_2008_04`, `events_2008_05`, `events_2008_06`) INSERT_METHOD=LAST;
- DROP TABLE `events_2008_Q3`;
- CREATE TABLE IF NOT EXISTS `events_2008_Q3` LIKE `events_2008_07`;
- ALTER TABLE `events_2008_Q3` ENGINE=MERGE UNION=(`events_2008_07`, `events_2008_08`, `events_2008_09`) INSERT_METHOD=LAST;
- DROP TABLE `events_2008_Q4`;
- CREATE TABLE IF NOT EXISTS `events_2008_Q4` LIKE `events_2008_10`;
- ALTER TABLE `events_2008_Q4` ENGINE=MERGE UNION=(`events_2008_10`, `events_2008_11`, `events_2008_12`) INSERT_METHOD=LAST;
- ALTER TABLE `comments` ADD COLUMN `instability` tinyint(1) NOT NULL default '0' AFTER `remoteUser`;
- ALTER TABLE `comments_2008` ADD COLUMN `instability` tinyint(1) NOT NULL default '0' AFTER `remoteUser`;
- SNMPTT making Weblogic 10 compatible:
- /plugins/snmptt/
- FIX create_ASNMTAP_weblogic_configuration_for_SNMP.pl: my $pluginTest = 'check_SNMPTT_weblogic.pl';
- UPDATE create_ASNMTAP_weblogic_configuration_for_SNMP.pl
- UPDATE create_NCPL_weblogic_configuration_for_SNMP.pl
- UPDATE create_weblogic_configuration_database_with_SNMP.pl
- UPDATE create_weblogic_configuration_for_SNMPTT.pl
- /plugins/templates/snmptt/
- UPDATE check_SNMPTT_weblogic.pl
- UPDATE snmptt-bea-weblogic.conf
- check_memory-free.pl
- UPDATE: making Blastwave compatible
ASNMTAP::Asnmtap::Plugins::Mail.pm
- FIX regarding MIME-Encoding '7bit' into MIME-tools-5.425
ASNMTAP::Asnmtap::Plugins::Nagios
- NEW check_nagiosv3-comments-cleanup.pl
ASNMTAP::Asnmtap::Plugins::Webtransact.pm
- NEW triesTiming & triesCodes
ATTENTION --> asnmtap-3.000.017.sql, asnmtap-3.000.017-distributed.sql,
asnmtap-3.000.017_mysql-v5.0.x.sql & asnmtap-3.000.017-distributed_mysql-v5.0.x.sql
- add `reportTitle` varchar(100) NOT NULL default '' to table reports
apache config
- UPDATE: replace 'ScriptAlias /cgi-bin/ ...' with 'ScriptAlias /asnmtap/cgi-bin/ ...'
Version 3.000.016, 2008/02/13, 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
- /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 COL...
- 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]'
- 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.20...
- 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.20...
- 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
<COMMON>
...
# <CHARTDIRECTOR>
# LIB /opt/ChartDirector/lib/.
- 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
Applications.cnf
#<DATABASE_ACCOUNT>
# <SERVER>
# VERSION 4.x # '4.x' or '5.0.x'
# MERGE 0 # '0' or '1'
# </SERVER>
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
- 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
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
- 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
ASNMTAP::Asnmtap::Plugins
- replaced 'Mozilla/5.0 (compatible; MSIE 6.0;' with 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1;'
De XP-versie als 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)'
De plusversie kan worden herkend als 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0)'
asnmtap-3.000.010.sql
CREATE TABLE `plugins` (
...
`trendline` smallint(6) NOT NULL default '0',
+ `percentage` tinyint(1) NOT NULL default '25',
+ `tolerance` tinyint(1) NOT NULL default '5',
`step` smallint(6) NOT NULL default '0',
...
Version 3.000.009, 2006/06/01, ASNMTAP::Asnmtap::Plugins::WebTransact
- RFC 1738 optimalisations
- add '500 SSL negotiation failed'
- add Perfdata_Label => 'IMAGE URL' to _download_images()
ASNMTAP::Asnmtap::Applications
- email SUBJECT changed to Display/Collector for the 'Application Monitoring'@HOSTNAME: ...
NPTest, v1.11
Information about the integration from ASNMTAP with HTMLDOC and Perfparse can be found at:
- man ASNMTAP::Asnmtap::Applications
./fixRights.sh
-------------------------------------------------------------------------
How do I install a ASNMTAP module into my home directory?
If you're not the Perl administrator you probably don't have permission to install a module to its default location.
Then you should install it for your own use into your home directory like so:
perl Makefile.PL INSTALL_BASE=~
-------------------------------------------------------------------------
Makefile.PL view on Meta::CPAN
Asnmtap/Plugins/Modem
Asnmtap/Plugins/Nagios
Asnmtap/Plugins/SOAP
Asnmtap/Plugins/WebTransact
Asnmtap/Plugins/XML
);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my @prerequisites = (
# [ '<level>', '<feature>', '<installed module>', <dependency hash>, <install by default: 0 = no, 1 = yes, 2 = always, 3 = reserved and 4 = info>, [[<files>, <x|r>], ...] ];
[ '*00', 'Package ASNMTAP::Asnmtap', 'ASNMTAP::Asnmtap', { 'CPAN' => '1.9205', 'CPANPLUS' => '0.84', 'Config::General' => '2.38', 'Config::General::Interpolated' => '2.07', 'Data::Dumper' => '2.121','Dumpvalue' => '1.11', 'Ge...
[
[ 'Changes', 'r' ],
[ 'AUTHORS', 'r' ],
[ 'INSTALL', 'r' ],
[ 'README', 'r' ],
[ 'Asnmtap.cnf', 'R' ],
[ 'log', 'd' ],
[ 'pid', 'd' ],
]
Makefile.PL view on Meta::CPAN
sub generate_PREREQ_PM_table {
my $buffer = sprintf ( "%-24s %-36s %-8s\n", 'Feature', 'Prerequisites', 'Install?' );
$buffer .= sprintf ( "%s %s %s\n","-" x 24,"-" x 36,"-" x 8 );
foreach my $prerequisites ( @prerequisites ) { $buffer .= generate_PREREQ_PM ( @$prerequisites[1..4] ); }
$buffer .= "\n<- An asterix [*] indicates if the module is currently installed.\n";
return $buffer;
}
# Update the entire prerequisites table
sub update_prerequisites_table {
my ($u_level, $u_default) = @_;
return if ( $u_default > 2 );
my ($action, $u1, $u2, $u3);
($u1, $u2, $u3) = $u_level =~ /^\*(\d{2,2})(?:(\d{2,2})(\d{2,2})?)?$/;
if ( defined $u3 ) {
return unless ( $u_default ); $action = 3;
} elsif ( defined $u2 ) {
return if ( $u_default ); $action = 2;
} elsif ( defined $u1 ) {
return unless ( $u1 eq '00' ); $action = 1;
} else {
return; $action = 0;
}
foreach my $prerequisite ( @prerequisites ) {
my ($level, $default) = ( @{$prerequisite}[0], @{$prerequisite}[4] );
if ( $action == 1 and $u_level eq $level ) { @{$prerequisite}[4] = 2; last; }
next if ( $default >= 2 );
if ( $u_level ne $level ) {
if ( $u_default ) {
next unless ( $action == 3 and length($u_level) == 7 and length($level) == 5 and $u_level =~ /^$level/ );
} else {
next unless ( $action == 2 and length($u_level) == 5 and length($level) == 7 and $level =~ /^$u_level/ );
}
}
@{$prerequisite}[4] = $u_default;
}
}
# Initialize the entire prerequisites table
foreach my $prerequisites ( @prerequisites ) { update_prerequisites_table( @$prerequisites[0], @$prerequisites[4] ); }
my $proceed = 0;
do {
print "\n". generate_PREREQ_PM_table() ."\n";
$proceed = ( $prompt ? ExtUtils::MakeMaker::prompt( "Do you want to proceed with this configuration?" => 'yes' ) =~ /^\s*y/i : 1 );
print "\nActivate test:\n" if ($proceed);
%PREREQ_PM = ();
foreach my $prerequisite ( @prerequisites ) {
my ($level, $feature, $dependency, $modules, $default) = @{$prerequisite}[0..4];
next unless ( $dependency ne '' );
unless ( $proceed || $default >= 2 ) {
$default = ( ( ExtUtils::MakeMaker::prompt( "Do you plan to use ${feature}?" => ( $default ? 'yes' : 'no' ) ) =~ /^\s*(y)/i ) ? 1 : 0 );
@{$prerequisite}[4] = $default;
}
update_prerequisites_table( $level, $default );
if ( $proceed and ( $default == 1 || $default == 2 ) ) {
if ( $dependency =~ /^ASNMTAP::Asnmtap::/ ) {
my $t = uc($');
$t =~ s/::/_/g;
my $enabled = 't/'. $t .'_ENABLED';
open (ENABLED, ">$enabled") or die "- activate test '$enabled' failed: $!\n";
close (ENABLED);
print "- activated test: '$enabled'\n";
}
foreach ( keys %$modules ) {
Makefile.PL view on Meta::CPAN
}
}
} while (! $proceed);
print "\n";
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
if ( $ASNMTAP_PLUGINS or $ASNMTAP_APPLICATIONS ) {
foreach my $prerequisite ( @prerequisites ) {
my ($feature, $default, $files) = ( @{$prerequisite}[1], @{$prerequisite}[4..5] );
if ( $default == 1 || $default == 2 ) {
if ( defined $files ) {
foreach ( @$files ) {
my $file = @$_[0];
my $mode = @$_[1];
my @files = glob($file);
foreach my $file (@files) {
my $destination = ( $file =~ /^\// ? $file : $ASNMTAP_PATH .'/'. $file );
$destination .= '-orig' if ( $mode =~ /^[RX]$/ );
$file = substr($file, 1) if ( $file =~ /^\// );
applications/archive.pl view on Meta::CPAN
use vars qw($opt_A $opt_c $opt_r $opt_d $opt_y $opt_f $opt_D $opt_V $opt_h $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = "archive.pl";
my $prgtext = "Archiver for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $doCgisess = 1; # default
my $doReports = 1; # default
my $doDatabase = 0; # default
my $doYearsAgo = -1; # default
my $doForce = 0; # default
my $debug = 0; # default
#------------------------------------------------------------------------
# Don't edit below here unless you know what you are doing. -------------
#------------------------------------------------------------------------
my $archivelist;
my $gzipDaysAgo = 8; # GZIP files older then n date
my $gzipDebugDaysAgo = 3; # GZIP files older then n days ago
my $removeGzipDaysAgo = 31; # Remove files older then n days ago
applications/archive.pl view on Meta::CPAN
print "Usage: $PROGNAME [-A <archivelist>] [-c F|T] [-r F|T] [-d F|T] [-y <years ago>] [-f F|T] [-D <debug>] [-V version] [-h help]\n";
}
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help () {
print_revision($PROGNAME, $version);
print "ASNMTAP Archiver for the '$APPLICATION'
-A, --archivelist=<filename>
FILENAME : filename from the archivelist for the html output loop (default undef)
-c, --cgisess=F|T
F(alse) : don't remove the cgisess files
T(true) : remove the cgisess files (default)
-r, --reports=F|T
F(alse) : don't backup Csv, Sql, Error, Week, Debug reports
T(true) : remove backup Csv, Sql, Error, Week, Debug reports (default)
-d, --database=F|T
F(alse) : don't archive the '$SERVERTABLEVENTS' and '$SERVERTABLCOMMENTS' tables (default)
T(true) : archive the '$SERVERTABLEVENTS' and '$SERVERTABLCOMMENTS' tables
-y, --yearsago=<years ago>
YEARS AGO: c => current year or 1..9 => the number of years ago that the '$SERVERTABLEVENTS'
and '$SERVERTABLCOMMENTS' tables need to be created
-f, --force=F|T
F(alse) : don't force CSV import (default)
T(true) : force CSV import
-D, --debug=F|T|L
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
L(ong) : long screendebugging on
-V, --version
-h, --help
Send email to $SENDEMAILTO if you have questions regarding
use of this software. To submit patches or suggest improvements, send
email to $SENDEMAILTO
";
applications/bin/generateCollectorDaemonSchedulingReports.pl view on Meta::CPAN
use vars qw($opt_V $opt_h $opt_D $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = "generateCollectorDaemonSchedulingReports.pl";
my $prgtext = "Generate Collector Daemon Scheduling Reports for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $debug = 0; # default
my $currentYear = sprintf ("%04d", (localtime)[5]+1900 ); # default
my $currentMonth= sprintf ("%02d", ((localtime)[4])+1 ); # default
my $currentDay = sprintf ("%02d", ((localtime)[3]) ); # default
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help ();
sub print_usage ();
Getopt::Long::Configure('bundling');
GetOptions (
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
applications/bin/generateCollectorDaemonSchedulingReports.pl view on Meta::CPAN
print "Usage: $PROGNAME [-D <debug>] [-V version] [-h help]\n";
}
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help () {
print_revision($PROGNAME, $version);
print "ASNMTAP Generate Collector Daemon Scheduling Reports for the '$APPLICATION'
-D, --debug=F|T|L
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
L(ong) : long screendebugging on
-V, --version
-h, --help
Send email to $SENDEMAILTO if you have questions regarding
use of this software. To submit patches or suggest improvements, send
email to $SENDEMAILTO
";
applications/bin/generateReports.pl view on Meta::CPAN
use vars qw($opt_y $opt_m $opt_d $opt_a $opt_u $opt_V $opt_h $opt_D $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = "generateReports.pl";
my $prgtext = "Generate Reports for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $debug = 0; # default
my $daysAfter = 3; # default
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my ($currentYear, $currentMonth, $currentDay) = ( ((localtime)[5] + 1900), ((localtime)[4] + 1), (localtime)[3] );
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help ();
sub print_usage ();
applications/bin/generateReports.pl view on Meta::CPAN
sub print_usage () {
print "Usage: $PROGNAME [-y <year>] [-m <month>] [-d <day>] [-a <days after>] [-u <uKey>] [-D <debug>] [-V version] [-h help]\n";
}
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help () {
print_revision($PROGNAME, $version);
print "ASNMTAP Generate Reports for the '$APPLICATION'
-y, --year=<year> (default: current year)
-m, --month=<month> (default: current month)
-d, --day=<day> (default: current day)
-a, --daysAfter=<days after|F(alse)> (default: 3)
-u, --uKey=<uKey plugin> (default: all plugins)
-D, --debug=F|T|L
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
L(ong) : long screendebugging on
-V, --version
-h, --help
Send email to $SENDEMAILTO if you have questions regarding
use of this software. To submit patches or suggest improvements, send
email to $SENDEMAILTO
";
applications/bin/holidayBundleSetDowntimes.pl view on Meta::CPAN
use vars qw($opt_V $opt_h $opt_D $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = "holidayBundleSetDowntimes.pl";
my $prgtext = "Set Holiday Bundle Downtimes for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $debug = 0; # default
my $daysBefore = 3;
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help ();
sub print_usage ();
Getopt::Long::Configure('bundling');
GetOptions (
applications/bin/holidayBundleSetDowntimes.pl view on Meta::CPAN
print "Usage: $PROGNAME [-D <debug>] [-V version] [-h help]\n";
}
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help () {
print_revision($PROGNAME, $version);
print "ASNMTAP Set Holiday Bundle Downtimes for the '$APPLICATION'
-D, --debug=F|T|L
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
L(ong) : long screendebugging on
-V, --version
-h, --help
Send email to $SENDEMAILTO if you have questions regarding
use of this software. To submit patches or suggest improvements, send
email to $SENDEMAILTO
";
applications/bin/importDataThroughCatalog.pl view on Meta::CPAN
use vars qw($opt_T $opt_M $opt_V $opt_h $opt_D $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = "importDataThroughCatalog.pl";
my $prgtext = "Import Data Through Catalog for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $debug = 0; # default 0
my $limit = 1000; # default 1000
my $type = 3; # default 3
my $logging = $RESULTSPATH .'/'; # default $RESULTSPATH .'/', disabled by '<NIHIL>'
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $alarm = 30; # default 15
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $boolean_screenDebug = 0; # default 0
my $boolean_debug_all = 0; # default 0
my $boolean_debug_NOK = 0; # default 0
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $booleanQuit = 0;
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help ();
sub print_usage ();
applications/bin/importDataThroughCatalog.pl view on Meta::CPAN
sub print_usage () {
print "Usage: $PROGNAME [-T <CONFIG|DATA|ALL>] [-D <debug>] [-V version] [-h help]\n";
}
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help () {
print_revision($PROGNAME, $version);
print "ASNMTAP Import Data Through Catalog for the '$APPLICATION'
-T, --type=<CONFIG|DATA|ALL> (default: current ALL)
-M, --mode=O|D
O(nce) : run the program once
D(aemon) : run the program as a loop
-D, --debug=F|T|L
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
L(ong) : long screendebugging on
-V, --version
-h, --help
Send email to $SENDEMAILTO if you have questions regarding
use of this software. To submit patches or suggest improvements, send
email to $SENDEMAILTO
";
applications/collector-test.pl view on Meta::CPAN
use vars qw($opt_H $opt_M $opt_C $opt_W $opt_A $opt_N $opt_s $opt_S $opt_D $opt_V $opt_h $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = "collector.pl";
my $prgtext = "Collector for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $status = 'N'; # default
my $dumphttp = 'N'; # default
my $debug = 'F'; # default
my $logging = '<NIHIL>'; # default
my $httpdump = '<NIHIL>'; # default
my $lockMySQL = 0; # default
my $alarm = 5; # default 5
my $perfParseMethode = 'PULP'; # 'AIP', default
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $boolean_screenDebug = 0; # default
my $boolean_debug_all = 0; # default
my $boolean_debug_NOK = 0; # default
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $boolean_loopQuit = 0;
my ($directory, $action, $dproc, $dcron);
my ($tmin, $thour, $tmday, $tmon, $twday, $tinterval, $tcommand);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
applications/collector-test.pl view on Meta::CPAN
-H, --hostname=<HOSTNAME>
HOSTNAME : hostname/address from the MySQL server
-M, --mode=O|L|C
O(nce) : run the program once
L(oop) : run the program as a loop
C(rontab) : run the program crontab based
-C, --collectorlist=<FILENAME>
FILENAME : filename from the collectorlist for the loop of crontab
-W, --screenDebug=F|T
F(alse) : all screendebugging off (default)
T(true) : all screendebugging on
-A, --allDebug=F|T
F(alse) : all file debugging off (default)
T(true) : all file debugging on
-N, --nokDebug=F|T
F(alse) : nok file debugging off (default)
T(true) : nok file debugging on
-s, --dumphttp=N|A|W|C|U
N(one) : httpdump off (default)
A(ll) : httpdump for all events
W(arning) : httpdump only the warning, critical and unknown critical events
C(ritical) : httpdump only the critical and unknown critical events
U(nknown) : httpdump only the unknown critical events
-S, --status=N|S
N(agios): Nagios custom plugin output (default)
S(nmp) : SNMP ...
-D, --debug=F|T|L
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
L(ong) : long screendebugging on
-V, --version
-h, --help
Send email to $SENDEMAILTO if you have questions regarding
use of this software. To submit patches or suggest improvements, send
email to $SENDEMAILTO
";
applications/collector.pl view on Meta::CPAN
use vars qw($opt_H $opt_M $opt_C $opt_W $opt_A $opt_N $opt_s $opt_S $opt_D $opt_V $opt_h $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = "collector.pl";
my $prgtext = "Collector for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $status = 'N'; # default
my $dumphttp = 'N'; # default
my $debug = 'F'; # default
my $logging = '<NIHIL>'; # default
my $httpdump = '<NIHIL>'; # default
my $lockMySQL = 0; # default
my $alarm = 5; # default 5
my $perfParseMethode = 'PULP'; # 'AIP', default
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $boolean_screenDebug = 0; # default
my $boolean_debug_all = 0; # default
my $boolean_debug_NOK = 0; # default
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $boolean_loopQuit = 0;
my ($directory, $action, $dproc, $dcron);
my ($tmin, $thour, $tmday, $tmon, $twday, $tinterval, $tcommand);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
applications/collector.pl view on Meta::CPAN
-H, --hostname=<HOSTNAME>
HOSTNAME : hostname/address from the MySQL server
-M, --mode=O|L|C
O(nce) : run the program once
L(oop) : run the program as a loop
C(rontab) : run the program crontab based
-C, --collectorlist=<FILENAME>
FILENAME : filename from the collectorlist for the loop of crontab
-W, --screenDebug=F|T
F(alse) : all screendebugging off (default)
T(true) : all screendebugging on
-A, --allDebug=F|T
F(alse) : all file debugging off (default)
T(true) : all file debugging on
-N, --nokDebug=F|T
F(alse) : nok file debugging off (default)
T(true) : nok file debugging on
-s, --dumphttp=N|A|W|C|U
N(one) : httpdump off (default)
A(ll) : httpdump for all events
W(arning) : httpdump only the warning, critical and unknown critical events
C(ritical) : httpdump only the critical and unknown critical events
U(nknown) : httpdump only the unknown critical events
-S, --status=N|S
N(agios): Nagios custom plugin output (default)
S(nmp) : SNMP ...
-D, --debug=F|T|L
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
L(ong) : long screendebugging on
-V, --version
-h, --help
Send email to $SENDEMAILTO if you have questions regarding
use of this software. To submit patches or suggest improvements, send
email to $SENDEMAILTO
";
applications/display-test.pl view on Meta::CPAN
use vars qw($opt_H $opt_V $opt_h $opt_C $opt_P $opt_D $opt_L $opt_t $opt_c $opt_T $opt_l $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = "display.pl";
my $prgtext = "Display for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $checklist = "DisplayCT"; # default
my $htmlOutput = $HTTPSPATH .'/nav/index/index'; # default
my $pagedir = 'index'; # default
my $pageset = 'index'; # default
my $debug = 0; # default
my $loop = 0; # default
my $trigger = 0; # default
my $creationTime; # default
my $displayTime = 1; # default
my $lockMySQL = 0; # default
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $displayTimeslot = 0; # only for extra debugging information
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help ();
sub print_usage ();
applications/display-test.pl view on Meta::CPAN
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help () {
print_revision($PROGNAME, $version);
print "ASNMTAP Display for the '$APPLICATION'
-H, --hostname=<HOSTNAME>
HOSTNAME : hostname/address from the MySQL server
-C, --checklist=<FILENAME>
FILENAME : filename from the checklist for the html output loop (default 'DisplayCT')
-P, --pagedir=<PAGEDIR>
PAGEDIR : sub directory name for the html output (default 'index')
-L, --loop=F|T
F(alse) : loop off (default)
T(rue) : loop on
-t, --trigger=F|T
F(alse) : trigger off (default)
T(rue) : trigger on
-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
-T, --displayTime=F|T
F(alse) : display timeslots into html output off
T(rue) : display timeslots into html output (default)
-l, --lockMySQL=F|T
F(alse) : lock MySQL table off (default)
T(rue) : lock MySQL table on
-D, --debug=F|T
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
-V, --version
-h, --help
Send email to $SENDEMAILTO if you have questions regarding
use of this software. To submit patches or suggest improvements, send
email to $SENDEMAILTO
";
}
applications/display.pl view on Meta::CPAN
use vars qw($opt_H $opt_V $opt_h $opt_C $opt_P $opt_D $opt_L $opt_t $opt_c $opt_T $opt_l $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = "display.pl";
my $prgtext = "Display for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $checklist = "DisplayCT"; # default
my $htmlOutput = $HTTPSPATH .'/nav/index/index'; # default
my $pagedir = 'index'; # default
my $pageset = 'index'; # default
my $debug = 0; # default
my $loop = 0; # default
my $trigger = 0; # default
my $creationTime; # default
my $displayTime = 1; # default
my $lockMySQL = 0; # default
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $displayTimeslot = 0; # only for extra debugging information
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help ();
sub print_usage ();
applications/display.pl view on Meta::CPAN
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
sub print_help () {
print_revision($PROGNAME, $version);
print "ASNMTAP Display for the '$APPLICATION'
-H, --hostname=<HOSTNAME>
HOSTNAME : hostname/address from the MySQL server
-C, --checklist=<FILENAME>
FILENAME : filename from the checklist for the html output loop (default 'DisplayCT')
-P, --pagedir=<PAGEDIR>
PAGEDIR : sub directory name for the html output (default 'index')
-L, --loop=F|T
F(alse) : loop off (default)
T(rue) : loop on
-t, --trigger=F|T
F(alse) : trigger off (default)
T(rue) : trigger on
-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
-T, --displayTime=F|T
F(alse) : display timeslots into html output off
T(rue) : display timeslots into html output (default)
-l, --lockMySQL=F|T
F(alse) : lock MySQL table off (default)
T(rue) : lock MySQL table on
-D, --debug=F|T
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
-V, --version
-h, --help
Send email to $SENDEMAILTO if you have questions regarding
use of this software. To submit patches or suggest improvements, send
email to $SENDEMAILTO
";
}
applications/htmlroot/cgi-bin/admin/generateConfig.pl view on Meta::CPAN
}
# pagedirs <-> plugins - - - - - - - - - - - - - - - - - - - - - -
$sqlTmp = "drop temporary table if exists tmp$SERVERTABLPLUGINS";
$sthTmp = $dbh->prepare( $sqlTmp ) or $rv = error_trap_DBI(*STDOUT, "Cannot dbh->prepare: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
$sthTmp->execute() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->execute: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID) if $rv;
if ( $rv ) {
$sthTmp->finish() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->finish: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
$sqlTmp = "create temporary table `tmp$SERVERTABLPLUGINS`(`catalogID` varchar(5) NOT NULL default '$CATALOGID', `pagedir` varchar(11) default '') TYPE=InnoDB";
$sthTmp = $dbh->prepare( $sqlTmp ) or $rv = error_trap_DBI(*STDOUT, "Cannot dbh->prepare: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
$sthTmp->execute() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->execute: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
if ( $rv ) {
$sthTmp->finish() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->finish: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID) if $rv;
$sql = "SELECT $SERVERTABLPLUGINS.pagedir FROM $SERVERTABLPLUGINS where catalogID = '$CATALOGID'";
$sth = $dbh->prepare( $sql ) or $rv = error_trap_DBI(*STDOUT, "Cannot dbh->prepare: $sql", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
$sth->execute() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->execute: $sql", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID) if $rv;
$sth->bind_columns( \$pagedirs ) or $rv = error_trap_DBI(*STDOUT, "Cannot sth->bind_columns: $sql", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID) if $rv;
applications/htmlroot/cgi-bin/admin/generateConfig.pl view on Meta::CPAN
}
# pagedirs <-> users - - - - - - - - - - - - - - - - - - - - - - -
$sqlTmp = "drop temporary table if exists tmp$SERVERTABLUSERS";
$sthTmp = $dbh->prepare( $sqlTmp ) or $rv = error_trap_DBI(*STDOUT, "Cannot dbh->prepare: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
$sthTmp->execute() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->execute: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID) if $rv;
if ( $rv ) {
$sthTmp->finish() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->finish: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
$sqlTmp = "create temporary table `tmp$SERVERTABLUSERS`(`catalogID` varchar(5) NOT NULL default '$CATALOGID', `pagedir` varchar(11) default '') TYPE=InnoDB";
$sthTmp = $dbh->prepare( $sqlTmp ) or $rv = error_trap_DBI(*STDOUT, "Cannot dbh->prepare: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
$sthTmp->execute() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->execute: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
if ( $rv ) {
$sthTmp->finish() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->finish: $sqlTmp", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID) if $rv;
$sql = "SELECT $SERVERTABLUSERS.pagedir FROM $SERVERTABLUSERS where catalogID = '$CATALOGID'";
$sth = $dbh->prepare( $sql ) or $rv = error_trap_DBI(*STDOUT, "Cannot dbh->prepare: $sql", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID);
$sth->execute() or $rv = error_trap_DBI(*STDOUT, "Cannot sth->execute: $sql", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID) if $rv;
$sth->bind_columns( \$pagedirs ) or $rv = error_trap_DBI(*STDOUT, "Cannot sth->bind_columns: $sql", $debug, $pagedir, $pageset, $htmlTitle, $subTitle, -1, '', $sessionID) if $rv;
applications/htmlroot/md5.js view on Meta::CPAN
* A JavaScript implementation of the RSA Data Security, Inc. MD5 Message
* Digest Algorithm, as defined in RFC 1321.
* Version 2.1 Copyright (C) Paul Johnston 1999 - 2002.
* Other contributors: Greg Holt, Andrew Kepert, Ydnar, Lostinet
* Distributed under the BSD License
* See http://pajhome.org.uk/crypt/md5 for more info.
*/
/*
* Configurable variables. You may need to tweak these to be compatible with
* the server-side, but the defaults work in most cases.
*/
var hexcase = 0; /* hex output format. 0 - lowercase; 1 - uppercase */
var b64pad = ""; /* base-64 pad character. "=" for strict RFC compliance */
var chrsz = 8; /* bits per input character. 8 - ASCII; 16 - Unicode */
/*
* These are the functions you'll usually want to call
* They take string arguments and return either hex or base-64 encoded strings
*/
function hex_md5(s){ return binl2hex(core_md5(str2binl(s), s.length * chrsz));}
applications/htmlroot/overlib.js view on Meta::CPAN
// overlib(arg0,...,argN)
// Loads parameters into global runtime variables.
function overlib() {
if (!olLoaded || isExclusive(overlib.arguments)) return true;
if (olCheckMouseCapture) olMouseCapture();
if (over) {
over = (typeof over.id != 'string') ? o3_frame.document.all['overDiv'] : over;
cClick();
}
// Load defaults to runtime.
olHideDelay=0;
o3_text=ol_text;
o3_cap=ol_cap;
o3_sticky=ol_sticky;
o3_background=ol_background;
o3_close=ol_close;
o3_hpos=ol_hpos;
o3_offsetx=ol_offsetx;
o3_offsety=ol_offsety;
o3_fgcolor=ol_fgcolor;
applications/htmlroot/overlib.js view on Meta::CPAN
// The Close onMouseOver function for stickies
function cClick() {
if (olLoaded) {
runHook("hideObject", FREPLACE, over);
o3_showingsticky = 0;
}
return false;
}
// Method for setting page specific defaults.
function overlib_pagedefaults() {
parseTokens('ol_', overlib_pagedefaults.arguments);
}
////////
// OVERLIB MAIN FUNCTION
////////
// This function decides what it is we want to display and how we want it done.
function olMain() {
var layerhtml, styleType;
applications/htmlroot/overlib.js view on Meta::CPAN
// Arg is maintext,unless its a number between pmStart and pmUpper
// then its a command.
if (typeof ar[i] == 'number' && ar[i] > pmStart && ar[i] < pmUpper) {
fnMark = (par ? 1 : 0);
i--; // backup one so that the next block can parse it
} else {
switch(pf) {
case 'ol_':
ol_text = ar[i].toString();
break;
default:
o3_text=ar[i].toString();
}
}
mode = 0;
} else {
// Note: NS4 doesn't like switch cases with vars.
if (ar[i] >= pmCount || ar[i]==DONOTHING) { continue; }
if (ar[i]==INARRAY) { fnMark = 0; eval(pf+'text=ol_texts['+ar[++i]+'].toString()'); continue; }
if (ar[i]==CAPARRAY) { eval(pf+'cap=ol_caps['+ar[++i]+'].toString()'); continue; }
if (ar[i]==STICKY) { if (pf!='ol_') eval(pf+'sticky=1'); continue; }
applications/htmlroot/overlib.js view on Meta::CPAN
if (o3_x < left || o3_x > right || o3_y < top || o3_y > bottom) return true;
return false;
}
////////
// COMMAND FUNCTIONS
////////
// Calls callme or the default function.
function opt_FUNCTION(callme) {
o3_text = (callme ? (typeof callme=='string' ? (/.+\(.*\)/.test(callme) ? eval(callme) : callme) : callme()) : (o3_function ? o3_function() : 'No Function'));
return 0;
}
// Handle hovering
function opt_NOCLOSE(unused) {
if (!unused) o3_close = "";
applications/htmlroot/overlib_cssstyle.js view on Meta::CPAN
var o3_closesizeunit="px";
var o3_closedecoration="";
var o3_closestyle="";
var o3_closeweight="";
////////
// PLUGIN FUNCTIONS
////////
// Function which sets runtime variables to their default values
function setCSSStyleVariables() {
o3_padunit=ol_padunit;
o3_heightunit=ol_heightunit;
o3_widthunit=ol_widthunit;
o3_textsizeunit=ol_textsizeunit;
o3_textdecoration=ol_textdecoration;
o3_textstyle=ol_textstyle;
o3_textweight=ol_textweight;
o3_captionsizeunit=ol_captionsizeunit;
o3_captiondecoration=ol_captiondecoration;
applications/htmlroot/overlib_followscroll.js view on Meta::CPAN
var k=i,v;
if (k < ar.length) {
if (ar[k]==FOLLOWSCROLL) { eval(pf +'followscroll=('+pf+'followscroll==0) ? 1 : 0'); return k; }
if (ar[k]==FOLLOWSCROLLREFRESH) { eval(pf+'followscrollrefresh='+ar[++k]); return k; }
}
return -1;
}
// Function to support scroll feature (overloads default)
function scroll_placeLayer() {
var placeX, placeY, widthFix = 0;
// HORIZONTAL PLACEMENT
if (o3_frame.innerWidth) {
widthFix=Math.ceil(1.2*(o3_frame.outerWidth - o3_frame.innerWidth));
widthFix = (widthFix > 50) ? 20 : widthFix;
iwidth=o3_frame.innerWidth;
} else if (eval('o3_frame.'+docRoot)&&eval("typeof o3_frame."+docRoot+".clientWidth=='number'")&&eval('o3_frame.'+docRoot+'.clientWidth'))
iwidth=eval('o3_frame.'+docRoot+'.clientWidth');
applications/htmlroot/overlib_shadow.js view on Meta::CPAN
var o3_shadow=0;
var o3_shadowcolor="#cccccc";
var o3_shadowimage='';
var o3_shadowopacity=0;
var o3_shadowx=5;
var o3_shadowy=5;
var bkSet=0; // Needed for this effect in NS4
// Function which sets runtime variables to their default values
function setShadowVariables() {
o3_shadow=ol_shadow;
o3_shadowcolor=ol_shadowcolor;
o3_shadowimage=ol_shadowimage;
o3_shadowopacity=ol_shadowopacity;
o3_shadowx=ol_shadowx;
o3_shadowy=ol_shadowy;
}
applications/htmlroot/snmptraps/include/js/overlib.js view on Meta::CPAN
// overlib(arg0,...,argN)
// Loads parameters into global runtime variables.
function overlib() {
if (!olLoaded || isExclusive(overlib.arguments)) return true;
if (olCheckMouseCapture) olMouseCapture();
if (over) {
over = (typeof over.id != 'string') ? o3_frame.document.all['overDiv'] : over;
cClick();
}
// Load defaults to runtime.
olHideDelay=0;
o3_text=ol_text;
o3_cap=ol_cap;
o3_sticky=ol_sticky;
o3_background=ol_background;
o3_close=ol_close;
o3_hpos=ol_hpos;
o3_offsetx=ol_offsetx;
o3_offsety=ol_offsety;
o3_fgcolor=ol_fgcolor;
applications/htmlroot/snmptraps/include/js/overlib.js view on Meta::CPAN
// The Close onMouseOver function for stickies
function cClick() {
if (olLoaded) {
runHook("hideObject", FREPLACE, over);
o3_showingsticky = 0;
}
return false;
}
// Method for setting page specific defaults.
function overlib_pagedefaults() {
parseTokens('ol_', overlib_pagedefaults.arguments);
}
////////
// OVERLIB MAIN FUNCTION
////////
// This function decides what it is we want to display and how we want it done.
function olMain() {
var layerhtml, styleType;
applications/htmlroot/snmptraps/include/js/overlib.js view on Meta::CPAN
// Arg is maintext,unless its a number between pmStart and pmUpper
// then its a command.
if (typeof ar[i] == 'number' && ar[i] > pmStart && ar[i] < pmUpper) {
fnMark = (par ? 1 : 0);
i--; // backup one so that the next block can parse it
} else {
switch(pf) {
case 'ol_':
ol_text = ar[i].toString();
break;
default:
o3_text=ar[i].toString();
}
}
mode = 0;
} else {
// Note: NS4 doesn't like switch cases with vars.
if (ar[i] >= pmCount || ar[i]==DONOTHING) { continue; }
if (ar[i]==INARRAY) { fnMark = 0; eval(pf+'text=ol_texts['+ar[++i]+'].toString()'); continue; }
if (ar[i]==CAPARRAY) { eval(pf+'cap=ol_caps['+ar[++i]+'].toString()'); continue; }
if (ar[i]==STICKY) { if (pf!='ol_') eval(pf+'sticky=1'); continue; }
applications/htmlroot/snmptraps/include/js/overlib.js view on Meta::CPAN
if (o3_x < left || o3_x > right || o3_y < top || o3_y > bottom) return true;
return false;
}
////////
// COMMAND FUNCTIONS
////////
// Calls callme or the default function.
function opt_FUNCTION(callme) {
o3_text = (callme ? (typeof callme=='string' ? (/.+\(.*\)/.test(callme) ? eval(callme) : callme) : callme()) : (o3_function ? o3_function() : 'No Function'));
return 0;
}
// Handle hovering
function opt_NOCLOSE(unused) {
if (!unused) o3_close = '';
applications/sbin/purge_table.pl view on Meta::CPAN
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $objectASNMTAP = ASNMTAP::Asnmtap::Applications->new (
_programName => 'purge_table.pl',
_programDescription => 'Purge table',
_programVersion => '3.002.003',
_programUsagePrefix => '-H|--host <HOST> [-P|--port <PORT>] -D|--database=<database> -T|--table=<table> [-A|--ago=<ago by STRING>] -u|--username|--loginname
<USERNAME> -p|--password|--passwd <PASSWORD>',
_programHelpPrefix => "-H, --host=<HOST>
hostname or ip address
-P, --port=<PORT> (default: 3306)
-D, --database=<database>
-T, --table=<table>
-A, --ago=<ago by STRING>
-u, --username/--loginname=<USERNAME>
-p, --password/--passwd=<PASSWORD>",
_programGetOptions => ['host|H=s', 'port|P:i', 'database|D=s', 'table|T=s', 'ago|A:s', 'username|u|loginname=s', 'password|p|passwd=s'],
_debug => 0);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
applications/sbin/sshWrapperASNMTAP.pl view on Meta::CPAN
use vars qw($opt_C $PROGNAME);
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$PROGNAME = 'sshWrapperASNMTAP.pl';
my $prgtext = "ASNMTAP SSH Wrapper for the '$APPLICATION'";
my $version = do { my @r = (q$Revision: 3.002.003$ =~ /\d+/g); sprintf "%d."."%03d" x $#r, @r }; # must be all on one line or MakeMaker will get confused.
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
my $debug = 1; # default
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
# Where to log successes and failures to set to /dev/null to turn off logging.
my $filename = "$LOGPATH/sshWrapperASNMTAP.log";
# What you want sent if access is denied.
my $denyString = 'Access Denied! Sorry';
my $sshCmdRm = 'remove';
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
USE `asnmtap`;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
/*Table structure for table catalog */
DROP TABLE IF EXISTS `catalog`;
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',
`databaseFQDN` varchar(64) NOT NULL default 'localhost',
`databasePort` varchar(4) NOT NULL default '3306',
`lastEventsID` int(11) NOT NULL default '0',
`lastCommentsID` int(11) NOT NULL default '0',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`),
KEY `catalogName` (`catalogName`)
) ENGINE=InnoDB;
/* Data for the table catalog */
insert into `catalog` (`catalogID`,`catalogName`,`catalogType`,`databaseFQDN`,`databasePort`,`lastEventsID`,`lastCommentsID`,`activated`) values ('CID','Central System Enterprise','central','localhost','3306',0,0,1);
/*Table structure for table `collectorDaemons` */
DROP TABLE IF EXISTS `collectorDaemons`;
CREATE TABLE `collectorDaemons` (
`catalogID` varchar(5) NOT NULL default 'CID',
`collectorDaemon` varchar(64) NOT NULL default '',
`groupName` varchar(64) NOT NULL default '',
`serverID` varchar(11) NOT NULL default '',
`mode` char(1) NOT NULL default 'C',
`dumphttp` char(1) NOT NULL default 'N',
`status` char(1) NOT NULL default 'N',
`debugDaemon` char(1) NOT NULL default 'F',
`debugAllScreen` char(1) NOT NULL default 'F',
`debugAllFile` char(1) NOT NULL default 'F',
`debugNokFile` char(1) NOT NULL default 'F',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`collectorDaemon`),
KEY `catalogID` (`catalogID`),
KEY `serverID` (`serverID`),
KEY `collectorDaemon` (`collectorDaemon`),
KEY `collectorDaemons_ibfk_1` (`catalogID`,`serverID`),
CONSTRAINT `collectorDaemons_ibfk_1` FOREIGN KEY (`catalogID`, `serverID`) REFERENCES `servers` (`catalogID`, `serverID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `collectorDaemons` */
insert into `collectorDaemons` (`catalogID`,`collectorDaemon`,`groupName`,`serverID`,`mode`,`dumphttp`,`status`,`debugDaemon`,`debugAllScreen`,`debugAllFile`,`debugNokFile`,`activated`) values ('CID','asnmtap01','Admin Collector [asnmtap01]','asnmtap...
insert into `collectorDaemons` (`catalogID`,`collectorDaemon`,`groupName`,`serverID`,`mode`,`dumphttp`,`status`,`debugDaemon`,`debugAllScreen`,`debugAllFile`,`debugNokFile`,`activated`) values ('CID','asnmtap02','Admin Collector [asnmtap02]','asnmtap...
insert into `collectorDaemons` (`catalogID`,`collectorDaemon`,`groupName`,`serverID`,`mode`,`dumphttp`,`status`,`debugDaemon`,`debugAllScreen`,`debugAllFile`,`debugNokFile`,`activated`) values ('CID','index','Production Daemon','CTP-CENTRAL','C','U',...
insert into `collectorDaemons` (`catalogID`,`collectorDaemon`,`groupName`,`serverID`,`mode`,`dumphttp`,`status`,`debugDaemon`,`debugAllScreen`,`debugAllFile`,`debugNokFile`,`activated`) values ('CID','test','Test Daemon','CTP-CENTRAL','C','U','N','F'...
/*Table structure for table `comments` */
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
`catalogID` varchar(5) NOT NULL default 'CID',
`id` int(11) NOT NULL auto_increment,
`uKey` varchar(11) NOT NULL default '',
`replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I',
`title` varchar(75) NOT NULL default '',
`remoteUser` varchar(11) NOT NULL default '',
`instability` tinyint(1) NOT NULL default '0',
`persistent` tinyint(1) NOT NULL default '0',
`downtime` tinyint(1) NOT NULL default '0',
`entryDate` date NOT NULL default '0000-00-00',
`entryTime` time NOT NULL default '00:00:00',
`entryTimeslot` varchar(10) NOT NULL default '0000000000',
`activationDate` date NOT NULL default '0000-00-00',
`activationTime` time NOT NULL default '00:00:00',
`activationTimeslot` varchar(10) NOT NULL default '0000000000',
`suspentionDate` date NOT NULL default '0000-00-00',
`suspentionTime` time NOT NULL default '00:00:00',
`suspentionTimeslot` varchar(10) NOT NULL default '9999999999',
`solvedDate` date NOT NULL default '0000-00-00',
`solvedTime` time NOT NULL default '00:00:00',
`solvedTimeslot` varchar(10) NOT NULL default '0000000000',
`problemSolved` tinyint(1) NOT NULL default '1',
`commentData` blob NOT NULL,
PRIMARY KEY (`catalogID`,`id`),
KEY `catalogID` (`catalogID`),
KEY `id` (`id`),
KEY `uKey` (`uKey`),
KEY `replicationStatus` (`replicationStatus`),
KEY `remoteUser` (`remoteUser`),
KEY `persistent` (`persistent`),
KEY `downtime` (`downtime`),
KEY `entryTimeslot` (`entryTimeslot`),
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`catalogID`, `remoteUser`) REFERENCES `users` (`catalogID`, `remoteUser`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `comments` */
/*Table structure for table `countries` */
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
`countryID` char(2) NOT NULL default '',
`countryName` varchar(45) default NULL,
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`countryID`),
KEY `countryName` (`countryName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `countries` */
insert into `countries` (`countryID`,`countryName`,`activated`) values ('00','+ All Countries',1);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AD','Andorra',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AE','United Arab Emirates',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AF','Afghanistan',0);
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ZA','South Africa',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ZM','Zambia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ZR','Zaire',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ZW','Zimbabwe',0);
/*Table structure for table `crontabs` */
DROP TABLE IF EXISTS `crontabs`;
CREATE TABLE `crontabs` (
`catalogID` varchar(5) NOT NULL default 'CID',
`lineNumber` char(2) NOT NULL default '',
`uKey` varchar(11) NOT NULL default '',
`collectorDaemon` varchar(64) NOT NULL default '',
`arguments` varchar(1024) default '',
`minute` varchar(167) NOT NULL default '*',
`hour` varchar(61) NOT NULL default '*',
`dayOfTheMonth` varchar(83) NOT NULL default '*',
`monthOfTheYear` varchar(26) NOT NULL default '*',
`dayOfTheWeek` varchar(13) NOT NULL default '*',
`noOffline` varchar(12) default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`lineNumber`,`uKey`),
KEY `catalogID` (`catalogID`),
KEY `uKey` (`uKey`),
KEY `collectorDaemon` (`collectorDaemon`),
KEY `crontabs_ibfk_1` (`catalogID`,`collectorDaemon`),
KEY `crontabs_ibfk_2` (`catalogID`,`uKey`),
CONSTRAINT `crontabs_ibfk_1` FOREIGN KEY (`catalogID`, `collectorDaemon`) REFERENCES `collectorDaemons` (`catalogID`, `collectorDaemon`),
CONSTRAINT `crontabs_ibfk_2` FOREIGN KEY (`catalogID`, `uKey`) REFERENCES `plugins` (`catalogID`, `uKey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
insert into `crontabs` (`catalogID`,`lineNumber`,`uKey`,`collectorDaemon`,`arguments`,`minute`,`hour`,`dayOfTheMonth`,`monthOfTheYear`,`dayOfTheWeek`,`noOffline`,`activated`) values ('CID','00','zCLUSTER-40','test','','*/2','*','*','*','*','',1);
insert into `crontabs` (`catalogID`,`lineNumber`,`uKey`,`collectorDaemon`,`arguments`,`minute`,`hour`,`dayOfTheMonth`,`monthOfTheYear`,`dayOfTheWeek`,`noOffline`,`activated`) values ('CID','00','zCLUSTER-41','test','','*/2','*','*','*','*','',1);
insert into `crontabs` (`catalogID`,`lineNumber`,`uKey`,`collectorDaemon`,`arguments`,`minute`,`hour`,`dayOfTheMonth`,`monthOfTheYear`,`dayOfTheWeek`,`noOffline`,`activated`) values ('CID','00','zCLUSTER-42','test','','*/2','*','*','*','*','',1);
insert into `crontabs` (`catalogID`,`lineNumber`,`uKey`,`collectorDaemon`,`arguments`,`minute`,`hour`,`dayOfTheMonth`,`monthOfTheYear`,`dayOfTheWeek`,`noOffline`,`activated`) values ('CID','00','zCLUSTER-43','test','','*/2','*','*','*','*','',1);
/*Table structure for table `displayDaemons` */
DROP TABLE IF EXISTS `displayDaemons`;
CREATE TABLE `displayDaemons` (
`catalogID` varchar(5) NOT NULL default 'CID',
`displayDaemon` varchar(64) NOT NULL default '',
`groupName` varchar(64) NOT NULL default '',
`pagedir` varchar(11) NOT NULL default '',
`serverID` varchar(11) NOT NULL default '',
`loop` char(1) NOT NULL default 'T',
`trigger` char(1) NOT NULL default 'T',
`displayTime` char(1) NOT NULL default 'T',
`lockMySQL` char(1) NOT NULL default 'F',
`debugDaemon` char(1) NOT NULL default 'F',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`displayDaemon`),
KEY `catalogID` (`catalogID`),
KEY `serverID` (`serverID`),
KEY `pagedir` (`catalogID`,`pagedir`),
KEY `displayDaemon` (`displayDaemon`),
KEY `displayDaemons_ibfk_2` (`catalogID`,`serverID`),
CONSTRAINT `displayDaemons_ibfk_1` FOREIGN KEY (`catalogID`, `pagedir`) REFERENCES `pagedirs` (`catalogID`, `pagedir`),
CONSTRAINT `displayDaemons_ibfk_2` FOREIGN KEY (`catalogID`, `serverID`) REFERENCES `servers` (`catalogID`, `serverID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `displayDaemons` */
insert into `displayDaemons` (`catalogID`,`displayDaemon`,`groupName`,`pagedir`,`serverID`,`loop`,`trigger`,`displayTime`,`lockMySQL`,`debugDaemon`,`activated`) values ('CID','index','Production Daemon','index','CTP-CENTRAL','T','F','T','F','F',1);
insert into `displayDaemons` (`catalogID`,`displayDaemon`,`groupName`,`pagedir`,`serverID`,`loop`,`trigger`,`displayTime`,`lockMySQL`,`debugDaemon`,`activated`) values ('CID','test','Test Daemon','test','CTP-CENTRAL','T','F','T','F','F',1);
/*Table structure for table `displayGroups` */
DROP TABLE IF EXISTS `displayGroups`;
CREATE TABLE `displayGroups` (
`catalogID` varchar(5) NOT NULL default 'CID',
`displayGroupID` int(11) NOT NULL auto_increment,
`groupTitle` varchar(100) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`displayGroupID`),
KEY `catalogID` (`catalogID`),
KEY `displayGroupID` (`displayGroupID`),
KEY `groupTitle` (`groupTitle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `displayGroups` */
insert into `displayGroups` (`catalogID`,`displayGroupID`,`groupTitle`,`activated`) values ('CID',1,'Testing Collector & Display for the \'Application Monitor\'',1);
insert into `displayGroups` (`catalogID`,`displayGroupID`,`groupTitle`,`activated`) values ('CID',2,'Condenced View Test',1);
insert into `displayGroups` (`catalogID`,`displayGroupID`,`groupTitle`,`activated`) values ('CID',3,'90 Monitoring Servers',1);
/*Table structure for table `environment` */
DROP TABLE IF EXISTS `environment`;
CREATE TABLE `environment` (
`environment` char(1) NOT NULL default 'L',
`label` varchar(12) default 'Local',
PRIMARY KEY (`environment`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `environment` */
insert into `environment` (`environment`,`label`) values ('A','Acceptation');
insert into `environment` (`environment`,`label`) values ('D','Development');
insert into `environment` (`environment`,`label`) values ('L','Local');
insert into `environment` (`environment`,`label`) values ('P','Production');
insert into `environment` (`environment`,`label`) values ('S','Simulation');
insert into `environment` (`environment`,`label`) values ('T','Test');
/*Table structure for table `events` */
DROP TABLE IF EXISTS `events`;
CREATE TABLE `events` (
`catalogID` varchar(5) NOT NULL default 'CID',
`id` int(11) NOT NULL auto_increment,
`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 '',
`perfdata` text,
`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`,`id`),
KEY `catalogID` (`catalogID`),
KEY `id` (`id`),
KEY `uKey` (`uKey`),
KEY `replicationStatus` (`replicationStatus`),
KEY `key_test` (`test`),
KEY `key_status` (`status`),
KEY `key_startDate` (`startDate`),
KEY `key_startTime` (`startTime`),
KEY `key_endDate` (`endDate`),
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
CONSTRAINT `events_ibfk_1` FOREIGN KEY (`catalogID`,`uKey`) REFERENCES `plugins` (`catalogID`,`uKey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `events` */
/*Table structure for table `eventsChangesLogData` */
DROP TABLE IF EXISTS `eventsChangesLogData`;
CREATE TABLE `eventsChangesLogData` (
`catalogID` varchar(5) NOT NULL default 'CID',
`uKey` varchar(11) NOT NULL default '',
`replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I',
`lastStatus` varchar(9) NOT NULL default '',
`lastTimeslot` varchar(10) NOT NULL default '',
`prevStatus` varchar(9) NOT NULL default '',
`prevTimeslot` varchar(10) NOT NULL default '',
`posTimeslot` int(11) NOT NULL DEFAULT '9',
PRIMARY KEY (`catalogID`,`uKey`),
KEY `catalogID` (`catalogID`),
KEY `uKey` (`uKey`),
KEY `replicationStatus` (`replicationStatus`),
KEY `eventsChangesLogData_ibfk_1` (`catalogID`,`uKey`),
CONSTRAINT `eventsChangesLogData_ibfk_1` FOREIGN KEY (`catalogID`,`uKey`) REFERENCES `plugins` (`catalogID`,`uKey`)
) ENGINE=InnoDB;
/*Data for the table `eventsChangesLogData` */
#
# Table structure for table eventsDisplayData
#
DROP TABLE IF EXISTS `eventsDisplayData`;
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 '',
`perfdata` text,
`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`)
) ENGINE=InnoDB;
/*Data for the table `eventsDisplayData` */
/*Table structure for table `holidays` */
DROP TABLE IF EXISTS `holidays`;
CREATE TABLE `holidays` (
`catalogID` varchar(5) NOT NULL default 'CID',
`holidayID` varchar(14) NOT NULL default '0-0-0-0-00',
`formule` char(1) NOT NULL default '0',
`month` char(2) NOT NULL default '0',
`day` char(2) NOT NULL default '0',
`offset` char(3) NOT NULL default '0',
`countryID` char(2) NOT NULL default '00',
`holiday` varchar(64) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`holidayID`),
KEY `catalogID` (`catalogID`),
KEY `countryID` (`countryID`),
KEY `holiday` (`holiday`),
CONSTRAINT `holidays_ibfk_1` FOREIGN KEY (`countryID`) REFERENCES `countries` (`countryID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `holidays` */
insert into `holidays` (`catalogID`,`holidayID`,`formule`,`month`,`day`,`offset`,`countryID`,`holiday`,`activated`) values ('CID','0-1-1-0-00','0','1','1','0','00','Nieuwjaarsdag',1);
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
insert into `holidays` (`catalogID`,`holidayID`,`formule`,`month`,`day`,`offset`,`countryID`,`holiday`,`activated`) values ('CID','1-0-0-1-00','1','0','0','1','00','Paasmaandag',1);
insert into `holidays` (`catalogID`,`holidayID`,`formule`,`month`,`day`,`offset`,`countryID`,`holiday`,`activated`) values ('CID','1-0-0-39-00','1','0','0','39','00','O.L.V. Hemelvaart',1);
insert into `holidays` (`catalogID`,`holidayID`,`formule`,`month`,`day`,`offset`,`countryID`,`holiday`,`activated`) values ('CID','1-0-0-49-00','1','0','0','49','00','Pinksteren',0);
insert into `holidays` (`catalogID`,`holidayID`,`formule`,`month`,`day`,`offset`,`countryID`,`holiday`,`activated`) values ('CID','1-0-0-50-00','1','0','0','50','00','Pinkstermaandag',1);
/*Table structure for table `holidaysBundle` */
DROP TABLE IF EXISTS `holidaysBundle`;
CREATE TABLE `holidaysBundle` (
`catalogID` varchar(5) NOT NULL default 'CID',
`holidayBundleID` int(11) NOT NULL auto_increment,
`holidayBundleName` varchar(64) NOT NULL default '',
`holidayID` varchar(254) NOT NULL default '',
`countryID` char(2) NOT NULL default '00',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`holidayBundleID`),
KEY `catalogID` (`catalogID`),
KEY `holidayBundleID` (`holidayBundleID`),
KEY `holidayBundleName` (`holidayBundleName`),
KEY `holidayID` (`holidayID`),
KEY `countryID` (`countryID`),
CONSTRAINT `holidaysBundle_ibfk_1` FOREIGN KEY (`countryID`) REFERENCES `countries` (`countryID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `holidaysBundle` */
insert into `holidaysBundle` (`catalogID`,`holidayBundleID`,`holidayBundleName`,`holidayID`,`countryID`,`activated`) values ('CID',1,'None','/0-0-0-0-00/','BE',0);
insert into `holidaysBundle` (`catalogID`,`holidayBundleID`,`holidayBundleName`,`holidayID`,`countryID`,`activated`) values ('CID',2,'ASNMTAP','/0-11-1-0-00/0-11-2-0-00/0-5-1-0-00/0-9-27-0-BE/0-7-11-0-BE/0-11-15-0-BE/0-12-25-0-00/0-12-26-0-BE/0-7-21-...
/*Table structure for table `language` */
DROP TABLE IF EXISTS `language`;
CREATE TABLE `language` (
`keyLanguage` char(2) NOT NULL default '',
`languageActive` tinyint(1) NOT NULL default '0',
`languageName` varchar(16) default NULL,
`languageFamily` varchar(24) default NULL,
PRIMARY KEY (`keyLanguage`),
KEY `languageName` (`languageName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `language` */
insert into `language` (`keyLanguage`,`languageActive`,`languageName`,`languageFamily`) values ('AA',0,'Afar','Hamitic');
insert into `language` (`keyLanguage`,`languageActive`,`languageName`,`languageFamily`) values ('AB',0,'Abkhazian','Ibero-Caucasian');
insert into `language` (`keyLanguage`,`languageActive`,`languageName`,`languageFamily`) values ('AF',0,'Afrikaans','Germanic');
insert into `language` (`keyLanguage`,`languageActive`,`languageName`,`languageFamily`) values ('AM',0,'Amharic','Semitic');
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
insert into `language` (`keyLanguage`,`languageActive`,`languageName`,`languageFamily`) values ('YI',0,'Yiddish','Germanic');
insert into `language` (`keyLanguage`,`languageActive`,`languageName`,`languageFamily`) values ('YO',0,'Yoruba','Negro-african');
insert into `language` (`keyLanguage`,`languageActive`,`languageName`,`languageFamily`) values ('ZH',0,'Chinese','Asian');
insert into `language` (`keyLanguage`,`languageActive`,`languageName`,`languageFamily`) values ('ZU',0,'Zulu','Negro-african');
/*Table structure for table `pagedirs` */
DROP TABLE IF EXISTS `pagedirs`;
CREATE TABLE `pagedirs` (
`catalogID` varchar(5) NOT NULL default 'CID',
`pagedir` varchar(11) NOT NULL default '',
`groupName` varchar(64) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`pagedir`),
KEY `catalogID` (`catalogID`),
KEY `pagedir` (`pagedir`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `pagedirs` */
insert into `pagedirs` (`catalogID`,`pagedir`,`groupName`,`activated`) values ('CID','index','Production View',1);
insert into `pagedirs` (`catalogID`,`pagedir`,`groupName`,`activated`) values ('CID','test','Test View',1);
/*Table structure for table `plugins` */
DROP TABLE IF EXISTS `plugins`;
CREATE TABLE `plugins` (
`catalogID` varchar(5) NOT NULL default 'CID',
`uKey` varchar(11) NOT NULL default '',
`test` varchar(100) NOT NULL default '',
`arguments` varchar(1024) default '',
`argumentsOndemand` varchar(1024) default '',
`title` varchar(75) NOT NULL default '',
`trendline` smallint(6) NOT NULL default '0',
`shortDescription` text,
`percentage` tinyint(1) NOT NULL default '25',
`tolerance` tinyint(1) NOT NULL default '5',
`step` smallint(6) NOT NULL default '0',
`ondemand` char(1) NOT NULL default '0',
`production` char(1) NOT NULL default '0',
`environment` char(1) NOT NULL default 'L',
`pagedir` varchar(254) NOT NULL default '',
`resultsdir` varchar(64) NOT NULL default '',
`helpPluginFilename` varchar(100) default '<NIHIL>',
`holidayBundleID` int(11) default '1',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`uKey`),
KEY `catalogID` (`catalogID`),
KEY `uKey` (`uKey`),
KEY `resultsdir` (`resultsdir`),
KEY `holidayBundleID` (`holidayBundleID`),
KEY `test` (`test`),
KEY `title` (`title`),
KEY `plugins_ibfk_1` (`catalogID`,`resultsdir`),
KEY `plugins_ibfk_2` (`catalogID`,`holidayBundleID`),
CONSTRAINT `plugins_ibfk_1` FOREIGN KEY (`catalogID`, `resultsdir`) REFERENCES `resultsdir` (`catalogID`, `resultsdir`),
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
insert into `plugins` (`catalogID`,`uKey`,`test`,`arguments`,`argumentsOndemand`,`title`,`shortDescription`,`trendline`,`percentage`,`tolerance`,`step`,`ondemand`,`production`,`environment`,`pagedir`,`resultsdir`,`helpPluginFilename`,`holidayBundleID...
insert into `plugins` (`catalogID`,`uKey`,`test`,`arguments`,`argumentsOndemand`,`title`,`shortDescription`,`trendline`,`percentage`,`tolerance`,`step`,`ondemand`,`production`,`environment`,`pagedir`,`resultsdir`,`helpPluginFilename`,`holidayBundleID...
insert into `plugins` (`catalogID`,`uKey`,`test`,`arguments`,`argumentsOndemand`,`title`,`shortDescription`,`trendline`,`percentage`,`tolerance`,`step`,`ondemand`,`production`,`environment`,`pagedir`,`resultsdir`,`helpPluginFilename`,`holidayBundleID...
insert into `plugins` (`catalogID`,`uKey`,`test`,`arguments`,`argumentsOndemand`,`title`,`shortDescription`,`trendline`,`percentage`,`tolerance`,`step`,`ondemand`,`production`,`environment`,`pagedir`,`resultsdir`,`helpPluginFilename`,`holidayBundleID...
/*Table structure for table `reports` */
DROP TABLE IF EXISTS `reports`;
CREATE TABLE `reports` (
`catalogID` varchar(5) NOT NULL default 'CID',
`id` int(11) NOT NULL auto_increment,
`uKey` varchar(11) NOT NULL default '',
`reportTitle` varchar(100) NOT NULL default '',
`periode` char(1) NOT NULL default 'F',
`timeperiodID` int(11) NOT NULL default '1',
`status` tinyint(1) NOT NULL default '0',
`errorDetails` tinyint(1) NOT NULL default '0',
`bar` tinyint(1) NOT NULL default '0',
`hourlyAverage` tinyint(1) NOT NULL default '0',
`dailyAverage` tinyint(1) NOT NULL default '0',
`showDetails` tinyint(1) NOT NULL default '0',
`showComments` tinyint(1) NOT NULL default '0',
`showPerfdata` tinyint(1) NOT NULL default '0',
`showTop20SlowTests` tinyint(1) NOT NULL default '0',
`printerFriendlyOutput` tinyint(1) NOT NULL default '0',
`formatOutput` varchar(4) NOT NULL default 'pdf',
`userPassword` varchar(15) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`id`),
KEY `catalogID` (`catalogID`),
KEY `id` (`id`),
KEY `uKey` (`uKey`),
KEY `periode` (`periode`),
KEY `reportTitle` (`reportTitle`),
KEY `timeperiodID` (`timeperiodID`),
KEY `reports_ibfk_1` (`catalogID`,`uKey`),
KEY `reports_ibfk_2` (`catalogID`,`timeperiodID`),
CONSTRAINT `reports_ibfk_1` FOREIGN KEY (`catalogID`, `uKey`) REFERENCES `plugins` (`catalogID`, `uKey`),
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
/*Data for the table `reports` */
#
# Table structure for table reports_perfdata
#
DROP TABLE IF EXISTS `reports_perfdata`;
CREATE TABLE `reports_perfdata` (
`catalogID` varchar(5) NOT NULL default 'CID',
`uKey` varchar(11) NOT NULL,
`metric_id` int(11) NOT NULL default '0',
`times` varchar(64) NOT NULL,
`percentiles` varchar(64) NOT NULL,
`unit` enum('ms','s') NOT NULL default 's',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`uKey`,`metric_id`),
KEY `catalogID` (`catalogID`),
KEY `uKey` (`uKey`),
CONSTRAINT `reports_perfdata_ibfk_1` FOREIGN KEY (`catalogID`, `uKey`) REFERENCES `plugins` (`catalogID`, `uKey`)
) ENGINE=InnoDB;
/*Table structure for table `resultsdir` */
DROP TABLE IF EXISTS `resultsdir`;
CREATE TABLE `resultsdir` (
`catalogID` varchar(5) NOT NULL default 'CID',
`resultsdir` varchar(64) NOT NULL default '',
`groupName` varchar(64) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`resultsdir`),
KEY `catalogID` (`catalogID`),
KEY `groupName` (`groupName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `resultsdir` */
insert into `resultsdir` (`catalogID`,`resultsdir`,`groupName`,`activated`) values ('CID','AdminCollector','Admin Collector',1);
insert into `resultsdir` (`catalogID`,`resultsdir`,`groupName`,`activated`) values ('CID','index','Production',1);
insert into `resultsdir` (`catalogID`,`resultsdir`,`groupName`,`activated`) values ('CID','MySQL','MySQL',1);
applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql view on Meta::CPAN
insert into `resultsdir` (`catalogID`,`resultsdir`,`groupName`,`activated`) values ('CID','test-03','Subdir for DUMMY-03',1);
insert into `resultsdir` (`catalogID`,`resultsdir`,`groupName`,`activated`) values ('CID','test-04','Subdir for DUMMY-04',1);
insert into `resultsdir` (`catalogID`,`resultsdir`,`groupName`,`activated`) values ('CID','test-05','Condenced View test',1);
insert into `resultsdir` (`catalogID`,`resultsdir`,`groupName`,`activated`) values ('CID','test','CLUSTER',1);
/*Table structure for table `servers` */
DROP TABLE IF EXISTS `servers`;
CREATE TABLE `servers` (
`catalogID` varchar(5) NOT NULL default 'CID',
`serverID` varchar(11) NOT NULL default '',
`serverTitle` varchar(64) default NULL,
`typeServers` tinyint(1) NOT NULL default '0',
`typeMonitoring` tinyint(1) NOT NULL default '0',
`typeActiveServer` char(1) NOT NULL DEFAULT 'M',
`masterFQDN` varchar(64) default NULL,
`masterASNMTAP_PATH` varchar(64) NOT NULL default '/opt/asnmtap',
`masterRSYNC_PATH` varchar(64) NOT NULL default '/usr/local/bin',
`masterSSH_PATH` varchar(64) NOT NULL default '/usr/bin',
`masterSSHlogon` varchar(15) default NULL,
`masterSSHpasswd` varchar(32) default NULL,
`masterDatabaseFQDN` varchar(64) NOT NULL default 'chablis.dvkhosting.com',
`masterDatabasePort` varchar(4) NOT NULL default '3306',
`slaveFQDN` varchar(64) default NULL,
`slaveASNMTAP_PATH` varchar(64) NOT NULL default '/opt/asnmtap',
`slaveRSYNC_PATH` varchar(64) NOT NULL default '/usr/local/bin',
`slaveSSH_PATH` varchar(64) NOT NULL default '/usr/bin',
`slaveSSHlogon` varchar(15) default NULL,
`slaveSSHpasswd` varchar(32) default NULL,
`slaveDatabaseFQDN` varchar(64) NOT NULL default 'chablis.dvkhosting.com',
`slaveDatabasePort` varchar(4) NOT NULL default '3306',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`serverID`),
KEY `catalogID` (`catalogID`),
KEY `serverTitle` (`serverTitle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `servers` */
insert into `servers` (`catalogID`,`serverID`,`serverTitle`,`typeServers`,`typeMonitoring`, `typeActiveServer`,`masterFQDN`,`masterASNMTAP_PATH`,`masterRSYNC_PATH`,`masterSSH_PATH`,`masterSSHlogon`,`masterSSHpasswd`,`masterDatabaseFQDN`,`masterDataba...
insert into `servers` (`catalogID`,`serverID`,`serverTitle`,`typeServers`,`typeMonitoring`, `typeActiveServer`,`masterFQDN`,`masterASNMTAP_PATH`,`masterRSYNC_PATH`,`masterSSH_PATH`,`masterSSHlogon`,`masterSSHpasswd`,`masterDatabaseFQDN`,`masterDataba...
insert into `servers` (`catalogID`,`serverID`,`serverTitle`,`typeServers`,`typeMonitoring`, `typeActiveServer`,`masterFQDN`,`masterASNMTAP_PATH`,`masterRSYNC_PATH`,`masterSSH_PATH`,`masterSSHlogon`,`masterSSHpasswd`,`masterDatabaseFQDN`,`masterDataba...
/*Table structure for table `timeperiods` */
DROP TABLE IF EXISTS `timeperiods`;
CREATE TABLE `timeperiods` (
`catalogID` varchar(5) NOT NULL default 'CID',
`timeperiodID` int(11) NOT NULL auto_increment,
`timeperiodAlias` varchar(24) NOT NULL default '',
`timeperiodName` varchar(64) NOT NULL default '',
`sunday` varchar(36) default NULL,
`monday` varchar(36) default NULL,
`tuesday` varchar(36) default NULL,
`wednesday` varchar(36) default NULL,
`thursday` varchar(36) default NULL,
`friday` varchar(36) default NULL,
`saturday` varchar(36) default NULL,
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`timeperiodID`),
KEY `catalogID` (`catalogID`),
KEY `timeperiodID` (`timeperiodID`),
KEY `timeperiodName` (`timeperiodName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `timeperiods` */
insert into `timeperiods` (`catalogID`,`timeperiodID`,`timeperiodAlias`,`timeperiodName`,`sunday`,`monday`,`tuesday`,`wednesday`,`thursday`,`friday`,`saturday`,`activated`) values ('CID',1,'24x7','24 Hours A Day, 7 Days A Week','','','','','','','',1...
insert into `timeperiods` (`catalogID`,`timeperiodID`,`timeperiodAlias`,`timeperiodName`,`sunday`,`monday`,`tuesday`,`wednesday`,`thursday`,`friday`,`saturday`,`activated`) values ('CID',2,'WorkingHours','Working Hours','','09:00-17:00','09:00-17:00'...
insert into `timeperiods` (`catalogID`,`timeperiodID`,`timeperiodAlias`,`timeperiodName`,`sunday`,`monday`,`tuesday`,`wednesday`,`thursday`,`friday`,`saturday`,`activated`) values ('CID',3,'Non-WorkingHours','Non-Working Hours','00:00-24:00','00:00-0...
/*Table structure for table `titles` */
DROP TABLE IF EXISTS `titles`;
CREATE TABLE `titles` (
`cKeyTitle` varchar(7) NOT NULL default '',
`keyTitle` varchar(4) default NULL,
`keyLanguage` char(2) default NULL,
`titleActive` tinyint(1) NOT NULL default '0',
`titleName` varchar(64) default NULL,
PRIMARY KEY (`cKeyTitle`),
KEY `keyTitle` (`keyTitle`),
KEY `keyLanguage` (`keyLanguage`),
CONSTRAINT `titles_ibfk_1` FOREIGN KEY (`keyLanguage`) REFERENCES `language` (`keyLanguage`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `titles` */
/*Table structure for table `users` */
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`catalogID` varchar(5) NOT NULL default 'CID',
`remoteUser` varchar(15) NOT NULL default '',
`remoteAddr` varchar(15) NOT NULL default '',
`remoteNetmask` char(2) NOT NULL default '',
`givenName` varchar(50) NOT NULL default '',
`familyName` varchar(50) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`downtimeScheduling` tinyint(1) NOT NULL default '1',
`generatedReports` tinyint(1) NOT NULL default '0',
`password` varchar(32) NOT NULL default '',
`userType` char(1) NOT NULL default '',
`pagedir` varchar(254) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
`keyLanguage` char(2) NOT NULL default '',
PRIMARY KEY (`catalogID`,`remoteUser`),
KEY `catalogID` (`catalogID`),
KEY `keyLanguage` (`keyLanguage`),
KEY `remoteUser` (`remoteUser`),
CONSTRAINT `users_ibfk_1` FOREIGN KEY (`keyLanguage`) REFERENCES `language` (`keyLanguage`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `users` */
insert into `users` (`catalogID`,`remoteUser`,`remoteAddr`,`remoteNetmask`,`givenName`,`familyName`,`email`,`downtimeScheduling`,`generatedReports`,`password`,`userType`,`pagedir`,`activated`,`keyLanguage`) values ('CID','admin','','','admin','admini...
insert into `users` (`catalogID`,`remoteUser`,`remoteAddr`,`remoteNetmask`,`givenName`,`familyName`,`email`,`downtimeScheduling`,`generatedReports`,`password`,`userType`,`pagedir`,`activated`,`keyLanguage`) values ('CID','guest','','','test','user','...
insert into `users` (`catalogID`,`remoteUser`,`remoteAddr`,`remoteNetmask`,`givenName`,`familyName`,`email`,`downtimeScheduling`,`generatedReports`,`password`,`userType`,`pagedir`,`activated`,`keyLanguage`) values ('CID','member','','','test','user',...
insert into `users` (`catalogID`,`remoteUser`,`remoteAddr`,`remoteNetmask`,`givenName`,`familyName`,`email`,`downtimeScheduling`,`generatedReports`,`password`,`userType`,`pagedir`,`activated`,`keyLanguage`) values ('CID','sadmin','','','sadmin','serv...
/*Table structure for table `views` */
DROP TABLE IF EXISTS `views`;
CREATE TABLE `views` (
`catalogID` varchar(5) NOT NULL default 'CID',
`uKey` varchar(11) NOT NULL default '',
`displayDaemon` varchar(64) NOT NULL default '',
`displayGroupID` int(11) NOT NULL default '1',
`timeperiodID` INT(11) NOT NULL DEFAULT '1',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`uKey`,`displayDaemon`),
KEY `displayDaemon` (`displayDaemon`),
KEY `displayGroupID` (`displayGroupID`),
KEY `uKey` (`uKey`),
KEY `timeperiodID` (`timeperiodID`),
KEY `views_ibfk_1` (`catalogID`,`displayDaemon`),
KEY `views_ibfk_2` (`catalogID`,`displayGroupID`),
KEY `views_ibfk_3` (`catalogID`,`uKey`),
KEY `views_ibfk_4` (`catalogID`,`timeperiodID`),
CONSTRAINT `views_ibfk_1` FOREIGN KEY (`catalogID`, `displayDaemon`) REFERENCES `displayDaemons` (`catalogID`, `displayDaemon`),
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
SET FOREIGN_KEY_CHECKS=0;
#
# Table structure for table catalog
#
DROP TABLE IF EXISTS `catalog`;
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',
`databaseFQDN` varchar(64) NOT NULL default 'localhost',
`databasePort` varchar(4) NOT NULL default '3306',
`lastEventsID` int(11) NOT NULL default '0',
`lastCommentsID` int(11) NOT NULL default '0',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`),
KEY `catalogName` (`catalogName`)
) ENGINE=InnoDB;
#
# Data for the table catalog
#
insert into `catalog` (`catalogID`,`catalogName`,`catalogType`,`databaseFQDN`,`databasePort`,`lastEventsID`,`lastCommentsID`,`activated`) values ('CID','Central System Enterprise','central','localhost','3306',0,0,1);
#
# Table structure for table collectorDaemons
#
DROP TABLE IF EXISTS `collectorDaemons`;
CREATE TABLE `collectorDaemons` (
`catalogID` varchar(5) NOT NULL default 'CID',
`collectorDaemon` varchar(64) NOT NULL default '',
`groupName` varchar(64) NOT NULL default '',
`serverID` varchar(11) NOT NULL default '',
`mode` char(1) NOT NULL default 'C',
`dumphttp` char(1) NOT NULL default 'N',
`status` char(1) NOT NULL default 'N',
`debugDaemon` char(1) NOT NULL default 'F',
`debugAllScreen` char(1) NOT NULL default 'F',
`debugAllFile` char(1) NOT NULL default 'F',
`debugNokFile` char(1) NOT NULL default 'F',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`collectorDaemon`),
KEY `catalogID` (`catalogID`),
KEY `serverID` (`serverID`),
KEY `collectorDaemon` (`collectorDaemon`),
KEY `collectorDaemons_ibfk_1` (`catalogID`,`serverID`),
CONSTRAINT `collectorDaemons_ibfk_1` FOREIGN KEY (`catalogID`, `serverID`) REFERENCES `servers` (`catalogID`, `serverID`)
) ENGINE=InnoDB;
#
# Data for the table collectorDaemons
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `collectorDaemons` values ('CID','index','Production Daemon','CTP-CENTRAL','C','U','N','F','F','F','F',0);
insert into `collectorDaemons` values ('CID','test','Test Daemon','CTP-CENTRAL','C','U','N','F','F','F','F',1);
#
# Table structure for table comments
#
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
`catalogID` varchar(5) NOT NULL default 'CID',
`id` int(11) NOT NULL auto_increment,
`uKey` varchar(11) NOT NULL default '',
`replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I',
`title` varchar(75) NOT NULL default '',
`remoteUser` varchar(11) NOT NULL default '',
`instability` tinyint(1) NOT NULL default '0',
`persistent` tinyint(1) NOT NULL default '0',
`downtime` tinyint(1) NOT NULL default '0',
`entryDate` date NOT NULL default '0000-00-00',
`entryTime` time NOT NULL default '00:00:00',
`entryTimeslot` varchar(10) NOT NULL default '0000000000',
`activationDate` date NOT NULL default '0000-00-00',
`activationTime` time NOT NULL default '00:00:00',
`activationTimeslot` varchar(10) NOT NULL default '0000000000',
`suspentionDate` date NOT NULL default '0000-00-00',
`suspentionTime` time NOT NULL default '00:00:00',
`suspentionTimeslot` varchar(10) NOT NULL default '9999999999',
`solvedDate` date NOT NULL default '0000-00-00',
`solvedTime` time NOT NULL default '00:00:00',
`solvedTimeslot` varchar(10) NOT NULL default '0000000000',
`problemSolved` tinyint(1) NOT NULL default '1',
`commentData` blob NOT NULL,
PRIMARY KEY (`catalogID`,`id`),
KEY `catalogID` (`catalogID`),
KEY `id` (`id`),
KEY `uKey` (`uKey`),
KEY `replicationStatus` (`replicationStatus`),
KEY `remoteUser` (`remoteUser`),
KEY `persistent` (`persistent`),
KEY `downtime` (`downtime`),
KEY `entryTimeslot` (`entryTimeslot`),
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`catalogID`, `remoteUser`) REFERENCES `users` (`catalogID`, `remoteUser`)
) ENGINE=InnoDB;
#
# Table structure for table countries
#
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
`countryID` char(2) NOT NULL default '',
`countryName` varchar(45) default NULL,
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`countryID`),
KEY `countryName` (`countryName`)
) ENGINE=InnoDB;
#
# Data for the table countries
#
insert into `countries` values ('00','+ All Countries',1);
insert into `countries` values ('AD','Andorra',0);
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `countries` values ('ZR','Zaire',0);
insert into `countries` values ('ZW','Zimbabwe',0);
#
# Table structure for table crontabs
#
DROP TABLE IF EXISTS `crontabs`;
CREATE TABLE `crontabs` (
`catalogID` varchar(5) NOT NULL default 'CID',
`lineNumber` char(2) NOT NULL default '',
`uKey` varchar(11) NOT NULL default '',
`collectorDaemon` varchar(64) NOT NULL default '',
`arguments` varchar(1024) default '',
`minute` varchar(167) NOT NULL default '*',
`hour` varchar(61) NOT NULL default '*',
`dayOfTheMonth` varchar(83) NOT NULL default '*',
`monthOfTheYear` varchar(26) NOT NULL default '*',
`dayOfTheWeek` varchar(13) NOT NULL default '*',
`noOffline` varchar(12) default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`lineNumber`,`uKey`),
KEY `catalogID` (`catalogID`),
KEY `uKey` (`uKey`),
KEY `collectorDaemon` (`collectorDaemon`),
KEY `crontabs_ibfk_1` (`catalogID`,`collectorDaemon`),
KEY `crontabs_ibfk_2` (`catalogID`,`uKey`),
CONSTRAINT `crontabs_ibfk_1` FOREIGN KEY (`catalogID`, `collectorDaemon`) REFERENCES `collectorDaemons` (`catalogID`, `collectorDaemon`),
CONSTRAINT `crontabs_ibfk_2` FOREIGN KEY (`catalogID`, `uKey`) REFERENCES `plugins` (`catalogID`, `uKey`)
) ENGINE=InnoDB;
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `crontabs` (`catalogID`,`lineNumber`,`uKey`,`collectorDaemon`,`arguments`,`minute`,`hour`,`dayOfTheMonth`,`monthOfTheYear`,`dayOfTheWeek`,`noOffline`,`activated`) values ('CID','00','zCLUSTER-42','test','','*/2','*','*','*','*','',1);
insert into `crontabs` (`catalogID`,`lineNumber`,`uKey`,`collectorDaemon`,`arguments`,`minute`,`hour`,`dayOfTheMonth`,`monthOfTheYear`,`dayOfTheWeek`,`noOffline`,`activated`) values ('CID','00','zCLUSTER-43','test','','*/2','*','*','*','*','',1);
#
# Table structure for table displayDaemons
#
DROP TABLE IF EXISTS `displayDaemons`;
CREATE TABLE `displayDaemons` (
`catalogID` varchar(5) NOT NULL default 'CID',
`displayDaemon` varchar(64) NOT NULL default '',
`groupName` varchar(64) NOT NULL default '',
`pagedir` varchar(11) NOT NULL default '',
`serverID` varchar(11) NOT NULL default '',
`loop` char(1) NOT NULL default 'T',
`trigger` char(1) NOT NULL default 'T',
`displayTime` char(1) NOT NULL default 'T',
`lockMySQL` char(1) NOT NULL default 'F',
`debugDaemon` char(1) NOT NULL default 'F',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`displayDaemon`),
KEY `catalogID` (`catalogID`),
KEY `serverID` (`serverID`),
KEY `pagedir` (`catalogID`,`pagedir`),
KEY `displayDaemon` (`displayDaemon`),
KEY `displayDaemons_ibfk_2` (`catalogID`,`serverID`),
CONSTRAINT `displayDaemons_ibfk_1` FOREIGN KEY (`catalogID`, `pagedir`) REFERENCES `pagedirs` (`catalogID`, `pagedir`),
CONSTRAINT `displayDaemons_ibfk_2` FOREIGN KEY (`catalogID`, `serverID`) REFERENCES `servers` (`catalogID`, `serverID`)
) ENGINE=InnoDB;
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `displayDaemons` values ('CID','index','Production Daemon','index','CTP-CENTRAL','T','F','T','F','F',0);
insert into `displayDaemons` values ('CID','test','Test Daemon','test','CTP-CENTRAL','T','F','T','F','F',1);
#
# Table structure for table displayGroups
#
DROP TABLE IF EXISTS `displayGroups`;
CREATE TABLE `displayGroups` (
`catalogID` varchar(5) NOT NULL default 'CID',
`displayGroupID` int(11) NOT NULL auto_increment,
`groupTitle` varchar(100) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`displayGroupID`),
KEY `catalogID` (`catalogID`),
KEY `displayGroupID` (`displayGroupID`),
KEY `groupTitle` (`groupTitle`)
) ENGINE=InnoDB;
#
# Data for the table displayGroups
#
insert into `displayGroups` values ('CID',1,'Testing Collector & Display for the \'Application Monitor\'',1);
insert into `displayGroups` values ('CID',2,'Condenced View Test',1);
#
# Table structure for table environment
#
DROP TABLE IF EXISTS `environment`;
CREATE TABLE `environment` (
`environment` char(1) NOT NULL default 'L',
`label` varchar(12) default 'Local',
PRIMARY KEY (`environment`)
) ENGINE=InnoDB;
#
# Data for the table environment
#
insert into `environment` values ('P','Production');
insert into `environment` values ('S','Simulation');
insert into `environment` values ('A','Acceptation');
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `environment` values ('D','Development');
insert into `environment` values ('L','Local');
#
# Table structure for table events
#
DROP TABLE IF EXISTS `events`;
CREATE TABLE `events` (
`catalogID` varchar(5) NOT NULL default 'CID',
`id` int(11) NOT NULL auto_increment,
`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 '',
`perfdata` text,
`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`,`id`),
KEY `catalogID` (`catalogID`),
KEY `id` (`id`),
KEY `uKey` (`uKey`),
KEY `replicationStatus` (`replicationStatus`),
KEY `key_test` (`test`),
KEY `key_status` (`status`),
KEY `key_startDate` (`startDate`),
KEY `key_startTime` (`startTime`),
KEY `key_endDate` (`endDate`),
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
CONSTRAINT `events_ibfk_1` FOREIGN KEY (`catalogID`,`uKey`) REFERENCES `plugins` (`catalogID`,`uKey`)
) ENGINE=InnoDB;
#
# Table structure for table eventsChangesLogData
#
DROP TABLE IF EXISTS `eventsChangesLogData`;
CREATE TABLE `eventsChangesLogData` (
`catalogID` varchar(5) NOT NULL default 'CID',
`uKey` varchar(11) NOT NULL default '',
`replicationStatus` ENUM('I','U','R') NOT NULL DEFAULT 'I',
`lastStatus` varchar(9) NOT NULL default '',
`lastTimeslot` varchar(10) NOT NULL default '',
`prevStatus` varchar(9) NOT NULL default '',
`prevTimeslot` varchar(10) NOT NULL default '',
`posTimeslot` int(11) NOT NULL DEFAULT '9',
PRIMARY KEY (`catalogID`,`uKey`),
KEY `catalogID` (`catalogID`),
KEY `uKey` (`uKey`),
KEY `replicationStatus` (`replicationStatus`),
KEY `eventsChangesLogData_ibfk_1` (`catalogID`,`uKey`),
CONSTRAINT `eventsChangesLogData_ibfk_1` FOREIGN KEY (`catalogID`,`uKey`) REFERENCES `plugins` (`catalogID`,`uKey`)
) ENGINE=InnoDB;
#
# Table structure for table eventsDisplayData
#
DROP TABLE IF EXISTS `eventsDisplayData`;
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 '',
`perfdata` text,
`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`)
) ENGINE=InnoDB;
/*Data for the table `eventsDisplayData` */
#
# Table structure for table holidays
#
DROP TABLE IF EXISTS `holidays`;
CREATE TABLE `holidays` (
`catalogID` varchar(5) NOT NULL default 'CID',
`holidayID` varchar(14) NOT NULL default '0-0-0-0-00',
`formule` char(1) NOT NULL default '0',
`month` char(2) NOT NULL default '0',
`day` char(2) NOT NULL default '0',
`offset` char(3) NOT NULL default '0',
`countryID` char(2) NOT NULL default '00',
`holiday` varchar(64) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`holidayID`),
KEY `catalogID` (`catalogID`),
KEY `countryID` (`countryID`),
KEY `holiday` (`holiday`),
CONSTRAINT `holidays_ibfk_1` FOREIGN KEY (`countryID`) REFERENCES `countries` (`countryID`)
) ENGINE=InnoDB;
#
# Data for the table holidays
#
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `holidays` values ('CID','0-11-11-0-BE','0','11','11','0','BE','Wapenstilstand',1);
#
# Table structure for table holidaysBundle
#
DROP TABLE IF EXISTS `holidaysBundle`;
CREATE TABLE `holidaysBundle` (
`catalogID` varchar(5) NOT NULL default 'CID',
`holidayBundleID` int(11) NOT NULL auto_increment,
`holidayBundleName` varchar(64) NOT NULL default '',
`holidayID` varchar(254) NOT NULL default '',
`countryID` char(2) NOT NULL default '00',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`holidayBundleID`),
KEY `catalogID` (`catalogID`),
KEY `holidayBundleID` (`holidayBundleID`),
KEY `holidayBundleName` (`holidayBundleName`),
KEY `holidayID` (`holidayID`),
KEY `countryID` (`countryID`),
CONSTRAINT `holidaysBundle_ibfk_1` FOREIGN KEY (`countryID`) REFERENCES `countries` (`countryID`)
) ENGINE=InnoDB;
#
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `holidaysBundle` values ('CID',1,'None','/0-0-0-0-00/','BE',0);
insert into `holidaysBundle` values ('CID',2,'ASNMTAP','/0-11-1-0-00/0-11-2-0-00/0-5-1-0-00/0-9-27-0-BE/0-7-11-0-BE/0-11-15-0-BE/0-12-25-0-00/0-12-26-0-BE/0-7-21-0-BE/0-1-1-0-00/0-8-15-0-00/1-0-0-39-00/1-0-0-1-00/1-0-0-0-00/1-0-0-49-00/1-0-0-50-00/0-...
#
# Table structure for table language
#
DROP TABLE IF EXISTS `language`;
CREATE TABLE `language` (
`keyLanguage` char(2) NOT NULL default '',
`languageActive` tinyint(1) NOT NULL default '0',
`languageName` varchar(16) default NULL,
`languageFamily` varchar(24) default NULL,
PRIMARY KEY (`keyLanguage`),
KEY `languageName` (`languageName`)
) ENGINE=InnoDB;
#
# Data for the table language
#
insert into `language` values ('AA',0,'Afar','Hamitic');
insert into `language` values ('AB',0,'Abkhazian','Ibero-Caucasian');
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `language` values ('ZH',0,'Chinese','Asian');
insert into `language` values ('ZU',0,'Zulu','Negro-african');
#
# Table structure for table pagedirs
#
DROP TABLE IF EXISTS `pagedirs`;
CREATE TABLE `pagedirs` (
`catalogID` varchar(5) NOT NULL default 'CID',
`pagedir` varchar(11) NOT NULL default '',
`groupName` varchar(64) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`pagedir`),
KEY `catalogID` (`catalogID`),
KEY `pagedir` (`pagedir`)
) ENGINE=InnoDB;
#
# Data for the table pagedirs
#
insert into `pagedirs` values ('CID','index','Production View',1);
insert into `pagedirs` values ('CID','test','Test View',1);
#
# Table structure for table plugins
#
DROP TABLE IF EXISTS `plugins`;
CREATE TABLE `plugins` (
`catalogID` varchar(5) NOT NULL default 'CID',
`uKey` varchar(11) NOT NULL default '',
`test` varchar(100) NOT NULL default '',
`arguments` varchar(1024) default '',
`argumentsOndemand` varchar(1024) default '',
`title` varchar(75) NOT NULL default '',
`trendline` smallint(6) NOT NULL default '0',
`shortDescription` text,
`percentage` tinyint(1) NOT NULL default '25',
`tolerance` tinyint(1) NOT NULL default '5',
`step` smallint(6) NOT NULL default '0',
`ondemand` char(1) NOT NULL default '0',
`production` char(1) NOT NULL default '0',
`environment` char(1) NOT NULL default 'L',
`pagedir` varchar(254) NOT NULL default '',
`resultsdir` varchar(64) NOT NULL default '',
`helpPluginFilename` varchar(100) default '<NIHIL>',
`holidayBundleID` int(11) default '1',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`uKey`),
KEY `catalogID` (`catalogID`),
KEY `uKey` (`uKey`),
KEY `resultsdir` (`resultsdir`),
KEY `holidayBundleID` (`holidayBundleID`),
KEY `test` (`test`),
KEY `title` (`title`),
KEY `plugins_ibfk_1` (`catalogID`,`resultsdir`),
KEY `plugins_ibfk_2` (`catalogID`,`holidayBundleID`),
CONSTRAINT `plugins_ibfk_1` FOREIGN KEY (`catalogID`, `resultsdir`) REFERENCES `resultsdir` (`catalogID`, `resultsdir`),
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `plugins` (`catalogID`,`uKey`,`test`,`arguments`,`argumentsOndemand`,`title`,`shortDescription`,`trendline`,`percentage`,`tolerance`,`step`,`ondemand`,`production`,`environment`,`pagedir`,`resultsdir`,`helpPluginFilename`,`holidayBundleID...
insert into `plugins` (`catalogID`,`uKey`,`test`,`arguments`,`argumentsOndemand`,`title`,`shortDescription`,`trendline`,`percentage`,`tolerance`,`step`,`ondemand`,`production`,`environment`,`pagedir`,`resultsdir`,`helpPluginFilename`,`holidayBundleID...
#
# Table structure for table reports
#
DROP TABLE IF EXISTS `reports`;
CREATE TABLE `reports` (
`catalogID` varchar(5) NOT NULL default 'CID',
`id` int(11) NOT NULL auto_increment,
`uKey` varchar(11) NOT NULL default '',
`reportTitle` varchar(100) NOT NULL default '',
`periode` char(1) NOT NULL default 'F',
`timeperiodID` int(11) NOT NULL default '1',
`status` tinyint(1) NOT NULL default '0',
`errorDetails` tinyint(1) NOT NULL default '0',
`bar` tinyint(1) NOT NULL default '0',
`hourlyAverage` tinyint(1) NOT NULL default '0',
`dailyAverage` tinyint(1) NOT NULL default '0',
`showDetails` tinyint(1) NOT NULL default '0',
`showComments` tinyint(1) NOT NULL default '0',
`showPerfdata` tinyint(1) NOT NULL default '0',
`showTop20SlowTests` tinyint(1) NOT NULL default '0',
`printerFriendlyOutput` tinyint(1) NOT NULL default '0',
`formatOutput` varchar(4) NOT NULL default 'pdf',
`userPassword` varchar(15) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`id`),
KEY `catalogID` (`catalogID`),
KEY `id` (`id`),
KEY `uKey` (`uKey`),
KEY `periode` (`periode`),
KEY `reportTitle` (`reportTitle`),
KEY `timeperiodID` (`timeperiodID`),
KEY `reports_ibfk_1` (`catalogID`,`uKey`),
KEY `reports_ibfk_2` (`catalogID`,`timeperiodID`),
CONSTRAINT `reports_ibfk_1` FOREIGN KEY (`catalogID`, `uKey`) REFERENCES `plugins` (`catalogID`, `uKey`),
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `reports` values ('CID',1,'DUMMY-T2','','M',1,0,1,1,1,0,0,1,1,1,1,'pdf','',1);
#
# Table structure for table reports_perfdata
#
DROP TABLE IF EXISTS `reports_perfdata`;
CREATE TABLE `reports_perfdata` (
`catalogID` varchar(5) NOT NULL default 'CID',
`uKey` varchar(11) NOT NULL,
`metric_id` int(11) NOT NULL default '0',
`times` varchar(64) NOT NULL,
`percentiles` varchar(64) NOT NULL,
`unit` enum('ms','s') NOT NULL default 's',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`uKey`,`metric_id`),
KEY `catalogID` (`catalogID`),
KEY `uKey` (`uKey`),
CONSTRAINT `reports_perfdata_ibfk_1` FOREIGN KEY (`catalogID`, `uKey`) REFERENCES `plugins` (`catalogID`, `uKey`)
) ENGINE=InnoDB;
#
# Table structure for table resultsdir
#
DROP TABLE IF EXISTS `resultsdir`;
CREATE TABLE `resultsdir` (
`catalogID` varchar(5) NOT NULL default 'CID',
`resultsdir` varchar(64) NOT NULL default '',
`groupName` varchar(64) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`resultsdir`),
KEY `catalogID` (`catalogID`),
KEY `groupName` (`groupName`)
) ENGINE=InnoDB;
#
# Data for the table resultsdir
#
insert into `resultsdir` values ('CID','index','Production',1);
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `resultsdir` values ('CID','test-05','Condenced View test',1);
insert into `resultsdir` values ('CID','test','CLUSTER',1);
#
# Table structure for table servers
#
DROP TABLE IF EXISTS `servers`;
CREATE TABLE `servers` (
`catalogID` varchar(5) NOT NULL default 'CID',
`serverID` varchar(11) NOT NULL default '',
`serverTitle` varchar(64) default NULL,
`typeServers` tinyint(1) NOT NULL default '0',
`typeMonitoring` tinyint(1) NOT NULL default '0',
`typeActiveServer` char(1) NOT NULL DEFAULT 'M',
`masterFQDN` varchar(64) default NULL,
`masterASNMTAP_PATH` varchar(64) NOT NULL default '/opt/asnmtap',
`masterRSYNC_PATH` varchar(64) NOT NULL default '/usr/local/bin',
`masterSSH_PATH` varchar(64) NOT NULL default '/usr/bin',
`masterSSHlogon` varchar(15) default NULL,
`masterSSHpasswd` varchar(32) default NULL,
`masterDatabaseFQDN` varchar(64) NOT NULL default 'chablis.dvkhosting.com',
`masterDatabasePort` varchar(4) NOT NULL default '3306',
`slaveFQDN` varchar(64) default NULL,
`slaveASNMTAP_PATH` varchar(64) NOT NULL default '/opt/asnmtap',
`slaveRSYNC_PATH` varchar(64) NOT NULL default '/usr/local/bin',
`slaveSSH_PATH` varchar(64) NOT NULL default '/usr/bin',
`slaveSSHlogon` varchar(15) default NULL,
`slaveSSHpasswd` varchar(32) default NULL,
`slaveDatabaseFQDN` varchar(64) NOT NULL default 'chablis.dvkhosting.com',
`slaveDatabasePort` varchar(4) NOT NULL default '3306',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`serverID`),
KEY `catalogID` (`catalogID`),
KEY `serverTitle` (`serverTitle`)
) ENGINE=InnoDB;
#
# Data for the table servers
#
insert into `servers` (`catalogID`,`serverID`,`serverTitle`,`typeServers`,`typeMonitoring`, `typeActiveServer`,`masterFQDN`,`masterASNMTAP_PATH`,`masterRSYNC_PATH`,`masterSSH_PATH`,`masterSSHlogon`,`masterSSHpasswd`,`masterDatabaseFQDN`,`masterDataba...
#
# Table structure for table timeperiods
#
DROP TABLE IF EXISTS `timeperiods`;
CREATE TABLE `timeperiods` (
`catalogID` varchar(5) NOT NULL default 'CID',
`timeperiodID` int(11) NOT NULL auto_increment,
`timeperiodAlias` varchar(24) NOT NULL default '',
`timeperiodName` varchar(64) NOT NULL default '',
`sunday` varchar(36) default NULL,
`monday` varchar(36) default NULL,
`tuesday` varchar(36) default NULL,
`wednesday` varchar(36) default NULL,
`thursday` varchar(36) default NULL,
`friday` varchar(36) default NULL,
`saturday` varchar(36) default NULL,
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`timeperiodID`),
KEY `catalogID` (`catalogID`),
KEY `timeperiodID` (`timeperiodID`),
KEY `timeperiodName` (`timeperiodName`)
) TYPE=InnoDB;
#
# Data for the table timeperiods
#
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `timeperiods` values ('CID',2,'WorkingHours','Working Hours','','09:00-17:00','09:00-17:00','09:00-17:00','09:00-17:00','09:00-17:00','',1);
insert into `timeperiods` values ('CID',3,'Non-WorkingHours','Non-Working Hours','00:00-24:00','00:00-09:00,17:00-24:00','00:00-09:00,17:00-24:00','00:00-09:00,17:00-24:00','00:00-09:00,17:00-24:00','00:00-09:00,17:00-24:00','00:00-24:00',1);
#
# Table structure for table titles
#
DROP TABLE IF EXISTS `titles`;
CREATE TABLE `titles` (
`cKeyTitle` varchar(7) NOT NULL default '',
`keyTitle` varchar(4) default NULL,
`keyLanguage` char(2) default NULL,
`titleActive` tinyint(1) NOT NULL default '0',
`titleName` varchar(64) default NULL,
PRIMARY KEY (`cKeyTitle`),
KEY `keyTitle` (`keyTitle`),
KEY `keyLanguage` (`keyLanguage`),
CONSTRAINT `titles_ibfk_1` FOREIGN KEY (`keyLanguage`) REFERENCES `language` (`keyLanguage`)
) ENGINE=InnoDB;
#
# Data for the table titles
#
#
# Table structure for table users
#
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`catalogID` varchar(5) NOT NULL default 'CID',
`remoteUser` varchar(15) NOT NULL default '',
`remoteAddr` varchar(15) NOT NULL default '',
`remoteNetmask` char(2) NOT NULL default '',
`givenName` varchar(50) NOT NULL default '',
`familyName` varchar(50) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`downtimeScheduling` tinyint(1) NOT NULL default '1',
`generatedReports` tinyint(1) NOT NULL default '0',
`password` varchar(32) NOT NULL default '',
`userType` char(1) NOT NULL default '',
`pagedir` varchar(254) NOT NULL default '',
`activated` tinyint(1) NOT NULL default '0',
`keyLanguage` char(2) NOT NULL default '',
PRIMARY KEY (`catalogID`,`remoteUser`),
KEY `catalogID` (`catalogID`),
KEY `keyLanguage` (`keyLanguage`),
KEY `remoteUser` (`remoteUser`),
CONSTRAINT `users_ibfk_1` FOREIGN KEY (`keyLanguage`) REFERENCES `language` (`keyLanguage`)
) ENGINE=InnoDB;
#
# Data for the table users
#
applications/tools/mysql/asnmtap-3.002.003_mysql-v5.0.x.sql view on Meta::CPAN
insert into `users` values ('CID','member','','','test','user','info@citap.com',1,0,'2157d29d0465deacbe112062f5947e1c','1','/index/test/',1,'EN');
insert into `users` values ('CID','sadmin','','','sadmin','server administrator','alex.peeters@citap.com',1,0,'2157d29d0465deacbe112062f5947e1c','8','/test/',1,'EN');
#
# Table structure for table views
#
DROP TABLE IF EXISTS `views`;
CREATE TABLE `views` (
`catalogID` varchar(5) NOT NULL default 'CID',
`uKey` varchar(11) NOT NULL default '',
`displayDaemon` varchar(64) NOT NULL default '',
`displayGroupID` int(11) NOT NULL default '1',
`timeperiodID` INT(11) NOT NULL DEFAULT '1',
`activated` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`catalogID`,`uKey`,`displayDaemon`),
KEY `displayDaemon` (`displayDaemon`),
KEY `displayGroupID` (`displayGroupID`),
KEY `uKey` (`uKey`),
KEY `timeperiodID` (`timeperiodID`),
KEY `views_ibfk_1` (`catalogID`,`displayDaemon`),
KEY `views_ibfk_2` (`catalogID`,`displayGroupID`),
KEY `views_ibfk_3` (`catalogID`,`uKey`),
KEY `views_ibfk_4` (`catalogID`,`timeperiodID`),
CONSTRAINT `views_ibfk_1` FOREIGN KEY (`catalogID`, `displayDaemon`) REFERENCES `displayDaemons` (`catalogID`, `displayDaemon`),
applications/tools/resources/CalendarPopup-combined.js view on Meta::CPAN
}
window.popupWindowOldEventListener = document.onmouseup;
if (window.popupWindowOldEventListener != null) {
document.onmouseup = new Function("window.popupWindowOldEventListener(); PopupWindow_hidePopupWindows();");
}
else {
document.onmouseup = PopupWindow_hidePopupWindows;
}
}
// CONSTRUCTOR for the PopupWindow object
// Pass it a DIV name to use a DHTML popup, otherwise will default to window popup
function PopupWindow() {
if (!window.popupWindowIndex) { window.popupWindowIndex = 0; }
if (!window.popupWindowObjects) { window.popupWindowObjects = new Array(); }
if (!window.listenerAttached) {
window.listenerAttached = true;
PopupWindow_attachListener();
}
this.index = popupWindowIndex++;
popupWindowObjects[this.index] = this;
this.divName = null;
applications/tools/resources/CalendarPopup-combined.js view on Meta::CPAN
USAGE:
// Create a new CalendarPopup object of type WINDOW
var cal = new CalendarPopup();
// Create a new CalendarPopup object of type DIV using the DIV named 'mydiv'
var cal = new CalendarPopup('mydiv');
// Easy method to link the popup calendar with an input box.
cal.select(inputObject, anchorname, dateFormat);
// Same method, but passing a default date other than the field's current value
cal.select(inputObject, anchorname, dateFormat, '01/02/2000');
// This is an example call to the popup calendar from a link to populate an
// input box. Note that to use this, date.js must also be included!!
<A HREF="#" onClick="cal.select(document.forms[0].date,'anchorname','MM/dd/yyyy'); return false;">Select</A>
// Set the type of date select to be used. By default it is 'date'.
cal.setDisplayType(type);
// When a date, month, quarter, or year is clicked, a function is called and
// passed the details. You must write this function, and tell the calendar
// popup what the function name is.
// Function to be called for 'date' select receives y, m, d
cal.setReturnFunction(functionname);
// Function to be called for 'month' select receives y, m
cal.setReturnMonthFunction(functionname);
// Function to be called for 'quarter' select receives y, q
applications/tools/resources/CalendarPopup-combined.js view on Meta::CPAN
// Show navigation for changing by the year, not just one month at a time
cal.showYearNavigation();
// Show month and year dropdowns, for quicker selection of month of dates
cal.showNavigationDropdowns();
// Set the text to be used above each day column. The days start with
// sunday regardless of the value of WeekStartDay
cal.setDayHeaders("S","M","T",...);
// Set the day for the first column in the calendar grid. By default this
// is Sunday (0) but it may be changed to fit the conventions of other
// countries.
cal.setWeekStartDay(1); // week is Monday - Sunday
// Set the weekdays which should be disabled in the 'date' select popup. You can
// then allow someone to only select week end dates, or Tuedays, for example
cal.setDisabledWeekDays(0,1); // To disable selecting the 1st or 2nd days of the week
// Selectively disable individual days or date ranges. Disabled days will not
// be clickable, and show as strike-through text on current browsers.
applications/tools/resources/CalendarPopup-combined.js view on Meta::CPAN
// But if you set the prefix like this:
cal.setCssPrefix("Test");
// The output will then look like:
// <SPAN CLASS="TestcpTodayTextDisabled">Today<SPAN>
// And you can define that style somewhere in your page.
// When using Year navigation, you can make the year be an input box, so
// the user can manually change it and jump to any year
cal.showYearNavigationInput();
// Set the calendar offset to be different than the default. By default it
// will appear just below and to the right of the anchorname. So if you have
// a text box where the date will go and and anchor immediately after the
// text box, the calendar will display immediately under the text box.
cal.offsetX = 20;
cal.offsetY = 20;
NOTES:
1) Requires the functions in AnchorPosition.js and PopupWindow.js
2) Your anchor tag MUST contain both NAME and ID attributes which are the
applications/tools/resources/CalendarPopup-combined.js view on Meta::CPAN
if (typeof(window.MONTH_NAMES)!="undefined" && window.MONTH_NAMES!=null) {
window.MONTH_NAMES = new Array();
for (var i=0; i<this.monthNames.length; i++) {
window.MONTH_NAMES[window.MONTH_NAMES.length] = this.monthNames[i];
}
for (var i=0; i<this.monthAbbreviations.length; i++) {
window.MONTH_NAMES[window.MONTH_NAMES.length] = this.monthAbbreviations[i];
}
}
}
// Temporary default functions to be called when items clicked, so no error is thrown
function CP_tmpReturnFunction(y,m,d) {
if (window.CP_targetInput!=null) {
var dt = new Date(y,m-1,d,0,0,0);
if (window.CP_calendarObject!=null) { window.CP_calendarObject.copyMonthNamesToWindow(); }
window.CP_targetInput.value = formatDate(dt,window.CP_dateFormat);
}
else {
alert('Use setReturnFunction() to define which function will get the clicked results!');
}
}
applications/tools/resources/CalendarPopup-combined.js view on Meta::CPAN
// Show next/last year navigation links
function CP_showYearNavigation() { this.isShowYearNavigation = (arguments.length>0)?arguments[0]:true; }
// Which type of calendar to display
function CP_setDisplayType(type) {
if (type!="date"&&type!="week-end"&&type!="month"&&type!="quarter"&&type!="year") { alert("Invalid display type! Must be one of: date,week-end,month,quarter,year"); return false; }
this.displayType=type;
}
// How many years back to start by default for year display
function CP_setYearSelectStartOffset(num) { this.yearSelectStartOffset=num; }
// Set which weekdays should not be clickable
function CP_setDisabledWeekDays() {
this.disabledWeekDays = new Object();
for (var i=0; i<arguments.length; i++) { this.disabledWeekDays[arguments[i]] = true; }
}
// Disable individual dates or ranges
// Builds an internal logical test which is run via eval() for efficiency
applications/tools/resources/CalendarPopup-combined.js view on Meta::CPAN
// If POPUP, write entire HTML document
if (this.type == "WINDOW") {
result += "<HTML><HEAD><TITLE>Calendar</TITLE>"+this.getStyles()+"</HEAD><BODY MARGINWIDTH=0 MARGINHEIGHT=0 TOPMARGIN=0 RIGHTMARGIN=0 LEFTMARGIN=0>\n";
result += '<CENTER><TABLE WIDTH=100% BORDER=0 BORDERWIDTH=0 CELLSPACING=0 CELLPADDING=0>\n';
}
else {
result += '<TABLE CLASS="'+this.cssPrefix+'cpBorder" WIDTH=144 BORDER=1 BORDERWIDTH=1 CELLSPACING=0 CELLPADDING=1>\n';
result += '<TR><TD ALIGN=CENTER>\n';
result += '<CENTER>\n';
}
// Code for DATE display (default)
// -------------------------------
if (this.displayType=="date" || this.displayType=="week-end") {
if (this.currentDate==null) { this.currentDate = now; }
if (arguments.length > 0) { var month = arguments[0]; }
else { var month = this.currentDate.getMonth()+1; }
if (arguments.length > 1 && arguments[1]>0 && arguments[1]-0==arguments[1]) { var year = arguments[1]; }
else { var year = this.currentDate.getFullYear(); }
var daysinmonth= new Array(0,31,28,31,30,31,30,31,31,30,31,30,31);
if ( ( (year%4 == 0)&&(year%100 != 0) ) || (year%400 == 0) ) {
daysinmonth[2] = 29;
etc/ppp/peers/ASNMTAP view on Meta::CPAN
hide-password
noauth
noipdefault
remotename ASNMTAP
ipparam ASNMTAP
usepeerdns
lib/ASNMTAP/Asnmtap.pod view on Meta::CPAN
'APPEND' => '1'
'INSERT' => '2'
'COMMA_REPLACE' => '3' # <- reserved !!!
'COMMA_APPEND' => '4'
'COMMA_INSERT' => '5'
=head1 CONFIG
You can change the values for the CONSTANTS by use of an config file 'Asnmtap.cnf'.
The default location for the config file is into the root for ASNMTAP-based applications and plugins '/opt/asnmtap'.
With the environment variable ASNMTAP_PATH you can change the default location for ASNMTAP-based applications and plugins.
=head2 Example Asnmtap.cnf
# SET ENVIRONMENT VARIABLES - - - - - - - - - - - - - - - - - - - - -
<ENV>
PATH /usr/bin:/bin:/usr/sbin:/sbin
BASH_ENV
ENV
</ENV>
lib/ASNMTAP/Asnmtap.pod view on Meta::CPAN
</SUBDIR>
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
=head1 ATTRIBUTES
=over 4
=item _programName
required, scalar, the program name, default: 'NOT DEFINED'
=item _programDescription
required, scalar, the program description, default: 'NOT DEFINED'
=item _programVersion
required, scalar, the program version, default: '0.000.000'
=item _programUsagePrefix
optional, scalar, the program usage prefix, default: undef
=item _programHelpPrefix
optional, scalar, the program help prefix, default: undef
=item _programUsageSuffix
scalar, the program predifined usage suffix
[-v|--verbose <LEVEL>]
[-V|--version]
[-h|--help]
[--usage]
[--dumpData]
lib/ASNMTAP/Asnmtap.pod view on Meta::CPAN
there are no get options values defined for ASNMTAP::Asnmtap
=item _getOptionsType
there are no get options types defined for ASNMTAP::Asnmtap
=item _debug
set object debuging on or off
scalar, 0 set 'debug off' (default) and 1 set 'debug on'
=back
=head1 METHODS
=head2 Object accessor methods
=over 4
=item programName()
lib/ASNMTAP/Asnmtap/Applications.pod view on Meta::CPAN
=item Central Apache
archive.pl -c T -r F -d F
=item Distributed ASNMTAP
archive.pl -A ArchiveCT -c T -r T -d F
=back
Shell script to run archive.pl with the default command line options
cd /opt/asnmtap/applications/
cp archive.sh-orig archive.sh
chmod 755 archive.sh
crontab -e
0 1 * * * /opt/asnmtap/applications/archive.sh > /dev/null
cd /opt/asnmtap/applications/
mv archive.sh-orig archive-apache.sh
lib/ASNMTAP/Asnmtap/Applications.pod view on Meta::CPAN
=over 4
=item generateCollectorDaemonSchedulingReports.pl
this program generating automatically Collector Daemon Scheduling Reports in PDF format
Located at URL: http://asnmtap.citap.be/results/_ASNMTAP/reports/
=item generateCollectorDaemonSchedulingReports.sh
Shell script to run generateCollectorDaemonSchedulingReports.pl with the default command line options
cd /opt/asnmtap/applications/bin
mv generateCollectorDaemonSchedulingReports.sh-orig generateCollectorDaemonSchedulingReports.sh
chmod 755 generateCollectorDaemonSchedulingReports.sh
crontab -e
0 0 * * * /opt/asnmtap/applications/bin/generateCollectorDaemonSchedulingReports.sh > /dev/null
=item generateReports.pl
this program generate automatically reports in PDF format, defined by the CGI program reports.pl
=item generateReports.sh
Shell script to run generateReports.pl with the default command line options
cd /opt/asnmtap/applications/bin
mv generateReports.sh-orig generateReports.sh
chmod 755 generateReports.sh
crontab -e
30 0 * * * /opt/asnmtap/applications/bin/generateReports.sh > /dev/null
=item holidayBundleSetDowntimes.pl
this program automatically set the plugin downtimes, defined by the CGI program plugin.pl and holidaysBundle.pl
=item holidayBundleSetDowntimes.sh
Shell script to run holidayBundleSetDowntimes.pl with the default command line options
cd /opt/asnmtap/applications/bin
mv holidayBundleSetDowntimes.sh-orig holidayBundleSetDowntimes.sh
chmod 755 holidayBundleSetDowntimes.sh
crontab -e
15 0 * * * /opt/asnmtap/applications/bin/holidayBundleSetDowntimes.sh > /dev/null
=item importDataThroughCatalog.pl
this program imports automatically the data for other distributed/federated catalog members, defined by the CGI program catalog.pl
=item importDataThroughCatalog.sh
Shell script to run importDataThroughCatalog.pl with the default command line options
cd /opt/asnmtap/applications/bin
mv generateReports.sh-orig importDataThroughCatalog.sh
chmod 755 importDataThroughCatalog.sh
crontab -e
30 0 * * * /opt/asnmtap/applications/bin/importDataThroughCatalog.sh --type=CONFIG > /dev/null
*/5 * * * * /opt/asnmtap/applications/bin/importDataThroughCatalog.sh --type=DATA > /dev/null
=back
lib/ASNMTAP/Asnmtap/Applications.pod view on Meta::CPAN
=item Apache
=over 4
=item Install for HTTPS support
install openssh, openssl, openssl096 & openssl-devel
=item add /etc/httpd/conf.d/asnmtap.conf
Link index.html and index-cv.html to the default screens
[/opt/asnmtap/applications/htmlroot]# ln -s citap.html index.html
[/opt/asnmtap/applications/htmlroot]# ln -s citap-cv.html index-cv.html
vi /etc/httpd/conf.d/asnmtap.conf
AddHandler cgi-script .cgi .pl
DirectoryIndex index.htm index.html index.html.var index.shtml index.cfm index.pl
<VirtualHost *:80>
lib/ASNMTAP/Asnmtap/Applications.pod view on Meta::CPAN
=item Update your ASNMTAP configuration
vi /opt/asnmtap/Asnmtap.cnf
Here you can modify all the varibales used by the ASNMTAP package !!!
vi /opt/asnmtap/applications/Applications.cnf
URL: http://asnmtap.citap.be/asnmtap/cgi-bin/sadmin/index.pl
regarding the server administrator, the default username: `sadmin` and password: `a1A`
Now you can build your config !!!
=back
=item Install perl modules from CPAN
export http_proxy=http://proxy:8080
export ftp_proxy=http://proxy:8080
lib/ASNMTAP/Asnmtap/Applications.pod view on Meta::CPAN
Test ASNMTAP Perfparse integration:
/usr/bin/printf "%b" "1107692900\tDUMMY-T1\tDUMMY-T1\tCRITICAL - Check Dummy: +DUMMY-T2+\tCRITICAL\ttperfdata=1;1;;;\n" | /opt/asnmtap/perfparse/bin/perfparse-log2mysql -c /opt/asnmtap/perfparse/etc/perfparse.cfg
Look for results into the database and the logfile located at /opt/asnmtap/log/perfparse-asnmtap-all.yyyymmdd.log
more /opt/asnmtap/log/perfparse-asmtap-all.yyyymmdd.log
yyyy/mm/dd hh:mmss1 [ storage.c:95 nnnn ] storage_mysql module successfully loaded
=item Database Maintenance
Deletion policies are defined at various places with default and user-defined policies available. A policy defines the time at which data is permanently deleted from the DB. The data is deleted by running the provided program 'perfparse-db-purge'. It...
To purge the Database daily using 'perfparse-db-purge' from crontab, you might use something like this:
# Purge PerfParse Database daily at 3 AM.
0 3 * * * /opt/asnmtap/perfparse/bin/perfparse-db-purge > /dev/null
=back
=item SNMPTT integration
lib/ASNMTAP/Asnmtap/Applications.pod view on Meta::CPAN
</VirtualHost>
# Module section - - - - - - - - - - - - - - - - - - - - - - - - - - - -
vi Makefile.pl
...
use lib qw(/opt/asnmtap/cpan-shared/lib/perl5/.);
...
# Configuration section - - - - - - - - - - - - - - - - - - - - - - - - -
If you're not the Perl administrator you probably don't have permission to install a module to its default location.
Then you should install it for your own use into your home directory or other directory like so:
perl Makefile.PL PREFIX=/opt/asnmtap/cpan-shared SITELIBEXP=/opt/asnmtap/cpan-shared/lib/perl5 LIB=/opt/asnmtap/cpan-shared/lib/perl5 INSTALLMAN1DIR=/opt/asnmtap/cpan-shared/share/man/man1 INSTALLMAN3DIR=/opt/asnmtap/cpan-shared/share/man/man3 INSTA...
or
perl Makefile.PL INSTALL_BASE=/opt/asnmtap/cpan-shared
This will put modules into /opt/asnmtap/cpan-shared/lib/perl5, man pages into /opt/asnmtap/cpan-shared/man and programs into /opt/asnmtap/cpan-shared/bin.
INSTALLARCHLIB INSTALL_BASE/lib/perl5/$Config{archname}
INSTALLPRIVLIB INSTALL_BASE/lib/perl5
lib/ASNMTAP/Asnmtap/Applications/CGI.pod view on Meta::CPAN
this program allow you to create all the collector daemon scheduling reports through the CGI Interface.
=item comments.pl
this program allow you to set comments by selecting a uKey from a drop and drag list for one ore more tests through the CGI Interface.
=item downtimes.pl
this program allow you to set downtimes by uploading a uKey list for a group of tests through the CGI Interface.
Format uKey without CatalogID (uses default CatalogID) list upload file, example: CatalogIDuKeyList.txt
# ASNMTAP DOWNTIMES
DUMMY-T1
DUMMY-T3
DUMMY-T5
EOF
or Format uKey with CatalogID list upload file, example: CatalogIDuKeyList.txt
# ASNMTAP DOWNTIMES
lib/ASNMTAP/Asnmtap/Applications/Collector.pod view on Meta::CPAN
=over 4
=item 1) Periodic ASNMTAP Log Parse
$perfParseMethode = 'PALP'
... TODO ...
=item 2) ASNMTAP Invokes Perfparse
$perfParseMethode = 'AIP', default
=item 3) Periodic User Log Parse
$perfParseMethode = 'PULP'
cd /opt/asnmtap/applications/sbin
mv perfparse_crontab.sh-orig perfparse_crontab.sh
chmod 755 perfparse_crontab.sh
when 'crontab': 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /opt/asnmtap/applications/sbin/perfparse_crontab.sh > /dev/null
lib/ASNMTAP/Asnmtap/Plugins.pm view on Meta::CPAN
sub _init {
$_[0]->SUPER::_init($_[1]);
carp ('ASNMTAP::Asnmtap::Plugins: _init') if ( $_[0]->{_debug} );
# --httpdump & --dumphttp tijdelijk voor backwards compatibiliteit !!!
$_[0]->{_programUsageSuffix} = ' [-S|--status N] [-A|asnmtapEnv [F|T]|[F|T]|[F|T]] [-O|onDemand F|T|N|Y] [-L|--logging <LOGGING>] [-D|--debugfile|--httpdump|--dumphttp <DEBUGFILE>] [-d|--debug F|T|L|M|A|S] '. $_[0]->{_programUsageSuffix};
$_[0]->{_programHelpSuffix} = "
-S, --status=N
N(agios) : Nagios custom plugin output (default)
-A, --asnmtapEnv=[F|T]|[F|T]|[F|T]
F(alse) : all screendebugging off (default)
T(true) : all screendebugging on
|
F(alse) : all file debugging off (default)
T(true) : all file debugging on
|
F(alse) : nok file debugging off (default)
T(true) : nok file debugging on
-O, --onDemand=F|T|N|Y
F(alse)/N(o) : normal plugin execution (default)
T(true)/Y(es) : plugin launched on demand
-L, --logging=LOGGING
write logging to file LOGGING
-D, --debugfile, --httpdump, --dumphttp=DEBUGFILE
write debug to file DEBUGFILE
-d, --debug=F|T|L|M|A|S
F(alse) : screendebugging off (default)
T(true) : normal screendebugging on
L(ong) : long screendebugging on
M(oderator) : long screendebugging on for Moderators
A(dmin) : long screendebugging on for Admins
S(erver Admin): long screendebugging on for Server Admins
" . $_[0]->{_programHelpSuffix};
push ( @{ $_[0]->{_programGetOptions} }, 'status|S:s', 'asnmtapEnv|A:s', 'onDemand|O:s', 'logging|L:s', 'debugfile|D|dumphttp|httpdump:s', 'debug|d:s' );
my ($_programUsageSuffix, $_programHelpSuffix);
( run in 0.774 second using v1.01-cache-2.11-cpan-0a6323c29d9 )