Логи ошибок
# systemctl status mysql.service
[?1h= ● mysql.service - MySQL Community Server[m
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en[m
Active: activating (start-post) (Result: exit-code) since Mon 2020-01-27 16:0[m
Process: 124370 ExecStart=/usr/sbin/mysqld [0;1;31m(code=exited, status=1/FAILURE)[0m[m
Process: 124361 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=ex[m
Main PID: 124370 (code=exited, status=1/FAILURE); : 124371 (mysql-syste[m
CGroup: /system.slice/mysql.service[m
└─control[m
├─124371 /bin/bash /usr/share/mysql/mysql-systemd-start post[m
└─124402 sleep 1[m
[m
Jan 27 16:02:47 zabbix mysqld[124370]: 2020-01-27T13:02:47.576599Z 0 [ERROR] Inn[m
Jan 27 16:02:47 zabbix mysqld[124370]: 2020-01-27T13:02:47.576689Z 0 [ERROR] Inn[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741780Z 0 [ERROR] Plu[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741897Z 0 [ERROR] Plu[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741911Z 0 [ERROR] Fai[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741920Z 0 [ERROR] Abo[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741945Z 0 [Note] Binl[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.742005Z 0 [Note] Shut[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.742340Z 0 [Note] /usr[m
Jan 27 16:02:48 zabbix systemd[1]: [0;1;39mmysql.service: Main process exited, code=exit[m
[systemd-start[1P/share/mysql/mysql-systemd-start[1P/share/mysql/mysql-systemd-startr/share/mysql/mysql-systemd-start
[?1049h[?1h=[1;24r[?12;25h[?12l[?25h[27m[23m[m[H[2J[?25l[24;1H"/usr/share/mysql/mysql-systemd-start" 58 lines, 1520 characters[1;1H#!/bin/bash
#
# Scripts to run by MySQL systemd service
#
# Needed argument: pre | post
#
# pre mode : try to perform sanity check for configuration, log, data
#post mode : ping server until answer is received
# Read a config option from mysql. Note that this will only work if a config
# file actually specifies the option, so it's important to specify a default
# $1 is application (e.g. mysqld for server)
# $2 is option
# $3 is default value used if no config value is found
get_mysql_option() {[16;9Hresult=$(my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1)[17;9Hif [ -z "$result" ];[18;9Hthen[19;17Hresult="$3"[20;9Hfi[21;9Hecho "$result"
}
sanity () {[1;1H[?12l[?25h[27m[23m[m[H[2J[?25l[1;1H#!/bin/bash
#
# Scripts to run by MySQL systemd service
#
# Needed argument: pre | post
#
# pre mode : try to perform sanity check for configuration, log, data
#post mode : ping server until answer is received
# Read a config option from mysql. Note that this will only work if a config
# file actually specifies the option, so it's important to specify a default
# $1 is application (e.g. mysqld for server)
# $2 is option
# $3 is default value used if no config value is found
get_mysql_option() {[16;9Hresult=$(my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1)[17;9Hif [ -z "$result" ];[18;9Hthen[19;17Hresult="$3"[20;9Hfi[21;9Hecho "$result"
}
sanity () {
if [ ! -r /etc/mysql/my.cnf ]; then
echo "MySQL configuration not found at /etc/mysql/my.cnf. Please create one."
exit 1
fi
datadir=$(get_mysql_option mysqld datadir "/var/lib/mysql")
if [ ! -d "${datadir}" ] && [ ! -L "${datadir}" ]; then
echo "MySQL data dir not found at ${datadir}. Please create one."
exit 1
fi
if [ ! -d "${datadir}/mysql" ] && [ ! -L "${datadir}/mysql" ]; then
echo "MySQL system database not found in ${datadir}. Please run mysqld --initialize."
exit 1
fi
}
pinger () {
server_up=false
for i in $(seq 1 30); do
sleep 1
if mysqladmin ping >/dev/null 2>&1; then[45;7Hserver_up=true[46;7Hbreak
fi
done
if [ ! $server_up ]; then
echo "MySQL server not started"
exit 1
fi
}
case $1 in
"pre") sanity ;;
"post") pinger ;;
esac
[1m[34m~ [60;1H~ [61;1H~ [1;1H[?12l[?25h[27m[23m[m[H[2J[?25l[1;1H#!/bin/bash
#
# Scripts to run by MySQL systemd service
#
# Needed argument: pre | post
#
# pre mode : try to perform sanity check for configuration, log, data
#post mode : ping server until answer is received
# Read a config option from mysql. Note that this will only work if a config
# file actually specifies the option, so it's important to specify a default
# $1 is application (e.g. mysqld for server)
# $2 is option
# $3 is default value used if no config value is found
get_mysql_option() {[16;9Hresult=$(my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1)[17;9Hif [ -z "$result" ];[18;9Hthen[19;17Hresult="$3"[20;9Hfi[21;9Hecho "$result"
}
sanity () {[1;1H[?12l[?25h[27m[23m[m[H[2J[?25l[1;1H#!/bin/bash
#
# Scripts to run by MySQL systemd service
#
# Needed argument: pre | post
#
# pre mode : try to perform sanity check for configuration, log, data
#post mode : ping server until answer is received
# Read a config option from mysql. Note that this will only work if a config
# file actually specifies the option, so it's important to specify a default
# $1 is application (e.g. mysqld for server)
# $2 is option
# $3 is default value used if no config value is found
get_mysql_option() {[16;9Hresult=$(my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1)[17;9Hif [ -z "$result" ];[18;9Hthen[19;17Hresult="$3"[20;9Hfi[21;9Hecho "$result"
}
sanity () {
if [ ! -r /etc/mysql/my.cnf ]; then
echo "MySQL configuration not found at /etc/mysql/my.cnf. Please create one."
exit 1
fi
datadir=$(get_mysql_option mysqld datadir "/var/lib/mysql")
if [ ! -d "${datadir}" ] && [ ! -L "${datadir}" ]; then
echo "MySQL data dir not found at ${datadir}. Please create one."
exit 1
fi
if [ ! -d "${datadir}/mysql" ] && [ ! -L "${datadir}/mysql" ]; then
echo "MySQL system database not found in ${datadir}. Please run mysqld --initialize."
exit 1
fi
}
pinger () {
server_up=false
for i in $(seq 1 30); do
sleep 1
if mysqladmin ping >/dev/null 2>&1; then[45;7Hserver_up=true[46;7Hbreak
fi
done
if [ ! $server_up ]; then
echo "MySQL server not started"
exit 1
fi
}
case $1 in
"pre") sanity ;;
"post") pinger ;;
esac
[1m[34m~ [60;1H~ [61;1H~ [1;1H[?12l[?25h[?25l[m[62;1HType :quit<Enter> to exit Vim[1;1H[?12l[?25h[?25l[62;1H[K[62;1H:[?12l[?25hq! [?25l[62;1H[K[62;1H[?1l>[?12l[?25h[?1049l]0;root@zabbix: # vi /usr/share/mysql/mysql-systemd-start[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[Ketc/mysql/my.cnf
[?1049h[?1h=[1;62r[?12;25h[?12l[?25h[27m[23m[m[H[2J[?25l[62;1H"/etc/mysql/my.cnf" 23 lines, 736 characters[1;1H#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/se...variables.html
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
#includedir /etc/mysql/conf.d/
[mysqld]
innodb_purge_threads=0
innodb_force_recovery=0
includedir /etc/mysql/mysql.conf.d/
[1m[34m~ [1;1H[?12l[?25h[?25l[m[62;1H[K[62;1H:[?12l
# journalcte -xe[1P -xel -xe
[?1h= [KJan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817049Z 0 [Note] InnoDB: PUNCH HOLE support available[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817077Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817089Z 0 [Note] InnoDB: Uses event mutexes[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817110Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817125Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817137Z 0 [Note] InnoDB: Using Linux native AIO[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817687Z 0 [Note] InnoDB: Number of pools: 1[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817925Z 0 [Note] InnoDB: Using CPU crc32 instructions[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.830417Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.850853Z 0 [Note] InnoDB: Completed initialization of buffer pool[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.856033Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.870446Z 0 [Note] InnoDB: Highest supported file format is Barracuda.[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.876356Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 377631420597[m
Jan 27 16:05:39 zabbix mysqld[125009]: 2020-01-27T13:05:39.404496Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 377636663296[m
Jan 27 16:05:39 zabbix mysqld[125009]: 2020-01-27T13:05:39.542839Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 377638792985[m
Jan 27 16:05:39 zabbix mysqld[125009]: 2020-01-27T13:05:39.546191Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 377631420597 and the end 377638792985.[m
Jan 27 16:05:39 zabbix mysqld[125009]: 2020-01-27T13:05:39.546229Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.740934Z 0 [ERROR] Plugin 'InnoDB' init function returned error.[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741064Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741081Z 0 [ERROR] Failed to initialize builtin plugins.[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741092Z 0 [ERROR] Aborting[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741123Z 0 [Note] Binlog end[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741361Z 0 [Note] Shutting down plugin 'MyISAM'[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741732Z 0 [Note] /usr/sbin/mysqld: Shutdown complete[m
Jan 27 16:05:40 zabbix systemd[1]: [0;1;39mmysql.service: Main process exited, code=exited, status=1/FAILURE[0m[m
proc-sys-fs-binfmt_misc.automount loaded active waiting Arbitrary Executable File Formats File System Automount Point[m
sys-devices-pci0000:00-0000:00:10.0-host32-target32:0:0-32:0:0:0-block-sda-sda1.device loaded active plugged VMware_Virtual_S 1[m
sys-devices-pci0000:00-0000:00:10.0-host32-target32:0:0-32:0:0:0-block-sda-sda2.device loaded active plugged VMware_Virtual_S 2[m
sys-devices-pci0000:00-0000:00:10.0-host32-target32:0:0-32:0:0:0-block-sda-sda5.device loaded active plugged VMware_Virtual_S 5[m
sys-devices-pci0000:00-0000:00:10.0-host32-target32:0:0-32:0:0:0-block-sda.device loaded active plugged VMware_Virtual_S[m
sys-devices-pci0000:00-0000:00:11.0-0000:02:01.0-net-ens33.device loaded active plugged 82545EM Gigabit Ethernet Controller (Copper) (PRO/1000 MT Single Port Adapter)[m
sys-devices-pci0000:00-0000:00:11.0-0000:02:02.0-sound-card0.device loaded active plugged ES1371 / Creative Labs CT2518/ES1373 (AudioPCI 64V/128 / Creative CT4810/CT5803/CT5806[m
sys-devices-platform-serial8250-tty-ttyS1.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS1[m
sys-devices-platform-serial8250-tty-ttyS10.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS10[m
sys-devices-platform-serial8250-tty-ttyS11.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS11[m
sys-devices-platform-serial8250-tty-ttyS12.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS12[m
sys-devices-platform-serial8250-tty-ttyS13.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS13[m
sys-devices-platform-serial8250-tty-ttyS14.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS14[m
sys-devices-platform-serial8250-tty-ttyS15.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS15[m
sys-devices-platform-serial8250-tty-ttyS16.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS16[m
sys-devices-platform-serial8250-tty-ttyS17.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS17[m
sys-devices-platform-serial8250-tty-ttyS18.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS18[m
sys-devices-platform-serial8250-tty-ttyS19.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS19[m
sys-devices-platform-serial8250-tty-ttyS2.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS2[m
sys-devices-platform-serial8250-tty-ttyS20.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS20[m
sys-devices-platform-serial8250-tty-ttyS21.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS21[m
sys-devices-platform-serial8250-tty-ttyS22.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS22[m
sys-devices-platform-serial8250-tty-ttyS23.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS23[m
sys-devices-platform-serial8250-tty-ttyS24.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS24[m
sys-devices-platform-serial8250-tty-ttyS25.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS25[m
sys-devices-platform-serial8250-tty-ttyS26.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS26[m
sys-devices-platform-serial8250-tty-ttyS27.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS27[m
sys-devices-platform-serial8250-tty-ttyS28.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS28[m
sys-devices-platform-serial8250-tty-ttyS29.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS29[m
sys-devices-platform-serial8250-tty-ttyS3.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS3[m
sys-devices-platform-serial8250-tty-ttyS30.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS30[m
sys-devices-platform-serial8250-tty-ttyS31.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS31[m
sys-devices-platform-serial8250-tty-ttyS4.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS4[m
sys-devices-platform-serial8250-tty-ttyS5.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS5[m
sys-devices-platform-serial8250-tty-ttyS6.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS6[m
sys-devices-platform-serial8250-tty-ttyS7.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS7[m
sys-devices-platform-serial8250-tty-ttyS8.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS8[m
sys-devices-platform-serial8250-tty-ttyS9.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS9[m
sys-devices-pnp0-00:05-tty-ttyS0.device loaded active plugged /sys/devices/pnp0/00:05/tty/ttyS0[m
sys-devices-virtual-block-dm\x2d0.device loaded active plugged /sys/devices/virtual/block/dm-0[m
sys-devices-virtual-block-dm\x2d1.device loaded active plugged /sys/devices/virtual/block/dm-1[m
sys-devices-virtual-misc-rfkill.device loaded active plugged /sys/devices/virtual/misc/rfkill[m
sys-devices-virtual-tty-ttyprintk.device loaded active plugged /sys/devices/virtual/tty/ttyprintk[m
sys-module-fuse.device loaded active plugged /sys/module/fuse[m
sys-subsystem-net-devices-ens33.device loaded active plugged 82545EM Gigabit Ethernet Controller (Copper) (PRO/1000 MT Single Port Adapter)[m
-.mount loaded active mounted /[m
boot.mount loaded active mounted /boot[m
dev-hugepages.mount loaded active mounted Huge Pages File System[m
dev-mqueue.mount loaded active mounted POSIX Message Queue File System[m
sys-fs-fuse-connections.mount loaded active mounted FUSE Control File System[m
sys-kernel-debug.mount loaded active mounted Debug File System[m
systemd-ask-password-plymouth.path loaded active waiting Forward Password Requests to Plymouth Directory Watch[m
systemd-ask-password-wall.path loaded active waiting Forward Password Requests to Wall Directory Watch[m
systemd-networkd-resolvconf-update.path loaded active waiting Trigger resolvconf update for networkd DNS[m
init.scope loaded active running System and Service Manager[m
apache2.service loaded active running LSB: Apache2 web server[m
apparmor.service loaded active exited LSB: AppArmor initialization[m
console-setup.service loaded active exited Set console font and keymap[m
cron.service loaded active running Regular background program processing daemon[m
getty-static.service loaded active exited getty on tty2-tty6 if dbus and logind are not available[m
[7mlines 1-61[27m[K [[email protected] loaded active running Getty on tty1[m
[7mlines 2-62[27m[K [[email protected] loaded active running Getty on tty2[m
[7mlines 3-63[27m[K [[email protected] loaded active running Getty on tty3[m
[7mlines 4-64[27m[K [[email protected] loaded active running Getty on tty4[m
[7mlines 5-65[27m[K [[email protected] loaded active running Getty on tty5[m
[7mlines 6-66[27m[K [[email protected] loaded active running Getty on tty6[m
[7mlines 7-67[27m[K [Kgrub-common.service loaded active exited LSB: Record successful boot for GRUB[m
[7mlines 8-68[27m[K [[email protected] loaded active exited ifup for ens33[m
[7mlines 9-69[27m[K [Kkeyboard-setup.service loaded active exited Set console keymap[m
[7mlines 10-70[27m[K [Kkmod-static-nodes.service loaded active exited Create list of required static device nodes for the current kernel[m
[7mlines 11-71[27m[K [Klvm2-lvmetad.service loaded active running LVM2 metadata daemon[m
[7mlines 12-72[27m[K [Klvm2-monitor.service loaded active exited Monitoring of LVM2 mirrors, snapshots etc. using dmeventd or progress polling[m
[7mlines 13-73[27m[K [Kmysql.service loaded activating start-post start MySQL Community Server[m
[7mlines 14-74[27m[K [Knetfilter-persistent.service loaded active exited netfilter persistent configuration[m
[7mlines 15-75[27m[K [Knetworking.service loaded active exited Raise network interfaces[m
[7mlines 16-76[27m[K [Kondemand.service loaded active exited LSB: Set the CPU Frequency Scaling governor to "ondemand"[m
[7mlines 17-77[27m[K [Krc-local.service loaded active exited /etc/rc.local Compatibility[m
[7mlines 18-78[27m[K [Kresolvconf.service loaded active exited Nameserver information manager[m
[7mlines 19-79[27m[K [Krsyslog.service loaded active running System Logging Service[m
[7mlines 20-80[27m[K [Ksetvtrgb.service loaded active exited Set console scheme[m
[7mlines 21-81[27m[K [Ksnmpd.service loaded active exited LSB: SNMP agents[m
[7mlines 22-82[27m[K [Ksnmptrapd.service loaded active running LSB: SNMP Trap daemon[m
[7mlines 23-83[27m[K [Ksnmptrapfmt.service loaded active running LSB: SNMP Trap Formatting Agent[m
[7mlines 24-84[27m[K [Kssh.service loaded active running OpenBSD Secure Shell server[m
[7mlines 25-85[27m[K [Ksystemd-fsck@dev-disk-by\x2duuid-9bddf64a\x2d4e56\x2d4070\x2d9be9\x2db4e9bb1001eb.s ervice loaded active exited File System Check on /dev/disk/by-uuid/9bddf64a-4e56-4070-9be9-b4e9bb1001eb[m
[7mlines 26-86[27m[K [Ksystemd-journal-flush.service loaded active exited Flush Journal to Persistent Storage[m
[7mlines 27-87[27m[K [Ksystemd-journald.service loaded active running Journal Service[m
[7mlines 28-88[27m[K [Ksystemd-modules-load.service loaded active exited Load Kernel Modules[m
[7mlines 29-89[27m[K [Ksystemd-random-seed.service loaded active exited Load/Save Random Seed[m
[7mlines 30-90[27m[K [Ksystemd-remount-fs.service loaded active exited Remount Root and Kernel File Systems[m
[7mlines 31-91[27m[K [Ksystemd-sysctl.service loaded active exited Apply Kernel Variables[m
[7mlines 32-92[27m[K [Ksystemd-timesyncd.service loaded active running Network Time Synchronization[m
[7mlines 33-93[27m[K [Ksystemd-tmpfiles-setup-dev.service loaded active exited Create Static Device Nodes in /dev[m
[7mlines 34-94[27m[K [Ksystemd-tmpfiles-setup.service loaded active exited Create Volatile Files and Directories[m
[7mlines 35-95[27m[K [Ksystemd-udev-trigger.service loaded active exited udev Coldplug all Devices[m
[7mlines 36-96[27m[K [Ksystemd-udevd.service loaded active running udev Kernel Device Manager[m
[7mlines 37-97[27m[K [Ksystemd-update-utmp.service loaded active exited Update UTMP about System Boot/Shutdown[m
[7mlines 38-98[27m[K [Ksystemd-user-sessions.service loaded active exited Permit User Sessions[m
[7mlines 39-99[27m[K [Kunattended-upgrades.service loaded active running Unattended Upgrades Shutdown[m
[7mlines 40-100[27m[K [Kzabbix-agent.service loaded active running Zabbix Agent[m
[7mlines 41-101[27m[K [Kzabbix-java-gateway.service loaded active running Zabbix Java Gateway[m
[7mlines 42-102[27m[K [Kzabbix-server.service loaded active running Zabbix Server[m
[7mlines 43-103[27m[K [K-.slice loaded active active Root Slice[m
[7mlines 44-104[27m[K [Ksystem-getty.slice loaded active active system-getty.slice[m
[7mlines 45-105[27m[K [Ksystem-systemd\x2dfsck.slice loaded active active system-systemd\x2dfsck.slice[m
[7mlines 46-106[27m[K [Ksystem.slice loaded active active System Slice[m
[7mlines 47-107[27m[K [Kdm-event.socket loaded active listening Device-mapper event daemon FIFOs[m
[7mlines 48-108[27m[K [Klvm2-lvmetad.socket loaded active running LVM2 metadata daemon socket[m
[7mlines 49-109[27m[K [Klvm2-lvmpolld.socket loaded active listening LVM2 poll daemon socket[m
[7mlines 50-110[27m[K [Ksyslog.socket loaded active running Syslog Socket[m
[7mlines 51-111[27m[K [Ksystemd-fsckd.socket loaded active listening fsck to fsckd communication Socket[m
[7mlines 52-112[27m[K [Ksystemd-initctl.socket loaded active listening /dev/initctl Compatibility Named Pipe[m
[7mlines 53-113[27m[K [Ksystemd-journald-audit.socket loaded active running Journal Audit Socket[m
[7mlines 54-114[27m[K [Ksystemd-journald-dev-log.socket loaded active running Journal Socket (/dev/log)[m
[7mlines 55-115[27m[K [Ksystemd-journald.socket loaded active running Journal Socket[m
[7mlines 56-116[27m[K [Ksystemd-rfkill.socket loaded active listening Load/Save RF Kill Switch Status /dev/rfkill Watch[m
[7mlines 57-117[27m[K [Ksystemd-udevd-control.socket loaded active running udev Control Socket[m
[7mlines 58-118[27m[K [Ksystemd-udevd-kernel.socket loaded active running udev Kernel Socket[m
[7mlines 59-119[27m[K [Kdev-mapper-zabbix\x2d\x2dvg\x2dswap_1.swap loaded active active /dev/mapper/zabbix--vg-swap_1[m
[7mlines 60-120[27m[K [Kbasic.target loaded active active Basic System[m
[7mlines 61-121[27m[K [Kcryptsetup.target loaded active active Encrypted Volumes[m
[7mlines 62-122[27m[K [Kgetty.target loaded active active Login Prompts[m
[7mlines 63-123[27m[K [Kgraphical.target loaded active active Graphical Interface[m
[7mlines 64-124[27m[K [Klocal-fs-pre.target loaded active active Local File Systems (Pre)[m
[7mlines 65-125[27m[K [Klocal-fs.target loaded active active Local File Systems[m
[7mlines 66-126[27m[K [Kmulti-user.target loaded active active Multi-User System[m
[7mlines 67-127[27m[K [Knetwork-online.target loaded active active Network is Online[m
[7mlines 68-128[27m[K [Knetwork-pre.target loaded active active Network (Pre)[m
[7mlines 69-129[27m[K [Knetwork.target loaded active active Network[m
[7mlines 70-130[27m[K [Kpaths.target loaded active active Paths[m
[7mlines 71-131[27m[K [Kremote-fs-pre.target loaded active active Remote File Systems (Pre)[m
[7mlines 72-132[27m[K [Kremote-fs.target loaded active active Remote File Systems[m
[7mlines 73-133[27m[K [Kslices.target loaded active active Slices[m
[7mlines 74-134[27m[K [Ksockets.target loaded active active Sockets[m
[7mlines 75-135[27m[K [Ksound.target loaded active active Sound Card[m
[7mlines 76-136[27m[K [Kswap.target loaded active active Swap[m
[7mlines 77-137[27m[K [Ksysinit.target loaded active active System Initialization[m
[7mlines 78-138[27m[K [Ktime-sync.target loaded active active System Time Synchronized[m
[7mlines 79-139[27m[K [Ktimers.target loaded active active Timers[m
[7mlines 80-140[27m[K [Kapt-daily-upgrade.timer loaded active waiting Daily apt upgrade and clean activities[m
[7mlines 81-141[27m[K [Kapt-daily.timer loaded active waiting Daily apt download activities[m
[7mlines 82-142[27m[K [Kmotd-news.timer loaded active waiting Message of the Day[m
[7mlines 83-143[27m[K [Ksystemd-tmpfiles-clean.timer loaded active waiting Daily Cleanup of Temporary Directories[m
[7mlines 84-144[27m[K [K[m
[7mlines 85-145[27m[K [KLOAD = Reflects whether the unit definition was properly loaded.[m
[7mlines 86-146[27m[K [KACTIVE = The high-level unit activation state, i.e. generalization of SUB.[m
[7mlines 87-147[27m[K [KSUB = The low-level unit activation state, values depend on unit type.[m
[7mlines 88-148[27m[K [KJOB = Pending job for the unit.[m
[7mlines 89-149[27m[K [K[m
[7mlines 90-150[27m[K [K[0;1;39m143 loaded units listed.[0m Pass --all to see loaded but inactive units, too.[m
[7mlines 91-151[27m[K [KTo show all installed unit files use 'systemctl list-unit-files'.[m
[7mlines 92-152[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K[?1l>
# mysql -V
mysql Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper
# n[Kmysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
#
]
# systemctl status mysql.service
[?1h= ● mysql.service - MySQL Community Server[m
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en[m
Active: activating (start-post) (Result: exit-code) since Mon 2020-01-27 16:0[m
Process: 124370 ExecStart=/usr/sbin/mysqld [0;1;31m(code=exited, status=1/FAILURE)[0m[m
Process: 124361 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=ex[m
Main PID: 124370 (code=exited, status=1/FAILURE); : 124371 (mysql-syste[m
CGroup: /system.slice/mysql.service[m
└─control[m
├─124371 /bin/bash /usr/share/mysql/mysql-systemd-start post[m
└─124402 sleep 1[m
[m
Jan 27 16:02:47 zabbix mysqld[124370]: 2020-01-27T13:02:47.576599Z 0 [ERROR] Inn[m
Jan 27 16:02:47 zabbix mysqld[124370]: 2020-01-27T13:02:47.576689Z 0 [ERROR] Inn[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741780Z 0 [ERROR] Plu[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741897Z 0 [ERROR] Plu[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741911Z 0 [ERROR] Fai[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741920Z 0 [ERROR] Abo[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.741945Z 0 [Note] Binl[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.742005Z 0 [Note] Shut[m
Jan 27 16:02:48 zabbix mysqld[124370]: 2020-01-27T13:02:48.742340Z 0 [Note] /usr[m
Jan 27 16:02:48 zabbix systemd[1]: [0;1;39mmysql.service: Main process exited, code=exit[m
[systemd-start[1P/share/mysql/mysql-systemd-start[1P/share/mysql/mysql-systemd-startr/share/mysql/mysql-systemd-start
[?1049h[?1h=[1;24r[?12;25h[?12l[?25h[27m[23m[m[H[2J[?25l[24;1H"/usr/share/mysql/mysql-systemd-start" 58 lines, 1520 characters[1;1H#!/bin/bash
#
# Scripts to run by MySQL systemd service
#
# Needed argument: pre | post
#
# pre mode : try to perform sanity check for configuration, log, data
#post mode : ping server until answer is received
# Read a config option from mysql. Note that this will only work if a config
# file actually specifies the option, so it's important to specify a default
# $1 is application (e.g. mysqld for server)
# $2 is option
# $3 is default value used if no config value is found
get_mysql_option() {[16;9Hresult=$(my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1)[17;9Hif [ -z "$result" ];[18;9Hthen[19;17Hresult="$3"[20;9Hfi[21;9Hecho "$result"
}
sanity () {[1;1H[?12l[?25h[27m[23m[m[H[2J[?25l[1;1H#!/bin/bash
#
# Scripts to run by MySQL systemd service
#
# Needed argument: pre | post
#
# pre mode : try to perform sanity check for configuration, log, data
#post mode : ping server until answer is received
# Read a config option from mysql. Note that this will only work if a config
# file actually specifies the option, so it's important to specify a default
# $1 is application (e.g. mysqld for server)
# $2 is option
# $3 is default value used if no config value is found
get_mysql_option() {[16;9Hresult=$(my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1)[17;9Hif [ -z "$result" ];[18;9Hthen[19;17Hresult="$3"[20;9Hfi[21;9Hecho "$result"
}
sanity () {
if [ ! -r /etc/mysql/my.cnf ]; then
echo "MySQL configuration not found at /etc/mysql/my.cnf. Please create one."
exit 1
fi
datadir=$(get_mysql_option mysqld datadir "/var/lib/mysql")
if [ ! -d "${datadir}" ] && [ ! -L "${datadir}" ]; then
echo "MySQL data dir not found at ${datadir}. Please create one."
exit 1
fi
if [ ! -d "${datadir}/mysql" ] && [ ! -L "${datadir}/mysql" ]; then
echo "MySQL system database not found in ${datadir}. Please run mysqld --initialize."
exit 1
fi
}
pinger () {
server_up=false
for i in $(seq 1 30); do
sleep 1
if mysqladmin ping >/dev/null 2>&1; then[45;7Hserver_up=true[46;7Hbreak
fi
done
if [ ! $server_up ]; then
echo "MySQL server not started"
exit 1
fi
}
case $1 in
"pre") sanity ;;
"post") pinger ;;
esac
[1m[34m~ [60;1H~ [61;1H~ [1;1H[?12l[?25h[27m[23m[m[H[2J[?25l[1;1H#!/bin/bash
#
# Scripts to run by MySQL systemd service
#
# Needed argument: pre | post
#
# pre mode : try to perform sanity check for configuration, log, data
#post mode : ping server until answer is received
# Read a config option from mysql. Note that this will only work if a config
# file actually specifies the option, so it's important to specify a default
# $1 is application (e.g. mysqld for server)
# $2 is option
# $3 is default value used if no config value is found
get_mysql_option() {[16;9Hresult=$(my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1)[17;9Hif [ -z "$result" ];[18;9Hthen[19;17Hresult="$3"[20;9Hfi[21;9Hecho "$result"
}
sanity () {[1;1H[?12l[?25h[27m[23m[m[H[2J[?25l[1;1H#!/bin/bash
#
# Scripts to run by MySQL systemd service
#
# Needed argument: pre | post
#
# pre mode : try to perform sanity check for configuration, log, data
#post mode : ping server until answer is received
# Read a config option from mysql. Note that this will only work if a config
# file actually specifies the option, so it's important to specify a default
# $1 is application (e.g. mysqld for server)
# $2 is option
# $3 is default value used if no config value is found
get_mysql_option() {[16;9Hresult=$(my_print_defaults "$1" | sed -n "s/^--$2=//p" | tail -n 1)[17;9Hif [ -z "$result" ];[18;9Hthen[19;17Hresult="$3"[20;9Hfi[21;9Hecho "$result"
}
sanity () {
if [ ! -r /etc/mysql/my.cnf ]; then
echo "MySQL configuration not found at /etc/mysql/my.cnf. Please create one."
exit 1
fi
datadir=$(get_mysql_option mysqld datadir "/var/lib/mysql")
if [ ! -d "${datadir}" ] && [ ! -L "${datadir}" ]; then
echo "MySQL data dir not found at ${datadir}. Please create one."
exit 1
fi
if [ ! -d "${datadir}/mysql" ] && [ ! -L "${datadir}/mysql" ]; then
echo "MySQL system database not found in ${datadir}. Please run mysqld --initialize."
exit 1
fi
}
pinger () {
server_up=false
for i in $(seq 1 30); do
sleep 1
if mysqladmin ping >/dev/null 2>&1; then[45;7Hserver_up=true[46;7Hbreak
fi
done
if [ ! $server_up ]; then
echo "MySQL server not started"
exit 1
fi
}
case $1 in
"pre") sanity ;;
"post") pinger ;;
esac
[1m[34m~ [60;1H~ [61;1H~ [1;1H[?12l[?25h[?25l[m[62;1HType :quit<Enter> to exit Vim[1;1H[?12l[?25h[?25l[62;1H[K[62;1H:[?12l[?25hq! [?25l[62;1H[K[62;1H[?1l>[?12l[?25h[?1049l]0;root@zabbix: # vi /usr/share/mysql/mysql-systemd-start[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[Ketc/mysql/my.cnf
[?1049h[?1h=[1;62r[?12;25h[?12l[?25h[27m[23m[m[H[2J[?25l[62;1H"/etc/mysql/my.cnf" 23 lines, 736 characters[1;1H#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/se...variables.html
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
#includedir /etc/mysql/conf.d/
[mysqld]
innodb_purge_threads=0
innodb_force_recovery=0
includedir /etc/mysql/mysql.conf.d/
[1m[34m~ [1;1H[?12l[?25h[?25l[m[62;1H[K[62;1H:[?12l
# journalcte -xe[1P -xel -xe
[?1h= [KJan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817049Z 0 [Note] InnoDB: PUNCH HOLE support available[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817077Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817089Z 0 [Note] InnoDB: Uses event mutexes[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817110Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817125Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817137Z 0 [Note] InnoDB: Using Linux native AIO[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817687Z 0 [Note] InnoDB: Number of pools: 1[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.817925Z 0 [Note] InnoDB: Using CPU crc32 instructions[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.830417Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.850853Z 0 [Note] InnoDB: Completed initialization of buffer pool[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.856033Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.870446Z 0 [Note] InnoDB: Highest supported file format is Barracuda.[m
Jan 27 16:05:38 zabbix mysqld[125009]: 2020-01-27T13:05:38.876356Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 377631420597[m
Jan 27 16:05:39 zabbix mysqld[125009]: 2020-01-27T13:05:39.404496Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 377636663296[m
Jan 27 16:05:39 zabbix mysqld[125009]: 2020-01-27T13:05:39.542839Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 377638792985[m
Jan 27 16:05:39 zabbix mysqld[125009]: 2020-01-27T13:05:39.546191Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 377631420597 and the end 377638792985.[m
Jan 27 16:05:39 zabbix mysqld[125009]: 2020-01-27T13:05:39.546229Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.740934Z 0 [ERROR] Plugin 'InnoDB' init function returned error.[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741064Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741081Z 0 [ERROR] Failed to initialize builtin plugins.[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741092Z 0 [ERROR] Aborting[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741123Z 0 [Note] Binlog end[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741361Z 0 [Note] Shutting down plugin 'MyISAM'[m
Jan 27 16:05:40 zabbix mysqld[125009]: 2020-01-27T13:05:40.741732Z 0 [Note] /usr/sbin/mysqld: Shutdown complete[m
Jan 27 16:05:40 zabbix systemd[1]: [0;1;39mmysql.service: Main process exited, code=exited, status=1/FAILURE[0m[m
proc-sys-fs-binfmt_misc.automount loaded active waiting Arbitrary Executable File Formats File System Automount Point[m
sys-devices-pci0000:00-0000:00:10.0-host32-target32:0:0-32:0:0:0-block-sda-sda1.device loaded active plugged VMware_Virtual_S 1[m
sys-devices-pci0000:00-0000:00:10.0-host32-target32:0:0-32:0:0:0-block-sda-sda2.device loaded active plugged VMware_Virtual_S 2[m
sys-devices-pci0000:00-0000:00:10.0-host32-target32:0:0-32:0:0:0-block-sda-sda5.device loaded active plugged VMware_Virtual_S 5[m
sys-devices-pci0000:00-0000:00:10.0-host32-target32:0:0-32:0:0:0-block-sda.device loaded active plugged VMware_Virtual_S[m
sys-devices-pci0000:00-0000:00:11.0-0000:02:01.0-net-ens33.device loaded active plugged 82545EM Gigabit Ethernet Controller (Copper) (PRO/1000 MT Single Port Adapter)[m
sys-devices-pci0000:00-0000:00:11.0-0000:02:02.0-sound-card0.device loaded active plugged ES1371 / Creative Labs CT2518/ES1373 (AudioPCI 64V/128 / Creative CT4810/CT5803/CT5806[m
sys-devices-platform-serial8250-tty-ttyS1.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS1[m
sys-devices-platform-serial8250-tty-ttyS10.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS10[m
sys-devices-platform-serial8250-tty-ttyS11.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS11[m
sys-devices-platform-serial8250-tty-ttyS12.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS12[m
sys-devices-platform-serial8250-tty-ttyS13.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS13[m
sys-devices-platform-serial8250-tty-ttyS14.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS14[m
sys-devices-platform-serial8250-tty-ttyS15.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS15[m
sys-devices-platform-serial8250-tty-ttyS16.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS16[m
sys-devices-platform-serial8250-tty-ttyS17.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS17[m
sys-devices-platform-serial8250-tty-ttyS18.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS18[m
sys-devices-platform-serial8250-tty-ttyS19.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS19[m
sys-devices-platform-serial8250-tty-ttyS2.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS2[m
sys-devices-platform-serial8250-tty-ttyS20.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS20[m
sys-devices-platform-serial8250-tty-ttyS21.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS21[m
sys-devices-platform-serial8250-tty-ttyS22.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS22[m
sys-devices-platform-serial8250-tty-ttyS23.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS23[m
sys-devices-platform-serial8250-tty-ttyS24.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS24[m
sys-devices-platform-serial8250-tty-ttyS25.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS25[m
sys-devices-platform-serial8250-tty-ttyS26.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS26[m
sys-devices-platform-serial8250-tty-ttyS27.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS27[m
sys-devices-platform-serial8250-tty-ttyS28.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS28[m
sys-devices-platform-serial8250-tty-ttyS29.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS29[m
sys-devices-platform-serial8250-tty-ttyS3.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS3[m
sys-devices-platform-serial8250-tty-ttyS30.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS30[m
sys-devices-platform-serial8250-tty-ttyS31.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS31[m
sys-devices-platform-serial8250-tty-ttyS4.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS4[m
sys-devices-platform-serial8250-tty-ttyS5.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS5[m
sys-devices-platform-serial8250-tty-ttyS6.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS6[m
sys-devices-platform-serial8250-tty-ttyS7.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS7[m
sys-devices-platform-serial8250-tty-ttyS8.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS8[m
sys-devices-platform-serial8250-tty-ttyS9.device loaded active plugged /sys/devices/platform/serial8250/tty/ttyS9[m
sys-devices-pnp0-00:05-tty-ttyS0.device loaded active plugged /sys/devices/pnp0/00:05/tty/ttyS0[m
sys-devices-virtual-block-dm\x2d0.device loaded active plugged /sys/devices/virtual/block/dm-0[m
sys-devices-virtual-block-dm\x2d1.device loaded active plugged /sys/devices/virtual/block/dm-1[m
sys-devices-virtual-misc-rfkill.device loaded active plugged /sys/devices/virtual/misc/rfkill[m
sys-devices-virtual-tty-ttyprintk.device loaded active plugged /sys/devices/virtual/tty/ttyprintk[m
sys-module-fuse.device loaded active plugged /sys/module/fuse[m
sys-subsystem-net-devices-ens33.device loaded active plugged 82545EM Gigabit Ethernet Controller (Copper) (PRO/1000 MT Single Port Adapter)[m
-.mount loaded active mounted /[m
boot.mount loaded active mounted /boot[m
dev-hugepages.mount loaded active mounted Huge Pages File System[m
dev-mqueue.mount loaded active mounted POSIX Message Queue File System[m
sys-fs-fuse-connections.mount loaded active mounted FUSE Control File System[m
sys-kernel-debug.mount loaded active mounted Debug File System[m
systemd-ask-password-plymouth.path loaded active waiting Forward Password Requests to Plymouth Directory Watch[m
systemd-ask-password-wall.path loaded active waiting Forward Password Requests to Wall Directory Watch[m
systemd-networkd-resolvconf-update.path loaded active waiting Trigger resolvconf update for networkd DNS[m
init.scope loaded active running System and Service Manager[m
apache2.service loaded active running LSB: Apache2 web server[m
apparmor.service loaded active exited LSB: AppArmor initialization[m
console-setup.service loaded active exited Set console font and keymap[m
cron.service loaded active running Regular background program processing daemon[m
getty-static.service loaded active exited getty on tty2-tty6 if dbus and logind are not available[m
[7mlines 1-61[27m[K [[email protected] loaded active running Getty on tty1[m
[7mlines 2-62[27m[K [[email protected] loaded active running Getty on tty2[m
[7mlines 3-63[27m[K [[email protected] loaded active running Getty on tty3[m
[7mlines 4-64[27m[K [[email protected] loaded active running Getty on tty4[m
[7mlines 5-65[27m[K [[email protected] loaded active running Getty on tty5[m
[7mlines 6-66[27m[K [[email protected] loaded active running Getty on tty6[m
[7mlines 7-67[27m[K [Kgrub-common.service loaded active exited LSB: Record successful boot for GRUB[m
[7mlines 8-68[27m[K [[email protected] loaded active exited ifup for ens33[m
[7mlines 9-69[27m[K [Kkeyboard-setup.service loaded active exited Set console keymap[m
[7mlines 10-70[27m[K [Kkmod-static-nodes.service loaded active exited Create list of required static device nodes for the current kernel[m
[7mlines 11-71[27m[K [Klvm2-lvmetad.service loaded active running LVM2 metadata daemon[m
[7mlines 12-72[27m[K [Klvm2-monitor.service loaded active exited Monitoring of LVM2 mirrors, snapshots etc. using dmeventd or progress polling[m
[7mlines 13-73[27m[K [Kmysql.service loaded activating start-post start MySQL Community Server[m
[7mlines 14-74[27m[K [Knetfilter-persistent.service loaded active exited netfilter persistent configuration[m
[7mlines 15-75[27m[K [Knetworking.service loaded active exited Raise network interfaces[m
[7mlines 16-76[27m[K [Kondemand.service loaded active exited LSB: Set the CPU Frequency Scaling governor to "ondemand"[m
[7mlines 17-77[27m[K [Krc-local.service loaded active exited /etc/rc.local Compatibility[m
[7mlines 18-78[27m[K [Kresolvconf.service loaded active exited Nameserver information manager[m
[7mlines 19-79[27m[K [Krsyslog.service loaded active running System Logging Service[m
[7mlines 20-80[27m[K [Ksetvtrgb.service loaded active exited Set console scheme[m
[7mlines 21-81[27m[K [Ksnmpd.service loaded active exited LSB: SNMP agents[m
[7mlines 22-82[27m[K [Ksnmptrapd.service loaded active running LSB: SNMP Trap daemon[m
[7mlines 23-83[27m[K [Ksnmptrapfmt.service loaded active running LSB: SNMP Trap Formatting Agent[m
[7mlines 24-84[27m[K [Kssh.service loaded active running OpenBSD Secure Shell server[m
[7mlines 25-85[27m[K [Ksystemd-fsck@dev-disk-by\x2duuid-9bddf64a\x2d4e56\x2d4070\x2d9be9\x2db4e9bb1001eb.s ervice loaded active exited File System Check on /dev/disk/by-uuid/9bddf64a-4e56-4070-9be9-b4e9bb1001eb[m
[7mlines 26-86[27m[K [Ksystemd-journal-flush.service loaded active exited Flush Journal to Persistent Storage[m
[7mlines 27-87[27m[K [Ksystemd-journald.service loaded active running Journal Service[m
[7mlines 28-88[27m[K [Ksystemd-modules-load.service loaded active exited Load Kernel Modules[m
[7mlines 29-89[27m[K [Ksystemd-random-seed.service loaded active exited Load/Save Random Seed[m
[7mlines 30-90[27m[K [Ksystemd-remount-fs.service loaded active exited Remount Root and Kernel File Systems[m
[7mlines 31-91[27m[K [Ksystemd-sysctl.service loaded active exited Apply Kernel Variables[m
[7mlines 32-92[27m[K [Ksystemd-timesyncd.service loaded active running Network Time Synchronization[m
[7mlines 33-93[27m[K [Ksystemd-tmpfiles-setup-dev.service loaded active exited Create Static Device Nodes in /dev[m
[7mlines 34-94[27m[K [Ksystemd-tmpfiles-setup.service loaded active exited Create Volatile Files and Directories[m
[7mlines 35-95[27m[K [Ksystemd-udev-trigger.service loaded active exited udev Coldplug all Devices[m
[7mlines 36-96[27m[K [Ksystemd-udevd.service loaded active running udev Kernel Device Manager[m
[7mlines 37-97[27m[K [Ksystemd-update-utmp.service loaded active exited Update UTMP about System Boot/Shutdown[m
[7mlines 38-98[27m[K [Ksystemd-user-sessions.service loaded active exited Permit User Sessions[m
[7mlines 39-99[27m[K [Kunattended-upgrades.service loaded active running Unattended Upgrades Shutdown[m
[7mlines 40-100[27m[K [Kzabbix-agent.service loaded active running Zabbix Agent[m
[7mlines 41-101[27m[K [Kzabbix-java-gateway.service loaded active running Zabbix Java Gateway[m
[7mlines 42-102[27m[K [Kzabbix-server.service loaded active running Zabbix Server[m
[7mlines 43-103[27m[K [K-.slice loaded active active Root Slice[m
[7mlines 44-104[27m[K [Ksystem-getty.slice loaded active active system-getty.slice[m
[7mlines 45-105[27m[K [Ksystem-systemd\x2dfsck.slice loaded active active system-systemd\x2dfsck.slice[m
[7mlines 46-106[27m[K [Ksystem.slice loaded active active System Slice[m
[7mlines 47-107[27m[K [Kdm-event.socket loaded active listening Device-mapper event daemon FIFOs[m
[7mlines 48-108[27m[K [Klvm2-lvmetad.socket loaded active running LVM2 metadata daemon socket[m
[7mlines 49-109[27m[K [Klvm2-lvmpolld.socket loaded active listening LVM2 poll daemon socket[m
[7mlines 50-110[27m[K [Ksyslog.socket loaded active running Syslog Socket[m
[7mlines 51-111[27m[K [Ksystemd-fsckd.socket loaded active listening fsck to fsckd communication Socket[m
[7mlines 52-112[27m[K [Ksystemd-initctl.socket loaded active listening /dev/initctl Compatibility Named Pipe[m
[7mlines 53-113[27m[K [Ksystemd-journald-audit.socket loaded active running Journal Audit Socket[m
[7mlines 54-114[27m[K [Ksystemd-journald-dev-log.socket loaded active running Journal Socket (/dev/log)[m
[7mlines 55-115[27m[K [Ksystemd-journald.socket loaded active running Journal Socket[m
[7mlines 56-116[27m[K [Ksystemd-rfkill.socket loaded active listening Load/Save RF Kill Switch Status /dev/rfkill Watch[m
[7mlines 57-117[27m[K [Ksystemd-udevd-control.socket loaded active running udev Control Socket[m
[7mlines 58-118[27m[K [Ksystemd-udevd-kernel.socket loaded active running udev Kernel Socket[m
[7mlines 59-119[27m[K [Kdev-mapper-zabbix\x2d\x2dvg\x2dswap_1.swap loaded active active /dev/mapper/zabbix--vg-swap_1[m
[7mlines 60-120[27m[K [Kbasic.target loaded active active Basic System[m
[7mlines 61-121[27m[K [Kcryptsetup.target loaded active active Encrypted Volumes[m
[7mlines 62-122[27m[K [Kgetty.target loaded active active Login Prompts[m
[7mlines 63-123[27m[K [Kgraphical.target loaded active active Graphical Interface[m
[7mlines 64-124[27m[K [Klocal-fs-pre.target loaded active active Local File Systems (Pre)[m
[7mlines 65-125[27m[K [Klocal-fs.target loaded active active Local File Systems[m
[7mlines 66-126[27m[K [Kmulti-user.target loaded active active Multi-User System[m
[7mlines 67-127[27m[K [Knetwork-online.target loaded active active Network is Online[m
[7mlines 68-128[27m[K [Knetwork-pre.target loaded active active Network (Pre)[m
[7mlines 69-129[27m[K [Knetwork.target loaded active active Network[m
[7mlines 70-130[27m[K [Kpaths.target loaded active active Paths[m
[7mlines 71-131[27m[K [Kremote-fs-pre.target loaded active active Remote File Systems (Pre)[m
[7mlines 72-132[27m[K [Kremote-fs.target loaded active active Remote File Systems[m
[7mlines 73-133[27m[K [Kslices.target loaded active active Slices[m
[7mlines 74-134[27m[K [Ksockets.target loaded active active Sockets[m
[7mlines 75-135[27m[K [Ksound.target loaded active active Sound Card[m
[7mlines 76-136[27m[K [Kswap.target loaded active active Swap[m
[7mlines 77-137[27m[K [Ksysinit.target loaded active active System Initialization[m
[7mlines 78-138[27m[K [Ktime-sync.target loaded active active System Time Synchronized[m
[7mlines 79-139[27m[K [Ktimers.target loaded active active Timers[m
[7mlines 80-140[27m[K [Kapt-daily-upgrade.timer loaded active waiting Daily apt upgrade and clean activities[m
[7mlines 81-141[27m[K [Kapt-daily.timer loaded active waiting Daily apt download activities[m
[7mlines 82-142[27m[K [Kmotd-news.timer loaded active waiting Message of the Day[m
[7mlines 83-143[27m[K [Ksystemd-tmpfiles-clean.timer loaded active waiting Daily Cleanup of Temporary Directories[m
[7mlines 84-144[27m[K [K[m
[7mlines 85-145[27m[K [KLOAD = Reflects whether the unit definition was properly loaded.[m
[7mlines 86-146[27m[K [KACTIVE = The high-level unit activation state, i.e. generalization of SUB.[m
[7mlines 87-147[27m[K [KSUB = The low-level unit activation state, values depend on unit type.[m
[7mlines 88-148[27m[K [KJOB = Pending job for the unit.[m
[7mlines 89-149[27m[K [K[m
[7mlines 90-150[27m[K [K[0;1;39m143 loaded units listed.[0m Pass --all to see loaded but inactive units, too.[m
[7mlines 91-151[27m[K [KTo show all installed unit files use 'systemctl list-unit-files'.[m
[7mlines 92-152[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K [K[7mlines 92-152/152 (END)[27m[K [K[?1l>
# mysql -V
mysql Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper
# n[Kmysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
#
]