root@otrs:~# systemctl status mysql.service
mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start-post) (Result: exit-code) since Tue 2017-09-26 13:43:57 UTC; 23s ago
Process: 20402 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 20394 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 20402 (code=exited, status=1/FAILURE); : 20403 (mysql-systemd-s)
Tasks: 2
Memory: 15.0M
CPU: 393ms
CGroup: /system.slice/mysql.service
└─control
├─20403 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─20466 sleep 1
Sep 26 13:43:57 otrs systemd[1]: Starting MySQL Community Server...
Sep 26 13:43:57 otrs systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
root@otrs:~# ^C
root@otrs:~# ^C
root@otrs:~# ^C
root@otrs:~# ^C
root@otrs:~# journalctl -xe
Sep 26 13:45:03 otrs otrs.Daemon.pl[20613]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20613]: [Error][Kernel::System::DB::Prepare][Line:667]: Can't connect to MySQL server on
Sep 26 13:45:03 otrs otrs.Daemon.pl[20613]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20613]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '1
Sep 26 13:45:04 otrs otrs.Daemon.pl[20616]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-10[20616]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1
Sep 26 13:45:05 otrs sshd[20603]: Failed password for root from 113.195.145.21 port 32554 ssh2
Sep 26 13:45:07 otrs sshd[20603]: Failed password for root from 113.195.145.21 port 32554 ssh2
Sep 26 13:45:08 otrs otrs.Daemon.pl[20625]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerFutureTaskManager-10[20625]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0
Sep 26 13:45:09 otrs sshd[20603]: Failed password for root from 113.195.145.21 port 32554 ssh2
Sep 26 13:45:09 otrs otrs.Daemon.pl[20628]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-10[20628]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1' (11
Sep 26 13:45:09 otrs sshd[20603]: Received disconnect from 113.195.145.21 port 32554:11: [preauth]
Sep 26 13:45:09 otrs sshd[20603]: Disconnected from 113.195.145.21 port 32554 [preauth]
Sep 26 13:45:09 otrs sshd[20603]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=113.195.145.21 user=root
Sep 26 13:45:13 otrs otrs.Daemon.pl[20637]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20637]: [Error][Kernel::System::DB::Prepare][Line:667]: Can't connect to MySQL server on
Sep 26 13:45:13 otrs otrs.Daemon.pl[20637]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20637]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '1
Sep 26 13:45:14 otrs otrs.Daemon.pl[20642]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-10[20642]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1
Sep 26 13:45:18 otrs otrs.Daemon.pl[20649]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerFutureTaskManager-10[20649]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0
Sep 26 13:45:19 otrs sshd[20650]: Invalid user ts3server from 115.186.30.67
Sep 26 13:45:19 otrs sshd[20650]: input_userauth_request: invalid user ts3server [preauth]
Sep 26 13:45:19 otrs sshd[20650]: pam_unix(sshd:auth): check pass; user unknown
Sep 26 13:45:19 otrs sshd[20650]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=115.186.30.67
Sep 26 13:45:19 otrs otrs.Daemon.pl[20656]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-10[20656]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1' (11
Sep 26 13:45:21 otrs sshd[20650]: Failed password for invalid user ts3server from 115.186.30.67 port 41621 ssh2
Sep 26 13:45:21 otrs sshd[20650]: Connection closed by 115.186.30.67 port 41621 [preauth]
Sep 26 13:45:24 otrs otrs.Daemon.pl[20665]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20665]: [Error][Kernel::System::DB::Prepare][Line:667]: Can't connect to MySQL server on
Sep 26 13:45:24 otrs otrs.Daemon.pl[20665]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20665]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '1
Sep 26 13:45:25 otrs otrs.Daemon.pl[20668]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-10[20668]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1
Sep 26 13:45:28 otrs systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support:
http://lists.freedesktop.org/mailman/listinfo/systemd-devel--
-- Unit mysql.service has failed.
--
-- The result is failed.
Sep 26 13:45:28 otrs systemd[1]: mysql.service: Unit entered failed state.
Sep 26 13:45:28 otrs systemd[1]: mysql.service: Failed with result 'exit-code'.
Sep 26 13:45:28 otrs systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Sep 26 13:45:28 otrs systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support:
http://lists.freedesktop.org/mailman/listinfo/systemd-devel--
-- Unit mysql.service has finished shutting down.
Sep 26 13:45:28 otrs systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support:
http://lists.freedesktop.org/mailman/listinfo/systemd-devel--
-- Unit mysql.service has begun starting up.
Sep 26 13:45:28 otrs audit[20687]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/20687/status" pid=20687 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=112 ouid=112
Sep 26 13:45:28 otrs audit[20687]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=20687 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=112 ouid=0
Sep 26 13:45:28 otrs audit[20687]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/20687/status" pid=20687 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=112 ouid=112
Sep 26 13:45:28 otrs kernel: audit: type=1400 audit(1506433528.832:866): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/20687/status" pid=20687 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=112 ouid=11
Sep 26 13:45:28 otrs kernel: audit: type=1400 audit(1506433528.832:867): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=20687 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=112
Sep 26 13:45:28 otrs kernel: audit: type=1400 audit(1506433528.832:868): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/20687/status" pid=20687 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=112 ouid=11
Sep 26 13:45:29 otrs systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Sep 26 13:45:29 otrs otrs.Daemon.pl[20684]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerFutureTaskManager-10[20684]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0
Sep 26 13:45:30 otrs otrs.Daemon.pl[20698]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-10[20698]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1' (11
Sep 26 13:45:34 otrs sshd[20703]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=113.195.145.21 user=root
Sep 26 13:45:34 otrs otrs.Daemon.pl[20709]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20709]: [Error][Kernel::System::DB::Prepare][Line:667]: Can't connect to MySQL server on
Sep 26 13:45:34 otrs otrs.Daemon.pl[20709]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20709]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '1
Sep 26 13:45:35 otrs otrs.Daemon.pl[20712]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-10[20712]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1
Sep 26 13:45:36 otrs sshd[20703]: Failed password for root from 113.195.145.21 port 12541 ssh2
Sep 26 13:45:38 otrs sshd[20703]: Failed password for root from 113.195.145.21 port 12541 ssh2
Sep 26 13:45:39 otrs otrs.Daemon.pl[20721]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerFutureTaskManager-10[20721]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0
Sep 26 13:45:40 otrs otrs.Daemon.pl[20724]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-10[20724]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1' (11
Sep 26 13:45:41 otrs sshd[20703]: Failed password for root from 113.195.145.21 port 12541 ssh2
Sep 26 13:45:42 otrs sshd[20703]: Received disconnect from 113.195.145.21 port 12541:11: [preauth]
Sep 26 13:45:42 otrs sshd[20703]: Disconnected from 113.195.145.21 port 12541 [preauth]
Sep 26 13:45:42 otrs sshd[20703]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=113.195.145.21 user=root
Sep 26 13:45:44 otrs otrs.Daemon.pl[20733]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20733]: [Error][Kernel::System::DB::Prepare][Line:667]: Can't connect to MySQL server on
Sep 26 13:45:45 otrs otrs.Daemon.pl[20733]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20733]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '1
Sep 26 13:45:46 otrs otrs.Daemon.pl[20736]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-10[20736]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1
Sep 26 13:45:50 otrs otrs.Daemon.pl[20745]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerFutureTaskManager-10[20745]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0
Sep 26 13:45:51 otrs otrs.Daemon.pl[20748]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-10[20748]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1' (11
Sep 26 13:45:55 otrs otrs.Daemon.pl[20759]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20759]: [Error][Kernel::System::DB::Prepare][Line:667]: Can't connect to MySQL server on
Sep 26 13:45:55 otrs otrs.Daemon.pl[20759]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-10[20759]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '1
Sep 26 13:45:56 otrs otrs.Daemon.pl[20762]: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-10[20762]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on '127.0.0.1