diff options
| -rw-r--r-- | OAM_API_1.0.pdf | bin | 483144 -> 0 bytes | |||
| -rw-r--r-- | OAM_API_1.1.pdf | bin | 0 -> 477860 bytes | |||
| -rw-r--r-- | OAM_CLI_USER_MANUAL_0.6.pdf | bin | 181068 -> 0 bytes | |||
| -rw-r--r-- | OAM_CLI_USER_MANUAL_0.8.pdf | bin | 0 -> 178766 bytes | |||
| -rw-r--r-- | oam_cli-1.0-1.0.x86_64.rpm | bin | 94039412 -> 94041908 bytes | |||
| -rw-r--r-- | oam_cli_agent-1.0-1.0.x86_64.rpm | bin | 14184624 -> 14185028 bytes | |||
| -rw-r--r-- | oam_cli_agent_mxn-1.0-1.0.x86_64.rpm | bin | 14184548 -> 14184952 bytes | |||
| -rw-r--r-- | oam_cluster-1.0-1.0.x86_64.rpm | bin | 28838776 -> 28838892 bytes | |||
| -rw-r--r-- | oam_core-1.0-1.0.x86_64.rpm | bin | 28549176 -> 29869804 bytes | |||
| -rw-r--r-- | oam_snmp-1.0-1.0.x86_64.rpm | bin | 2135428 -> 2135448 bytes | |||
| -rw-r--r-- | snmpTrap使用说明.docx | bin | 0 -> 64844 bytes | |||
| -rw-r--r-- | snmptrapdV3.txt | 16 | ||||
| -rw-r--r-- | trap文档说明.txt | 33 | ||||
| -rw-r--r-- | tsg_threshold-20200303.sql | 275 | ||||
| -rw-r--r-- | tsg_threshold.sql | 39 | ||||
| -rw-r--r-- | 安装包说明.txt | 227 |
16 files changed, 573 insertions, 17 deletions
diff --git a/OAM_API_1.0.pdf b/OAM_API_1.0.pdf Binary files differdeleted file mode 100644 index a6fc01b..0000000 --- a/OAM_API_1.0.pdf +++ /dev/null diff --git a/OAM_API_1.1.pdf b/OAM_API_1.1.pdf Binary files differnew file mode 100644 index 0000000..ee55593 --- /dev/null +++ b/OAM_API_1.1.pdf diff --git a/OAM_CLI_USER_MANUAL_0.6.pdf b/OAM_CLI_USER_MANUAL_0.6.pdf Binary files differdeleted file mode 100644 index fe5c31e..0000000 --- a/OAM_CLI_USER_MANUAL_0.6.pdf +++ /dev/null diff --git a/OAM_CLI_USER_MANUAL_0.8.pdf b/OAM_CLI_USER_MANUAL_0.8.pdf Binary files differnew file mode 100644 index 0000000..7049c4d --- /dev/null +++ b/OAM_CLI_USER_MANUAL_0.8.pdf diff --git a/oam_cli-1.0-1.0.x86_64.rpm b/oam_cli-1.0-1.0.x86_64.rpm Binary files differindex ca061a0..6150768 100644 --- a/oam_cli-1.0-1.0.x86_64.rpm +++ b/oam_cli-1.0-1.0.x86_64.rpm diff --git a/oam_cli_agent-1.0-1.0.x86_64.rpm b/oam_cli_agent-1.0-1.0.x86_64.rpm Binary files differindex 82564c5..8360ed2 100644 --- a/oam_cli_agent-1.0-1.0.x86_64.rpm +++ b/oam_cli_agent-1.0-1.0.x86_64.rpm diff --git a/oam_cli_agent_mxn-1.0-1.0.x86_64.rpm b/oam_cli_agent_mxn-1.0-1.0.x86_64.rpm Binary files differindex 0a4274c..131c9fb 100644 --- a/oam_cli_agent_mxn-1.0-1.0.x86_64.rpm +++ b/oam_cli_agent_mxn-1.0-1.0.x86_64.rpm diff --git a/oam_cluster-1.0-1.0.x86_64.rpm b/oam_cluster-1.0-1.0.x86_64.rpm Binary files differindex 626e01c..da61c66 100644 --- a/oam_cluster-1.0-1.0.x86_64.rpm +++ b/oam_cluster-1.0-1.0.x86_64.rpm diff --git a/oam_core-1.0-1.0.x86_64.rpm b/oam_core-1.0-1.0.x86_64.rpm Binary files differindex 4e37a8c..27de970 100644 --- a/oam_core-1.0-1.0.x86_64.rpm +++ b/oam_core-1.0-1.0.x86_64.rpm diff --git a/oam_snmp-1.0-1.0.x86_64.rpm b/oam_snmp-1.0-1.0.x86_64.rpm Binary files differindex 143b57c..913f688 100644 --- a/oam_snmp-1.0-1.0.x86_64.rpm +++ b/oam_snmp-1.0-1.0.x86_64.rpm diff --git a/snmpTrap使用说明.docx b/snmpTrap使用说明.docx Binary files differnew file mode 100644 index 0000000..2043d21 --- /dev/null +++ b/snmpTrap使用说明.docx diff --git a/snmptrapdV3.txt b/snmptrapdV3.txt new file mode 100644 index 0000000..e88be21 --- /dev/null +++ b/snmptrapdV3.txt @@ -0,0 +1,16 @@ +1.修改snmptrapd.conf，增加用户tsgadmin，并设置密码为：cli202001，不能少于8位 +vi /etc/snmp/snmptrapd.conf + +增加： +createUser -e 0x8000000001020304 tsgadmin SHA cli202001 AES cli202001 +authuser log tsgadmin + +2.启动snmptrapd +snmptrapd -f -C -c /etc/snmp/snmptrapd.conf -Le + +3.另外启动一个xshell连接，向本机162端口发送trap，用户名tsgadmin，密码cli202001 +snmptrap -v 3 -n "" -a SHA -A cli202001 -x AES -X cli202001 -l authPriv -u tsgadmin -e 0x8000000001020304 localhost:162 0 .1.1.1.2.2.3.3.3 .1.1.1.2.2.3.3.3.9 s '1234567890' + +4.在第2步中的xshell连接会显示如下信息： +2020-01-31 17:43:38 localhost [UDP: [127.0.0.1]:40139->[127.0.0.1]:162]: +DISMAN-EVENT-MIB::sysUpTimeInstance = Timeticks: (0) 0:00:00.00 SNMPv2-MIB::snmpTrapOID.0 = OID: iso.1.1.2.2.3.3.3 iso.1.1.2.2.3.3.3.9 = STRING: "1234567890"
\ No newline at end of file diff --git a/trap文档说明.txt b/trap文档说明.txt new file mode 100644 index 0000000..921f3a5 --- /dev/null +++ b/trap文档说明.txt @@ -0,0 +1,33 @@ +vi /etc/snmp/snmptrapd.conf +文件内容： +traphandle default /root/traphandler.sh +authCommunity log,execute,net public + +/root/traphandler.sh脚本内容如下： + +!/bin/sh +read host +read ip +vars= + +while read oid val +do + if [ "$vars" = "" ] + then + vars="$oid = $val" + else + vars="$vars, $oid = $val" + fi +done +echo trap: $1 $host $ip $vars >> /root/trap.log + +启动trap监听器 +snmptrapd -C -c /etc/snmp/snmptrapd.conf + +发送trap： +snmptrap -v 2c -c public localhost "" .1.3.6.1.4.1.2345 .1.3.6.1.4.1.2345.1.1 s "test v2" + +查看结果 +cat /root/trap.log + +snmptrap -v 2c -c public 127.0.0.1:50162 "" 1.3.6.1.4.1.2345 .1.3.6.1.4.1.54450.15.2 s "Alarm{id=108830, name='PVCCIO_threshold', description='Current:1.058. More than critical high:1.029', chassisSn='CBT2201925000003', sledId=2, component='hardware', createTime=2020-01-15 20:02:56.0, severity='Critical', status=false, syn=true, clearBy='null', clearTime=null, ackStatus=false, ackBy='null', ackTime=null, notes='null'}" diff --git a/tsg_threshold-20200303.sql b/tsg_threshold-20200303.sql new file mode 100644 index 0000000..c104ad8 --- /dev/null +++ b/tsg_threshold-20200303.sql @@ -0,0 +1,275 @@ +/* +Navicat MySQL Data Transfer + +Source Server : localhost +Source Server Version : 50713 +Source Host : localhost:3306 +Source Database : alt + +Target Server Type : MYSQL +Target Server Version : 50713 +File Encoding : 65001 + +Date: 2020-01-21 17:33:00 +*/ + +SET FOREIGN_KEY_CHECKS=0; + +-- ---------------------------- +-- Table structure for `tsg_threshold` +-- ---------------------------- +DROP TABLE IF EXISTS `tsg_threshold`; +CREATE TABLE `tsg_threshold` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `component` varchar(200) COLLATE utf8_unicode_ci NOT NULL, + `counter` varchar(64) COLLATE utf8_unicode_ci NOT NULL, + `critical_high` float DEFAULT NULL, + `critical_low` float DEFAULT NULL, + `major_high` float DEFAULT NULL, + `major_low` float DEFAULT NULL, + `minor_high` float DEFAULT NULL, + `minor_low` float DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=239 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- ---------------------------- +-- Records of tsg_threshold +-- ---------------------------- +INSERT INTO `tsg_threshold` VALUES ('1', 'CBT2201925000001_mxn_hardware', 'CMM_TEMP', '55', '-10', '46', '-5', '39', '0'); +INSERT INTO `tsg_threshold` VALUES ('2', 'CBT2201925000001_mxn_network_port_1', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('3', 'CBT2201925000001_mxn_hardware', 'COME_TEMP', '90', '-10', '76', '-5', '63', '0'); +INSERT INTO `tsg_threshold` VALUES ('4', 'CBT2201925000001_mxn_hardware', 'RRC_TEMP', '90', '-10', '76', '-5', '63', '0'); +INSERT INTO `tsg_threshold` VALUES ('5', 'CBT2201925000001_mxn_hardware', 'P1V', '1.15', '0.85', '1.1', '0.9', '1.05', '0.95'); +INSERT INTO `tsg_threshold` VALUES ('6', 'CBT2201925000001_mxn_hardware', 'PVDDS', '1.07', '0.71', '1.04', '0.73', '1', '0.76'); +INSERT INTO `tsg_threshold` VALUES ('7', 'CBT2201925000001_mxn_hardware', 'PVDDF', '1.12', '0.71', '1.1', '0.73', '1.05', '0.76'); +INSERT INTO `tsg_threshold` VALUES ('8', 'CBT2201925000001_mxn_hardware', 'P3V3', '3.636', '2.964', '3.535', '3.066', '3.475', '3.139'); +INSERT INTO `tsg_threshold` VALUES ('9', 'CBT2201925000001_mxn_hardware', 'P5V', '5.745', '4.234', '5.494', '4.486', '5.242', '4.738'); +INSERT INTO `tsg_threshold` VALUES ('10', 'CBT2201925000001_mxn_hardware', 'P12V', '13.583', '10.415', '13.072', '10.926', '12.51', '11.488'); +INSERT INTO `tsg_threshold` VALUES ('11', 'CBT2201925000001_mxn_hardware', 'P1V_RT', '1.15', '0.85', '1.1', '0.9', '1.05', '0.95'); +INSERT INTO `tsg_threshold` VALUES ('12', 'CBT2201925000001_mxn_hardware', 'Fan_1', '9472', '512', '8672', '672', '7872', '832'); +INSERT INTO `tsg_threshold` VALUES ('13', 'CBT2201925000001_mxn_hardware', 'Fan_2', '9472', '512', '8672', '672', '7872', '832'); +INSERT INTO `tsg_threshold` VALUES ('14', 'CBT2201925000001_mxn_hardware', 'Fan_3', '9472', '512', '8672', '672', '7872', '832'); +INSERT INTO `tsg_threshold` VALUES ('15', 'CBT2201925000001_mcn0_hardware', 'HS_Current0', '40.25', '0', '37.25', '0', '36.75', '0'); +INSERT INTO `tsg_threshold` VALUES ('16', 'CBT2201925000001_mcn1_hardware', 'HS_Current0', '40.25', '0', '37.25', '0', '36.75', '0'); +INSERT INTO `tsg_threshold` VALUES ('17', 'CBT2201925000001_mcn2_hardware', 'HS_Current0', '40.25', '0', '37.25', '0', '36.75', '0'); +INSERT INTO `tsg_threshold` VALUES ('18', 'CBT2201925000001_mcn3_hardware', 'HS_Current0', '40.25', '0', '37.25', '0', '36.75', '0'); +INSERT INTO `tsg_threshold` VALUES ('19', 'CBT2201925000001_mcn0_hardware', 'HS_Volt0', '12.75', '10.5', '12.5', '10.875', '12.25', '11.125'); +INSERT INTO `tsg_threshold` VALUES ('20', 'CBT2201925000001_mcn1_hardware', 'HS_Volt0', '12.75', '10.5', '12.5', '10.875', '12.25', '11.125'); +INSERT INTO `tsg_threshold` VALUES ('21', 'CBT2201925000001_mcn2_hardware', 'HS_Volt0', '12.75', '10.5', '12.5', '10.875', '12.25', '11.125'); +INSERT INTO `tsg_threshold` VALUES ('22', 'CBT2201925000001_mcn3_hardware', 'HS_Volt0', '12.75', '10.5', '12.5', '10.875', '12.25', '11.125'); +INSERT INTO `tsg_threshold` VALUES ('23', 'CBT2201925000001_mcn0_hardware', 'P1V05_PCH', '1.147', '0.941', '1.117', '0.97', '1.098', '1'); +INSERT INTO `tsg_threshold` VALUES ('24', 'CBT2201925000001_mcn1_hardware', 'P1V05_PCH', '1.147', '0.941', '1.117', '0.97', '1.098', '1'); +INSERT INTO `tsg_threshold` VALUES ('25', 'CBT2201925000001_mcn2_hardware', 'P1V05_PCH', '1.147', '0.941', '1.117', '0.97', '1.098', '1'); +INSERT INTO `tsg_threshold` VALUES ('26', 'CBT2201925000001_mcn3_hardware', 'P1V05_PCH', '1.147', '0.941', '1.117', '0.97', '1.098', '1'); +INSERT INTO `tsg_threshold` VALUES ('27', 'CBT2201925000001_mcn0_hardware', 'P1V2_DDR0', '1.303', '1.078', '1.284', '1.117', '1.254', '1.137'); +INSERT INTO `tsg_threshold` VALUES ('28', 'CBT2201925000001_mcn1_hardware', 'P1V2_DDR0', '1.303', '1.078', '1.284', '1.117', '1.254', '1.137'); +INSERT INTO `tsg_threshold` VALUES ('29', 'CBT2201925000001_mcn2_hardware', 'P1V2_DDR0', '1.303', '1.078', '1.284', '1.117', '1.254', '1.137'); +INSERT INTO `tsg_threshold` VALUES ('30', 'CBT2201925000001_mcn3_hardware', 'P1V2_DDR0', '1.303', '1.078', '1.284', '1.117', '1.254', '1.137'); +INSERT INTO `tsg_threshold` VALUES ('31', 'CBT2201925000001_mcn0_hardware', 'P1V2_DDR1', '1.303', '1.078', '1.284', '1.117', '1.254', '1.137'); +INSERT INTO `tsg_threshold` VALUES ('32', 'CBT2201925000001_mcn1_hardware', 'P1V2_DDR1', '1.303', '1.078', '1.284', '1.117', '1.254', '1.137'); +INSERT INTO `tsg_threshold` VALUES ('33', 'CBT2201925000001_mcn2_hardware', 'P1V2_DDR1', '1.303', '1.078', '1.284', '1.117', '1.254', '1.137'); +INSERT INTO `tsg_threshold` VALUES ('34', 'CBT2201925000001_mcn3_hardware', 'P1V2_DDR1', '1.303', '1.078', '1.284', '1.117', '1.254', '1.137'); +INSERT INTO `tsg_threshold` VALUES ('35', 'CBT2201925000001_mcn0_hardware', 'P3V3', '3.569', '2.945', '3.51', '3.042', '3.452', '3.12'); +INSERT INTO `tsg_threshold` VALUES ('36', 'CBT2201925000001_mcn1_hardware', 'P3V3', '3.569', '2.945', '3.51', '3.042', '3.452', '3.12'); +INSERT INTO `tsg_threshold` VALUES ('37', 'CBT2201925000001_mcn2_hardware', 'P3V3', '3.569', '2.945', '3.51', '3.042', '3.452', '3.12'); +INSERT INTO `tsg_threshold` VALUES ('38', 'CBT2201925000001_mcn3_hardware', 'P3V3', '3.569', '2.945', '3.51', '3.042', '3.452', '3.12'); +INSERT INTO `tsg_threshold` VALUES ('39', 'CBT2201925000001_mcn0_hardware', 'P5V', '5.453', '4.494', '5.343', '4.631', '5.233', '4.74'); +INSERT INTO `tsg_threshold` VALUES ('40', 'CBT2201925000001_mcn1_hardware', 'P5V', '5.453', '4.494', '5.343', '4.631', '5.233', '4.74'); +INSERT INTO `tsg_threshold` VALUES ('41', 'CBT2201925000001_mcn2_hardware', 'P5V', '5.453', '4.494', '5.343', '4.631', '5.233', '4.74'); +INSERT INTO `tsg_threshold` VALUES ('42', 'CBT2201925000001_mcn3_hardware', 'P5V', '5.453', '4.494', '5.343', '4.631', '5.233', '4.74'); +INSERT INTO `tsg_threshold` VALUES ('43', 'CBT2201925000001_mcn0_hardware', 'PVCCIN_CPU0', '2.019', '1.323', '1.98', '1.343', '1.94', '1.352'); +INSERT INTO `tsg_threshold` VALUES ('44', 'CBT2201925000001_mcn1_hardware', 'PVCCIN_CPU0', '2.019', '1.323', '1.98', '1.343', '1.94', '1.352'); +INSERT INTO `tsg_threshold` VALUES ('45', 'CBT2201925000001_mcn2_hardware', 'PVCCIN_CPU0', '2.019', '1.323', '1.98', '1.343', '1.94', '1.352'); +INSERT INTO `tsg_threshold` VALUES ('46', 'CBT2201925000001_mcn3_hardware', 'PVCCIN_CPU0', '2.019', '1.323', '1.98', '1.343', '1.94', '1.352'); +INSERT INTO `tsg_threshold` VALUES ('47', 'CBT2201925000001_mcn0_hardware', 'PVCCIN_CPU1', '2.019', '1.323', '1.98', '1.343', '1.94', '1.352'); +INSERT INTO `tsg_threshold` VALUES ('48', 'CBT2201925000001_mcn1_hardware', 'PVCCIN_CPU1', '2.019', '1.323', '1.98', '1.343', '1.94', '1.352'); +INSERT INTO `tsg_threshold` VALUES ('49', 'CBT2201925000001_mcn2_hardware', 'PVCCIN_CPU1', '2.019', '1.323', '1.98', '1.343', '1.94', '1.352'); +INSERT INTO `tsg_threshold` VALUES ('50', 'CBT2201925000001_mcn3_hardware', 'PVCCIN_CPU1', '2.019', '1.323', '1.98', '1.343', '1.94', '1.352'); +INSERT INTO `tsg_threshold` VALUES ('51', 'CBT2201925000001_mcn0_hardware', 'PVCCIO', '1.029', '0.853', '1.009', '0.882', '1', '0.902'); +INSERT INTO `tsg_threshold` VALUES ('52', 'CBT2201925000001_mcn1_hardware', 'PVCCIO', '1.029', '0.853', '1.009', '0.882', '1', '0.902'); +INSERT INTO `tsg_threshold` VALUES ('53', 'CBT2201925000001_mcn2_hardware', 'PVCCIO', '1.029', '0.853', '1.009', '0.882', '1', '0.902'); +INSERT INTO `tsg_threshold` VALUES ('54', 'CBT2201925000001_mcn3_hardware', 'PVCCIO', '1.029', '0.853', '1.009', '0.882', '1', '0.902'); +INSERT INTO `tsg_threshold` VALUES ('55', 'CBT2201925000001_mcn0_hardware', 'Temp_LL', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('56', 'CBT2201925000001_mcn1_hardware', 'Temp_LL', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('57', 'CBT2201925000001_mcn2_hardware', 'Temp_LL', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('58', 'CBT2201925000001_mcn3_hardware', 'Temp_LL', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('59', 'CBT2201925000001_mcn0_hardware', 'Temp_LR', '45', '-10', '42', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('60', 'CBT2201925000001_mcn1_hardware', 'Temp_LR', '45', '-10', '42', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('61', 'CBT2201925000001_mcn2_hardware', 'Temp_LR', '45', '-10', '42', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('62', 'CBT2201925000001_mcn3_hardware', 'Temp_LR', '45', '-10', '42', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('63', 'CBT2201925000001_mcn0_hardware', 'Temp_PCH', '82', '-10', '74', '-5', '66', '0'); +INSERT INTO `tsg_threshold` VALUES ('64', 'CBT2201925000001_mcn1_hardware', 'Temp_PCH', '82', '-10', '74', '-5', '66', '0'); +INSERT INTO `tsg_threshold` VALUES ('65', 'CBT2201925000001_mcn2_hardware', 'Temp_PCH', '82', '-10', '74', '-5', '66', '0'); +INSERT INTO `tsg_threshold` VALUES ('66', 'CBT2201925000001_mcn3_hardware', 'Temp_PCH', '82', '-10', '74', '-5', '66', '0'); +INSERT INTO `tsg_threshold` VALUES ('67', 'CBT2201925000001_mcn0_hardware', 'Temp_UL', '85', '-10', '75', '-5', '66', '0'); +INSERT INTO `tsg_threshold` VALUES ('68', 'CBT2201925000001_mcn1_hardware', 'Temp_UL', '85', '-10', '75', '-5', '66', '0'); +INSERT INTO `tsg_threshold` VALUES ('69', 'CBT2201925000001_mcn2_hardware', 'Temp_UL', '85', '-10', '75', '-5', '66', '0'); +INSERT INTO `tsg_threshold` VALUES ('70', 'CBT2201925000001_mcn3_hardware', 'Temp_UL', '85', '-10', '75', '-5', '66', '0'); +INSERT INTO `tsg_threshold` VALUES ('71', 'CBT2201925000001_mcn0_hardware', 'Temp_UR', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('72', 'CBT2201925000001_mcn1_hardware', 'Temp_UR', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('73', 'CBT2201925000001_mcn2_hardware', 'Temp_UR', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('74', 'CBT2201925000001_mcn3_hardware', 'Temp_UR', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('75', 'CBT2201925000001_mcn0_hardware', 'Temp_XL710_82599', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('76', 'CBT2201925000001_mcn1_hardware', 'Temp_XL710_82599', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('77', 'CBT2201925000001_mcn2_hardware', 'Temp_XL710_82599', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('78', 'CBT2201925000001_mcn3_hardware', 'Temp_XL710_82599', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('79', 'CBT2201925000001_mcn0_hardware', 'Temp_mIO0', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('80', 'CBT2201925000001_mcn1_hardware', 'Temp_mIO0', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('81', 'CBT2201925000001_mcn2_hardware', 'Temp_mIO0', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('82', 'CBT2201925000001_mcn3_hardware', 'Temp_mIO0', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('83', 'CBT2201925000001_mcn0_hardware', 'Temp_mIO1', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('84', 'CBT2201925000001_mcn1_hardware', 'Temp_mIO1', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('85', 'CBT2201925000001_mcn2_hardware', 'Temp_mIO1', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('86', 'CBT2201925000001_mcn3_hardware', 'Temp_mIO1', '60', '-10', '50', '-5', '40', '0'); +INSERT INTO `tsg_threshold` VALUES ('87', 'CBT2201925000001_mcn0_hardware', 'PECI_CPU0', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('88', 'CBT2201925000001_mcn1_hardware', 'PECI_CPU0', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('89', 'CBT2201925000001_mcn2_hardware', 'PECI_CPU0', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('90', 'CBT2201925000001_mcn3_hardware', 'PECI_CPU0', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('91', 'CBT2201925000001_mcn0_hardware', 'PECI_CPU1', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('92', 'CBT2201925000001_mcn1_hardware', 'PECI_CPU1', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('93', 'CBT2201925000001_mcn2_hardware', 'PECI_CPU1', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('94', 'CBT2201925000001_mcn3_hardware', 'PECI_CPU1', '90', '-10', '80', '-5', '70', '0'); +INSERT INTO `tsg_threshold` VALUES ('95', 'CBT2201925000001_mxn_cpu', 'laLoad_1', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('96', 'CBT2201925000001_mcn0_cpu', 'laLoad_1', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('97', 'CBT2201925000001_mcn1_cpu', 'laLoad_1', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('98', 'CBT2201925000001_mcn2_cpu', 'laLoad_1', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('99', 'CBT2201925000001_mcn3_cpu', 'laLoad_1', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('100', 'CBT2201925000001_mxn_cpu', 'laLoad_5', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('101', 'CBT2201925000001_mcn0_cpu', 'laLoad_5', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('102', 'CBT2201925000001_mcn1_cpu', 'laLoad_5', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('103', 'CBT2201925000001_mcn2_cpu', 'laLoad_5', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('104', 'CBT2201925000001_mcn3_cpu', 'laLoad_5', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('105', 'CBT2201925000001_mxn_cpu', 'laLoad_10', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('106', 'CBT2201925000001_mcn0_cpu', 'laLoad_10', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('107', 'CBT2201925000001_mcn1_cpu', 'laLoad_10', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('108', 'CBT2201925000001_mcn2_cpu', 'laLoad_10', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('109', 'CBT2201925000001_mcn3_cpu', 'laLoad_10', '99', null, '85', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('110', 'CBT2201925000001_mxn_cpu', 'ssCpuUser', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('111', 'CBT2201925000001_mcn0_cpu', 'ssCpuUser', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('112', 'CBT2201925000001_mcn1_cpu', 'ssCpuUser', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('113', 'CBT2201925000001_mcn2_cpu', 'ssCpuUser', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('114', 'CBT2201925000001_mcn3_cpu', 'ssCpuUser', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('115', 'CBT2201925000001_mxn_cpu', 'ssCpuSystem', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('116', 'CBT2201925000001_mcn0_cpu', 'ssCpuSystem', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('117', 'CBT2201925000001_mcn1_cpu', 'ssCpuSystem', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('118', 'CBT2201925000001_mcn2_cpu', 'ssCpuSystem', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('119', 'CBT2201925000001_mcn3_cpu', 'ssCpuSystem', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('120', 'CBT2201925000001_mxn_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); +INSERT INTO `tsg_threshold` VALUES ('121', 'CBT2201925000001_mcn0_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); +INSERT INTO `tsg_threshold` VALUES ('122', 'CBT2201925000001_mcn1_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); +INSERT INTO `tsg_threshold` VALUES ('123', 'CBT2201925000001_mcn2_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); +INSERT INTO `tsg_threshold` VALUES ('124', 'CBT2201925000001_mcn3_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); +INSERT INTO `tsg_threshold` VALUES ('125', 'CBT2201925000001_mxn_memory', 'memTotalReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('126', 'CBT2201925000001_mcn0_memory', 'memTotalReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('127', 'CBT2201925000001_mcn1_memory', 'memTotalReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('128', 'CBT2201925000001_mcn2_memory', 'memTotalReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('129', 'CBT2201925000001_mcn3_memory', 'memTotalReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('130', 'CBT2201925000001_mxn_memory', 'memAvailReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('131', 'CBT2201925000001_mcn0_memory', 'memAvailReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('132', 'CBT2201925000001_mcn1_memory', 'memAvailReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('133', 'CBT2201925000001_mcn2_memory', 'memAvailReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('134', 'CBT2201925000001_mcn3_memory', 'memAvailReal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('135', 'CBT2201925000001_mxn_memory', 'memTotalSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('136', 'CBT2201925000001_mcn0_memory', 'memTotalSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('137', 'CBT2201925000001_mcn1_memory', 'memTotalSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('138', 'CBT2201925000001_mcn2_memory', 'memTotalSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('139', 'CBT2201925000001_mcn3_memory', 'memTotalSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('140', 'CBT2201925000001_mxn_memory', 'memAvailSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('141', 'CBT2201925000001_mcn0_memory', 'memAvailSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('142', 'CBT2201925000001_mcn1_memory', 'memAvailSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('143', 'CBT2201925000001_mcn2_memory', 'memAvailSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('144', 'CBT2201925000001_mcn3_memory', 'memAvailSwap', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('145', 'CBT2201925000001_mxn_memory', 'memTotalFree', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('146', 'CBT2201925000001_mcn0_memory', 'memTotalFree', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('147', 'CBT2201925000001_mcn1_memory', 'memTotalFree', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('148', 'CBT2201925000001_mcn2_memory', 'memTotalFree', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('149', 'CBT2201925000001_mcn3_memory', 'memTotalFree', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('150', 'CBT2201925000001_mxn_disk', 'dskTotal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('151', 'CBT2201925000001_mcn0_disk', 'dskTotal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('152', 'CBT2201925000001_mcn1_disk', 'dskTotal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('153', 'CBT2201925000001_mcn2_disk', 'dskTotal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('154', 'CBT2201925000001_mcn3_disk', 'dskTotal', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('155', 'CBT2201925000001_mxn_disk', 'dskUsed', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('156', 'CBT2201925000001_mcn0_disk', 'dskUsed', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('157', 'CBT2201925000001_mcn1_disk', 'dskUsed', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('158', 'CBT2201925000001_mcn2_disk', 'dskUsed', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('159', 'CBT2201925000001_mcn3_disk', 'dskUsed', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('160', 'CBT2201925000001_mxn_disk', 'dskAvail', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('161', 'CBT2201925000001_mcn0_disk', 'dskAvail', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('162', 'CBT2201925000001_mcn1_disk', 'dskAvail', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('163', 'CBT2201925000001_mcn2_disk', 'dskAvail', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('164', 'CBT2201925000001_mcn3_disk', 'dskAvail', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('165', 'CBT2201925000001_mxn_disk', 'dskPercent', '90', null, '80', null, '70', null); +INSERT INTO `tsg_threshold` VALUES ('166', 'CBT2201925000001_mcn0_disk', 'dskPercent', '90', null, '80', null, '70', null); +INSERT INTO `tsg_threshold` VALUES ('167', 'CBT2201925000001_mcn1_disk', 'dskPercent', '90', null, '80', null, '70', null); +INSERT INTO `tsg_threshold` VALUES ('168', 'CBT2201925000001_mcn2_disk', 'dskPercent', '90', null, '80', null, '70', null); +INSERT INTO `tsg_threshold` VALUES ('169', 'CBT2201925000001_mcn3_disk', 'dskPercent', '90', null, '80', null, '70', null); +INSERT INTO `tsg_threshold` VALUES ('170', 'CBT2201925000001_mxn_disk', 'dskPercentSled', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('171', 'CBT2201925000001_mcn0_disk', 'dskPercentSled', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('172', 'CBT2201925000001_mcn1_disk', 'dskPercentSled', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('173', 'CBT2201925000001_mcn2_disk', 'dskPercentSled', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('174', 'CBT2201925000001_mcn3_disk', 'dskPercentSled', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('175', 'CBT2201925000001_mxn_network_port_1', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('176', 'CBT2201925000001_mxn_network_port_2', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('177', 'CBT2201925000001_mxn_network_port_3', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('178', 'CBT2201925000001_mxn_network_port_4', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('179', 'CBT2201925000001_mxn_network_port_5', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('180', 'CBT2201925000001_mxn_network_port_6', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('181', 'CBT2201925000001_mxn_network_port_9', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('182', 'CBT2201925000001_mxn_network_port_10', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('183', 'CBT2201925000001_mxn_network_port_37', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('184', 'CBT2201925000001_mxn_network_port_39', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('185', 'CBT2201925000001_mxn_network_port_41', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('186', 'CBT2201925000001_mxn_network_port_43', 'ifInOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('187', 'CBT2201925000001_mxn_network_port_2', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('188', 'CBT2201925000001_mxn_network_port_3', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('189', 'CBT2201925000001_mxn_network_port_4', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('190', 'CBT2201925000001_mxn_network_port_5', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('191', 'CBT2201925000001_mxn_network_port_6', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('192', 'CBT2201925000001_mxn_network_port_9', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('193', 'CBT2201925000001_mxn_network_port_10', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('194', 'CBT2201925000001_mxn_network_port_37', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('195', 'CBT2201925000001_mxn_network_port_39', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('196', 'CBT2201925000001_mxn_network_port_41', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('197', 'CBT2201925000001_mxn_network_port_43', 'ifInUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('198', 'CBT2201925000001_mxn_network_port_1', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('199', 'CBT2201925000001_mxn_network_port_2', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('200', 'CBT2201925000001_mxn_network_port_3', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('201', 'CBT2201925000001_mxn_network_port_4', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('202', 'CBT2201925000001_mxn_network_port_5', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('203', 'CBT2201925000001_mxn_network_port_6', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('204', 'CBT2201925000001_mxn_network_port_9', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('205', 'CBT2201925000001_mxn_network_port_10', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('206', 'CBT2201925000001_mxn_network_port_37', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('207', 'CBT2201925000001_mxn_network_port_39', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('208', 'CBT2201925000001_mxn_network_port_41', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('209', 'CBT2201925000001_mxn_network_port_43', 'ifInErrors', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('210', 'CBT2201925000001_mxn_network_port_1', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('211', 'CBT2201925000001_mxn_network_port_2', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('212', 'CBT2201925000001_mxn_network_port_3', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('213', 'CBT2201925000001_mxn_network_port_4', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('214', 'CBT2201925000001_mxn_network_port_5', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('215', 'CBT2201925000001_mxn_network_port_6', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('216', 'CBT2201925000001_mxn_network_port_9', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('217', 'CBT2201925000001_mxn_network_port_10', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('218', 'CBT2201925000001_mxn_network_port_37', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('219', 'CBT2201925000001_mxn_network_port_39', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('220', 'CBT2201925000001_mxn_network_port_41', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('221', 'CBT2201925000001_mxn_network_port_43', 'ifOutOctets', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('222', 'CBT2201925000001_mxn_network_port_1', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('223', 'CBT2201925000001_mxn_network_port_2', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('224', 'CBT2201925000001_mxn_network_port_3', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('225', 'CBT2201925000001_mxn_network_port_4', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('226', 'CBT2201925000001_mxn_network_port_5', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('227', 'CBT2201925000001_mxn_network_port_6', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('228', 'CBT2201925000001_mxn_network_port_9', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('229', 'CBT2201925000001_mxn_network_port_10', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('230', 'CBT2201925000001_mxn_network_port_37', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('231', 'CBT2201925000001_mxn_network_port_39', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('232', 'CBT2201925000001_mxn_network_port_41', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('233', 'CBT2201925000001_mxn_network_port_43', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('234', 'CBT2201925000001_mxn_memory', 'memPercent', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('235', 'CBT2201925000001_mcn0_memory', 'memPercent', '0.9', null, '0.8', null, '0.7', null); +INSERT INTO `tsg_threshold` VALUES ('236', 'CBT2201925000001_mcn1_memory', 'memPercent', '0.9', null, '0.8', null, '0.7', null); +INSERT INTO `tsg_threshold` VALUES ('237', 'CBT2201925000001_mcn2_memory', 'memPercent', '0.9', null, '0.8', null, '0.7', null); +INSERT INTO `tsg_threshold` VALUES ('238', 'CBT2201925000001_mcn3_memory', 'memPercent', '0.9', null, '0.8', null, '0.7', null); diff --git a/tsg_threshold.sql b/tsg_threshold.sql index f82349a..c104ad8 100644 --- a/tsg_threshold.sql +++ b/tsg_threshold.sql @@ -1,16 +1,16 @@ /* Navicat MySQL Data Transfer -Source Server : 192.168.161.134 -Source Server Version : 50505 -Source Host : 192.168.161.134:3306 -Source Database : tsg_oam +Source Server : localhost +Source Server Version : 50713 +Source Host : localhost:3306 +Source Database : alt Target Server Type : MYSQL -Target Server Version : 50505 +Target Server Version : 50713 File Encoding : 65001 -Date: 2019-10-03 22:27:26 +Date: 2020-01-21 17:33:00 */ SET FOREIGN_KEY_CHECKS=0; @@ -30,7 +30,7 @@ CREATE TABLE `tsg_threshold` ( `minor_high` float DEFAULT NULL, `minor_low` float DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=234 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=239 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of tsg_threshold @@ -154,11 +154,11 @@ INSERT INTO `tsg_threshold` VALUES ('116', 'CBT2201925000001_mcn0_cpu', 'ssCpuSy INSERT INTO `tsg_threshold` VALUES ('117', 'CBT2201925000001_mcn1_cpu', 'ssCpuSystem', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('118', 'CBT2201925000001_mcn2_cpu', 'ssCpuSystem', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('119', 'CBT2201925000001_mcn3_cpu', 'ssCpuSystem', null, null, null, null, null, null); -INSERT INTO `tsg_threshold` VALUES ('120', 'CBT2201925000001_mxn_cpu', 'ssCpuIdle', null, null, null, null, null, null); -INSERT INTO `tsg_threshold` VALUES ('121', 'CBT2201925000001_mcn0_cpu', 'ssCpuIdle', null, null, null, null, null, null); -INSERT INTO `tsg_threshold` VALUES ('122', 'CBT2201925000001_mcn1_cpu', 'ssCpuIdle', null, null, null, null, null, null); -INSERT INTO `tsg_threshold` VALUES ('123', 'CBT2201925000001_mcn2_cpu', 'ssCpuIdle', null, null, null, null, null, null); -INSERT INTO `tsg_threshold` VALUES ('124', 'CBT2201925000001_mcn3_cpu', 'ssCpuIdle', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('120', 'CBT2201925000001_mxn_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); +INSERT INTO `tsg_threshold` VALUES ('121', 'CBT2201925000001_mcn0_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); +INSERT INTO `tsg_threshold` VALUES ('122', 'CBT2201925000001_mcn1_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); +INSERT INTO `tsg_threshold` VALUES ('123', 'CBT2201925000001_mcn2_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); +INSERT INTO `tsg_threshold` VALUES ('124', 'CBT2201925000001_mcn3_cpu', 'ssCpuIdle', null, '15', null, '30', null, '40'); INSERT INTO `tsg_threshold` VALUES ('125', 'CBT2201925000001_mxn_memory', 'memTotalReal', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('126', 'CBT2201925000001_mcn0_memory', 'memTotalReal', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('127', 'CBT2201925000001_mcn1_memory', 'memTotalReal', null, null, null, null, null, null); @@ -199,11 +199,11 @@ INSERT INTO `tsg_threshold` VALUES ('161', 'CBT2201925000001_mcn0_disk', 'dskAva INSERT INTO `tsg_threshold` VALUES ('162', 'CBT2201925000001_mcn1_disk', 'dskAvail', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('163', 'CBT2201925000001_mcn2_disk', 'dskAvail', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('164', 'CBT2201925000001_mcn3_disk', 'dskAvail', null, null, null, null, null, null); -INSERT INTO `tsg_threshold` VALUES ('165', 'CBT2201925000001_mxn_disk', 'dskPercent', '99', null, '95', null, null, null); -INSERT INTO `tsg_threshold` VALUES ('166', 'CBT2201925000001_mcn0_disk', 'dskPercent', '99', null, '95', null, null, null); -INSERT INTO `tsg_threshold` VALUES ('167', 'CBT2201925000001_mcn1_disk', 'dskPercent', '99', null, '95', null, null, null); -INSERT INTO `tsg_threshold` VALUES ('168', 'CBT2201925000001_mcn2_disk', 'dskPercent', '99', null, '95', null, null, null); -INSERT INTO `tsg_threshold` VALUES ('169', 'CBT2201925000001_mcn3_disk', 'dskPercent', '99', null, '95', null, null, null); +INSERT INTO `tsg_threshold` VALUES ('165', 'CBT2201925000001_mxn_disk', 'dskPercent', '90', null, '80', null, '70', null); +INSERT INTO `tsg_threshold` VALUES ('166', 'CBT2201925000001_mcn0_disk', 'dskPercent', '90', null, '80', null, '70', null); +INSERT INTO `tsg_threshold` VALUES ('167', 'CBT2201925000001_mcn1_disk', 'dskPercent', '90', null, '80', null, '70', null); +INSERT INTO `tsg_threshold` VALUES ('168', 'CBT2201925000001_mcn2_disk', 'dskPercent', '90', null, '80', null, '70', null); +INSERT INTO `tsg_threshold` VALUES ('169', 'CBT2201925000001_mcn3_disk', 'dskPercent', '90', null, '80', null, '70', null); INSERT INTO `tsg_threshold` VALUES ('170', 'CBT2201925000001_mxn_disk', 'dskPercentSled', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('171', 'CBT2201925000001_mcn0_disk', 'dskPercentSled', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('172', 'CBT2201925000001_mcn1_disk', 'dskPercentSled', null, null, null, null, null, null); @@ -268,3 +268,8 @@ INSERT INTO `tsg_threshold` VALUES ('230', 'CBT2201925000001_mxn_network_port_37 INSERT INTO `tsg_threshold` VALUES ('231', 'CBT2201925000001_mxn_network_port_39', 'ifOutUcastPkts', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('232', 'CBT2201925000001_mxn_network_port_41', 'ifOutUcastPkts', null, null, null, null, null, null); INSERT INTO `tsg_threshold` VALUES ('233', 'CBT2201925000001_mxn_network_port_43', 'ifOutUcastPkts', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('234', 'CBT2201925000001_mxn_memory', 'memPercent', null, null, null, null, null, null); +INSERT INTO `tsg_threshold` VALUES ('235', 'CBT2201925000001_mcn0_memory', 'memPercent', '0.9', null, '0.8', null, '0.7', null); +INSERT INTO `tsg_threshold` VALUES ('236', 'CBT2201925000001_mcn1_memory', 'memPercent', '0.9', null, '0.8', null, '0.7', null); +INSERT INTO `tsg_threshold` VALUES ('237', 'CBT2201925000001_mcn2_memory', 'memPercent', '0.9', null, '0.8', null, '0.7', null); +INSERT INTO `tsg_threshold` VALUES ('238', 'CBT2201925000001_mcn3_memory', 'memPercent', '0.9', null, '0.8', null, '0.7', null); diff --git a/安装包说明.txt b/安装包说明.txt new file mode 100644 index 0000000..e116abf --- /dev/null +++ b/安装包说明.txt @@ -0,0 +1,227 @@ +1.安装包，在40.166的/root/rpmbuild/RPMS/x86_64/目录下 +cd /root/rpmbuild/RPMS/x86_64/ + +2.将下面rpm安装包拷贝到mxn板的/root目录下 + +oam_snmp-1.0-1.0.x86_64.rpm +oam_cli_agent_mxn-1.0-1.0.x86_64.rpm +oam_cli-1.0-1.0.x86_64.rpm +oam_core-1.0-1.0.x86_64.rpm +可以使用如下命令： +scp /root/rpmbuild/RPMS/x86_64/*.rpm [email protected]:/root/ + + +2.0.安装oam_cli_agent_mxn + +/usr/lib/jvm/jdk1.8.0_45/bin/java -version +说明：如果能够看到java版本号，说明Java路径正确，继续安装否则停止安装参考节点6 + + +a.查找oam_cli_agent_mxn进程并杀死(注意：不是查找oam_cli_agent_mxn)： +ps -ef | grep cli_agent +systemctl stop oam_cli_agent_mxn +等5秒在查看是否重启（未重启为成功停掉） +ps -ef | grep cli_agent + +b.安装rpm包 +rpm -qa| grep oam_cli_agent_mxn +rpm -e oam_cli_agent_mxn +rpm -ivh /root/oam_cli_agent_mxn-1.0-1.0.x86_64.rpm + +c.启动 +systemctl start oam_cli_agent_mxn + +d.查看服务日志 +tail -n 10 /opt/tsg/cli_agent/oam-cli-agent.log + +e.测试一下 +http://192.168.40.170:50222/cmd?command=hostname + +2.1.安装oam_cli +a.查找oam_cli进程并杀死： +ps -ef | grep oam_cli +kill -9 xxxx +xxxx为进程号 + +b.查询之前是否安装： +rpm -qa| grep oam_cli +如果已经安装，则删除： +rpm -e oam_cli +安装： +rpm -ivh /root/oam_cli-1.0-1.0.x86_64.rpm + +如果mxn重启，需要执行如下命令： +mount --bind /opt/tsg/etc /home/tsgroot/opt/tsg/etc +mount -o bind /proc /home/tsgroot/proc +mount -o remount,rw,bind /proc /home/tsgroot/proc + +2.2.需要修改/home/tsgroot/opt/tsg/cli/application.properties文件中的influxdb信息 +oam.influx.url=http://192.168.40.166:58086 +（ 如果需要修改时区： +cd /opt/tsg/cli/shell/bash/.bash_profile修改以下设置 +# 设置系统时区 +TZ=Asia/Shanghai +export TZ ） + +2.3.安装oam_core： +a.查找oam_core进程并杀死： +ps -ef | grep oam_core +systemctl stop oam_core + +b.安装rpm包 +查询之前是否安装： +rpm -qa| grep oam_core +如果已经安装，则删除： +rpm -e oam_core +安装： +rpm -ivh /root/oam_core-1.0-1.0.x86_64.rpm + +2.4.需要修改/opt/tsg/oam_core/application-centos2.properties文件中的数据库信息 +# 本机influx和mariadb地址 +oam.local.server.ip=192.168.40.166 + +# 集群influx和mariadb地址 +oam.cluster.server.ip=192.168.40.210 + +# datasource - mcn上数据库密码 +datasource.first.password=tsg2019 + +# datasource - cluster上数据库密码 +datasource.second.password=111111 + +2.5.需要在mcn0的mysql数据库tsg_oam上执行数据库脚本：/opt/tsg/oam_core/tsg_threshold.sql +如果采用上面的配置，mxn的mysql数据库应该在192.168.40.166上 + +2.7.启动时钟同步服务 +systemctl restart ntpdate + +2.8.重启snmpd +查找snmp进程，并杀死，然后再启动： +/usr/sbin/snmpd -C -c /usr/share/snmp/snmpd.conf + +2.9.启动oam_core +注意：启动之前，请先启动所有mcn板上的agent服务，并和mxn做时钟同步（见下面第3节） +systemctl start oam_core + +2.10.安装oam_snmp + +a.查找oam_snmp进程并杀死： +ps -ef | grep oam_snmp +systemctl stop oam_snmp + +b.安装rpm包 +rpm -qa| grep oam_snmp +rpm -e oam_snmp +rpm -ivh /root/oam_snmp-1.0-1.0.x86_64.rpm + +c.修改influxdb地址： +/opt/tsg/snmp/application.properties + +d.启动 +systemctl start oam_snmp + +3.将oam_cli_agent-1.0-1.0.x86_64.rpm拷贝到所有mcn机器上/root下 +scp oam_cli_agent-1.0-1.0.x86_64.rpm [email protected]:/root/ + +3.0.检查java路径 +/usr/bin/java -version +说明：如果能够看到java版本号，说明Java路径正确，继续安装否则停止安装参考节点6 + +3.1.安装 + +a.查找oam_cli_agent进程并杀死： +ps -ef | grep oam_cli_agent +systemctl stop oam_cli_agent + +b.安装rpm包 +rpm -qa| grep oam_cli_agent +rpm -e oam_cli_agent +rpm -ivh /root/oam_cli_agent-1.0-1.0.x86_64.rpm + +3.2.和mxn时钟同步 +下面的命令中假设mxn的ip为192.168.40.165 +ntpdate 192.168.40.165 + +3.3.重启snmp服务 +systemctl restart snmpd + +3.4.启动 +systemctl start oam_cli_agent + +3.5测试一下 +http://192.168.40.166:50222/cmd?command=hostname + +3.6.查看服务日志 +tail -n 10 /opt/tsg/cli_agent/oam-cli-agent.log + +4.将oam_cluster-1.0-1.0.x86_64.rpm拷贝到集群机器上/root下 +可以使用如下命令： +scp oam_cluster-1.0-1.0.x86_64.rpm [email protected]:/root/ +a.查找oam_cluster进程并杀死： +ps -ef | grep oam_cluster +systemctl stop oam_cluster + +b.安装rpm包 +rpm -qa| grep oam_cluster +rpm -e oam_cluster +rpm -ivh /root/oam_cluster-1.0-1.0.x86_64.rpm +systemctl start oam_cluster + +5.1修改数据库配置（分别在166，161，210上） +vi /etc/mysql/my.cny +5.2修改内容（配置在原文件中有的直接修改参数，没有的直接新增） +skip-external-locking +back_log = 384 +key_buffer_size = 256M +max_allowed_packet = 4M +table_open_cache = 512 +thread_stack = 256K +table_cache = 128K +sort_buffer_size = 6M +read_buffer_size = 4M +read_rnd_buffer_size = 8M +myisam_sort_buffer_size = 64M +thread_cache_size = 8 +query_cache_size = 32M +join_buffer_size = 8M +# Try number of CPU's*2 for thread_concurrency +thread_concurrency = 8 +wait_timeout=2880000 +interactive_timeout = 2880000 +max_allowed_packet = 200M + +max_connections = 1500 +open-files-limit = 10240 + +key_buffer_size=256M +back_log = 512 +table_open_cache=2048 +innodb_file_per_table= 1 +innodb_buffer_pool_size = 2048M +innodb_log_file_size = 1024M +innodb_log_buffer_size = 16M +innodb_flush_log_at_trx_commit = 2 +innodb_flush_method = 'O_DIRECT' +innodb_max_dirty_pages_pct = 90 + + +innodb_log_file_size = 100M +innodb_log_buffer_size = 1G +innodb_buffer_pool_instances = 1 +innodb_flush_log_at_trx_commit = 1 +innodb_lock_wait_timeout = 50 + +6.java安装路径不正确解决方案 + +6.1.查找java安装路径 +find / -name java + +6.2.创建java正确路径 +mkdir -p /usr/lib/jvm/jdk1.8.0_45/bin/（该路径为mxn上的java路径） +mkdir -p /usr/bin/（该路径为mcn上的java路径） + +6.3.创建软链接 +ln -s /usr/lib/jvm/jdk1.8.0_73/bin/java /usr/lib/jvm/jdk1.8.0_45/bin/java +6.4.查看软连接创建后java路径是否正确使用 + +/usr/lib/jvm/jdk1.8.0_45/bin/java -version
\ No newline at end of file |