ddns server.py

该程序是一个DDNS实现的演示程序

import MySQLModule
import socket
import time

try:
    db=MySQLModule.dbtools("172.30.70.126","ddns","root","753159")
    conn=db.getconn()
    cursor=conn.cursor()
except:
    pass
print conn

s=socket.socket()

s.bind(('127.0.0.1',8686))
s.listen(10)
connection,address = s.accept()
print 'Connection from address:',address[0],'prot:',address[1],'at', time.ctime(time.time())
while True:
    try:
        data=connection.recv(512)
        if data !='':
            print "%s:%s>> %s Online" % (address[0],address[1],data)
            if conn:
                sql="update ddns_user set ddnsstatus = 1,u_ip = '%s' where u_name = '%s'" % (address[0],data)
                print sql
                cursor.execute(sql)
    except:
        pass
    try:
        connection.send('200 OK')
    except:
        pass
    data=''
connection.close()
conn.close()