国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 學院 > 開發設計 > 正文

python執行shell獲取硬件參數寫入mysql

2019-11-14 17:26:06
字體:
來源:轉載
供稿:網友

最近要獲取服務器各種參數,包括cpu、內存、磁盤、型號等信息。試用了Hyperic HQ、Nagios和Snmp,它們功能都挺強大的,但是于需求不是太符,亦或者太heavy。

于是乎想到用python執行shell獲取這些信息,python執行shell腳本有以下三種方法:

1. os.system()

os.system('ls')
#返回結果0或者1,不能得到命令的輸出

2. os.popen()

output = os.popen('ls')PRint output.read()
#打印出的是命令輸出,但是得不到執行的返回值

3. commands.getstatusoutput()

(status, output) = commands.getstatusoutput('ls')print status, output
#打印出返回值和命令輸出

可以根據需要選取其中一種方法,以下是python執行shell獲取硬件參數寫入MySQL,并定期更新的程序:

 1 ''' 2 Created on Dec 10, 2014 3  4 @author: liufei 5 ''' 6 #coding=utf-8 7 import time, sched, os, string 8 from datetime import datetime 9 import MySQLdb10  11 s = sched.scheduler(time.time,time.sleep)12 13 def event_func():14     try:15         #主機名16         name = os.popen(""" hostname """).read()17         #cpu數目18         cpu_num = os.popen(""" cat /proc/cpuinfo | grep processor | wc -l """).read()19         #內存大小20         mem = os.popen(""" free | grep Mem | awk '{print $2}' """).read()21         #機器品牌22         brand = os.popen(""" dmidecode | grep 'Vendor' | head -1 | awk -F: '{print $2}' """).read()23         #型號24         model = os.popen(""" dmidecode | grep 'Product Name' | head -1 | awk -F: '{print $2}' """).read()25         #磁盤大小26         storage = os.popen(""" fdisk -l | grep 'Disk /dev/sd' | awk 'BEGIN{sum=0}{sum=sum+$3}END{print sum}' """).read()27         #mac地址28         mac = os.popen(""" ifconfig -a | grep HWaddr | head -1 | awk '{print $5}' """).read()29         30     31         32         name = name.replace("/n","").lstrip()33         cpu_num =  cpu_num.replace("/n","").lstrip()34         memory_gb = round(string.atof(mem.replace("/n","").lstrip())/1000.0/1000.0, 1)35         brand = brand.replace("/n","").lstrip()36         model = model.replace("/n","").lstrip()37         storage_gb = storage.replace("/n","").lstrip()38         mac = mac.replace("/n","").lstrip()39         40         print name41         print cpu_num42         print memory_gb43         print storage_gb44         print brand45         print model46         print mac47     48         conn=MySQLdb.connect(host='xx.xx.xx.xx',user='USERNAME',passwd='PASSWord',db='DBNAME',port=3306)49         cur=conn.cursor()50         cur.execute('select mac from servers where mac=%s',mac)51         data = cur.fetchone()52 53         if data is None:54             value = [name, brand, model, memory_gb, storage_gb, cpu_num, mac, datetime.now(), datetime.now()]55             cur.execute("insert into servers(name, brand, model, memory_gb, storage_gb, cpu_num, mac,  created_at, updated_at) values(%s, %s, %s, %s, %s, %s, %s, %s, %s)",value)            56         else:57             value1 = [name, brand, model, memory_gb, storage_gb, cpu_num, datetime.now(), mac]58             cur.execute("update servers set name=%s,brand=%s,model=%s,memory_gb=%s,storage_gb=%s,cpu_num=%s, updated_at=%s where mac=%s",value1)59            60         conn.commit()61         cur.close()62         conn.close()63         64     except MySQLdb.Error,e:65         print "Mysql Error %d: %s" % (e.args[0], e.args[1])66     67 def perform(inc):68     s.enter(inc,0,perform,(inc,))69     event_func()70     71 def mymain(inc=10):72     s.enter(0,0,perform,(inc,))73     s.run()74  75 if __name__ == "__main__":76     mymain()

 


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 辽宁省| 开原市| 胶州市| 紫阳县| 弥勒县| 微博| 辉南县| 阳曲县| 格尔木市| 湘阴县| 化隆| 穆棱市| 凤台县| 松溪县| 车致| 资溪县| 鄂尔多斯市| 平陆县| 新昌县| 泽普县| 东平县| 新竹市| 遂昌县| 赫章县| 苍南县| 海城市| 普陀区| 乐平市| 南澳县| 理塘县| 舟曲县| 灵寿县| 思南县| 兴仁县| 嫩江县| 和平县| 疏勒县| 方正县| 措勤县| 宝坻区| 阜城县|