Trying to update my current 28.0.9 version (had been updated to by ncp) I always get an access denied error.
[ nc-update-nextcloud ] (Sun Sep 15 08:57:28 BST 2024)
Failed to reset failed state of unit ncp-encrypt.service: Unit ncp-encrypt.service not loaded.
Running as unit: ncp-update-nc.service
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
Current Nextcloud version 28.0.9
Requested Nextcloud version latest
Selected Nextcloud version 28.0.10
INFO: You have requested an update to ālatestā, but a direct update to ālatestā cannot be performed, so the latest available version that can be updated to (28.0.10) has been selected automatically.
ERROR 1045 (28000): Access denied for user ārootā@ālocalhostā (using password: NO)
Nextcloud update finished successfully.
No idea what permission should be wrong here, it looks to me like i can not download actually
i can login without a password, so it looks to me like the reason is something different.
looks like this btw:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12625
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
pi@nextcloudpi:~ $ mysql -u root
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
pi@nextcloudpi:~ $ sudo mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 246196
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> exit
Bye
pi@nextcloudpi:~ $
Did it?
How did you setup your instance? (container, pi, other)
pi@nextcloudpi:~ $ sudo ncp-report
<--! Paste this in GitHub report -->
<details>
<summary>NextcloudPi diagnostics</summary>
NextcloudPi version v1.55.1
NextcloudPi image NextCloudPi_RaspberryPi_v1.50.5.img
OS Debian GNU/Linux 12. 6.1.21-v8+ (aarch64)
automount yes
USB devices sda sdb
datadir /opt/ncdata/data
data in SD yes
data filesystem ext2/ext3
data disk usage 27G/220G
rootfs usage 27G/220G
swapfile /var/swap
dbdir /var/lib/mysql
Nextcloud check ok
Nextcloud version 29.0.7.1
HTTPD service up
PHP service up
MariaDB service up
Redis service up
HPB service up
Postfix service up
Internet check ok
Public IPv4 ***REMOVED SENSITIVE VALUE***
Public IPv6 ***REMOVED SENSITIVE VALUE***
Port 80 closed
Port 443 closed
IP ***REMOVED SENSITIVE VALUE***
Gateway ***REMOVED SENSITIVE VALUE***
Interface end0
Certificates ***REMOVED SENSITIVE VALUE***
NAT loopback no
Uptime 20days
</details>
...
pi@nextcloudpi:~ $
The only advice I can give is try an āupdateā on the running version 28.0.9.
I did try that, but i get a message, that this version of nextcloud is already installed.
I also tried to update via cli, with same effect. Strange seems to me, that nextcloud itself is running correctly, changing the password in /root/.my.cnf results in nextcloud being unaccessible, so imo mariadb is configured correctly.
What also concerns me, is that the error message says ā(using password: NO)ā
while the google search gave me results saying ā(using password: YES)ā
Temporary fixed by removing mariadb root user password to empty and editing the password string in nextcloud config.php and /root/.my.cnf
Now update is possible, looking at the .my.cnf the password in there had been like