I changed my NextCloud host address from xxduckdns.org to xxyy.duckdns.org because overnight the https://xxduckdns.org wouldn’t connect in https.
Why ? no idea and couldn’t get it to work/connect again so I changed it to https://xxyy.duckdns.org which is working fine
I’m now seeing in my logs :
Exception
HMAC does not match.
Could not decrypt or decode encrypted session data
This error is only a couple of days old , so it seem tied into me changing the duckdns address
Have seen nothing about this via Google that seems to be linked to my problem so any help clearing it up would be nice
It may be due multiple authentication tokens on the same devices. Tried deleting all the tokes and login in again. I will monitor, but seems to have fixed the problem.
./occ user:list # list users
./occ user:auth-tokens:list username # list all tokens for this user
./occ user:auth-tokens:delete username 1 # delete token of id 1 for user username
or
./occ user:auth-tokens:delete username --last-used-before 2024-01-01
Also facing this issue since I upgrade all the way up to Stable 29.0.2. Alredy checked APCu settings, deleted my auth-tokens but nothing helped. Would like to find a solution.
He literally gave the command in his posting. log in into your database via mysql and in the mysql prompt type DELETE FROM oc_storages_credentials WHERE user = ‘YOURUSERNAME’;
I get these errors too. When I run this comand I get: " Failed to execute SQL : SQL delete from oc_storages_credentials where user = ‘myuser’; failed : Unknown column ‘‘myuser’ in ‘where clause’"
Out of curiosity I opened the oc_storages_credentials table in my Nextcloud database (MariaDB) and it appears to have no data. There are four fields in it: id, user, indentifer, credentials but they contain no data.