Ncp can not update nextcloud from 28.0.9

Hi,

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

The only hard coin here is:

A Google search may illumine what went wrong with your setup.

when i try to log in to sql server using root via

mysql -u root

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.

Similar effects on mine ncp.

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)

no it did not do anything
standard NCP image…

i just checked the password in /root/.my.cnf and it seems correct.

it did correctly update autmatically until 28.0.9 and i dont remember to have changed anything on the system.

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)’

@theCalcaholic can you probably shed some light on this?

My system info:

NextcloudPi version v1.55.1
NextcloudPi image NextCloudPi_RaspberryPi_v1.52.2.img
OS Debian GNU/Linux 12. 6.1.21-v8+ (aarch64)
automount yes
USB devices sda
datadir /media/myCloudDrive/ncdata
data in SD no
data filesystem btrfs
data disk usage 1.1T/1.9T
rootfs usage 18G/29G
swapfile /var/swap
dbdir /media/USBdrive/ncdatabase
Nextcloud check ok
Nextcloud version 28.0.9.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
Public IPv6 not found
Port 80 open
Port 443 open
IP 10.0.0.4
Gateway 10.0.0.1
Interface eth0
Certificates removed
NAT loopback yes
Uptime 1:09

Nextcloud configuration

passwordsalt removed
secret removed
trusted_domains 0 localhost


5 nextcloudpi.local
1 10.0.0.4
7 nextcloudpi
8 nextcloudpi.lan
11 removed
20 removed
3 removed
14 nextcloudpi
datadirectory /media/myCloudDrive/ncdata
tempdirectory /media/myCloudDrive/ncdata/tmp
overwrite.cli.url removed
dbtype mysql
version 28.0.9.1
dbname nextcloud
dbhost localhost
dbport
dbtableprefix oc_
mysql.utf8mb4 1
dbuser root
dbpassword removed
installed 1
instanceid removed
memcache.local \OC\Memcache\Redis
memcache.locking \OC\Memcache\Redis
redis host /var/run/redis/redis.sock


port 0
timeout 0
password removed
appstoreenabled 1
mail_smtpmode smtp
mail_smtpauthtype LOGIN
mail_from_address removed
overwriteprotocol https
maintenance
logfile /media/myCloudDrive/ncdata/nextcloud.log
loglevel 2
log_type file
theme
updater.release.channel stable
htaccess.RewriteBase /
jpeg_quality 60
data-fingerprint removed
default_locale removed
default_phone_region removed
app_install_overwrite 0 apporder


1 impersonate
2 defaultlinkopen
3 initialcheck
4 occweb
5 files_texteditor
6 dashboard
7 radio
8 files_external_onedrive
9 social
10 printer
11 admin_notifications
12 previewgenerator
13 weather
14 files_trackdownloads
15 folderplayer
16 keeporsweep
17 files_external_dropbox
18 files_markdown
19 sharingpath
20 cms_pico
21 ransomware_protection
22 dicomviewer
23 duplicatefinder
24 epubreader
25 files_ebookreader
26 files_reader
27 sharerenamer
28 news
29 metadata
30 files_rightclick
31 7
mail_sendmailmode smtp
mail_smtpsecure tls
mail_smtpauth 1
mail_smtphost removed
mail_smtpport 587
mail_smtpname removed
mail_smtppassword removed
trusted_proxies 11 127.0.0.1


12 ::1
14 10.0.0.4
memories.exiftool /var/www/nextcloud/apps/memories/bin-ext/exiftool-aarch64-glibc
memories.vod.path /var/www/nextcloud/apps/memories/bin-ext/go-vod-aarch64
maintenance_window_start 8
memories.db.triggers.fcu 1
memories.vod.ffmpeg /usr/bin/ffmpeg
memories.vod.ffprobe /usr/bin/ffprobe
memories.gis_type 1
enabledPreviewProviders 1 OC\Preview\Movie


2 OC\Preview\Image
3 OC\Preview\MP3
preview_max_x 2048
preview_max_y 2048

Sorry, I can’t find an error. If your instance is running ok, than I would wait for new ncp versions; or try to force an update on nc 29.0.7.

I am already in contact with theCalcaholic on github about this issue. We will see…

I saw it
Here something to notice
https://help.nextcloud.com/t/update-to-29-0-4-via-ncp-1-55-nc-update-nextcloud-failed/203280/5?u=geow

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

password=mypassword

my guess is, that it should look like

password=ā€˜mypassword’

Could anyone confirm this?