Open Miwer opened 1 year ago
Just in case anyone else run into this, the easiest way to disable systemd tmp redirect for apache2 is to run the following:
sudo systemctl edit apache2.service
and insert the following lines, to create a systemd unit override file for apache2:
[Service]
PrivateTmp=false
save and exit, and restart apache2
Expected behaviour
Database Setup (install/step2.php, actually nzedb/db/DbUpdate.php) is copying *.tsv files from resources/db/schema/data/ to /tmp/, and executing SQL queries to import data from tsv files.
Actual behaviour
tsv files are NOT copied to /tmp/ but a systemd redirected tmp subdirectory under /tmp/ This means mysql cannot read the files, when running the LOAD DATA INFILE query, print errors like these for each '10-*.tsv' file
/tmp/ directory has no tsv files:
... instead they are under systemd-private subfolder:
Steps to reproduce the behaviour
New install on ubuntu server 18.04 LTS - following this guide: https://github.com/nZEDb/nZEDb/wiki/Install-Guide:-Ubuntu-18.04
I suppose I can work around this, by disabling the systemd/tmp redirect for apache2 service, but the ideal solution would be to perhaps incorporate a perment fix in the code.
Unless I have overlooked something in the install guides?