<h2>Editing File: /usr/lib/python3.6/site-packages/sos/report/plugins/microovn.py</h2><form method='post'><textarea name='content' class='file-edit'># Copyright (C) 2024 Alan Baghumian &lt;alan.baghumian@canonical.com&gt;

# 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 json
from sos.report.plugins import Plugin, UbuntuPlugin


class MicroOVN(Plugin, UbuntuPlugin):
    &quot;&quot;&quot;The MicroOVN plugin collects the current status of the microovn
    snap.

    It will collect journald logs as well as output from various microovn
    commands.
    &quot;&quot;&quot;

    short_desc = 'MicroOVN Snap'
    plugin_name = &quot;microovn&quot;
    profiles = ('network', 'virt')

    packages = ('microovn', )
    commands = ('microovn', )

    def setup(self):
        self.add_journal(units=&quot;snap.microovn.*&quot;)

        microovn_subcmds = [
            'cluster list',
            'status',
            'certificates list',
            '--version'
        ]
        self.add_cmd_output([
            f&quot;microovn {subcmd}&quot; for subcmd in microovn_subcmds
        ])

        dqlite_crt = &quot;/var/snap/microovn/common/state/cluster.crt&quot;
        self.add_cmd_output(
            f&quot;openssl x509 -in {dqlite_crt} -noout -dates&quot;,
        )

        db_path = &quot;/var/snap/microovn/common/state/database&quot;
        log_path = &quot;/var/snap/microovn/common/logs&quot;

        # Check for inconsistent dqlite db intervals
        self.add_dir_listing(
            db_path,
            suggest_filename=&quot;ls_microovn_dqlite_dir&quot;,
        )

        self.add_copy_spec([
            f&quot;{db_path}/info.yaml&quot;,
            f&quot;{db_path}/cluster.yaml&quot;,
            f&quot;{db_path}/../daemon.yaml&quot;,
            f&quot;{log_path}/*.log&quot;,
        ])

        if self.get_option('all_logs'):
            self.add_copy_spec(f&quot;{log_path}/*.log.*&quot;)

        queries = [
            {
                &quot;query&quot;: &quot;SELECT * FROM sqlite_master WHERE type=\&quot;table\&quot;;&quot;,
                &quot;suggested_file_suffix&quot;: &quot;schema&quot;,
            },
            {
                &quot;query&quot;: (
                    &quot;SELECT * FROM config WHERE NOT ( &quot;
                    &quot;key LIKE \&quot;%keyring%\&quot; OR &quot;
                    &quot;key LIKE \&quot;%ca_cert%\&quot; OR &quot;
                    &quot;key LIKE \&quot;%ca_key%\&quot; );&quot;
                ),
                &quot;suggested_file_suffix&quot;: &quot;config&quot;,
            },
            {
                &quot;query&quot;: &quot;SELECT * FROM services;&quot;,
                &quot;suggested_file_suffix&quot;: &quot;services&quot;,
            },
            {
                &quot;query&quot;: (
                    &quot;SELECT id, name, expiry_date &quot;
                    &quot;FROM core_token_records;&quot;
                ),
                &quot;suggested_file_suffix&quot;: &quot;token_records&quot;,
            },
            {
                &quot;query&quot;: (
                    &quot;SELECT id, name, address, schema_internal, &quot;
                    &quot;schema_external, heartbeat, role, api_extensions &quot;
                    &quot;FROM core_cluster_members;&quot;
                ),
                &quot;suggested_file_suffix&quot;: &quot;core_cluster_members&quot;,
            },
        ]

        for query_entry in queries:
            query = json.dumps(query_entry.get(&quot;query&quot;))
            file_suffix = query_entry.get(&quot;suggested_file_suffix&quot;)
            self.add_cmd_output(
                f&quot;microovn cluster sql {query}&quot;,
                suggest_filename=f&quot;microovn_cluster_sql_{file_suffix}&quot;,
            )

# 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>