| Server IP : 77.50.203.18 / Your IP : 192.168.0.10 Web Server : Apache/2.4.62 (CentOS Stream) OpenSSL/3.5.7 mpm-itk/2.4.7-04 PHP/8.4.23 System : Linux web2 5.14.0-722.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Mon Jul 6 09:07:51 UTC 2026 x86_64 User : warsnews.ru ( 1001) PHP Version : 8.4.23 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/lib/python3.9/site-packages/sos/report/plugins/__pycache__/ |
Upload File : |
a
ܓ�i�& � @ sF d dl Z d dlZd dlmZmZmZ d dlmZ G dd� dee�ZdS )� N)�Plugin� PluginOpt� UbuntuPlugin)�
is_executablec @ s� e Zd ZdZdZdZg d�ZdZdZdZ dZ
d Z d
d d d
dd�Z e
ddedd�e
ddedd�e
ddedd�e
dded d�gZd d � Zd d � Zd!d"� Zd#d$� Zd%d&� Zd'd(� Zd)d*� Zd+d,� Zd-d.� Zd/S )0� CharmedMySQLa�
The Charmed MySQL plugin is used to collect MySQL configuration and logs
from the Charmed MySQL snap package or K8s deployment.
It also collects MySQL Router and MySQL Shell configuration and logs
where available, journal logs for the snap, and snap info.
If the `dumpdbs` option is set to `True`, the plugin will also try and
collect the names of the databases that the user has access to. The
`mysql` user is used by default, but that can be set using the `dbuser`
option. When using the `dumpdbs` option, you must then provide the
password for the user using the `dbpass` option or the `MYSQL_PWD`
environment variable.
z
Charmed MySQLZ
charmed_mysql)zshow databases;z*select * from mysql.juju_units_operations;zPselect * from performance_schema.replication_group_members order by MEMBER_HOST;z"show global status like "%conne%";z,select * from performance_schema.host_cache;zshow ENGINE InnoDB STATUS;z
charmed-mysqlz /var/snap/charmed-mysql/commonz /var/snap/charmed-mysql/currentZkubectlz app.kubernetes.io/name=mysql-k8sz
/etc/mysqlz/var/log/mysqlz/etc/mysqlrouterz/var/log/mysqlrouterz/var/log/mysqlsh)�
MYSQL_CONF�
MYSQL_LOGS�MYSQL_ROUTER_CONF�MYSQL_ROUTER_LOGS�MYSQL_SHELL_LOGS�dbuser�mysqlz%Username for database dump collection)�defaultZval_typeZdesc�dbpass� z%Password for database dump collection�dumpdbsFzGet name of all databases�
logs_sinceZ48hz9How far back to fetch logs with kubectl --since, K8s onlyc C sV | � d�}| � d�}dtjv r:|s:| j�d� tjd }n|sN| j�d� dS ||fS )Nr r � MYSQL_PWDzWMYSQL_PWD present: Using MYSQL_PWD environment variable, user did not provide password.zHdumpdbs_error: option is set, but username and password are not provided)NN)�
get_option�os�environZsoslog�infoZwarning)�self�db_user�db_pass� r �D/usr/lib/python3.9/site-packages/sos/report/plugins/charmed_mysql.py�_get_db_credentials[ s
� �z CharmedMySQL._get_db_credentialsc C sB | � | j� d| j� d��}|d dkr>tt|d �� �� ��S g S )Nz get pods -A -l z- -o jsonpath='{.items[*].metadata.namespace}'�statusr �output)�exec_cmd�kube_cmd�selector�list�set�strip�split)r �
namespacesr r r �_determine_namespacesn s � z"CharmedMySQL._determine_namespacesc C s@ | � | j� d|� d| j� d��}|d dkr<|d �� �� S g S )N� -n z
get pods -l z( -o jsonpath='{.items[*].metadata.name}'r r r )r r! r" r% r& )r � namespace�podsr r r �_get_pod_namesw s � zCharmedMySQL._get_pod_namesc C s^ | j � d|� �}| �|� d| j� d�|� d| j� �g� | �|� d| j� d|� d�� d}| �|�}| �� }| j�� D ]f\}}|D ]X} tj|� d | � d |� �d
d � |� d |� d
| � d|� d
|� d | � d |� �
}
| � |
� q�qv| �
|� d�|� d�g� | � d��rZ| � � \} } | �r | �s d S d| � �}
d|
� d�}d
�
dd� | jD ��}t�� ��}d}|d | }t|ddd��}|�| � W d � n1 �s�0 Y |D ]�} |� d|� d
| � d |� �}| � |� |� d |� d
|� d
| � d|� � }
| � |
� |� d|� d
| � d |� d |� d |� d |� �
}| j|| � d!�d"� �q�W d � n1 �sP0 Y d S )#Nr) z get all -l z -o widez describe pods -l z logs -l z --since=z* --all-containers=true --prefix --all-podsr
�/T)�exist_okz cp -c � �:z/*/MYSQL_CONF/*.pemz/*/MYSQL_CONF/*.keyr �-h 127.0.0.1 -u�mysql � -ec s s | ]}|� d d�V qdS )�"z\"N)�replace��.0�queryr r r � <genexpr>� s �z6CharmedMySQL._collect_per_namespace.<locals>.<genexpr>Z mysql_pwd�w�utf8)�encodingz exec -c z
-- mkdir -p z -- sh -lc 'MYSQL_PWD=$(cat z) z "z
"' && rm -rf z_dbs.txt)Zsuggest_filename)r! �add_cmd_outputr" r, Zget_cmd_output_path�
conf_paths�itemsr �makedirsr �add_forbidden_pathr r �join�
mysql_queries�tempfileZTemporaryDirectory�open�write)r r* r r! Z
mysql_contr+ Zdump_files_path�name�pathZpodZcopy_cmdr r �opts�sql_cmdZqueriesZtmpdirZpwd_fileZpwd_path�fZ mkdir_cmdZ queries_cmdr r r �_collect_per_namespace� s� ��
�����
�
*��
����
������z#CharmedMySQL._collect_per_namespacec G s" dd� |D �}t jj|g|�R � S )Nc S s g | ]}|� tjj��qS r )�lstripr rH �sep)r7 �pr r r �
<listcomp>� � z0CharmedMySQL._join_conf_path.<locals>.<listcomp>)r rH rB )r �base�partsZstripped_partsr r r �_join_conf_path� s z CharmedMySQL._join_conf_pathc C s, | � d�}| �� }|D ]}| �||� qd S )Nr )r r( rL )r r r' r* r r r � _process_k8s� s
zCharmedMySQL._process_k8sc s | � | �| j| jd d�| �| j| jd d�g� | �| �| j| jd �| �| j| jd �| �| j| jd �| �| j| jd �| �| j| jd �g� | �d� | �d � | �d
��r
| � � \}}|r�|s�d S d |i}d |� �}d
|� d�� | j� fdd�| j
D �|d� d S )Nr z*.pemz*.keyr r r
r zsnap.charmed-mysql.*zsnap info charmed-mysqlr r r1 r2 r3 c s g | ]}� � d |� d��qS )z '�'r r6 �rJ r r rP rQ z.CharmedMySQL._process_snap.<locals>.<listcomp>)�env) rA rT �snap_path_currentr> Z
add_copy_spec�snap_path_commonZ add_journalr= r r rC )r r r Z mysql_envrI r rW r �
_process_snap� s^ ���������
�zCharmedMySQL._process_snapc C s* | � | j�rdS t| j| j�o(t| �� �S )NT)� is_installed� snap_packager r! �sysroot�boolr( �r r r r �
check_enabled s
�zCharmedMySQL.check_enabledc C s. | � | j�r| �� t| j| j�r*| �� d S )N)r\ r] r[ r r! r^ rU r` r r r �setup s zCharmedMySQL.setupN)�__name__�
__module__� __qualname__�__doc__Z
short_descZ plugin_namerC r] rZ rY r! r" r> r �strr_ Z option_listr r( r, rL rT rU r[ ra rb r r r r r sR � ����� N< r ) r rD Zsos.report.pluginsr r r Z
sos.utilitiesr r r r r r �<module> s