Archiv verlassen und diese Seite im Standarddesign anzeigen : Speicherort von Mysql Datenbank verschieben
Hallo,
ich setze gerade einen neuen UbuntuServer 16.04 mit Mysql auf und wollte das Datenverzeichnis auf die zweite Platte packen. Nach der Installation habe ich die Datein von "/var/lib/mysql" auf die zweite Platte kopiert, die Konfigurationsdatei angepasst und neu gestartet. Mysql lässt sich aber nicht starten. Stelle ich es wieder zurück geht es wieder.
Orginalverzeichnis:
drwxr-xr-x 2 root root 4096 Mai 1 17:06 mlocate
drwxr-xr-x 3 root root 4096 Mär 30 01:38 mplayer
drwx------ 6 mysql mysql 4096 Mai 1 20:12 mysql
drwx------ 2 mysql mysql 4096 Mai 1 18:22 mysql-files
drwx------ 2 mysql mysql 4096 Mai 1 18:22 mysql-keyring
drwxr-xr-x 2 root root 4096 Apr 27 02:28 mysql-upgrade
drwxr-xr-x 2 root root 4096 Mär 26 14:29 NetworkManager
root@Kopano:/var/lib/mysql# ls -l
insgesamt 122912
-rw-r----- 1 mysql mysql 56 Mai 1 18:22 auto.cnf
-rw-r--r-- 1 root root 0 Mai 1 18:22 debian-5.7.flag
-rw-r----- 1 mysql mysql 326 Mai 1 20:08 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 Mai 1 20:12 ibdata1
-rw-r----- 1 mysql mysql 50331648 Mai 1 20:12 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Mai 1 18:22 ib_logfile1
-rw-r----- 1 mysql mysql 12582912 Mai 1 20:12 ibtmp1
drwxr-x--- 2 mysql mysql 4096 Mai 1 18:22 mysql
drwxr-x--- 2 mysql mysql 4096 Mai 1 18:22 performance_schema
drwxr-x--- 2 mysql mysql 4096 Mai 1 18:24 phpmyadmin
drwxr-x--- 2 mysql mysql 12288 Mai 1 18:22 sys
root@Kopano:/var/lib/mysql#
Neues Verzeichnis:
chris15 ist der Mountpunkt der zweiten Platte
root@Kopano:/chris15# ls -l
insgesamt 24
drwxrwxrwx 5 nobody nogroup 4096 Mai 1 17:46 Download
drwx------ 2 root root 16384 Mär 26 12:52 lost+found
drwx------ 6 mysql mysql 4096 Mai 1 18:56 mysql
root@Kopano:/chris15/mysql# ls -l
insgesamt 122912
-rw-r----- 1 mysql mysql 56 Mai 1 18:56 auto.cnf
-rw-r--r-- 1 mysql root 0 Mai 1 18:56 debian-5.7.flag
-rw-r----- 1 mysql mysql 419 Mai 1 18:56 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 Mai 1 18:56 ibdata1
-rw-r----- 1 mysql mysql 50331648 Mai 1 18:56 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Mai 1 18:56 ib_logfile1
-rw-r----- 1 mysql mysql 12582912 Mai 1 18:56 ibtmp1
drwxr-x--- 2 mysql mysql 4096 Mai 1 18:56 mysql
drwxr-x--- 2 mysql mysql 4096 Mai 1 18:56 performance_schema
drwxr-x--- 2 mysql mysql 4096 Mai 1 18:56 phpmyadmin
drwxr-x--- 2 mysql mysql 12288 Mai 1 18:56 sys
root@Kopano:/chris15/mysql#
Konfigurationsdatei:
nano /etc/mysql/mysql.conf.d/mysqld.cnf
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
##datadir = /var/lib/mysql
datadir = /chris15/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
Was mache ich falsch???
Danke für die Hilfe
Was ergibt denn die Ausgabe von ls -ld /chris15? Sprich: Hat der mysqld auch in diesem Verzeichnis zumindest "r-x"(Also lesen und ausführen)?
Ansonsten: Einfach mal nachschauen, was der mysqld an Fehlern protokolliert. Das sollte Aufschluss geben. AppArmor und Konsorten beschränken die Rechte evtl. auch noch Mal. Aber erstmal die Rechte prüfen.
Habe folgendes gefunden. Vielleicht kann mir jemand weiterhelfen.
root@Kopano:~# ls -ld /chris15
drwxrwxrwx 6 root christian 4096 Mai 1 20:36 /chris15
root@Kopano:~# ls -ld /chris15/mysql
drwx------ 6 mysql mysql 4096 Mai 1 18:56 /chris15/mysql
root@Kopano:~#
root@Kopano:~# service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
root@Kopano:~#
root@Kopano:~# systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
Active: activating (start-post) (Result: exit-code) since Di 2017-05-02 20:45
Process: 3176 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 3169 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit
Main PID: 3176 (code=exited, status=1/FAILURE); : 3177 (mysql-systemd-s
CGroup: /system.slice/mysql.service
└─control
├─3177 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─3196 sleep 1
Mai 02 20:45:12 Kopano systemd[1]: Starting MySQL Community Server...
Mai 02 20:45:13 Kopano systemd[1]: mysql.service: Main process exited, code=exit
root@Kopano:~# journalctl -xe
--
-- The result is failed.
Mai 02 20:46:13 Kopano systemd[1]: mysql.service: Unit entered failed state.
Mai 02 20:46:13 Kopano systemd[1]: mysql.service: Failed with result 'exit-code'
Mai 02 20:46:13 Kopano systemd[1]: mysql.service: Service hold-off time over, sc
Mai 02 20:46:13 Kopano 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.
Mai 02 20:46:13 Kopano 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.
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profi
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profi
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profi
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:323): appar
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:324): appar
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:325): appar
lines 1349-1371/1371 (END)
--
-- The result is failed.
Mai 02 20:46:13 Kopano systemd[1]: mysql.service: Unit entered failed state.
Mai 02 20:46:13 Kopano systemd[1]: mysql.service: Failed with result 'exit-code'.
Mai 02 20:46:13 Kopano systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Mai 02 20:46:13 Kopano 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.
Mai 02 20:46:13 Kopano 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.
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:323): apparmor="DENIED" operation="open
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:324): apparmor="DENIED" operation="open
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:325): apparmor="DENIED" operation="open
root@Kopano:~# journalctl -xe
-- Unit mysql.service has finished shutting down.
Mai 02 20:46:13 Kopano 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.
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:323): apparmor="DENIED" operation="open
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:324): apparmor="DENIED" operation="open
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:325): apparmor="DENIED" operation="open
Mai 02 20:46:14 Kopano audit[3361]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:46:14 Kopano audit[3361]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:46:14 Kopano audit[3361]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:46:14 Kopano kernel: audit: type=1400 audit(1493750774.036:326): apparmor="DENIED" operation="mkno
Mai 02 20:46:14 Kopano kernel: audit: type=1400 audit(1493750774.036:327): apparmor="DENIED" operation="mkno
Mai 02 20:46:14 Kopano kernel: audit: type=1400 audit(1493750774.036:328): apparmor="DENIED" operation="mkno
Mai 02 20:46:14 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:14 Kopano kernel: audit: type=1400 audit(1493750774.056:329): apparmor="DENIED" operation="open
Mai 02 20:46:14 Kopano systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Mai 02 20:46:21 Kopano sshd[3410]: Did not receive identification string from 172.29.124.215
root@Kopano:~#
root@Kopano:~#
root@Kopano:~# journalctl -xe
Mai 02 20:46:44 Kopano 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.
Mai 02 20:46:44 Kopano systemd[1]: mysql.service: Unit entered failed state.
Mai 02 20:46:44 Kopano systemd[1]: mysql.service: Failed with result 'exit-code'.
Mai 02 20:46:44 Kopano systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Mai 02 20:46:44 Kopano 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.
-- Subject: Unit cups.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit cups.service has finished starting up.
--
-- The start-up result is done.
Mai 02 20:45:43 Kopano 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.
Mai 02 20:45:43 Kopano systemd[1]: mysql.service: Unit entered failed state.
Mai 02 20:45:43 Kopano systemd[1]: mysql.service: Failed with result 'exit-code'.
Mai 02 20:45:43 Kopano systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Mai 02 20:45:43 Kopano 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.
Mai 02 20:45:43 Kopano 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.
Mai 02 20:45:43 Kopano audit[3273]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:45:43 Kopano audit[3273]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:45:43 Kopano audit[3273]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:45:43 Kopano kernel: audit: type=1400 audit(1493750743.388:316): apparmor="DENIED" operation="open
Mai 02 20:45:43 Kopano kernel: audit: type=1400 audit(1493750743.388:317): apparmor="DENIED" operation="open
Mai 02 20:45:43 Kopano kernel: audit: type=1400 audit(1493750743.388:318): apparmor="DENIED" operation="open
Mai 02 20:45:43 Kopano audit[3273]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:45:43 Kopano kernel: audit: type=1400 audit(1493750743.524:319): apparmor="DENIED" operation="mkno
Mai 02 20:45:43 Kopano audit[3273]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:45:43 Kopano audit[3273]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:45:43 Kopano kernel: audit: type=1400 audit(1493750743.528:320): apparmor="DENIED" operation="mkno
Mai 02 20:45:43 Kopano kernel: audit: type=1400 audit(1493750743.528:321): apparmor="DENIED" operation="mkno
Mai 02 20:45:43 Kopano audit[3273]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:45:43 Kopano kernel: audit: type=1400 audit(1493750743.544:322): apparmor="DENIED" operation="open
Mai 02 20:45:44 Kopano systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Mai 02 20:45:51 Kopano sshd[3304]: Did not receive identification string from 172.29.124.215
Mai 02 20:46:13 Kopano 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.
Mai 02 20:46:13 Kopano systemd[1]: mysql.service: Unit entered failed state.
Mai 02 20:46:13 Kopano systemd[1]: mysql.service: Failed with result 'exit-code'.
Mai 02 20:46:13 Kopano systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Mai 02 20:46:13 Kopano 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.
Mai 02 20:46:13 Kopano 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.
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:13 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:323): apparmor="DENIED" operation="open
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:324): apparmor="DENIED" operation="open
Mai 02 20:46:13 Kopano kernel: audit: type=1400 audit(1493750773.892:325): apparmor="DENIED" operation="open
Mai 02 20:46:14 Kopano audit[3361]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:46:14 Kopano audit[3361]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:46:14 Kopano audit[3361]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:46:14 Kopano kernel: audit: type=1400 audit(1493750774.036:326): apparmor="DENIED" operation="mkno
Mai 02 20:46:14 Kopano kernel: audit: type=1400 audit(1493750774.036:327): apparmor="DENIED" operation="mkno
Mai 02 20:46:14 Kopano kernel: audit: type=1400 audit(1493750774.036:328): apparmor="DENIED" operation="mkno
Mai 02 20:46:14 Kopano audit[3361]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:14 Kopano kernel: audit: type=1400 audit(1493750774.056:329): apparmor="DENIED" operation="open
Mai 02 20:46:14 Kopano systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Mai 02 20:46:21 Kopano sshd[3410]: Did not receive identification string from 172.29.124.215
Mai 02 20:46:44 Kopano 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.
Mai 02 20:46:44 Kopano systemd[1]: mysql.service: Unit entered failed state.
Mai 02 20:46:44 Kopano systemd[1]: mysql.service: Failed with result 'exit-code'.
Mai 02 20:46:44 Kopano systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Mai 02 20:46:44 Kopano 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.
Mai 02 20:46:44 Kopano 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.
Mai 02 20:46:44 Kopano audit[3472]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:44 Kopano audit[3472]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:44 Kopano audit[3472]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:44 Kopano kernel: audit: type=1400 audit(1493750804.376:330): apparmor="DENIED" operation="open
Mai 02 20:46:44 Kopano kernel: audit: type=1400 audit(1493750804.376:331): apparmor="DENIED" operation="open
Mai 02 20:46:44 Kopano kernel: audit: type=1400 audit(1493750804.376:332): apparmor="DENIED" operation="open
Mai 02 20:46:44 Kopano audit[3472]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:46:44 Kopano audit[3472]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:46:44 Kopano audit[3472]: AVC apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name=
Mai 02 20:46:44 Kopano kernel: audit: type=1400 audit(1493750804.512:333): apparmor="DENIED" operation="mkno
Mai 02 20:46:44 Kopano kernel: audit: type=1400 audit(1493750804.512:334): apparmor="DENIED" operation="mkno
Mai 02 20:46:44 Kopano kernel: audit: type=1400 audit(1493750804.512:335): apparmor="DENIED" operation="mkno
Mai 02 20:46:44 Kopano audit[3472]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="
Mai 02 20:46:44 Kopano kernel: audit: type=1400 audit(1493750804.532:336): apparmor="DENIED" operation="open
Mai 02 20:46:45 Kopano systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Mai 02 20:46:47 Kopano webmin[2616]: Timeout of session for root
Mai 02 20:46:51 Kopano sshd[3502]: Did not receive identification string from 172.29.124.215
lines 1359-1381/1381 (END)
(1) Bitte [code]-Tags verwenden - das steigert die Lesbarkeit enorm.
(2) Da spuckt Dir wohl Apparmor dazwischen. Also entweder abschalten oder sauber konfigurieren.
Habe Apparmor gestoppt, ist noch nicht programmiert. Geht aber immer noch nicht.
Code-Tags werden mir leider in der Antwort nicht angezeigt.
root@Kopano:~# service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
root@Kopano:~# 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 Di 2017-05-02 22:14:55 CEST; 20s ago
Process: 6117 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 6110 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 6117 (code=exited, status=1/FAILURE); : 6118 (mysql-systemd-s)
CGroup: /system.slice/mysql.service
└─control
├─6118 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─6173 sleep 1
Mai 02 22:14:55 Kopano systemd[1]: Starting MySQL Community Server...
Mai 02 22:14:56 Kopano systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
root@Kopano:~#
bzgl Code Tags:
da dann einfach
den code zwischen
root@Kopano:~# service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
root@Kopano:~# 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 Di 2017-05-02 22:14:55 CEST; 20s ago
Process: 6117 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 6110 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 6117 (code=exited, status=1/FAILURE); : 6118 (mysql-systemd-s)
CGroup: /system.slice/mysql.service
└─control
├─6118 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─6173 sleep 1
Mai 02 22:14:55 Kopano systemd[1]: Starting MySQL Community Server...
Mai 02 22:14:56 Kopano systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
root@Kopano:~#
[edit]Kannst du auch noch nachträglich drum basteln...
Nur so im überfliegen, sehe ich Unstimmigkeiten der Rechte, wer hat da gefummelt!
Die Gruppenrechte fehlen fast überall, auf keinem meiner Server kann ich lediglich User-Rechte für Mysql finden. Also schlage ich vor, die Rechte entsprechend zu ändern.
z.B.
-rw-rw---- 1 mysql mysql 203423744 Mai 3 09:45 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Mai 3 09:45 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Mai 3 09:45 ib_logfile1
Hallo,
apparmor limitiert die Zugriffe des mysqld-Prozesses:
Ich habe /etc/apparmor.d/usr.sbin.mysqld wie folgt angepasst:
# Allow data dir access
/var/lib/mysql/ r,
/var/lib/mysql/** rwk,
/srv/mysql/ r,
/srv/mysql/** rwk,
Gruß bmk
Powered by vBulletin® Version 4.2.5 Copyright ©2024 Adduco Digital e.K. und vBulletin Solutions, Inc. Alle Rechte vorbehalten.