| Server IP : 127.0.0.2 / Your IP : 3.148.217.66 Web Server : Apache/2.4.18 (Ubuntu) System : User : www-data ( ) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : disk_free_space,disk_total_space,diskfreespace,dl,exec,fpaththru,getmyuid,getmypid,highlight_file,ignore_user_abord,leak,listen,link,opcache_get_configuration,opcache_get_status,passthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,php_uname,phpinfo,posix_ctermid,posix_getcwd,posix_getegid,posix_geteuid,posix_getgid,posix_getgrgid,posix_getgrnam,posix_getgroups,posix_getlogin,posix_getpgid,posix_getpgrp,posix_getpid,posix,_getppid,posix_getpwnam,posix_getpwuid,posix_getrlimit,posix_getsid,posix_getuid,posix_isatty,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setuid,posix_times,posix_ttyname,posix_uname,pclose,popen,proc_open,proc_close,proc_get_status,proc_nice,proc_terminate,shell_exec,source,show_source,system,virtual MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/sosreport/sos/plugins/ |
Upload File : |
# 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.plugins import Plugin, RedHatPlugin, DebianPlugin, UbuntuPlugin
import os
class Mysql(Plugin):
"""MySQL and MariaDB RDBMS
"""
plugin_name = "mysql"
profiles = ('services',)
mysql_cnf = "/etc/my.cnf"
pw_warn_text = " (password visible in process listings)"
option_list = [
("dbuser", "username for database dumps", "", "mysql"),
("dbpass", "password for database dumps" + pw_warn_text, "", ""),
("dbdump", "collect a database dump", "", False)
]
def setup(self):
super(Mysql, self).setup()
self.add_copy_spec([
self.mysql_cnf,
# Required for MariaDB under pacemaker (MariaDB-Galera)
"/var/log/mysqld.log",
"/var/log/mysql/mysqld.log",
"/var/log/mariadb/mariadb.log",
"/var/lib/mysql/grastate.dat"
])
if self.get_option("all_logs"):
self.add_copy_spec([
"/var/log/mysql*",
"/var/log/mariadb*"
])
if self.get_option("dbdump"):
msg = "database user name and password must be supplied"
dbdump_err = "mysql.dbdump: %s" % msg
dbuser = self.get_option("dbuser")
dbpass = self.get_option("dbpass")
if 'MYSQL_PWD' in os.environ:
dbpass = os.environ['MYSQL_PWD']
if dbuser is True or dbpass is True:
# sosreport -a or -k mysql.{dbuser,dbpass}
self.soslog.warning(dbdump_err)
return
if not dbpass or dbpass is False:
# no MySQL password
self.soslog.warning(dbdump_err)
return
# no need to save/restore as this variable is private to
# the mysql plugin.
os.environ['MYSQL_PWD'] = dbpass
opts = "--user=%s --all-databases" % dbuser
name = "mysqldump_--all-databases"
self.add_cmd_output("mysqldump %s" % opts, suggest_filename=name)
self.add_cmd_output("du -s /var/lib/mysql/*")
class RedHatMysql(Mysql, RedHatPlugin):
packages = (
'mysql-server',
'mysql',
'mariadb-server',
'mariadb',
'openstack-selinux'
)
def setup(self):
super(RedHatMysql, self).setup()
self.add_copy_spec([
"/etc/ld.so.conf.d/mysql-*.conf",
"/etc/ld.so.conf.d/mariadb-*.conf",
"/etc/my.cnf.d/*",
"/var/lib/config-data/puppet-generated/mysql/etc/my.cnf.d/*"
])
class DebianMysql(Mysql, DebianPlugin, UbuntuPlugin):
packages = (
'mysql-server',
'mysql-common',
'mariadb-server',
'mariadb-common'
)
def setup(self):
super(DebianMysql, self).setup()
self.add_copy_spec("/etc/mysql/conf.d/mysql*")
# vim: set et ts=4 sw=4 :