File: //proc/self/root/usr/local/CyberCP/databases/__pycache__/databaseManager.cpython-310.pyc
o
��h�8 � @ s� d dl Zd dlZd dlZd dlmZ ej�d� ej� dd� e�
� d dl m Z d dl
Z
d dlmZ d dlmZ d dlmZ d d lmZ d d
lmZmZ d dlZd d lm Z d dl m Z d d l m Z d d
l!m"Z" G dd� d�Z#dd� Z$e%dkr}e$� dS dS )� N)�redirectz/usr/local/CyberCP�DJANGO_SETTINGS_MODULEzCyberCP.settings)� HttpResponse)�
ACLManager)�mysqlUtilities)�Websites)� Databases�DBMeta)�
Administrator)�httpProc)�DBUsersc @ s� e Zd ZdZd!dd�Zd!dd�Zd!dd�Zd"d d
�Zd!d d �Zd!d
d�Z d!dd�Z
d!dd�Z d!dd�Z d!dd�Z
d!dd�Zd!dd�Zd!dd �Zd!d d �Zed d � �ZdS )#�DatabaseManager�
remote_accessNc C � d}t ||d d�}|�� S )Nzdatabases/index.html�createDatabase�r �render��self�request�userID�template�proc� r �//usr/local/CyberCP/databases/databaseManager.py�loadDatabaseHome � z DatabaseManager.loadDatabaseHomec C r )Nzdatabases/phpMyAdmin.htmlr r r r r r �
phpMyAdmin r zDatabaseManager.phpMyAdminc C �4 t �|�}t �||�}d}t||d|id�}|�� S )Nz databases/createDatabase.html� websitesListr �r � loadedACL� findAllSitesr r �r r r �
currentACL� websitesNamer r r r r r % �
z DatabaseManager.createDatabasec
C sH z�t �|�}tjj|d�}t �|d�dkr t �dd�W S |d }|d }|d }|d } |d }
t �|||�d
kr:nt �� W S |d krO|
d | }|
d | }t� ||| |�} | d d
krod
d
d ||d
�} t
� | �}
t |
�W S dd| d
d�} t
� | �}
t |
�W S t
y� } zddt|�d�} t
� | �}
t |
�W Y d }~S d }~ww )N��pkr r �createDBStatus�databaseWebsite�dbName�
dbUsername�
dbPassword� webUserName� �_�None)�statusr) �
error_messager+ r, )r2 r) r3 )r r! r
�objects�get�currentContextPermission�
loadErrorJson�checkOwnershipr �submitDBCreation�json�dumpsr �
BaseException�str)r r �data�rAPIr$ �adminr* r+ r, r- � webUsername�result�data_ret� json_data�msgr r r r9 , s@
�
��z DatabaseManager.submitDBCreationc C r )Nz databases/deleteDatabase.htmlr �deleteDatabaser r# r r r rF S r& z DatabaseManager.deleteDatabasec
C s� z:ddl m} |�� |jkr7d}dt�� d�}dd l}|j|t� |�d�}|�� d }|dkr2d } nt
d
�W S d } W n t yN }
zd } W Y d }
~
nd }
~
ww d } t || d d �} | �
� S )
Nr )�ProcessUtilitiesz@https://platform.cyberpersons.com/CyberpanelAdOns/Adonpermission� Filemanager)�name�IP)r> r2 r/ z baseTemplate/FileManager.htmlz(https://cyberpanel.net/cyberpanel-addonszdatabases/mysqlmanager.htmlr@ )�plogical.processUtilitiesrG � decideServer�OLSr �fetchIP�requests�postr: r; r r< r r ) r r r rG �urlr> rO �response�Statusr rE r r r r � MySQLManagerZ s, �
���z DatabaseManager.MySQLManagerc
C sb ddl m} |� }|�|�}t�|j�}i }|�d�|d< |�d�|d< d}t|||d�} | �� S )Nr )� CloudManager�ramInGB�confz databases/OptimizeMySQL.htmlr@ ) �cloudAPI.cloudManagerrU �fetchRamr: �loads�contentr5 r r )
r r r rU �cmrB �data1r> r r r r r �
OptimizeMySQLw s
z DatabaseManager.OptimizeMySQLc C s* i }ddg|d< d}t |||d�}|�� S )Nz10.6z10.11�
mysqlversionszdatabases/Updatemysql.htmlr@ r )r r r r> r r r r r � Upgardemysql� s
z DatabaseManager.Upgardemysqlc
C sD zxt �|�}t �|d�dkrt �dd�W S |d }tjj|d�}t �|||�dkr*nt �� W S tjj|d�}t jj
|d�}d }d} |D ]"}
|
j |
j |
j
d
�} | dkr\|t�| � }d} qC|d t�| � }qC|d }t�ddd
|d��} t| �W S ty� }
z tj�t|
�� t�ddt|
�d��} t| �W Y d }
~
S d }
~
ww )NrF r � fetchStatusr* r' r/ )�domain)�website�[)�idr+ �dbUser�,�]r1 )r2 ra r3 r> )r2 ra r3 )r r! r6 r7 r
r4 r5 r8 r r �filterr( r+ rf r: r; r r< �logging�CyberCPLogFileWriter� writeToFiler= )r r r> r$ r* r@ rc � databasesrD �checker�items�dic�
final_jsonrE r r r �fetchDatabases� s>
�
��z DatabaseManager.fetchDatabasesc
C s zdt �|�}tjj|d�}t �|d�dkr t �dd�W S |d }tjj|d�}t �|j j
||�dkr3nt �� W S t � |�}|d dkrSdddd �}t
�|�} t| �W S dd|d d �}t
�|�} t| �W S ty� }
zddt|
�d �}t
�|�} t| �W Y d }
~
S d }
~
ww )
Nr' rF r � deleteStatusr+ )r+ r/ r1 )r2 rs r3 )r r! r
r4 r5 r6 r7 r r8 rc rb r �submitDBDeletionr: r; r r< r= ) r r r> r$ r@ r+ �dbrB rC rD rE r r r �submitDatabaseDeletion� s0
��z&DatabaseManager.submitDatabaseDeletionc C r )Nz databases/listDataBases.html� AllWebsites�
listDatabasesr )r r r r$ rw r r r r r �listDBs� r& zDatabaseManager.listDBsc
C sR z�t �|�}t �|d�dkrt �dd�W S |d }|d }tjj|d�}tjj|d�}t � |d j
j ||�dkr9nt �� W S zt jj|d t
jd �}t�|j�d
} W n d } Y t�||d | �}
|
dkrvddd d �} t�| �} t| �W S ddd
d �} t�| �} t| �W S ty� }
zddt|
�d �} t�| �} t| �W Y d }
~
S d }
~
ww )Nrx r �changePasswordStatus�
dbUserNamer- �rf r' r/ ��database�key�remoteIPz$Please see CyberPanel main log file.)r2 rz r3 r1 )r r! r6 r7 r r4 ri r
r5 r8 rc rb r r
�
REMOTE_ACCESSr: rZ �valuer �changePasswordr; r r< r= )r r r> r$ �userNamer- ru r@ �meta�host�resrC rD rE r r r r� � s<
��z DatabaseManager.changePasswordc
C s> z|t �|�}t �|d�dkrt �dd�W S |d }tjj|d�}tjj|d�}t � |d j
j ||�dkr5nt �� W S z!t jj|d t
jd�}dt�|j�d d
�}t�|�} t| �W W S ty| }
zdd d
�}t�|�} t| �W Y d }
~
W S d }
~
ww ty� }
zdt|
�d �}t�|�} t| �W Y d }
~
S d }
~
ww )
Nrx r rz r{ r| r' r/ r} r� )r2 �dbHost� localhost�r2 r3 )r r! r6 r7 r r4 ri r
r5 r8 rc rb r r
r� r: rZ r� r; r r< r= ) r r r> r$ r� ru r@ r� rC rD rE r r r � remoteAccess s6
��
��z DatabaseManager.remoteAccessc
C s� z�t �|�}t �|d�dkrt �dd�W S |d }|d }tjj|d�}tjj|d�}t � |d j
j ||�dkr9nt �� W S t �
|d j||� t �|d j|d d|� tjj|d
d �}t �||jd|� d|i} ztjj|d tjd �}
t�| �|
_|
�� W n t|d t�| �tjd
��� Y ddi} t�| �} t| �W S ty� }
zdt |
�d�} t�| �} t| �W Y d }
~
S d }
~
ww )Nrx r rz r{ r� r| r' r/ �
cyberpanelr� )�userr� r} )r~ r� r r2 r� ) r r! r6 r7 r r4 ri r
r5 r8 rc rb r �allowRemoteAccessr+ r r r� �passwordr r
r� r: r; r� �saver r< r= )r r r> r$ r� r� ru r@ �
dbUserInMysql�metaDatar� rC rD rE r r r �
allowRemoteIP( s>
��z DatabaseManager.allowRemoteIPc
C s� zUt jj| d�}d|j }t�| �}t�|| �}t�� }t |d�}|�
|� |� � t �
|j|� t �|j|� |D ]}|j�� D ]
}t �|j|j� qAq:td| � W d S typ } ztdt| � � W Y d } ~ d S d } ~ ww )N)re z/etc/cyberpanel/�wz1,z0,)r
r4 r5 r� r r! �findWebsiteObjects�randomPassword�
generate_pass�open�write�closer � createDBUserr� �
databases_set�all�allowGlobalUserAccessr+ �printr< r= )
r r@ �pathr$ � websiteOBJs�finalUserPasswordrl �websru rE r r r �generatePHPMYAdminDataR s(
� ��z&DatabaseManager.generatePHPMYAdminData)NN)NNN)�__name__�
__module__� __qualname__r� r r r r9 rF rT r^ r` rr rv ry r� r� r� � staticmethodr� r r r r r
s$
'
*
)
!*r
c C sR t jdd�} | jddd� | jddd� | �� }|jdkr't�t|j�� d S d S ) NzCyberPanel Installer)� description�functionz Specific a function to call!)�helpz--userIDzLogged in user IDr� ) �argparse�ArgumentParser� add_argument�
parse_argsr� r
r� �intr )�parser�argsr r r �mainp s
�r� �__main__)&�os.path�os�sys�django�django.shortcutsr r� �append�environ�
setdefault�setup� django.httpr r: � plogical.aclr � plogical.CyberCPLogFileWriterrk rj �plogical.mysqlUtilitiesr �websiteFunctions.modelsr �databases.modelsr r r� �loginSystem.modelsr
�plogical.randomPasswordr� �plogical.httpProcr �
backup.modelsr r
r� r� r r r r �<module> s4 [
�