([Qh8ddlZddlmZmZmZGddeeZy)N)Plugin PluginOpt UbuntuPlugincheZdZdZdZdZdZeddeded d ed ed d e dgZ dZ y) CharmedMySQLa_ The Charmed MySQL plugin is used to collect MySQL configuration and logs from the Charmed MySQL snap package. 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. z Charmed MySQL charmed_mysql)z charmed-mysqldbusermysqlz%Username for database dump collection)defaultval_typedescdbpassz%Password for database dump collectiondumpdbsFzGet name of all databasescd}d}tdtjD}|rd}d}|d|d|d|d|d d }|j|d d |d d g|j |d |d|d|d|dg|s"|j d|j d|jdr|jd}|jd}dtjvr1|s/|jjdtjd}n|s|jjdyd|i}d|}d|d} gd} |j | D cgc] } | d|  c} |yycc} w) Nz/var/snap/charmed-mysql/commonz/var/snap/charmed-mysql/currentc3$K|]}d|v yw) KUBERNETESN).0keys B/usr/lib/python3/dist-packages/sos/report/plugins/charmed_mysql.py z%CharmedMySQL.setup..5sC,Csrz /etc/mysqlz/var/log/mysqlz/etc/mysqlrouterz/var/log/mysqlrouterz/var/log/mysqlsh) MYSQL_CONF MYSQL_LOGSMYSQL_ROUTER_CONFMYSQL_ROUTER_LOGSMYSQL_SHELL_LOGSrz/*.pemz/*.keyrrrrzsnap.charmed-mysql.*zsnap info charmed-mysqlrr 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 providedz-h 127.0.0.1 -uzmysql z -e)z'show databases;'z,'select * from mysql.juju_units_operations;'zR'select * from performance_schema.replication_group_members order by MEMBER_HOST;'z$'show global status like "%conne%";'z.'select * from performance_schema.host_cache;' )env) anyosenvironadd_forbidden_path add_copy_spec add_journaladd_cmd_output get_optionsosloginfowarning) selfsnap_path_commonsnap_path_current k8s_deploy conf_pathsdb_userdb_pass mysql_envoptssql_cmdqueriesquerys rsetupzCharmedMySQL.setup/s;=C CC  !  " //z:-.n=$5#66F!G$4#55I!J#3"44D E   ,'( /,'( /!   | $ | $ * + * + ) *      3 4    9 : ??9 %ooh/Gooh/Gbjj(   5**[1 ##'$g.I$WI.DtfC(GG(   3:;%G9AeW%;  W &XrEs  >>@6<@rC