Как запустить MySQL сервер?

Question

[Александр Воробьев]

Стоял себе работал Nextcloud апач/мускул/пхп и после перезагрузки Mysql падает.

-- Начат процесс запуска юнита mariadb.service.
сен 21 11:27:47 data-server mysqld[8321]: 2018-09-21 11:27:47 140485620505728 [Note] /usr/sbin/mysqld (mysqld 10.1.34-MariaDB-0ubuntu0.18.04.1) starting as process 8321 ...
сен 21 11:27:47 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:27:47 data-server kernel: kauditd_printk_skb: 6 callbacks suppressed
сен 21 11:27:47 data-server kernel: audit: type=1400 audit(1537489667.848:166): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:17 data-server systemd[1]: mariadb.service: Start operation timed out. Terminating.
сен 21 11:29:17 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:17 data-server kernel: audit: type=1400 audit(1537489757.142:167): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:17 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:17 data-server kernel: audit: type=1400 audit(1537489757.242:168): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:17 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:17 data-server kernel: audit: type=1400 audit(1537489757.342:169): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:17 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:17 data-server kernel: audit: type=1400 audit(1537489757.442:170): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:17 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:17 data-server kernel: audit: type=1400 audit(1537489757.542:171): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:17 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:17 data-server kernel: audit: type=1400 audit(1537489757.642:172): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:17 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:17 data-server kernel: audit: type=1400 audit(1537489757.746:173): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:17 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:17 data-server kernel: audit: type=1400 audit(1537489757.846:174): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:17 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:17 data-server kernel: audit: type=1400 audit(1537489757.946:175): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:18 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:18 data-server kernel: audit: type=1400 audit(1537489758.046:176): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profil
сен 21 11:29:18 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:18 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:18 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:19 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:19 data-server audit[8321]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/syst
сен 21 11:29:19 data-server systemd[1]: mariadb.service: Failed with result 'timeout'.
сен 21 11:29:19 data-server systemd[1]: Failed to start MariaDB 10.1.34 database server.
-- Subject: Ошибка юнита mariadb.service
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Произошел сбой юнита mariadb.service.
<blockquote>

root@data-server:/var/run/mysqld# aa-complain /usr/sbin/mysqld
Назначение /usr/sbin/mysqld претензионного режима.
ERROR: /etc/apparmor.d/usr.sbin.mysqld не содержит профиль

Answer 1

[Roman Terekhin]

sudo apt-get install apparmor-utils
sudo aa-complain /usr/sbin/mysqld
sudo service apparmor reload

Comments

[Александр Воробьев]

не так то вывод я отписал выше в самом конце

ot@data-server:/var/run/mysqld# aa-complain /usr/sbin/mysqld
Назначение /usr/sbin/mysqld претензионного режима.
ERROR: /etc/apparmor.d/usr.sbin.mysqld не содержит профиль

но мускуль не запускался systemctl start mysql но после перезагрузки системы reboot все заработало, можно ли считать это решением я не знаю, но все же отмечу!