mirror of
https://github.com/aaPanel/aaPanel.git
synced 2026-08-17 21:25:47 +02:00
Jack
ed55fa708d
Since version 7.7.0, we recommend yours update python to 3.12. [+] Using nginx technology to load static files improves access speed [+] Refactor homepage, website, FTP, and database using vue3 [+] Table loading changed to skeleton screen [+] Add Website statistics-v2 professional plug-in [+] Add Home page - top 5 resource occupancy [+] Add protection for Files management (requires Tamper-proof for Enterprise 3.7) [+] Website, FTP, Databases page add program status [+] Add FTP log analysis (only supports Centos) [+] Add password-free login to phpMyAdmin [+] Add Proxy Project in Website (Supported when web service uses Nginx) [+] Add WP Toolkit (Pro version only) [+] Redesigned Docker module [+] Add WP Toolkit Protection [+] Add WP Toolkit Backup and Restore [+] Add WP Toolkit Migrated [+] Add WP Toolkit Clone site (supports new domain and subdomain) [+] Add WP Toolkit Create site from backup of other panel [+] Add WP Toolkit support for Cron automatic backup (only save Local disk) [+] Add WP Toolkit operation log [+] Add Integrity check for WP Toolkit [+] Add WP Toolkit plug-in management and themes management [*] Optimize phpMyAdmin formula access method [*] Optimize Home page PHP display problem [*] Optimize jump to the login interface after the login expires [*] Optimize automatic renewal of SSL at some times [*] Optimize Let's Encrypt to increase application success rate [-] Fix Logs Audit cannot be opened [-] Fix apache URL rewrite issue [-] Fix phpmyadmin installation problem [-] Fix the problem that some servers cannot install software [-] Fix upload file error [-] Fix left menu hiding problem [-] Fix aaPanel Mobile QR code display problem [-] Fix problem that third-party plug-ins are not displayed in the App Store [-] Fix issue where the menu bar is blank when opening new tabs [-] Fixed panel not being accessible in some cases [-] Fix the issue where Curl warning caused the inability to apply for SSL [-] Fix Quota issues for Website, FTP, Databases [-] Fix file interface display problem on mobile terminal
58 lines
2.4 KiB
Python
58 lines
2.4 KiB
Python
#!/usr/bin/python
|
|
# coding: utf-8
|
|
# -------------------------------------------------------------------
|
|
# aaPanel
|
|
# -------------------------------------------------------------------
|
|
# Copyright (c) 2015-2099 aaPanel(www.aapanel.com) All rights reserved.
|
|
# -------------------------------------------------------------------
|
|
# Author: linxiao
|
|
# -------------------------------------------------------------------
|
|
|
|
# -------------------------------------------------------------------
|
|
# 数据库备份权限检测
|
|
# -------------------------------------------------------------------
|
|
|
|
import os, re, public, panelMysql
|
|
|
|
_title = 'Database backup permission detection'
|
|
_version = 1.0 # 版本
|
|
_ps = "Check whether the MySQL root user has database backup privileges" # 描述
|
|
_level = 3 # 风险级别： 1.提示(低) 2.警告(中) 3.危险(高)
|
|
_date = '2020-09-19' # 最后更新时间
|
|
_ignore = os.path.exists("data/warning/ignore/sw_database_priv.pl")
|
|
_tips = [
|
|
"To temporarily enter the database without authorization, it is recommended to restore all permissions of the root user.",
|
|
]
|
|
|
|
_help = ''
|
|
_remind = 'This scheme ensures that the root user has the permission to backup the database and ensures that the database backup work is carried out. '
|
|
|
|
def check_run():
|
|
"""检测root用户是否具备数据库备份权限
|
|
|
|
@author linxiao<2020-9-18>
|
|
@return (bool, msg)
|
|
"""
|
|
mycnf_file = '/etc/my.cnf'
|
|
if not os.path.exists(mycnf_file):
|
|
return True, 'Risk-free'
|
|
mycnf = public.readFile(mycnf_file)
|
|
port_tmp = re.findall(r"port\s*=\s*(\d+)", mycnf)
|
|
if not port_tmp:
|
|
return True, 'Risk-free'
|
|
if not public.ExecShell("lsof -i :{}".format(port_tmp[0]))[0]:
|
|
return True, 'Risk-free'
|
|
|
|
base_backup_privs = ["Lock_tables_priv", "Select_priv"]
|
|
select_sql = "Select {} FROM mysql.user WHERE user='root' and " \
|
|
"host=SUBSTRING_INDEX((select current_user()),'@', " \
|
|
"-1);".format(",".join(base_backup_privs))
|
|
select_result = panelMysql.panelMysql().query(select_sql)
|
|
if not select_result:
|
|
return False, "The root user has insufficient privileges to perform mysqldump backups."
|
|
select_result = select_result[0]
|
|
for priv in select_result:
|
|
if priv.lower() != "y":
|
|
return False, "The root user has insufficient privileges to perform mysqldump backups."
|
|
return True, 'Risk-free'
|