在python脚本中使用sudo

2024-09-29 20:28:58 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在做一个项目,ping局域网设备并将ping所花费的平均时间写入MySQL数据库。在

# Python script to update contents of MySQL database

import MySQLdb
import subprocess
import re

#Connecting to MySQL database
db = MySQLdb.connect("localhost","tempLocal","thunderbolt","dbavgspeed")
#initializing cursor
cur = db.cursor()

error = "Request"

while 1:
    # 0.1 is the interval between pings and 4 is the number of times ping operation is performed and -t 1 sets the timeout to 1 sec 
    command1 = ['ping','-n','-i','0.1','-t','1','-c','400','192.168.1.1']
    p1 = subprocess.Popen(command1,stdout=subprocess.PIPE)
    #text is the string which stores the output from the terminal
    text1 = p1.stdout.read()


    if error in text1:
        status1 = 0
        cur.execute("""UPDATE tbavgspeed SET status = %s WHERE id = %s""",(status1,1))
        db.commit()
    else:
        status1 = 1

        find11 = re.search("stddev(.+?)ms", text1)
        allValues1 = find11.group(1)
        find12 = re.search("/(.+?)/", allValues1)
        avgTime1 = find12.group(1)

        cur.execute("""UPDATE tbavgspeed SET avg_time = %s, status = %s WHERE id = %s""",(avgTime1,status1,1))
        db.commit()

#terminates the connection
db.close()
  • 这个脚本可以很好地使用简单的ping命令,但是如何通过需要sudo的python脚本使用flood ping(ping-f)
  • 有没有更好的方法来计算路由器的当前数据传输速率

Tags: ofthetoimportredbismysql
1条回答
网友
1楼 · 发布于 2024-09-29 20:28:58

您可以使用sudo运行Python脚本。例如:

import os
os.system('ping -f google.com')

没有sudo

^{pr2}$

使用sudo

$ sudo python
>>> import os
>>> os.system('ping -f google.com')
PING google.com (172.217.6.78): 56 data bytes
.^C
 - google.com ping statistics  -
409 packets transmitted, 408 packets received, 0.2% packet loss
round-trip min/avg/max/stddev = 3.334/3.645/9.459/0.362 ms
0

相关问题 更多 >

    热门问题