ctf之AWD(5)_服务器

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