Installed NC 27, getting the following security warnings (warnings were clean/non-existent before the update):
The database is used for transactional file locking. To enhance performance, please configure memcache, if available. See the documentation ? for more information.
The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.
Missing index "mounts_user_root_path_index" in table "oc_mounts".
Please double check the installation guides ?, and check for any errors or warnings in the log.
Check the security of your Nextcloud over our security scan ?.
Running NC27 under OMV6 under docker on a Pi4.
Any comments appreciated.
Ran the occ command for the second warning, and only the first warning remains now. I think it can be ignored…
redis is recommended for performance but if you are happy with your system nothing wrong to stay at this point.
ok thanks, just read that in the NC documentation.
I’m worried about breaking my installation as I don’t see instructions for Docker installs.
Is is safe to install this:
I would also need to figure out any PHP file mods.
I’m happy with the performance of NC27 under docker on a Pi4 so I may leave well enough alone.
yes adding redis is safe. see Docker .examples
Because of this Warning I installed Redis but the warning won’t disappear. Checked if Redis is getting input, but redid-cli monitor is not showing anything when I surf on my nextcloud instance.
Tried both with Unix socket as well as over TCP.
in my instance with working redis I see tons of redis logs only browsing through the interface…
there must b something wrong with your redis config…
Slowly I am getting the feeling the problem is my NGINX setting using a php-fpm socket.
This command, and it’s okay
sudo -u www-data php /var/www/html/nextcloud/occ db:add-missing-indices
This adds only the missing indices, and does not solve the problem with the memcache.
no - apache docker behind traefik
Turned out, installing
php8.1-redis solved my problem… My bad, thought this is already installed.
Thx for your help!
I installed redis today and edited the config.php file accordingly with file locking enabled… everything works fine and Nextcloud 27 seems a little snappier. All warnings are now gone from my Nextcloud install. Happy days.
After some tests, it seems that you should add these 2 lines in
config.php to suppress the warning without needing to install and configure redis :
'memcache.local' => 'OC\\Memcache\\APCu',
'memcache.locking' => 'OC\\Memcache\\APCu',
The first is from nextcloud doc recommandations. The second make the warning go away.