| Server IP : 74.208.127.88 / Your IP : 216.73.216.19 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /proc/thread-self/root/usr/lib/python3/dist-packages/sos/report/plugins/ |
Upload File : |
# Copyright (C) 2018 Red Hat, K.K., Takayoshi Tanaka <tatanaka@redhat.com>
#
# 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.
from sos.report.plugins import Plugin, RedHatPlugin, PluginOpt
class MsSQL(Plugin, RedHatPlugin):
short_desc = 'Microsoft SQL Server on Linux'
plugin_name = "mssql"
profiles = ('services',)
packages = ('mssql-server',)
option_list = [
PluginOpt('mssql-conf', default='/var/opt/mssql/mssql.conf',
desc='SQL server configuration file')
]
def setup(self):
mssql_conf = self.get_option('mssql-conf')
# Pick error log file from mssql_conf.
# Expecting the following format
# ```
# [filelocation]
# errorlogfile = /var/opt/mssql/log
# [sqlagent]
# errorlogfile = /var/opt/mssql/log/sqlagentstartup.log
# [network]
# kerberoskeytabfile = /var/opt/mssql/secrets/mssql.keytab
# ```
section = ''
# default values
errorlogfile = '/var/opt/mssql/log'
sqlagent_errorlogfile = '/var/opt/mssql/log/sqlagentstartup.log'
kerberoskeytabfile = None
try:
with open(mssql_conf, 'r', encoding='UTF-8') as mfile:
for line in mfile.read().splitlines():
if line.startswith('['):
section = line
continue
words = line.split('=')
if words[0].strip() == 'errorlogfile':
if section == '[filelocation]':
errorlogfile = words[1].strip()
elif section == '[sqlagent]':
sqlagent_errorlogfile = words[1].strip()
elif (words[0].strip() == 'kerberoskeytabfile') and \
(section == '[network]'):
kerberoskeytabfile = words[1].strip()
except IOError as ex:
self._log_error(f'Could not open conf file {mssql_conf}: {ex}')
return
# Collect AD authentication configuratoin
keytab_err = ('keytab file is specfieid in mssql_conf'
f' but not found in {kerberoskeytabfile}')
if kerberoskeytabfile is not None:
if self.path_isfile(kerberoskeytabfile):
self.add_cmd_output(f'ls -l {kerberoskeytabfile}')
self.add_cmd_output(f'klist -e -k {kerberoskeytabfile}')
else:
self._log_error(keytab_err)
# Expecting mssql_conf doesn't includeno sensitive information.
self.add_copy_spec([
mssql_conf,
errorlogfile + '/*',
sqlagent_errorlogfile
])
if not self.get_option('all_logs'):
self.add_copy_spec(errorlogfile + '/*')
self.add_copy_spec(sqlagent_errorlogfile)
else:
self.add_copy_spec(errorlogfile + '/*')
self.add_copy_spec(sqlagent_errorlogfile)
self.add_journal(units=['mssql-server'])
# vim: set et ts=4 sw=4 :