• zabbix通过API创建交换机模板,ifAdminStatus;ifOperStatus;ifInUcastPkts;ifAlias

    最终效果：




    目的：
            通过zabbix的Latest data查看主机就可以看到其监控结果。

    监控项：
            # 管理状态 
            IF-MIB::ifAdminStatus.
            # 操作状态 
            IF-MIB::ifOperStatus.
            # 接收 单播包 
            IF-MIB::ifInUcastPkts.
            # 发送 单播包
            IF-MIB::ifOutUcastPkts.
            # 接收 错误包 
            IF-MIB::ifInErrors.
            # 发送 错误包
            IF-MIB::ifOutErrors.
            # 接收 列队 
            IF-MIB::ifInQLen.
            # 发送 列队
            IF-MIB::ifOutQLen.
            # 接收 多播包 
            IF-MIB::ifInMulticastPkts.
            # 发送 多播包
            IF-MIB::ifOutMulticastPkts.
            # 接收 广播包 
            IF-MIB::ifInBroadcastPkts.
            # 发送 广播包
            IF-MIB::ifOutBroadcastPkts.
           # 接收 非单播包
           IF-MIB::ifInNUcastPkts.
           # 发送 非单播包
           IF-MIB::ifOutNUcastPkts
            # 端口描述 
            IF-MIB::ifAlias.

    基础环境：
           centos6.5
           xampp集成环境
           snmpwalk

    流程原理：
           通过shell截取snmpwalk出来的index对应端口信息存入MYSQL表内，PHP脚本读取存入MYSQL表内的信息，通过给予的OID名字进行字符串截取生成item名字,KEY,OID创建items，一单items被创建成功，会返回itmeids，脚本讲把这个ID与其他信息存入另一个MYSQL表内。

    目录结构：
           snmpwalk.sh               # SNMP信息截取  调用
           insert_snmp_oid.php    # SNMP信息写入  使用
           zbx.inc.php                  #  ZABBIX API     调用
           zbx.templates.class.php   # 创建模板    调用
           usage.php                      # 创建模板    使用

    MYSQL表内容

    点击(此处)折叠或打开

    1. --
    2. -- 表的结构 `snmp_oid`
    3. --

    5. CREATE TABLE IF NOT EXISTS `snmp_oid` (
    6.   `ID` int(11) NOT NULL AUTO_INCREMENT,
    7.   `IP` varchar(255) NOT NULL,
    8.   `COMMUNITY` varchar(255) NOT NULL,
    9.   `VERSION` varchar(10) DEFAULT NULL,
    10.   `OID_index` varchar(255) NOT NULL,
    11.   `OID_port` varchar(255) NOT NULL,
    12.   `OID_in` varchar(255) NOT NULL,
    13.   `OID_out` varchar(255) NOT NULL,
    14.   PRIMARY KEY (`ID`)
    15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

    点击(此处)折叠或打开

    1. --
    2. -- 表的结构 `items_plus`
    3. --

    5. CREATE TABLE IF NOT EXISTS `items_plus` (
    6.   `id` int(11) NOT NULL AUTO_INCREMENT,
    7.   `hostid` int(50) NOT NULL,
    8.   `snmp_index` varchar(50) DEFAULT NULL,
    9.   `itemids` int(50) NOT NULL,
    10.   `items_name` varchar(50) DEFAULT NULL,
    11.   `items_key` varchar(50) DEFAULT NULL,
    12.   `items_oid` varchar(50) DEFAULT NULL,
    13.   `ApplicationID` int(10) NOT NULL,
    14.   PRIMARY KEY (`id`)
    15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;


    脚本内容：
     snmpwalk.sh    

    点击(此处)折叠或打开

    1. #!/bin/bash

    3. # 迈普交换机设置成 mp
    4. # 锐捷或者华为 随便设定一个值就行。
    5. a="cc"

    7. # 函数

    9. # 生成索引文件
    10. function index() {
    11.     if [ $a == "mp" ];then
    12.         #snmpwalk -$version -c $community $ip IF-MIB::ifDescr |grep 'gi' |awk -F'[ ,=]' '{print $1}' > index.txt
    13.         snmpwalk -$version -c $community $ip IF-MIB::ifDescr |grep 'port' |awk -F'[ ,=]' '{print $1}' > index.txt
    14.     else
    15.         snmpwalk -$version -c $community $ip IF-MIB::ifDescr |grep 'Ethernet' |awk -F'[ ,=]' '{print $1}' > index.txt
    16.     fi
    17. }

    19. # 生成端口名称
    20. function port() {
    21.     if [ $a == "mp" ];then
    22.         #snmpwalk -$version -c $community $ip IF-MIB::ifDescr |grep 'gi' |awk -F'[ ,=]' '{print $5 $6}' > port.txt
    23.         snmpwalk -$version -c $community $ip IF-MIB::ifDescr |grep 'port' |awk -F'[ ,=]' '{print $5 $6}' > port.txt
    24.     else
    25.         snmpwalk -$version -c $community $ip IF-MIB::ifDescr |grep 'Ethernet' |awk -F'[ ,=]' '{print $5 $6}' > port.txt
    26.     fi
    27. }

    29. # 删除生成txt文件
    30. function del(){
    31.     rm -rf ./in.txt out.txt index.txt port.txt
    32. }

    34. # 生成端口流入文件
    35. function _in(){
    36.     if [ -f "index.txt" ];then
    37.         cp ./index.txt in.txt
    38.         
    39.         #SNMP v1
    40.         if [ $version == "v1" ];then
    41.             sed -i "s/IF-MIB::ifDescr/IF-MIB::ifInOctets/g" `grep IF-MIB::ifDescr -rl in.txt `
    42.         fi

    44.         #SNMP v2c
    45.         if [ $version == "v2c" ];then
    46.             sed -i "s/IF-MIB::ifDescr/IF-MIB::ifHCInOctets/g" `grep IF-MIB::ifDescr -rl in.txt `
    47.         fi
    48.  
    49.     else
    50.         echo "not index.txt"
    51.     fi
    52. }

    54. # 生出端口流出文件
    55. function _out(){
    56.     if [ -f "index.txt" ];then
    57.         cp ./index.txt out.txt
    58.        
    59.         #SNMP v1
    60.         if [ $version == "v1" ];then
    61.             sed -i "s/IF-MIB::ifDescr/IF-MIB::ifOutOctets/g" `grep IF-MIB::ifDescr -rl out.txt `
    62.         fi
    63.       
    64.         #SNMP v2c
    65.         if [ $version == "v2c" ];then
    66.             sed -i "s/IF-MIB::ifDescr/IF-MIB::ifHCOutOctets/g" `grep IF-MIB::ifDescr -rl out.txt `
    67.         fi

    69.     else
    70.         echo "not index.txt"
    71.     fi

    73. }

    75. # 外部参数
    76. parameter=$1
    77. community=$3
    78. version=$2
    79. ip=$4

    81. # 参数使用
    82. case $parameter in
    83.     "index")
    84.          index $2 $3 $4 $a
    85.     ;;
    86.     "port")
    87.          port $2 $3 $4 $a
    88.     ;;
    89.     "del")
    90.          del
    91.     ;;
    92.     "in")
    93.          _in $2
    94.     ;;
    95.     "out")
    96.          _out $2
    97.     ;;
    98.     *)
    99.         echo ""
    100.         echo "Usage: {$0 Verison Community Parameter Ip}"
    101.         echo "Parameter: {index|port|del|in|out}"
    102.         echo "Community: {Public}"
    103.         echo "Example: {$0 index v1 Public 202.206.33.37}"
    104.         echo ""
    105.     ;;
    106. esac

    insert_snmp_oid.php

    点击(此处)折叠或打开

    1. #!/opt/lampp/bin/php
    2. <?php
    3. /*
    4.     使用方法
    5.     chmo +x ./inster_snmp_oid.php
    6.     ./inster_snmp_oid.php v1 stdu.edu.cn_nmc 202.206.32.42
    7. */

    9. /* var */
    10. @@$Version = $argv[1];
    11. @@$Community = $argv[2];
    12. @@$IP = $argv[3];
    13. @@$Factory = $argv[4];

    15. if(isset($Version) && isset($Community) && isset($IP)){
    16.     echo "生成中 ";
    17. }else{
    18.     echo "参数格式:版本,社区名,IP地址 ";
    19.         echo "例子:./inster_snmp_oid.php v1 stdu.edu.cn_nmc 202.206.32.42 ";
    20.     exit;
    21. }

    23. /* PDO mysql */
    24. $pdo = new PDO('mysql:host=202.206.32.218;dbname=test1', 'root', 'zsdsywr.');
    25. $pdo->exec('set names utf8');
    26. $pdo->exec('TRUNCATE TABLE `snmp_oid`');

    28. /* Config */
    29. $Parameter_1 = "index";
    30. $Parameter_2 = "port";
    31. $Parameter_3 = "in";
    32. $Parameter_4 = "out";

    34. /* Shell Script */
    35. function shell($Parameter_1,$Parameter_2,$Parameter_3,$Parameter_4,$Version,$Community,$IP){
    36.    exec("./snmpwalk.sh $Parameter_1 $Version $Community $IP");
    37.    exec("./snmpwalk.sh $Parameter_2 $Version $Community $IP");
    38.    exec("./snmpwalk.sh $Parameter_3 $Version $Community $IP");
    39.    exec("./snmpwalk.sh $Parameter_4 $Version $Community $IP");
    40. }

    42. /* Run Shell */
    43. shell($Parameter_1,$Parameter_2,$Parameter_3,$Parameter_4,$Version,$Community,$IP);

    45. /* Shell Add Files */
    46. $file_index = 'index.txt';
    47. $file_port ='port.txt';
    48. $file_in = 'in.txt';
    49. $file_out = 'out.txt';

    51. /* File Array */
    52. $index = file($file_index);
    53. $port = file($file_port);
    54. $in = file($file_in);
    55. $out = file($file_out);

    57. $sql ="INSERT INTO `snmp_oid`(`ID`,`IP`,`COMMUNITY`,`VERSION`,`OID_index`,`OID_port`,`OID_in`,`OID_out`) VALUES";

    59. foreach ($index as $value1){
    60.    $value2 = current($port);
    61.    $value3 = current($in);
    62.    $value4 = current($out);
    63.  
    64.    $new[] = array("$value1","$value2","$value3","$value4");
    65.    next($port);
    66.    next($in);
    67.    next($out);
    68. }

    70. foreach($new as $value => $key){
    71.   #print_r($key);
    72.   $sql .= "(NULL, '$IP', '$Community', '$Version', '$key[0]','$key[1]','$key[2]','$key[3]'),";
    73. }

    75. $SQL = rtrim($sql,',');
    76. $new_sql = $SQL.";";

    78. $inster = $pdo->exec("$new_sql");

    80. exec("./snmpwalk.sh del");
    81. if($inster == true){
    82.    echo "insert success ";
    83. }else{
    84.     echo "inster error ";
    85. }

    zbx.inc.php

    点击(此处)折叠或打开

    1. <?php
    2. class jsonrpc{
    3.     
    4.     protected function connect($server, $query){
    5.         $http = curl_init($server);
    6.         curl_setopt($http, CURLOPT_CUSTOMREQUEST, 'POST');
    7.         curl_setopt($http, CURLOPT_POSTFIELDS, $query);
    8.         curl_setopt($http, CURLOPT_RETURNTRANSFER, TRUE);
    9.         curl_setopt($http, CURLOPT_SSL_VERIFYPEER, FALSE);
    10.         /* curl_setopt($http, CURLOPT_PROXY, 'proxy_url');
    11.         curl_setopt($http, CURLOPT_PROXYPORT, '3128');
    12.         curl_setopt($http, CURLOPT_PROXYUSERPWD, 'login:pass'); */
    13.         curl_setopt($http, CURLOPT_SSL_VERIFYHOST, FALSE);
    14.         curl_setopt($http, CURLOPT_HTTPHEADER, ['Content-Type: application/json']);
    15.         $response = curl_exec($http);
    16.         return json_decode($response, true);
    17.         curl_close($http);
    18.     }
    19.     
    20. }


    23. class zbx extends jsonrpc{

    25.     public $method;
    26.     public $access_token;
    27.     public $url;
    28.     public $query;

    30.     function call(){
    31.         $data['jsonrpc'] = '2.0';
    32.         $data['method'] = $this->method;
    33.         $data['params'] = $this->query;
    34.         $this->query = '';
    35.         if(!empty($this->access_token))
    36.         $data['auth'] = $this->access_token;
    37.         $data['id'] = rand(1,100);
    38.         $data = json_encode($data, JSON_PRETTY_PRINT);
    39.         return $this->connect($this->url, $data);
    40.     }
    41.         
    42. }

    zbx.templates.class.php

    点击(此处)折叠或打开

    1. #!/opt/lampp/bin/php
    2. <?php
    3. /**
    4. *交换机snmp模板创建
    5. *
    6. *用于创建zabbix模板的items trigger
    7. * @author kingsh2012@163.com
    8. */

    10. /* Import Zabbix API */
    11. require __DIR__ . '/zbx.inc.php';


    14. class ZabbixTemplates{
    15.     
    16.     /**
    17.     * 构造函数
    18.     * 负责zabbix API调用，与32.218数据库的PDO方式连接。
    19.     *
    20.     * @return $this->zbx;
    21.     * @return $this->pdo;
    22.     */
    23.     function __construct() {
    24.         // zabbix API import
    25.         $this->zbx = new zbx;
    26.         $this->zbx->url = "http://202.206.32.203/api_jsonrpc.php";        //网页地址
    27.         $this->zbx->method = 'user.login';                                
    28.         $this->zbx->query['user'] = 'api';                                //用户名管理员
    29.         $this->zbx->query['password'] = 'zabbix';                        //密码            
    30.         $this->zbx->access_token = $this->zbx->call()['result'];

    32.         // connect 202.206.32.218 databases
    33.         try {
    34.             $this->pdo = new PDO("mysql:host=202.206.32.218;dbname=test1", "root", "zsdsywr.");        //数据库连接
    35.             $this->pdo->exec('set names utf8');
    36.             $sql = "SELECT * FROM `snmp_oid` ";
    37.             // $sql = "SELECT * FROM `items_plus` ";
    38.             $this->snmp = $this->pdo->query($sql);
    39.             }catch (PDOException $e) {
    40.                 exit($e->getMessage());
    41.             }
    42.     }
    43.     
    44.     
    45.     /**
    46.     * GetTemplateID
    47.     * 获取模板ID
    48.     *
    49.     * @access public
    50.     * @param string $name 模板名称
    51.     * @return integer
    52.     */
    53.     function GetTemplateID ($name) {
    54.         $this->zbx->method = 'template.get';
    55.         $this->zbx->query['output'] = 'extend';
    56.         $this->zbx->query['filter']['host'] = "$name";
    57.         @$templateid = $this->zbx->call()['result'][0]['templateid'];
    58.         if(!empty($templateid)){
    59.             return $templateid;
    60.         }else{
    61.             echo "输入主机错误";
    62.         }
    63.     }
    64.     
    65.     /**
    66.     * GetHostID
    67.     * 获取主机ID
    68.     *
    69.     * @access public
    70.     * @param string $host 主机名称
    71.     * @return integer
    72.     */
    73.     function GetHostID ($host) {
    74.         $this->zbx->method = 'host.get';
    75.         $this->zbx->query['output'] = 'extend';
    76.         $this->zbx->query['filter']['host'] = "$host";
    77.         $hostid = $this->zbx->call();
    78.         return $hostid;
    79.     }
    80.     
    81.     /**
    82.     * GetApplicationID
    83.     * 获取应用ID
    84.     *
    85.     * @access 调试
    86.     */     
    87.     function GetApplicationID(){
    88.         $this->zbx->method = 'application.get';
    89.         $this->zbx->query['output'] = 'extend';
    90.         $this->zbx->query['hostids']['host'] = "11562";
    91.         $result = $this->zbx->call();
    92.         print_r($result);
    93.     }
    94.     
    95.     /**
    96.     * DeltetItem
    97.     * 删除items
    98.     *
    99.     * @access 调试
    100.     */     
    101.     function DeltetItem(){
    102.         // $i = 0;
    103.         // foreach($this->snmp as $key => $value ){
    104.             // $itmsids = $value["itemids"];
    105.             // echo $itmsids;
    106.             // exit;
    107.             $this->zbx->method = 'item.delete';
    108.             // $this->zbx->query = ["$itmsids"];
    109.             $this->zbx->query = ['85668'];
    110.             $result = $this->zbx->call();
    111.             print_r($result);
    112.             // echo $i++." ";
    113.             // print_r($value);
    114.             // echo $value["itemids"];
    115.         // }
    116.     }
    117.     
    118.     /**
    119.     * GetHostID
    120.     * 获取主机ID
    121.     *
    122.     * @access public
    123.     * @param string $host 主机名称
    124.     * @return integer
    125.     */
    126.     function GetGroupID($GroupNmae){
    127.         $this->zbx->method = 'hostgroup.get';
    128.         $this->zbx->query['output'] = 'extend';
    129.         $this->zbx->query['filter']['name'] = "$GroupNmae";
    130.         @$groupid = $this->zbx->call()['result']['0']['groupid'];
    131.         if(isset($groupid)){
    132.             return $groupid;
    133.         }else{
    134.             echo $GroupNmae . "你输入的组不存在 ";
    135.             exit;
    136.         }
    137.     }
    138.     
    139.     /**
    140.     * CreateTemplate
    141.     * 创建模板
    142.     *
    143.     * @access public
    144.     * @param string $GroupNmae 以存在的 组名称
    145.     * @param string $TemplateNmae 不存在的 模板名称
    146.     * @return integer
    147.     */
    148.     function CreateTemplate($GroupNmae,$TemplateNmae){
    149.         
    150.         $groupid = $this->GetGroupID($GroupNmae);
    151.         // echo $groupid;
    152.         // exit;
    153.         $this->zbx->method = 'template.create';
    154.         $this->zbx->query['host'] = "$TemplateNmae";
    155.         $this->zbx->query['groups']['groupid'] = "$groupid";
    156.         @$templateids = $this->zbx->call()['result']['templateids']['0'];
    157.         if(isset($templateids)){
    158.             return $templateids;
    159.         }else{
    160.             echo $TemplateNmae . "模板已经存在 ";
    161.             exit;
    162.         }
    163.     }
    164.     
    165.     /**
    166.     * CreateApplication
    167.     * 创建应用
    168.     * 这个很重要,在 Zabbix Latest data里面相当于items的分组
    169.     *
    170.     * @access public
    171.     * @param integer $hostid Application创建在哪个主机下面.主机ID
    172.     * @param integer $number 不同的数字对应着不同的Application名字
    173.     * @return integer
    174.     */
    175.     function CreateApplication($hostid,$number){
    176.         if($number == 1){
    177.             $name = '端口列队';
    178.         }elseif($number == 2){
    179.             $name = '端口单播包';
    180.         }elseif($number == 3){
    181.             $name = '端口多播包';
    182.         }elseif($number == 4){
    183.             $name = '端口广播包';
    184.         }elseif($number == 5){
    185.             $name = '端口描述';
    186.         }elseif($number == 6){
    187.             $name = '端口操作状态';
    188.         }elseif($number == 7){
    189.             $name = '端口流量';
    190.         }elseif($number == 8){
    191.             $name = '端口管理状态';
    192.         }elseif($number == 9){
    193.             $name = '端口错误包';
    194.         }elseif($number == 10){
    195.             $name = '端口非单播包';
    196.         }else{
    197.             echo "应用ID输入错误 ";
    198.             exit;
    199.         }
    200.         $this->zbx->method = 'application.create';
    201.         $this->zbx->query['name'] = "$name";
    202.         $this->zbx->query['hostid'] = "$hostid";
    203.         $applicationids = $this->zbx->call()['result']['applicationids']['0'];
    204.         return $applicationids;
    205.     }
    206.     
    207.     /**
    208.     * CreateItem
    209.     * 创建itme
    210.     *
    211.     * @access public
    212.     * @param integer $type                各种item的选择
    213.     * @param integer $hostid            主机ID
    214.     * @param string $items_name            名字
    215.     * @param string $snmp_version        snmp版本
    216.     * @param string $items_key            KEY
    217.     * @param string $items_oid            OID
    218.     * @param string $snmp_community        社区名
    219.     * @param string $applications        应用ID
    220.     * @param string $description        备注
    221.     * @return integer
    222.     */
    223.     function CreateItem($type, $hostid, $items_name, $snmp_version, $items_key, $items_oid, $snmp_community, $applications,$description){
    224.         // 数据包 双向OID
    225.         if($type == 0){
    226.             $this->zbx->method = 'item.create';
    227.             $this->zbx->query['hostid'] = "$hostid"; //主机号
    228.             $this->zbx->query['name'] = "$items_name"; //items名字
    229.             $this->zbx->query['type'] = "$snmp_version"; //snmp版本号
    230.             $this->zbx->query['key_'] = "$items_key"; //itmes值
    231.             $this->zbx->query['snmp_oid'] = "$items_oid"; //oid
    232.             $this->zbx->query['snmp_community'] = "$snmp_community"; //snmp社区
    233.             $this->zbx->query['port'] = '161'; //端口
    234.             $this->zbx->query['value_type'] = '3'; //3 - numeric unsigned; 数值 特殊
    235.             $this->zbx->query['delay'] = '60';
    236.             $this->zbx->query['applications'] = ["$applications"]; //应用ID
    237.             $this->zbx->query['history'] = '7'; //记录时间 天
    238.             $this->zbx->query['description'] = "$description"; //描述
    239.             $this->zbx->query['delta'] = '1'; //1 - Delta, speed per second; 特殊
    240.             $itemids = $this->zbx->call()['result']['itemids']['0'];
    241.             return $itemids;
    242.         }elseif($type == 1){
    243.             // 流量 双向OID 这个被单独拿了出来是因为流量的涉及到 单位换算 显示单位 差值
    244.             // 注意 其实这个流量生成不建议使用这个函数    有单独对流量做过完整脚本
    245.             $this->zbx->method = 'item.create';
    246.             $this->zbx->query['hostid'] = "$hostid";
    247.             $this->zbx->query['name'] = "$items_name";
    248.             $this->zbx->query['type'] = "$snmp_version";
    249.             $this->zbx->query['key_'] = "$items_key";
    250.             $this->zbx->query['snmp_oid'] = "$items_oid";
    251.             $this->zbx->query['snmp_community'] = "$snmp_community";
    252.             $this->zbx->query['port'] = '161';
    253.             $this->zbx->query['value_type'] = '3';
    254.             $this->zbx->query['delay'] = '60';
    255.             $this->zbx->query['applications'] = ["$applications"];
    256.             $this->zbx->query['history'] = '7';
    257.             $this->zbx->query['description'] = "$description";
    258.             $this->zbx->query['delta'] = '1';
    259.             $this->zbx->query['formula'] = '8'; //特殊
    260.             $this->zbx->query['multiplier'] = '1'; //特殊
    261.             $this->zbx->query['units'] = 'bps'; //特殊
    262.             $itemids = $this->zbx->call()['result']['itemids']['0'];
    263.             return $itemids;
    264.         }elseif($type == 2){
    265.             // 单项 OID
    266.             $this->zbx->method = 'item.create';
    267.             $this->zbx->query['hostid'] = "$hostid";
    268.             $this->zbx->query['name'] = "$items_name";
    269.             $this->zbx->query['type'] = "$snmp_version";
    270.             $this->zbx->query['key_'] = "$items_key";
    271.             $this->zbx->query['snmp_oid'] = "$items_oid";
    272.             $this->zbx->query['snmp_community'] = "$snmp_community";
    273.             $this->zbx->query['port'] = '161';
    274.             $this->zbx->query['value_type'] = '1'; //特殊
    275.             $this->zbx->query['delay'] = '60';
    276.             $this->zbx->query['applications'] = ["$applications"];
    277.             $this->zbx->query['history'] = '7';
    278.             $this->zbx->query['description'] = "$description";
    279.             $itemids = $this->zbx->call()['result']['itemids']['0'];
    280.             return $itemids;
    281.         }elseif($type == 3){
    282.             // 单项OID 管理状态 这个被单独拿了出来是因为"Show value"这个项,在官方的API里面没有找到怎么取这个值. Value mapping
    283.             // 这个item被创建以后返回值是 1-3 (1=up,2=down,3=testing)
    284.             $this->zbx->method = 'item.create';
    285.             $this->zbx->query['hostid'] = "$hostid";
    286.             $this->zbx->query['name'] = "$items_name";
    287.             $this->zbx->query['type'] = "$snmp_version";
    288.             $this->zbx->query['key_'] = "$items_key";
    289.             $this->zbx->query['snmp_oid'] = "$items_oid";
    290.             $this->zbx->query['snmp_community'] = "$snmp_community";
    291.             $this->zbx->query['port'] = '161';
    292.             $this->zbx->query['value_type'] = '1';
    293.             $this->zbx->query['delay'] = '60';
    294.             $this->zbx->query['applications'] = ["$applications"];
    295.             $this->zbx->query['history'] = '7';
    296.             $this->zbx->query['description'] = "$description";
    297.             $this->zbx->query['valuemapid'] = '11'; //特殊
    298.             $itemids = $this->zbx->call()['result']['itemids']['0'];
    299.             return $itemids;
    300.         }elseif($type == 4){
    301.             // 单项OID 操作状态 这个被单独拿了出来是因为"Show value"这个项,在官方的API里面没有找到怎么取这个值. Value mapping
    302.             // 这个item被创建以后返回值是 1-7 (1=up,2=down,3=testing,4=unknown,5=dormant,6=notPresent,7=lowerLayerDown)
    303.             $this->zbx->method = 'item.create';
    304.             $this->zbx->query['hostid'] = "$hostid";
    305.             $this->zbx->query['name'] = "$items_name";
    306.             $this->zbx->query['type'] = "$snmp_version";
    307.             $this->zbx->query['key_'] = "$items_key";
    308.             $this->zbx->query['snmp_oid'] = "$items_oid";
    309.             $this->zbx->query['snmp_community'] = "$snmp_community";
    310.             $this->zbx->query['port'] = '161';
    311.             $this->zbx->query['value_type'] = '1';
    312.             $this->zbx->query['delay'] = '60';
    313.             $this->zbx->query['applications'] = ["$applications"];
    314.             $this->zbx->query['history'] = '7';
    315.             $this->zbx->query['description'] = "$description";
    316.             $this->zbx->query['valuemapid'] = '8'; //特殊
    317.             $itemids = $this->zbx->call()['result']['itemids']['0'];
    318.             return $itemids;
    319.         }
    320.     }
    321.     
    322.     /**
    323.     * Usage_CreateTwoOID
    324.     * 执行函数 创建双OID
    325.     *
    326.     * @access public
    327.     * @param string $GroupNmae            组名称
    328.     * @param string $TemplateNmae        新建模板名称
    329.     * @param string $oid                OID
    330.     * @param integer $applications        应用ID
    331.     * @param integer $type                item类型选择
    332.     * @param string $description        描述
    333.     * @return integer
    334.     */
    335.     function Usage_CreateOneOID($GroupNmae, $TemplateNmae, $oid, $applications, $type, $description){
    336.         
    337.         if(!isset($GroupNmae) || !isset($TemplateNmae) || !isset($oid) || !isset($applications) || !isset($type) || !isset($description)){
    338.             echo "################################################################################################### ";
    339.             echo "# 说明: $a->Pkts('组名称','模板名称','oid','应用ID','类型ID','描述'); # ";
    340.             echo "# 使用: $a->Pkts('华为交换机2326模板','Switch_Quidway_S2326TP-EI','ifAlias',5,2,'端口描述'); # ";
    341.             echo "# 创建应用ID: 输入1-10 # ";
    342.             echo "# 对应关系: 5=端口描述;6=操作状态;8=管理状态 # ";
    343.             echo "# 创建类型ID: 输入2-4 # ";
    344.             echo "# 对应关系: 2=其他;3=管理状态;4=操作状态 # ";
    345.             echo "################################################################################################### ";
    346.             exit();
    347.         }
    348.         
    349.         $TemplateID = $this->CreateTemplate($GroupNmae,$TemplateNmae);
    350.         $ApplicationsID = $this->CreateApplication($TemplateID,$applications);
    351.         $oid_name = str_replace(array('if'), "",$oid);
    352.         
    353.         $insert_sql="INSERT INTO `items_plus`(`id`, `hostid`, `snmp_index`, `itemids`, `items_name`, `items_key`, `items_oid`, `ApplicationID`) VALUES ";

    355.         foreach($this->snmp as $key => $value ){

    357.             if($value['VERSION'] == 'v1'){
    358.                 $snmp_version = "1";
    359.             }elseif($value['VERSION'] == 'v2c'){
    360.                 $snmp_version = "4";
    361.             }
    362.             
    363.             $items = str_replace(array(" ", " ", " "), "", $value['OID_port']);
    364.             $items_name = $items."_$oid_name";
    365.             $items_key = str_replace('/','_',$items_name);
    366.             $items_oid = str_replace('ifDescr',"$oid",$value['OID_index']);
    367.             $items_oid = str_replace(array(" ", " ", " "), "", $items_oid);
    368.             
    369.             $itemids = $this->CreateItem($type, $TemplateID, $items_name, $snmp_version, $items_key, $items_oid, $value['COMMUNITY'], $ApplicationsID,$description);

    371.             $insert_sql .= "(NULL,'$TemplateID','$value[4]','$itemids','$items_name','$items_key','$items_oid','$ApplicationsID'),";
    372.         }
    373.         $insert_sql = rtrim($insert_sql,',');
    374.         $insert_sql = $insert_sql.";";
    375.         $this->pdo->exec("$insert_sql");
    376.     }
    377.     
    378.     /**
    379.     * Usage_CreateTwoOID
    380.     * 执行函数 创建双OID
    381.     *
    382.     * @access public
    383.     * @param string $GroupNmae            组名称
    384.     * @param string $TemplateNmae        新建模板名称
    385.     * @param string $InPkts                接收OID
    386.     * @param string $OutPkts            发送OID
    387.     * @param integer $type                选择item
    388.     * @param integer $applications        应用ID
    389.     * @param string $in_description        接收item描述
    390.     * @param string $out_description    发送item描述
    391.     * @return integer
    392.     */
    393.     function Usage_CreateTwoOID($GroupNmae, $TemplateNmae, $InPkts, $OutPkts, $type, $applications, $in_description,$out_description){

    395.         if(!isset($GroupNmae) || !isset($TemplateNmae) || !isset($InPkts) || !isset($OutPkts) || !isset($type) || !isset($applications) || !isset($in_description) || !isset($out_description)){
    396.             echo "########################################################################################################################### ";
    397.             echo "# 说明: $a->Pkts('组名称', '模板名称', '接收OID', '发送OID', '选择item', '应用ID', '接收OID描述', '发送OID描述'); # ";
    398.             echo "# 使用: $a->Pkts('华为交换机2326模板', 'Switch_Quidway_S2326TP-EI', 'ifInUcastPkts', 'ifOutUcastPkts', 0, 2, '单波包'); # ";
    399.             echo "# type: 输入0-1 # ";
    400.             echo "# 对应关系: 0=其他数据包差值,1=特指流量包; # ";
    401.             echo "# 创建应用ID: 输入1-10 # ";
    402.             echo "# 对应关系: 1=列队;2=单播包;3=多播包;4=广播包;9=错误包;10=非单播包; # ";
    403.             echo "########################################################################################################################### ";
    404.             exit();
    405.         }
    406.         
    407.         $TemplateID = $this->CreateTemplate($GroupNmae,$TemplateNmae);
    408.         $ApplicationsID = $this->CreateApplication($TemplateID,$applications);
    409.         
    410.         $InPkts_name = str_replace(array('ifIn'), "",$InPkts);
    411.         $OutPkts_name = str_replace(array('ifOut'), "",$OutPkts);
    412.         
    413.         $insert_sql="INSERT INTO `items_plus`(`id`, `hostid`, `snmp_index`, `itemids`, `items_name`, `items_key`, `items_oid`, `ApplicationID`) VALUES ";

    415.         foreach($this->snmp as $key => $value ){

    417.             if($value['VERSION'] == 'v1'){
    418.                 $snmp_version = "1";
    419.             }elseif($value['VERSION'] == 'v2c'){
    420.                 $snmp_version = "4";
    421.             }
    422.             
    423.             $items = str_replace(array(" ", " ", " "), "", $value['OID_port']);
    424.             $items_in_name = $items."_in_$InPkts_name";
    425.             $items_in_key = str_replace('/','_',$items_in_name);
    426.             $items_in_oid = str_replace('ifDescr',"$InPkts",$value['OID_index']);
    427.             $items_in_oid = str_replace(array(" ", " ", " "), "", $items_in_oid);

    429.             $items_out_name = $items."_out_$OutPkts_name";
    430.             $items_out_key = str_replace('/','_',$items_out_name);
    431.             $items_out_oid = str_replace('ifDescr',"$OutPkts",$value['OID_index']);
    432.             $items_out_oid = str_replace(array(" ", " ", " "), "", $items_out_oid);
    433.             
    434.             $in_itemids = $this->CreateItem($type, $TemplateID, $items_in_name, $snmp_version, $items_in_key, $items_in_oid, $value['COMMUNITY'], $ApplicationsID,$in_description);
    435.             $out_itemids = $this->CreateItem($type, $TemplateID, $items_out_name, $snmp_version, $items_out_key, $items_out_oid, $value['COMMUNITY'], $ApplicationsID,$out_description);

    437.             $insert_sql .= "(NULL,'$TemplateID','$value[4]','$in_itemids','$items_in_name','$items_in_key','$items_in_oid','$ApplicationsID'),";
    438.             $insert_sql .= "(NULL,'$TemplateID','$value[4]','$in_itemids','$items_out_name','$items_out_key','$items_out_oid','$ApplicationsID'),";
    439.         }
    440.         $insert_sql = rtrim($insert_sql,',');
    441.         $insert_sql = $insert_sql.";";
    442.         $this->pdo->exec("$insert_sql");
    443.     }
    444.     
    445.     /**
    446.     * CreateTrigger
    447.     * 这个函数是创建触发器,但只是创建接收NUcastPkts的触发器
    448.     * 预防广播风暴
    449.     *
    450.     * @access public
    451.     * @param string $HostName            模板名称
    452.     * @return
    453.     */
    454.     function CreateTrigger($HostName){
    455.         $Macros1_1 = '{$NUCASTPKTS_VALUE1}';
    456.         $Macros1_2 = '{$NUCASTPKTS_VALUE2}';
    457.         $Macros1_3 = '{$NUCASTPKTS_VALUE3}';
    458.         $Macros2 = '{$NUCASTPKTS_NAME_HEAD}';
    459.         $Macros3 = '{$NUCASTPKTS_NAME_TAIL}';
    460.         $HostID = $this->GetTemplateID($HostName);
    461.         $sql = "SELECT * FROM `items_plus` WHERE `hostid` = $HostID AND `items_key` LIKE '%in%'";
    462.         $this->items = $this->pdo->query($sql);
    463.         
    464.         $i = 1;
    465.         foreach($this->items as $key => $value ){
    466.             $description_name = str_replace(array(" ", " ", " "), "", $value['items_name']);
    467.             $description_name = str_replace(array('_in_NUcastPkts'), "",$description_name);
    468.             // print_r($description_name);
    469.             
    470.             $this->zbx->method = 'trigger.create';
    471.             $this->zbx->query['description'] = $Macros2 . ' ' . $description_name . " > " . $Macros1_1 .' '. $Macros3;
    472.             $this->zbx->query['expression'] = '{' . $HostName . ':' . $value['items_key'] . ".last(#5)" . '}>' . $Macros1_1;
    473.             $this->zbx->query['priority'] = '1';
    474.             $result1 = $this->zbx->call();
    475.             
    476.             $this->zbx->method = 'trigger.create';
    477.             $this->zbx->query['description'] = $Macros2 . ' ' . $description_name . " > " . $Macros1_2 .' '. $Macros3;
    478.             $this->zbx->query['expression'] = '{' . $HostName . ':' . $value['items_key'] . ".last(#5)" . '}>' . $Macros1_2;
    479.             $this->zbx->query['priority'] = '2';
    480.             $result2 = $this->zbx->call();
    481.             
    482.             $this->zbx->method = 'trigger.create';
    483.             $this->zbx->query['description'] = $Macros2 . ' ' . $description_name . " > " . $Macros1_3 .' '. $Macros3;
    484.             $this->zbx->query['expression'] = '{' . $HostName . ':' . $value['items_key'] . ".last(#5)" . '}>' . $Macros1_3;
    485.             $this->zbx->query['priority'] = '3';
    486.             $result3 = $this->zbx->call();
    487.             echo $i++." ";
    488.         }
    489.     }
    490. }
    491. ?>

    usage.php

    点击(此处)折叠或打开

    1. #!/opt/lampp/bin/php
    2. <?php
    3. require __DIR__ . '/zbx.templates.class.php';
    4. $ZabbixTemplates = new ZabbixTemplates;
    5. # 华为2326交换机
    6. // $ZabbixTemplates->Usage_CreateOneOID('华为交换机2326模板','Switch_Quidway_S2326TP-EI_Alias','ifAlias',5,2,'端口描述');
    7. // $ZabbixTemplates->Usage_CreateOneOID('华为交换机2326模板','Switch_Quidway_S2326TP-EI_AdminStatus','ifAdminStatus',8,3,'端口管理状态');
    8. // $ZabbixTemplates->Usage_CreateOneOID('华为交换机2326模板','Switch_Quidway_S2326TP-EI_OperStatus','ifOperStatus',6,4,'端口操作状态');
    9. // $ZabbixTemplates->Usage_CreateTwoOID('华为交换机2326模板 ','Switch_Quidway_S2326TP- EI_NUcastPkts','ifInNUcastPkts','ifOutNUcastPkts',0,10,'接收非单波包','发送非单波包 ');
    10. // $ZabbixTemplates->Usage_CreateTwoOID('华为交换机2326模板 ','Switch_Quidway_S2326TP-EI_Errors','ifInErrors','ifOutErrors',0,9,'接收错 误包','发送错误包');
    11. // $ZabbixTemplates->Usage_CreateTwoOID('华为交换机2326模板 ','Switch_Quidway_S2326TP- EI_MulticastPkts','ifInMulticastPkts','ifInMulticastPkts',0,3,'接收多波包','发 送多波包');
    12. // $ZabbixTemplates->Usage_CreateTwoOID('华为交换机2326模板 ','Switch_Quidway_S2326TP- EI_UcastPkts','ifInUcastPkts','ifOutUcastPkts',0,2,'接收单波包','发送单波包');
    13. // $ZabbixTemplates->Usage_CreateTwoOID('华为交换机2326模板 ','Switch_Quidway_S2326TP- EI_BroadcastPkts','ifInBroadcastPkts','ifOutBroadcastPkts',0,4,'接收广波包',' 发送广波包');
    14. // $ZabbixTemplates->Usage_CreateTwoOID('华为交换机2326模板 ','Switch_Quidway_S2326TP-EI_QLen','ifInQLen','ifOutQLen',0,1,'接收列队','发送 列队');
    15. // $ZabbixTemplates->CreateTrigger('Switch_Quidway_S2326TP-EI_NUcastPkts');

    注意：
           insert_snmp_oid.php这个文件是操作文件，用来生成SNMP信息。
          usage.php这个文件是导入的操作文件。这个导入只能一次一个的执行这个文件来完成。不能同时导入多个。上边有10个导入，就得执行10次这个文件。
           本人是这样用的，第一开个putty的SSH客户端，打开一个可以支持sftp的编辑器notepad++，putty创建文件加入操作权限，通过notepad++连接centos进行编辑修改。
          为什么要创建这么多的模板？模板关联模板自己想吧。 
          最后的那个itmes_plus表是干什么用的？ 存itemids有了这个id，后期再写trigger 和 graphs就比较容易了。
          其实那些OID都是用的OID名字，zabbix支持这种写法。
           为什么TMD用PHP写？因为目前我就会点这语言，以后会重新写成PYTHON的。
  • 相关阅读:
    Coursera机器学习week11 单元测试
    关于 TypeReference 的解释
    getModifiers 方法解释。
    instanceof isInstance isAssignableFrom 比较
    elasticsearch 基础 语法总结
    kibana 启动 关闭 和进程查找
    MD5 SHA1 SHA256 SHA512 SHA1WithRSA 的区别
    spring boot 项目 热启动
    java zip 压缩文件
    Packet for query is too large (1660 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
  • 原文地址：https://www.cnblogs.com/swordxia/p/4904808.html
Copyright © 2020-2023  润新知