Summary
Enabling app. use bad temporary folder, throwing error etc…
Context:
Upgrading (NC11 to) NC12 to NC13.
Problem:
Enabling an app. (calendar or contact) through web admin. or occ fail with this error:
Error: An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'XXX_cloud' AND TABLE_NAME = 'oc_accounts'':
SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_9e9_0.MAI' (Errcode: 13 "Permission denied")
The thing is that I don’t give access to this “tmp” folder. My current php-fpm config is:
env[PATH] = /usr/local/bin:/usr/bin:/bin
env[TMP]=/var/www/XXX.XX/tmp
env[TMPDIR]=/var/www/XXX.XX/tmp
env[TEMP]=/var/www/XXX.XX/tmp
php_admin_value[open_basedir] = /var/www/XXX.XX/web/:/var/www/XXX.XX/tmp/:/var/www/XXX.XX/data/:/dev/urandom
php_admin_value[session.save_path] = /var/www/XXX.XX/tmp
php_admin_value[upload_tmp_dir] = /var/www/XXX.XX/tmp
My NC config set 'tempdirectory' => '/var/www/sites/XXX.XX/tmp',
To know, /var/www/XXX.XX/tmp is a symbolic link to /var/www/sites/XXX.XX/tmp
Did I miss something on the conf. / upgrade or?
Thanks,