- 论坛徽章:
- 0
|
- import os
- import time
- import MySQLdb as sql
- os.system('''netstat -atl |awk {'print $5'}|grep '^[0-9]'|cut -f 1,12 -d : |sort -d |uniq -d -c |sort -d >/root/list.txt''')
- #-----------------------var def--------------------
- FILEPATH='/root/list.txt'
- sqlstr='''insert into mytable (ltime,IP,lnum,sname) values (%s,%s,%s,%s)'''
- SIP='192.168.1.1'
- SNAME='abc'
- SPWD='def'
- SDB='run'
- SVRNAME='server1'
- linestr=''
- datetime=time.strftime('%Y-%m-%d %H:%M:%S')
- conn=sql.Connection(SIP,SNAME,SPWD,SDB)
- cur=conn.cursor()
- num=0
- ip=''
- onum=0
- oip=''
- index=0
- ips=range(0,4)
- #-------------------------------------------------
- f=file(FILEPATH,'r')
- while True:
- linestr = f.readline().lstrip()
- if not len(linestr):
- break
- index=linestr.find(' ')
- onum=num
- num=int(linestr[0:index].strip())
- if num>=5:
- oip=ip;
- ip=linestr[index+1:].strip()
- echar=ip[len(ip)-1:]
- if not (echar>='0' and echar <='9'):
- for i in range(0,4):
- index=ip.find('.')
- if index=='-1' :
- index=1
- else:
- index=ip.find('.')
- ips[i]=ip[0:index]
- ips[i]=ip[0:index]
- ip=ip[index+1:]
- ip='%s.%s.%s.%s' %(ips[3],ips[2],ips[1],ips[0])
- if oip==ip:
- num=onum+num
- #print 'datetime %s,num is %s,ip is %s,SVRNAME is %s' % (datetime,num,ip,SVRNAME)
- else:
- #print 'datetime is %s,num is %s,ip is %s,SVRNAME is %s' % (datetime,num,ip,SVRNAME)
- param=(datetime,ip,num,SVRNAME)
- cur.execute(sqlstr,param)
- del cur
复制代码
这是我的代码,在执行了cur.execute之后,程序就报段错误,然后中止运行. |
|