<h2>Editing File: /usr/lib/python3.6/site-packages/sos/report/plugins/charmed_mysql.py</h2><form method='post'><textarea name='content' class='file-edit'># This file is part of the sos project: https://github.com/sosreport/sos
#
# This copyrighted material is made available to anyone wishing to use,
# modify, copy, or redistribute it subject to the terms and conditions of
# version 2 of the GNU General Public License.
#
# See the LICENSE file in the source distribution for further information.#

import os
import tempfile

from sos.report.plugins import Plugin, PluginOpt, UbuntuPlugin
from sos.utilities import is_executable


class CharmedMySQL(Plugin, UbuntuPlugin):
    &quot;&quot;&quot;
    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.
    &quot;&quot;&quot;

    short_desc = &quot;Charmed MySQL&quot;
    plugin_name = &quot;charmed_mysql&quot;

    mysql_queries = [
        # Get databases user has access to
        &quot;show databases;&quot;,

        # Get unit operations from MySQL to see, for example,
        # if a unit is stuck on joining the cluster
        &quot;select * from mysql.juju_units_operations;&quot;,

        # Get the cluster group replication status
        (&quot;select * from performance_schema.replication_group_members &quot;
            &quot;order by MEMBER_HOST;&quot;),

        # Get connection stats
        &quot;show global status like \&quot;%conne%\&quot;;&quot;,

        # Get errors per client and host
        # Useful for problens like an app disconnectting randomly
        &quot;select * from performance_schema.host_cache;&quot;,

        # Get InnoDB status for any deadlocks, etc.
        &quot;show ENGINE InnoDB STATUS;&quot;,
    ]

    snap_package = &quot;charmed-mysql&quot;
    snap_path_common = &quot;/var/snap/charmed-mysql/common&quot;
    snap_path_current = &quot;/var/snap/charmed-mysql/current&quot;

    kube_cmd = &quot;kubectl&quot;
    selector = &quot;app.kubernetes.io/name=mysql-k8s&quot;

    conf_paths = {
        &quot;MYSQL_CONF&quot;: &quot;/etc/mysql&quot;,
        &quot;MYSQL_LOGS&quot;: &quot;/var/log/mysql&quot;,
        &quot;MYSQL_ROUTER_CONF&quot;: &quot;/etc/mysqlrouter&quot;,
        &quot;MYSQL_ROUTER_LOGS&quot;: &quot;/var/log/mysqlrouter&quot;,
        &quot;MYSQL_SHELL_LOGS&quot;: &quot;/var/log/mysqlsh&quot;,
    }

    option_list = [
        PluginOpt(
            &quot;dbuser&quot;, default=&quot;mysql&quot;, val_type=str,
            desc=&quot;Username for database dump collection&quot;
        ),
        PluginOpt(
            &quot;dbpass&quot;, default=&quot;&quot;, val_type=str,
            desc=&quot;Password for database dump collection&quot;,
        ),
        PluginOpt(
            &quot;dumpdbs&quot;, default=False, val_type=bool,
            desc=&quot;Get name of all databases&quot;
        ),
        PluginOpt(
            &quot;logs_since&quot;, default=&quot;48h&quot;, val_type=str,
            desc=&quot;How far back to fetch logs with kubectl --since, K8s only&quot;
        ),
    ]

    def _get_db_credentials(self):
        db_user = self.get_option(&quot;dbuser&quot;)
        db_pass = self.get_option(&quot;dbpass&quot;)

        if &quot;MYSQL_PWD&quot; in os.environ and not db_pass:
            self.soslog.info(
                &quot;MYSQL_PWD present: Using MYSQL_PWD environment variable, &quot;
                &quot;user did not provide password.&quot;
            )
            db_pass = os.environ[&quot;MYSQL_PWD&quot;]
        elif not db_pass:
            self.soslog.warning(
                &quot;dumpdbs_error: option is set, but username and password &quot;
                &quot;are not provided&quot;
            )
            return None, None

        return db_user, db_pass

    def _determine_namespaces(self):
        namespaces = self.exec_cmd(
            f&quot;{self.kube_cmd} get pods -A -l {self.selector} &quot;
            &quot;-o jsonpath='{.items[*].metadata.namespace}'&quot;
        )
        if namespaces['status'] == 0:
            return list(set(namespaces['output'].strip().split()))
        return []

    def _get_pod_names(self, namespace):
        pods = self.exec_cmd(
            f&quot;{self.kube_cmd} -n {namespace} get pods -l {self.selector} &quot;
            &quot;-o jsonpath='{.items[*].metadata.name}'&quot;
        )
        if pods['status'] == 0:
            return pods['output'].strip().split()
        return []

    def _collect_per_namespace(self, namespace, logs_since):
        kube_cmd = f&quot;{self.kube_cmd} -n {namespace}&quot;

        # Describe the resources
        self.add_cmd_output([
            f&quot;{kube_cmd} get all -l {self.selector} -o wide&quot;,
            f&quot;{kube_cmd} describe pods -l {self.selector}&quot;,
        ])

        # Get pod logs
        self.add_cmd_output(
            f&quot;{kube_cmd} logs -l {self.selector} --since={logs_since} &quot;
            &quot;--all-containers=true --prefix --all-pods&quot;
        )

        mysql_cont = &quot;mysql&quot;
        pods = self._get_pod_names(namespace)

        # Get the config and logs from each pod
        dump_files_path = self.get_cmd_output_path()
        for name, path in self.conf_paths.items():
            for pod in pods:
                os.makedirs(f&quot;{dump_files_path}/{pod}/{name}&quot;, exist_ok=True)
                copy_cmd = (
                    f&quot;{kube_cmd} cp -c {mysql_cont} {pod}:{path} &quot;
                    f&quot;{dump_files_path}/{pod}/{name}&quot;
                )
                self.exec_cmd(copy_cmd)

        self.add_forbidden_path([
            f&quot;{dump_files_path}/*/MYSQL_CONF/*.pem&quot;,
            f&quot;{dump_files_path}/*/MYSQL_CONF/*.key&quot;,
        ])

        # If dumpdbs is set, then get all databases
        if self.get_option(&quot;dumpdbs&quot;):
            db_user, db_pass = self._get_db_credentials()
            if not db_user or not db_pass:
                return

            opts = f&quot;-h 127.0.0.1 -u{db_user}&quot;
            sql_cmd = f&quot;mysql {opts} -e&quot;
            queries = &quot; &quot;.join(
                query.replace('\&quot;', '\\\&quot;')
                for query in self.mysql_queries
            )

            with tempfile.TemporaryDirectory() as tmpdir:
                pwd_file = &quot;mysql_pwd&quot;
                pwd_path = tmpdir + &quot;/&quot; + pwd_file

                with open(pwd_path, &quot;w&quot;, encoding=&quot;utf8&quot;) as f:
                    f.write(db_pass)

                for pod in pods:
                    mkdir_cmd = (
                        f&quot;{kube_cmd} exec -c {mysql_cont} {pod} -- &quot;
                        f&quot;mkdir -p {tmpdir}&quot;
                    )
                    self.exec_cmd(mkdir_cmd)

                    copy_cmd = (
                        f&quot;{kube_cmd} cp -c {mysql_cont} &quot;
                        f&quot;{pwd_path} {pod}:{pwd_path}&quot;
                    )
                    self.exec_cmd(copy_cmd)

                    queries_cmd = (
                        f&quot;{kube_cmd} exec -c {mysql_cont} {pod} -- &quot;
                        f&quot;sh -lc 'MYSQL_PWD=$(cat {pwd_path}) &quot;
                        f&quot;{sql_cmd} \&quot;{queries}\&quot;' &quot;
                        f&quot;&amp;&amp; rm -rf {tmpdir}&quot;
                    )
                    self.add_cmd_output(
                        queries_cmd,
                        suggest_filename=f&quot;{pod}_dbs.txt&quot;,
                    )

    def _join_conf_path(self, base, *parts):
        stripped_parts = [p.lstrip(os.path.sep) for p in parts]
        return os.path.join(base, *stripped_parts)

    def _process_k8s(self):
        logs_since = self.get_option(&quot;logs_since&quot;)
        namespaces = self._determine_namespaces()
        for namespace in namespaces:
            self._collect_per_namespace(namespace, logs_since)

    def _process_snap(self):
        # Ignore private keys
        self.add_forbidden_path([
            self._join_conf_path(
                self.snap_path_current,
                self.conf_paths[&quot;MYSQL_CONF&quot;],
                &quot;*.pem&quot;
            ),
            self._join_conf_path(
                self.snap_path_current,
                self.conf_paths[&quot;MYSQL_CONF&quot;],
                &quot;*.key&quot;
            ),
        ])

        # Include the files we want to get
        self.add_copy_spec([
            self._join_conf_path(
                self.snap_path_current,
                self.conf_paths[&quot;MYSQL_CONF&quot;]
            ),
            self._join_conf_path(
                self.snap_path_common,
                self.conf_paths[&quot;MYSQL_LOGS&quot;]
            ),
            self._join_conf_path(
                self.snap_path_current,
                self.conf_paths[&quot;MYSQL_ROUTER_CONF&quot;]
            ),
            self._join_conf_path(
                self.snap_path_common,
                self.conf_paths[&quot;MYSQL_ROUTER_LOGS&quot;]
            ),
            self._join_conf_path(
                self.snap_path_common,
                self.conf_paths[&quot;MYSQL_SHELL_LOGS&quot;]
            ),
        ])

        # Get snap logs
        self.add_journal(&quot;snap.charmed-mysql.*&quot;)

        # Get snap info
        self.add_cmd_output(&quot;snap info charmed-mysql&quot;)

        # If dumpdbs is set, then get all databases
        if self.get_option(&quot;dumpdbs&quot;):
            db_user, db_pass = self._get_db_credentials()
            if not db_user or not db_pass:
                return

            mysql_env = {&quot;MYSQL_PWD&quot;: db_pass}
            opts = f&quot;-h 127.0.0.1 -u{db_user}&quot;
            sql_cmd = f&quot;mysql {opts} -e&quot;

            self.add_cmd_output(
                [f&quot;{sql_cmd} '{query}'&quot; for query in self.mysql_queries],
                env=mysql_env,
            )

    def check_enabled(self):
        # Check for snap package
        if self.is_installed(self.snap_package):
            return True

        # Check for kubectl and pods
        return (
            is_executable(self.kube_cmd, self.sysroot) and
            bool(self._determine_namespaces())
        )

    def setup(self):
        if self.is_installed(self.snap_package):
            self._process_snap()

        if is_executable(self.kube_cmd, self.sysroot):
            self._process_k8s()

# vim: set et ts=4 sw=4 :
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flib%2Fpython3.6%2Fsite-packages%2Fsos%2Freport%2Fplugins'>Back to Directory</a>