zabbix自定义脚本，实现线路时延波动超出允许范围时联动mtr，并前端展示mtr结果

#安装
sudo apt install mysql-server
#初始化，初始化过程中需要设置密码和是否禁止远程登录(当前建议禁止)
mysql_secure_installation
#创建pingvalues数据库
create database pingvalues default charset utf8; 
#创建表
create table pingvalue(nid int not null auto_increment primary key, num int,ipaddress varchar(64) ) engine=innodb default charset=utf8;

#!/usr/bin/env python3
#-*-coding:utf-8-*-
import pymysql,subprocess
def ping_value(value,tip):
    value = int(value)
    conn = pymysql.connect(host=‘127.0.0.1‘,port = 3306,user = ‘root‘,passwd = ‘test‘, db=‘pingvalues‘,charset=‘utf8‘)
    coursor = conn.cursor(cursor=pymysql.cursors.DictCursor) 
#筛选出此次探测ip并根据自增id列倒序，获取最后一组数据
    coursor.execute(‘select num from pingvalue where ipaddress like %s order by nid  desc limit 1;‘,tip)
#try防止新建item从数据库select不到数据报错
    try:  
        history_value = coursor.fetchone()[‘num‘]
#在此处控制波动范围
        if value - history_value > 20:
            mtr = ‘/etc/zabbix/bin/mtr_bash %s‘%tip
#满足条件调用shell，实测使用python调用系统mtr获取结果会有部分丢失，所以调用shell脚本          subprocess.Popen(mtr,shell=True,stdout=subprocess.PIPE,stderr=subprocess.PIPE)
    except Exception as a:
        pass
#写入最新数据   
    coursor.execute(‘insert into pingvalue(num,ipaddress) values(%s,%s)‘,(value,tip))    
    conn.commit()

#shell脚本
#!/usr/bin/env bash
IP=$1
mtr -r -n -c 30 -w -b $IP >> /etc/zabbix/bin/log/$1-$(date +%Y-%m-%d)

#前端展示
#!/usr/bin/env python 
#-*-coding:utf-8-*-
from time import strftime, localtime
import argparse,os
local_time = strftime(‘%Y-%m-%d‘,localtime())
def op(filename):
    with open(filename) as a:
        return(a.read())
#只在前端展示当天数据
if __name__  == "__main__":
    for i in os.listdir(‘/etc/zabbix/bin/log‘):
        if i[-10:] == local_time:
            filename = ‘/etc/zabbix/bin/log/%s‘%i
            print(op(filename))