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的。

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/swordxia/p/4904808.html