[Bug 1902744] Re: MariaDB Update changes ProtectHome option, breaking MySQL
> Disregard. Creating the file in /etc/systemd/system/mariadb.service.d/ > works fine. Indeed, the documentation was not clear enough I have updated it: https://mariadb.com/kb/en/systemd/#configuring-access-to-home-directories Thanks! > That's what I get for googling how to disable ProtectHome in Ubuntu. > First answer was to modify a system file that is overwritten when the > package is updated. You should always trust the official documentation, here it is: https://www.freedesktop.org/software/systemd/man/systemd.unit.html Regards, Faustin -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1902744 Title: MariaDB Update changes ProtectHome option, breaking MySQL To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.1/+bug/1902744/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1902744] Re: MariaDB Update changes ProtectHome option, breaking MySQL
Disregard. Creating the file in /etc/systemd/system/mariadb.service.d/ works fine. On Ubuntu you must mkdir -p first, since /etc/systemd/system does not exist If anyone else stumbles across this annoying issue: mkdir -p /etc/systemd/system/mariadb.service.d cat > /etc/systemd/system/mariadb.service.d/dontprotecthome.conf << EOL [Service] ProtectHome=false EOL systemctl daemon-reload systemctl restart mariadb That's what I get for googling how to disable ProtectHome in Ubuntu. First answer was to modify a system file that is overwritten when the package is updated. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1902744 Title: MariaDB Update changes ProtectHome option, breaking MySQL To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.1/+bug/1902744/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1902744] Re: MariaDB Update changes ProtectHome option, breaking MySQL
Where is the drop-in directory supposed to exist in Ubuntu? Supposedly you can find out with the systemctl status command, but there is nothing in the output. Nor can I find anything in the default service file that "includes" a specific folder. # systemctl status mariadb.service ● mariadb.service - MariaDB 10.1.47 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: active (running) since Tue 2020-11-03 09:09:17 MST; 2h 47min ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 20863 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 20860 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS) Process: 20723 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 20721 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 20720 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 20833 (mysqld) Status: "Taking your SQL requests now..." Tasks: 36 (limit: 4915) CGroup: /system.slice/mariadb.service └─20833 /usr/sbin/mysqld -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1902744 Title: MariaDB Update changes ProtectHome option, breaking MySQL To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.1/+bug/1902744/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1902744] Re: MariaDB Update changes ProtectHome option, breaking MySQL
Hi Zizzy! Thanks for your report and for helping making ubuntu better. Here is how you want to handle this situation: https://mariadb.com/kb/en/systemd/#configuring-access-to-home-directories Regards, Faustin ** Changed in: mariadb-10.1 (Ubuntu) Status: New => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1902744 Title: MariaDB Update changes ProtectHome option, breaking MySQL To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.1/+bug/1902744/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs