ctf之AWD(5)_服务器
根据github源码做了一些修改和添加
内容
: (1)修改mysql密码
(2)数据库监控
(3)文件监控
(1)修改mysql密码
##### change_mysql.py #####
# -- coding: utf-8 --
#mysqladmin -uroot -proot password test1234
import os
COLOR_GREEN = '\033[1;32;40m'
COLOR_RED = '\033[1;31;40m'
def change_mysql_pass(db_user, old_pass, new_pass):
host = '127.0.0.1'
command = "mysqladmin -h%s -u%s -p%s password %s" % (host, db_user, old_pass, new_pass)
try:
c = os.system(command)
if c == 0:
print(COLOR_GREEN + '[+]: 修改成功')
else:
print(COLOR_RED + '[-]: 修改失败')
except Exception as e:
print(COLOR_RED +'[-]: ' + str(e))
pass
if __name__ == '__main__':
db_user = 'root'
old_pass = 'root'
new_pass = '123456'
change_mysql_pass(db_user, old_pass, new_pass)
(2)数据库监控
文件: (1)main_log_mon_linux.py
(2)monitor.py
##### main_log_mon_linux.py #####
#coding:utf-8
import subprocess
import time
import pymysql
import os
from monitor import logMonitor
def execSQL(db, sql):
cursor = db.cursor()
cursor.execute(sql)
data = cursor.fetchone()
return data
print(time.strftime('[%H:%M:%S]: ') + str(data ))
def getConfig():
host = '127.0.0.1'
port = 3306
user = 'root'
password = 'root'
db_name = 'dvwa'
charset = 'utf8'
try:
# global db
db = pymysql.connect(host,user,password,db_name,port=port,charset=charset)
print(time.strftime('[%H:%M:%S]') + 'Database connection succeed.')
return db
except:
print(time.strftime('[%H:%M