File: //usr/local/CyberCP/databases/__pycache__/views.cpython-310.pyc
o
��hA? � @ s� d dl Z d dlmZ d dlmZmZ d dlmZ d dlm Z d dl
m Z ddl m
Z
dd lmZ dd
lmZ d dlZd d lmZ d d lmZ d d
lmZ d dlmZ d dlmZ d dl m Z d dl m Z d dl m!Z" dd� Z#dd� Z$dd� Z%dd� Z&dd � Z'd d � Z(d d � Z)d!d"� Z*d#d$� Z+d%d&� Z,d'd(� Z-d)d*� Z.ed+d,� �Z/d-d.� Z0d/d0� Z1d1d2� Z2d3d4� Z3d5d6� Z4d7d8� Z5d9d:� Z6d;d<� Z7d=d>� Z8dS )?� N)�randint)�redirect� HttpResponse)� csrf_exempt)� CloudManager)�
loadLoginPage� )�DatabaseManager)�MySQLOptimizer)�
pluginManager)�ProcessUtilities)�
Administrator)�
ACLManager)� GlobalUserDB)�randomPassword)�Fernet)�mysqlUtilities)�CyberCPLogFileWriterc C �: z| j d }t� }|�| |�W S ty tt� Y S w �N�userID)�sessionr �loadDatabaseHome�KeyErrorr r ��requestr �dm� r �%/usr/local/CyberCP/databases/views.pyr �
�r c C sp z*t �| �}|dkr
|W S | jd }t� }|�| |�}t �| |�}|dkr(|W S |W S ty7 tt� Y S w )N�� r ) r �preCreateDatabaser r �createDatabase�postCreateDatabaser r r )r �resultr r �
coreResultr r r r" # s
�r" c C �x z.| j d }t�| �}|dkr|W S t� }|�|t�| j��}t�| |�}|dkr,|W S |W S t y; t
t � Y S w �Nr r ) r r �preSubmitDBCreationr �submitDBCreation�json�loads�body�postSubmitDBCreationr r r �r r r$ r r% r r r r) 7 s
�r) c C r r )r r �deleteDatabaser r r r r r r r/ L r r/ c C sB z| j d }t� }|�|t�| j��W S ty tt� Y S w r ) r r �fetchDatabasesr* r+ r, r r r r r r r r0 U s
�r0 c C r& r' ) r r �preSubmitDatabaseDeletionr �submitDatabaseDeletionr* r+ r, �postSubmitDatabaseDeletionr r r r. r r r r2 ^ s
�r2 c C r r )r r �listDBsr r r r r r r r4 q r r4 c C r& r' ) r r �preChangePasswordr �changePasswordr* r+ r, �postChangePasswordr r r r. r r r r6 z s
�r6 c C �F z| j d }t� }|�|t�| j��}|W S ty" tt� Y S w r ) r r � remoteAccessr* r+ r, r r r �r r r r% r r r r9 � �
�r9 c C r8 r ) r r �
allowRemoteIPr* r+ r, r r r r: r r r r< � r; r< c C r r )r r �
phpMyAdminr r r r r r r r= � r r= c
C sb �z| j d }tjj|d�}t�|�}d}t�|� |d dkrlz tjj|j d��
� W n ztjj |j d�}|D ]}|�
� q;W n Y Y t �
� }t �
� }t|j ||d��� d||j d�}t�|�} t| �W S d |j }
z tjj|j d��
� W n Y d
|
}t�|� t�� } t|
d �} | �| �� � | �� d |
}t�|� d
|
}t�|� t �
� }t �
� }t| �}
t|j |
�|�d���� |d��� t�||�}t� d |j |d� |D ]}|j � � D ] }t� |j |j |d� q�q�d||j d�}t�|�} t| �W S t �y0 } z t!�"t#|�� ddt#|�d�}t�|�} t| �W Y d }~S d }~ww )Nr ��idz4chmod 640 /usr/local/lscp/cyberpanel/logs/access.log�adminr ��username)rB �password�token)�statusrD rB � /home/cyberpanel/phpmyadmin_%szrm -f %s�wzchown root:root %sz chmod 600 %s�utf-8r �rE �createDBStatus�
error_message)$r r
�objects�getr � loadedACLr � executionerr �userName�delete�filterr �
generate_pass�saver* �dumpsr r � generate_key�open�write�decode�close�encrypt�encode�findWebsiteObjectsr � addUserToDB�
databases_set�all�dbName�
BaseException�logging� writeToFile�str)r r r@ �
currentACL�command�gbobsrC rD �data_ret� json_data� keySavePath�keyrd �f�sites�site�db�msgr r r �generateAccess� s|
��
� �
��rr c
C sf �z
| j d }tjj|d�}t�|�}| j�d�}| j�d�}ddlm} || d �}||j kr4t
t �W S t jj|j d�}|j
|k�r
|d d kr�d
} z)t�t| d ��� �}
|
d } |
d
} i }
| |
d< | |
d< || d|
d�}|�� W W S ty� } z4t| �}|�� }
|
�dd �d } | �d��d�} i }
d|
d< | |
d< || d|
d�}|�� W Y d }~W S d }~ww d|j }t�d| ��d��� }t|�}|�|j�d��} t� ||�}|D ]}|j � � D ]}t � |j!|j | �"� d� q�q�i }
|j |
d< | �"� |
d< || d|
d�}|�� W S t
t �W S t�y2 } zddt#|�d�}t�$|�}t%|�W Y d }~S d }~ww )Nr r> rD rB r )�httpProcrA r@ r z /etc/cyberpanel/mysqlPassword�r� mysqluser�
mysqlpasswordrP rC zdatabases/AutoLogin.html�
�
�rootrF zcat %srH �
listDatabasesrI )&r r
rL rM r rN �POST�plogical.httpProcrs rP r r r rD r* r+ rW �read�renderrb �split�stripr �outputExecutionerr\ r �decryptrC r] r_ r` r r^ ra rY re rU r )r r r@ rf rD rB rs �proc�gdb�passFile�jsonDataru rC �datarq rm rk rl rn ro rp ri rj r r r �fetchDetailsPHPMYAdmin s|
� ���
�
�
��r� c C r r )r r � MySQLManagerr r r r r r r r� b r r� c C r r )r r �
OptimizeMySQLr r r r r r r r� k r r� c C r r )r r � Upgardemysqlr r r r r r r � UpgradeMySQLt r r� c C sh z&| j d }t�� }t�|�}|d dkrnt�dd�W S t�|�}t|�W S t y3 t
t � Y S w )Nr r@ r �FilemanagerAdminr ) r r �
showStatusr rN �
loadErrorJsonr* rU r r r r )r r � finalDatarf r r r �getMysqlstatus} s
�r� c C s� z4| j d }t�|�}|d dkrnt�dd�W S i }t�� }|d |d< |d |d< t�|�}t|�W S t yA t
t � Y S w �Nr r@ r r� r rE rK ) r r rN r� r � restartMySQLr* rU r r r r )r r rf r� r� rj r r r r� � s
�r� c C s� z9| j d }t�|�}|d dkrnt�dd�W S t�| j�}|d }i }d|d< t�|�|d< t� |�}t
|�W S t yF t t
� Y S w ) Nr r@ r r� r � detectedRamrE �
generatedConf)r r rN r� r* r+ r, r
�generateRecommendationsrU r r r r )r r rf r� r� �
final_jsonr r r r� � s
�r� c C s� z;| j d }t�|�}|d dkrnt�dd�W S t�| j�}t�|�}i }|d |d< |d |d< t� |�}t
|�W S t yH t t
� Y S w r� )r r rN r� r* r+ r, r �applyMySQLChangesrU r r r r )r r rf r� r� r� r r r r� � s
�r� c
C s� zSddl m} | jd }t�|�}|d dkrnt�dd�W S t�| j�}|d }dt t
d d
�� }d |� d |� �}t � |� t
�d
� dd|d�}t�|�} t| �W S ty` tt� Y S w )Nr )�virtualHostUtilitiesr r@ r r� � mysqlversionz/home/cyberpanel/i� i' ze/usr/local/CyberCP/bin/python /usr/local/CyberCP/plogical/mysqlUtilities.py UpgradeMariaDB --version z --tempStatusPath � �None)rE rK �tempStatusPath)� plogical.virtualHostUtilitiesr� r r rN r� r* r+ r, re r r �popenExecutioner�time�sleeprU r r r r )
r r� r rf r� �versionr� �execPathri rj r r r �upgrademysqlnow� s*
�
�r� c C s zu| j d }t�|�}|d dkrnt�dd�W S t�| j�}|d }t�d| �}|� d�d krId
| }t�
|� t� d |ddd ��}t |�W S |� d
�d krhd
| }t�
|� t� ddd |d��}t |�W S t� dd |d��}t |�W S t
y� tt� Y S w )Nr r@ r r� r �
statusfilez sudo cat z[200]���z sudo rm -f r� )rK �
requestStatus�abort� installedz[404])r� r� rK r� )r� rK r� )r r rN r� r* r+ r, r r� �findrO rU r r r r )r r rf r� r� �
installStatusrg r� r r r �upgrademysqlstatus� sL
�
�
�
�r� )9r� �randomr �django.shortcutsr r � django.views.decorators.csrfr �cloudAPI.cloudManagerr �loginSystem.viewsr �databaseManagerr �mysqlOptimizerr
r r* �plogical.processUtilitiesr �loginSystem.modelsr
� plogical.aclr �databases.modelsr �plogicalr �cryptography.fernetr �plogical.mysqlUtilitiesr � plogical.CyberCPLogFileWriterr rc r r" r) r/ r0 r2 r4 r6 r9 r< r= rr r� r� r� r� r� r� r� r� r� r� r r r r �<module> sR R
`