Api扫描RouterOS路由器的线路，并将故障线路写入xlsx表格中

Python API调用 MikroTik RouterOS 实现故障线路监控并写入Excel

最新推荐文章于 2025-01-10 11:22:06 发布

原创

最新推荐文章于 2025-01-10 11:22:06 发布 · 593 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#python #excel #window

本文介绍了一个Python脚本，通过调用RouterOS API获取网络状态，筛选出静态且未禁用的故障线路，将其数量和恢复时间记录到Excel表格中。脚本首先初始化SSL连接，登录设备，然后定期读取路由表并更新故障线路列表。

1.api参考于routeros官方api文档：

API_Python3 - RouterOS - MikroTik Documentationhttps://help.mikrotik.com/docs/display/ROS/API_Python3

2.内嵌routeros路由器命令的api代码如下(api6.py)：

#!/usr/bin/python3
import sys, time, binascii, socket, select, ssl
import hashlib
import re


class ApiRos:
    "Routeros api"

    def __init__(self, sk):
        self.sk = sk
        self.currenttag = 0

    def login(self, username, pwd):
        for repl, attrs in self.talk(["/login", "=name=" + username,
                                      "=password=" + pwd]):
            if repl == '!trap':
                return False
            elif '=ret' in attrs.keys():
                # for repl, attrs in self.talk(["/login"]):
                chal = binascii.unhexlify((attrs['=ret']).encode(sys.stdout.encoding))
                md = hashlib.md5()
                md.update(b'\x00')
                md.update(pwd.encode(sys.stdout.encoding))
                md.update(chal)
                for repl2, attrs2 in self.talk(["/login", "=name=" + username,
                                                "=response=00" + binascii.hexlify(md.digest()).decode(
                                                    sys.stdout.encoding)]):
                    if repl2 == '!trap':
                        return False
        return True

    def talk(self, words):
        if self.writeSentence(words) == 0: return
        r = []
        while 1:
            i = self.readSentence();
            if len(i) == 0: continue
            reply = i[0]
            attrs = {}
            for w in i[1:]:
                j = w.find('=', 1)
                if (j == -1):
                    attrs[w] = ''
                else:
                    attrs[w[:j]] = w[j + 1:]
            r.append((reply, attrs))
            if reply == '!done': return r

    def writeSentence(self, words):
        ret = 0
        for w in words:
            self.writeWord(w)
            ret += 1

最低0.47元/天解锁文章