maria-discuss team mailing list archive

[Daniel Black <daniel@xxxxxxxxxxx>]

On Thu, Oct 13, 2022 at 12:27 AM Jogchum Reitsma
<jogchum.reitsma@xxxxxxxxx> wrote:

> Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test
> can't be created and how to solve that?

In systemd ProtectHome=read-only is the default.

systemctl edit mariadb.service and add:
[Service]
ProtectHome=false

https://mariadb.com/kb/en/systemd/#useful-systemd-options

You may also need to selinux relabel the new directory:

sudo semanage fcontext -a -t mysqld_db_t "/home/jogchum/mysql_recover(/.*)?"
sudo restorecon -Rv /home/jogchum/mysql_recover

https://mariadb.com/kb/en/selinux/#setting-the-file-context-for-the-data-directory