File: //usr/local/CyberCP/plogical/__pycache__/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
�