1ãè¿å
¥mysqlï¼å建ä¸ä¸ªæ°ç¨æ·testï¼
æ ¼å¼ï¼grant æé on æ°æ®åºå.表å ç¨æ·@ç»å½ä¸»æº identified by "ç¨æ·å¯ç ";
grant all privileges on *.* to
[email protected] identified by "123456";
æè
grant select,update,insert,delete on *.* to
[email protected] identified by "123456";
2ã ./mysqladmin -uroot -ppwd reload
è®°ä½ï¼å¯¹ææ表çä»»ä½ä¿®æ¹é½éè¦éæ°reload
è¿æ¶æ们åºè¯¥å¯ä»¥ä»192.168.0.2æ¥è¿ç¨ç®¡ç192.168.0.1çæ°æ®åºäº
ä¸é¢å°±æ¯è¯¥èæ¬radius.pyï¼å
¶ä¸åºç°ä¸ä¸ªæ¥æï¼10天以åçæ¥æfutureãä»å¤©çæ¥ænowãç¨æ·å°ææ¶é´userdateï¼å¦æuserdate <= future å¹¶ä¸ userdate >= nowï¼é£ä¹åradreply表ä¸æå
¥ä¸è¡ï¼åç¨æ·æ示å°ææ¶é´ï¼åæ¶ç¼´è´¹ï¼å¦æuserdate < nowï¼é£ä¹å°è¯¥ç¨æ·çç¶æ设为åæºï¼ä¸å
许å
¶åç»éã
#! /usr/local/python/bin/python
# -*- coding: UTF-8 -*-
#å¼å
¥æ¨¡å
import MySQLdb
import datetime
#æ ¼å¼åæ¥æï¼åªæç¸åæ ¼å¼çæ¥ææè½è¿è¡æ¯è¾
future = (datetime.date.today() + datetime.timedelta(10)).strftime("%Y-%m-%d")
now = (datetime.date.today()).strftime("%Y-%m-%d")
#è¿éå°±æ¯è¿æ¥è¿ç«¯æ°æ®åºäº
conn = MySQLdb.connect (host = "192.168.0.1",
user = "test",
passwd = "123456",
db = "radius")
cursor = conn.cursor ()
cursor.execute ("SELECT login_name,id,last_date FROM customer where last_date!='' and type='å
æ' and status='å¼é'")