Storage in /home
Hello Archers, I though I'd ask before jumping in with an edit:
I've spent some hours tracking down and fixing an issue that is not covered in relation to the topic.
If you add storage to Zoneminder that is mounted under a home directory, it will not be accessible. It's possible to get in a big mess following out of date fixes around php open_basedir
I did not want to move the mount point, so I decided to apply the following fix copied from an unrelated post else where:
sudo nano /etc/systemd/system/multi-user.target.wants/php-fpm.service 1. Set ProtectHome=false in /etc/systemd/system/multi-user.target.wants/php-fpm.service 2. systemctl daemon-reload 3. systemctl restart nginx.service 4. systemctl restart php-fpm.service
This will be over written by php-fpm updates and modifies the maintainers security setting ... not ideal.
MySQL creation database
$ mysql -u root -p
Shouldn't this be run as root?
# mysql -u root -p