From 31de029a7dc181fc44fc7e34e08e4bd20e7df320 Mon Sep 17 00:00:00 2001 From: lijia Date: Mon, 14 Oct 2019 15:05:30 +0800 Subject: 10-12现场部署文件和文档更新. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- 1011update.txt | 18 + OAM_CLI_USER_MANUAL_0.3.pdf | Bin 94921 -> 0 bytes OAM_CLI_USER_MANUAL_v0.6.pdf | Bin 0 -> 795586 bytes TSG-OAM-MIB | 764 +++++++++++++++++++++ TSG_MIB_Spec_0.3.pdf | Bin 0 -> 194540 bytes oam_snmp-1.0-1.0.x86_64.rpm | Bin 0 -> 1361856 bytes snmp_nbi_configuration.pdf | Bin 0 -> 42285 bytes tsg_threshold.sql | 270 ++++++++ ...05\345\214\205\350\257\264\346\230\2161009.txt" | 108 --- 9 files changed, 1052 insertions(+), 108 deletions(-) create mode 100644 1011update.txt delete mode 100644 OAM_CLI_USER_MANUAL_0.3.pdf create mode 100644 OAM_CLI_USER_MANUAL_v0.6.pdf create mode 100644 TSG-OAM-MIB create mode 100644 TSG_MIB_Spec_0.3.pdf create mode 100644 oam_snmp-1.0-1.0.x86_64.rpm create mode 100644 snmp_nbi_configuration.pdf create mode 100644 tsg_threshold.sql delete mode 100644 "\345\256\211\350\243\205\345\214\205\350\257\264\346\230\2161009.txt" diff --git a/1011update.txt b/1011update.txt new file mode 100644 index 0000000..556d3e9 --- /dev/null +++ b/1011update.txt @@ -0,0 +1,18 @@ +CLI 更新: + +root登录mxn + +cd /home/tsgroot/opt/tsg/cli +delete tsg_software_reboot + +cd /home/tsgroot/bin +delete passwd + +打开同一目录下的help.txt +删除这一行 tsg_software_reboot Y Restart the application + +SNMP 更新: +login mxn +systemctl stop oam_snmp +替换 /opt/tsg/snmp/oam_snmp.jar +systemctl start oam_snmp \ No newline at end of file diff --git a/OAM_CLI_USER_MANUAL_0.3.pdf b/OAM_CLI_USER_MANUAL_0.3.pdf deleted file mode 100644 index 8fa0ec0..0000000 Binary files a/OAM_CLI_USER_MANUAL_0.3.pdf and /dev/null differ diff --git a/OAM_CLI_USER_MANUAL_v0.6.pdf b/OAM_CLI_USER_MANUAL_v0.6.pdf new file mode 100644 index 0000000..10d5535 Binary files /dev/null and b/OAM_CLI_USER_MANUAL_v0.6.pdf differ diff --git a/TSG-OAM-MIB b/TSG-OAM-MIB new file mode 100644 index 0000000..d2453ff --- /dev/null +++ b/TSG-OAM-MIB @@ -0,0 +1,764 @@ +TSG-MIB DEFINITIONS ::= BEGIN + +IMPORTS + NOTIFICATION-TYPE, + MODULE-IDENTITY, + Integer32, + enterprises, + Counter32, + Unsigned32 + FROM SNMPv2-SMI + TEXTUAL-CONVENTION, + DisplayString, + TruthValue + FROM SNMPv2-TC + OBJECT-TYPE + FROM RFC-1212; + + +-- general + +hw OBJECT IDENTIFIER + -- 1.3.6.1.4.1.54450.1 +::= { tsgoam 1 } + +hwRRCTEMP OBJECT-TYPE + SYNTAX INTEGER + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for RRC" + -- 1.3.6.1.4.1.54450.1.2 +::= { hw 2 } + + +hwCMMTEMP OBJECT-TYPE + SYNTAX INTEGER + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for CMM" + -- 1.3.6.1.4.1.54450.1.3 +::= { hw 3 } + + +hwP1V OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Voltage monitor for power" + -- 1.3.6.1.4.1.54450.1.4 +::= { hw 4 } + + +hwPVDDS OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Voltage monitor for power" + -- 1.3.6.1.4.1.54450.1.5 +::= { hw 5 } + + +hwPVDDF OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Voltage monitor for power" + -- 1.3.6.1.4.1.54450.1.6 +::= { hw 6 } + + +hwP12V OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Voltage monitor for power" + -- 1.3.6.1.4.1.54450.1.9 +::= { hw 9 } + + +hwP1VRT OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Voltage monitor for power" + -- 1.3.6.1.4.1.54450.1.10 +::= { hw 10 } + + +hwFan1 OBJECT-TYPE + SYNTAX INTEGER + ACCESS read-only + STATUS optional + DESCRIPTION + "Fan 1 Speed monitor" + -- 1.3.6.1.4.1.54450.1.11 +::= { hw 11 } + + +hwFan2 OBJECT-TYPE + SYNTAX INTEGER + ACCESS read-only + STATUS optional + DESCRIPTION + "Fan 2 Speed monitor" + -- 1.3.6.1.4.1.54450.1.12 +::= { hw 12 } + + +hwFan3 OBJECT-TYPE + SYNTAX INTEGER + ACCESS read-only + STATUS optional + DESCRIPTION + "Fan 3 Speed monitor" + -- 1.3.6.1.4.1.54450.1.13 +::= { hw 13 } + + +hwMCNTable OBJECT-TYPE + SYNTAX SEQUENCE OF HwMCNEntry + ACCESS not-accessible + STATUS mandatory + DESCRIPTION + "Disk watching information. Partions to be watched + are configured by the snmpd.conf file of the agent." + -- 1.3.6.1.4.1.54450.1.100 +::= { hw 100 } + + +hwMCNEntry OBJECT-TYPE + SYNTAX HwMCNEntry + ACCESS not-accessible + STATUS mandatory + DESCRIPTION + "An entry containing mcn hardware statistics." + INDEX { + hwMCNID } + -- 1.3.6.1.4.1.54450.1.100.1 +::= { hwMCNTable 1 } + + +HwMCNEntry ::= SEQUENCE { + + hwMCNID INTEGER, + hwHSCurrent0 DisplayString, + hwHSVolt0 DisplayString, + hwP1V05PCH DisplayString, + hwP1V2DDR0 DisplayString, + hwP1V2DDR1 DisplayString, + hwPVCCINCPU0 DisplayString, + hwPVCCINCPU1 DisplayString, + hwPVCCIO DisplayString, + hwTempLL INTEGER, + hwTempLR INTEGER, + hwTempPCH INTEGER, + hwTempUL INTEGER, + hwTempUR INTEGER, + hwTempXL71082599 INTEGER, + hwTempmIO0 INTEGER, + hwTempmIO1 INTEGER, + hwPECICPU0 INTEGER, + hwPECICPU1 INTEGER } + + +hwMCNID OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS mandatory + DESCRIPTION + "MCN sled id." + -- 1.3.6.1.4.1.54450.1.100.1.1 +::= { hwMCNEntry 1 } + + +hwHSCurrent0 OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Current monitor for power." + -- 1.3.6.1.4.1.54450.1.100.1.2 +::= { hwMCNEntry 2 } + + +hwHSVolt0 OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS mandatory + DESCRIPTION + "Current monitor for power." + -- 1.3.6.1.4.1.54450.1.100.1.3 +::= { hwMCNEntry 3 } + + +hwP1V05PCH OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Current monitor for power." + -- 1.3.6.1.4.1.54450.1.100.1.4 +::= { hwMCNEntry 4 } + + +hwP1V2DDR0 OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Current monitor for power." + -- 1.3.6.1.4.1.54450.1.100.1.5 +::= { hwMCNEntry 5 } + + +hwP1V2DDR1 OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Current monitor for power." + -- 1.3.6.1.4.1.54450.1.100.1.6 +::= { hwMCNEntry 6 } + + +hwPVCCINCPU0 OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Current monitor for power." + -- 1.3.6.1.4.1.54450.1.100.1.9 +::= { hwMCNEntry 9 } + + +hwPVCCINCPU1 OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Current monitor for power." + -- 1.3.6.1.4.1.54450.1.100.1.10 +::= { hwMCNEntry 10 } + + +hwPVCCIO OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Current monitor for power." + -- 1.3.6.1.4.1.54450.1.100.1.11 +::= { hwMCNEntry 11 } + + +hwTempLL OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for LL." + -- 1.3.6.1.4.1.54450.1.100.1.12 +::= { hwMCNEntry 12 } + + +hwTempLR OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for LR." + -- 1.3.6.1.4.1.54450.1.100.1.13 +::= { hwMCNEntry 13 } + + +hwTempPCH OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for PCH." + -- 1.3.6.1.4.1.54450.1.100.1.14 +::= { hwMCNEntry 14 } + + +hwTempUL OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for UL." + -- 1.3.6.1.4.1.54450.1.100.1.15 +::= { hwMCNEntry 15 } + + +hwTempUR OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for UR." + -- 1.3.6.1.4.1.54450.1.100.1.16 +::= { hwMCNEntry 16 } + + +hwTempXL71082599 OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for XL710_82599." + -- 1.3.6.1.4.1.54450.1.100.1.17 +::= { hwMCNEntry 17 } + + +hwTempmIO0 OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for mIO0." + -- 1.3.6.1.4.1.54450.1.100.1.18 +::= { hwMCNEntry 18 } + + +hwTempmIO1 OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for mIO1." + -- 1.3.6.1.4.1.54450.1.100.1.19 +::= { hwMCNEntry 19 } + + +hwPECICPU0 OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for CPU0." + -- 1.3.6.1.4.1.54450.1.100.1.20 +::= { hwMCNEntry 20 } + + +hwPECICPU1 OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Temperature monitor for CPU2." + -- 1.3.6.1.4.1.54450.1.100.1.21 +::= { hwMCNEntry 21 } + + +cpu OBJECT IDENTIFIER + -- 1.3.6.1.4.1.54450.2 +::= { tsgoam 2 } + +cpuTable OBJECT-TYPE + SYNTAX SEQUENCE OF CpuEntry + ACCESS not-accessible + STATUS mandatory + DESCRIPTION + "Disk watching information. Partions to be watched + are configured by the snmpd.conf file of the agent." + -- 1.3.6.1.4.1.54450.2.100 +::= { cpu 100 } + + +cpuEntry OBJECT-TYPE + SYNTAX CpuEntry + ACCESS not-accessible + STATUS mandatory + DESCRIPTION + "An entry containing mcn hardware statistics." + INDEX { + cpuSled } + -- 1.3.6.1.4.1.54450.2.100.1 +::= { cpuTable 1 } + + +CpuEntry ::= SEQUENCE { + + cpuSled INTEGER, + laLoad1 DisplayString, + laLoad5 DisplayString, + laLoad10 DisplayString, + ssCpuUser DisplayString, + ssCpuSystem DisplayString, + ssCpuIdle DisplayString } + + +cpuSled OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS mandatory + DESCRIPTION + "MXN and MCN sled id." + -- 1.3.6.1.4.1.54450.2.100.1.1 +::= { cpuEntry 1 } + + +laLoad1 OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Load averages for last 1 minute. Cumulative for CPUs and cores." + -- 1.3.6.1.4.1.54450.2.100.1.2 +::= { cpuEntry 2 } + + +laLoad5 OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Load averages for last 5 minute. Cumulative for CPUs and cores." + -- 1.3.6.1.4.1.54450.2.100.1.3 +::= { cpuEntry 3 } + + +laLoad10 OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Load averages for last 10 minute. Cumulative for CPUs and cores." + -- 1.3.6.1.4.1.54450.2.100.1.4 +::= { cpuEntry 4 } + + +ssCpuUser OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "The percentage of CPU time spent processing user-level code, calculated over the last minute." + -- 1.3.6.1.4.1.54450.2.100.1.5 +::= { cpuEntry 5 } + + +ssCpuSystem OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "The percentage of System time spent processing user-level code, calculated over the last minute." + -- 1.3.6.1.4.1.54450.2.100.1.6 +::= { cpuEntry 6 } + + +ssCpuIdle OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "The percentage of processor time spent idle, calculated over the last minute." + -- 1.3.6.1.4.1.54450.2.100.1.7 +::= { cpuEntry 7 } + + +mem OBJECT IDENTIFIER + -- 1.3.6.1.4.1.54450.3 +::= { tsgoam 3 } + +memTable OBJECT-TYPE + SYNTAX SEQUENCE OF MemEntry + ACCESS not-accessible + STATUS optional + DESCRIPTION + "Disk watching information. Partions to be watched + are configured by the snmpd.conf file of the agent." + -- 1.3.6.1.4.1.54450.3.100 +::= { mem 100 } + + +memEntry OBJECT-TYPE + SYNTAX MemEntry + ACCESS not-accessible + STATUS optional + DESCRIPTION + "An entry containing mcn hardware statistics." + INDEX { + memSled } + -- 1.3.6.1.4.1.54450.3.100.1 +::= { memTable 1 } + + +MemEntry ::= SEQUENCE { + + memSled INTEGER, + memTotalReal INTEGER, + memAvailReal INTEGER, + memTotalSwap INTEGER, + memAvailSwap INTEGER, + memTotalFree INTEGER } + + +memSled OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "MXN and MCN sled id." + -- 1.3.6.1.4.1.54450.3.100.1.1 +::= { memEntry 1 } + + +memTotalReal OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "The total amount of real/physical memory installed on this host." + -- 1.3.6.1.4.1.54450.3.100.1.2 +::= { memEntry 2 } + + +memAvailReal OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "The amount of real/physical memory currently unused or available." + -- 1.3.6.1.4.1.54450.3.100.1.3 +::= { memEntry 3 } + + +memTotalSwap OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "The total amount of swap space configured for this host." + -- 1.3.6.1.4.1.54450.3.100.1.4 +::= { memEntry 4 } + + +memAvailSwap OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "The amount of swap space currently unused or available." + -- 1.3.6.1.4.1.54450.3.100.1.5 +::= { memEntry 5 } + + +memTotalFree OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "The total amount of memory free or available for use on this host. This value typically covers both real memory and swap space or virtual memory." + -- 1.3.6.1.4.1.54450.3.100.1.6 +::= { memEntry 6 } + + +dsk OBJECT IDENTIFIER + -- 1.3.6.1.4.1.54450.4 +::= { tsgoam 4 } + +dskTable OBJECT-TYPE + SYNTAX SEQUENCE OF DskEntry + ACCESS not-accessible + STATUS optional + DESCRIPTION + "Disk watching information. Partions to be watched + are configured by the snmpd.conf file of the agent." + -- 1.3.6.1.4.1.54450.4.100 +::= { dsk 100 } + + +dskEntry OBJECT-TYPE + SYNTAX DskEntry + ACCESS not-accessible + STATUS optional + DESCRIPTION + "An entry containing mcn hardware statistics." + INDEX { + dskSled } + -- 1.3.6.1.4.1.54450.4.100.1 +::= { dskTable 1 } + + +DskEntry ::= SEQUENCE { + + dskSled INTEGER, + dskTotal INTEGER, + dskUsed INTEGER, + dskAvail INTEGER, + dskPercent DisplayString, + dskPercentNode DisplayString } + + +dskSled OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "MXN and MCN sled id." + -- 1.3.6.1.4.1.54450.4.100.1.1 +::= { dskEntry 1 } + + +dskTotal OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Total size of the disk/partion (kBytes). For large lightly-used disks (>2Tb), this value will latch at INT32_MAX (2147483647)." + -- 1.3.6.1.4.1.54450.4.100.1.2 +::= { dskEntry 2 } + + +dskUsed OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Used space on the disk. For large lightly-used disks (>2Tb), this value will latch at INT32_MAX (2147483647)." + -- 1.3.6.1.4.1.54450.4.100.1.3 +::= { dskEntry 3 } + + +dskAvail OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS optional + DESCRIPTION + "Available space on the disk. For large lightly-used disks (>2Tb), this value will latch at INT32_MAX (2147483647)." + -- 1.3.6.1.4.1.54450.4.100.1.4 +::= { dskEntry 4 } + + +dskPercent OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Percentage of space used on disk." + -- 1.3.6.1.4.1.54450.4.100.1.5 +::= { dskEntry 5 } + + +dskPercentNode OBJECT-TYPE + SYNTAX DisplayString + ACCESS read-only + STATUS optional + DESCRIPTION + "Percentage of isleds used on disk." + -- 1.3.6.1.4.1.54450.4.100.1.6 +::= { dskEntry 6 } + + +net OBJECT IDENTIFIER + -- 1.3.6.1.4.1.54450.5 +::= { tsgoam 5 } + +netTable OBJECT-TYPE + SYNTAX SEQUENCE OF NetEntry + ACCESS not-accessible + STATUS optional + DESCRIPTION + "Disk watching information. Partions to be watched + are configured by the snmpd.conf file of the agent." + -- 1.3.6.1.4.1.54450.5.100 +::= { net 100 } + + +netEntry OBJECT-TYPE + SYNTAX NetEntry + ACCESS not-accessible + STATUS optional + DESCRIPTION + "An entry containing mcn hardware statistics." + INDEX { + mxnNIC } + -- 1.3.6.1.4.1.54450.5.100.1 +::= { netTable 1 } + + +NetEntry ::= SEQUENCE { + + mxnNIC INTEGER, + ifInOctets DisplayString, + ifInUcastPkts DisplayString, + ifInErrors DisplayString, + ifOutOctets DisplayString, + ifOutUcastPkts DisplayString } + + +mxnNIC OBJECT-TYPE + SYNTAX INTEGER (0..65535) + ACCESS read-only + STATUS mandatory + DESCRIPTION + "NIC id on MXN." + -- 1.3.6.1.4.1.54450.5.100.1.1 +::= { netEntry 1 } + + +ifInOctets OBJECT-TYPE + SYNTAX DisplayString (SIZE (0..65535)) + ACCESS read-only + STATUS optional + DESCRIPTION + "The total number of octets received on the interface." + -- 1.3.6.1.4.1.54450.5.100.1.2 +::= { netEntry 2 } + + +ifInUcastPkts OBJECT-TYPE + SYNTAX DisplayString (SIZE (0..65535)) + ACCESS read-only + STATUS mandatory + DESCRIPTION + "The number of subnetwork-unicast packets delivered to a higher-layer protocol." + -- 1.3.6.1.4.1.54450.5.100.1.3 +::= { netEntry 3 } + + +ifInErrors OBJECT-TYPE + SYNTAX DisplayString (SIZE (0..65535)) + ACCESS read-only + STATUS mandatory + DESCRIPTION + "The number of inbound packets that contained errors preventing them from being deliverable to a higher-layer protocol." + -- 1.3.6.1.4.1.54450.5.100.1.4 +::= { netEntry 4 } + + +ifOutOctets OBJECT-TYPE + SYNTAX DisplayString (SIZE (0..65535)) + ACCESS read-only + STATUS optional + DESCRIPTION + "The total number of octets transmitted out of the interface." + -- 1.3.6.1.4.1.54450.5.100.1.5 +::= { netEntry 5 } + + +ifOutUcastPkts OBJECT-TYPE + SYNTAX DisplayString (SIZE (0..65535)) + ACCESS read-only + STATUS optional + DESCRIPTION + "The total number of packets that higher-level protocols requested be transmitted to a subnetwork-unicast address." + -- 1.3.6.1.4.1.54450.5.100.1.6 +::= { netEntry 6 } + + +tsgoam OBJECT IDENTIFIER + -- 1.3.6.1.4.1.54450 ---- 1.3.6.1.4.1.54450 +::= { enterprises 54450 } + +END diff --git a/TSG_MIB_Spec_0.3.pdf b/TSG_MIB_Spec_0.3.pdf new file mode 100644 index 0000000..ed161c8 Binary files /dev/null and b/TSG_MIB_Spec_0.3.pdf differ diff --git a/oam_snmp-1.0-1.0.x86_64.rpm b/oam_snmp-1.0-1.0.x86_64.rpm new file mode 100644 index 0000000..e744803 Binary files /dev/null and b/oam_snmp-1.0-1.0.x86_64.rpm differ diff --git a/snmp_nbi_configuration.pdf b/snmp_nbi_configuration.pdf new file mode 100644 index 0000000..ec0cef9 Binary files /dev/null and b/snmp_nbi_configuration.pdf differ diff --git a/tsg_threshold.sql b/tsg_threshold.sql new file mode 100644 index 0000000..f82349a --- /dev/null +++ b/tsg_threshold.sql @@ -0,0 +1,270 @@ +/* +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 + +Target Server Type : MYSQL +Target Server Version : 50505 +File Encoding : 65001 + +Date: 2019-10-03 22:27:26 +*/ + +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=234 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, 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 ('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', '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 ('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); diff --git "a/\345\256\211\350\243\205\345\214\205\350\257\264\346\230\2161009.txt" "b/\345\256\211\350\243\205\345\214\205\350\257\264\346\230\2161009.txt" deleted file mode 100644 index aa30dd8..0000000 --- "a/\345\256\211\350\243\205\345\214\205\350\257\264\346\230\2161009.txt" +++ /dev/null @@ -1,108 +0,0 @@ -1.安装包,在40.25的/root目录下 -/root/rpmbuild/RPMS/x86_64 - -2.将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拷贝到mxn板的/root目录下 - -2.0.安装oam_cli_agent_mxn - -a.查找oam_cli_agent_mxn进程并杀死(注意:不是查找oam_cli_agent_mxn): -ps -ef | grep cli_agent -kill -9 xxxx -其中xxxx为上一个命令查到的进程号 - -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 - -2.1.安装oam_cli -查询之前是否安装: -rpm -qa| grep oam_cli -如果已经安装,则删除: -rpm -e oam_cli -安装: -rpm -ivh /root/oam_cli-1.0-1.0.x86_64.rpm - - -2.2.需要修改/home/tsgroot/opt/tsg/cli/application-centos2.properties文件中的influxdb信息 -oam.influx.url=http://192.168.40.161:58086 - -2.3.安装oam_core: -a.查找oam_core进程并杀死: -ps -ef | grep oam_core -kill -9 xxxx -其中xxxx为上一个命令查到的进程号 - -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.161 - -# 集群influx和mariadb地址 -oam.cluster.server.ip=192.168.40.210 - -# datasource - mcn上数据库密码 -datasource.first.password=tsg2019 - -# datasource - cluster上数据库密码 -datasource.second.password=111111 - -2.5.需要在mxn的mysql数据库tsg_oam上执行数据库脚本:/opt/tsg/oam_core/tsg_threshold.sql -如果采用上面的配置,mxn的mysql数据库应该在192.168.40.161上 - -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 - -3.将oam_cli_agent-1.0-1.0.x86_64.rpm拷贝到所有mcn机器上/root下 - -3.1.安装 - -a.查找cli_agent进程并杀死: -ps -ef | grep oam_cli_agent -kill -9 xxxx -其中xxxx为上一个命令查到的进程号 - -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.查看服务日志 -tail -n 10 /opt/tsg/cli_agent/oam-cli-agent.log - -4.将oam_cluster-1.0-1.0.x86_64.rpm拷贝到集群机器上/root下 -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 \ No newline at end of file -- cgit v1.2.3