Hi, after fixing the daily update message by updating NCP to 1.55.2, it is no more possible to update nextcloud as long as the mysql root user has a password set.
if i do so, i get the folowing result in console:
[ nc-update ] (Tue Sep 24 21:01:42 BST 2024)
Downloading updates
Performing updates
Running nc-autoupdate-nc
[ nc-autoupdate-nc ] (Tue Sep 24 21:03:33 BST 2024)
automatic Nextcloud updates enabled
automatic Nextcloud updates enabled
Installing template 'mysql/91-ncp.cnf.sh'...
Reloading MariaDB database server: mariadbd�/usr/bin/mariadb-admin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Error while applying update 1.55.2. Exiting...
so wondering about the using password: NO part i got adventurous and set the mysql root password to an empty string. also changed that in the config.php file of nextcloud and in the /root/.my.cnf file.
This enabled me again to update nextcloud, but i doubt this is a long term practical and secure way.
Also i am pretty sure, the password stored in /root/.my.cnf, which is used by ncp normally, was correct and i think this is a bug in nc-update-nextcloud in v1.55.2, because my nextcloud had been updated to 28.0.9 perfectly fine before. Also backups in ncp work just fine and i think they also need to access the database.
@theCalcaholic did you probably already look into this? i had reported this in the already closed bug report for the daily update message on github.