Hi radius,
i have the same issue, in my case i convert the MySQL to 4-byte support (Nextcloud Documentation)
I found a similar error here mail/issues/362
MariaDB [nextcloud]> DESCRIBE oc_credentials;
Field |
Type |
Null |
Key |
Default |
Extra |
user |
varchar(64) |
NO |
PRI |
NULL |
|
identifier |
varchar(64) |
NO |
PRI |
NULL |
|
credentials |
longtext |
YES |
|
NULL |
|
MariaDB [nextcloud]> DESCRIBE oc_share_external;
Field |
Type |
Null |
Key |
Default |
Extra |
id |
int(11) |
NO |
PRI |
NULL |
auto_increment |
remote |
varchar(512) |
NO |
|
NULL |
|
remote_id |
int(11) |
NO |
|
-1 |
|
share_token |
varchar(64) |
NO |
|
NULL |
|
password |
varchar(64) |
YES |
|
NULL |
|
name |
varchar(64) |
NO |
|
NULL |
|
owner |
varchar(64) |
NO |
|
NULL |
|
user |
varchar(64) |
NO |
MUL |
NULL |
|
mountpoint |
varchar(4000) |
NO |
|
NULL |
|
mountpoint_hash |
varchar(32) |
NO |
|
NULL |
|
accepted |
int(11) |
NO |
|
0 |
|
Maybe the Type of the varchar(64) from the field password into oc_share_external doesn’t fit.
Steps to reproduce
- Login as Admin User
- select the external storage
- Error Message: Internal Servererror - Exception: HMAC does not match.
Expected behaviour
Internel Servererror: Exception: HMAC does not match.
Actual behaviour
The external share i can use like before i migrate the mysql database, only can’t edit the Settings.
Server configuration detail
Operating system: Linux 4.9.0-4-amd64 #1 SMP Debian 4.9.65-3 (2017-12-03) x86_64
Webserver: nginx/1.13.7 (fpm-fcgi)
Database: mysql 10.2.11
PHP version: 7.1.12
Modules loaded: Core, date, libxml, openssl, pcre, sqlite3, zlib, ctype, curl, dom, fileinfo, filter, ftp, hash, iconv, json, mbstring, SPL, PDO, session, posix, readline, Reflection, standard, SimpleXML, pdo_sqlite, Phar, tokenizer, xml, xmlreader, xmlwriter, mysqlnd, cgi-fcgi, apcu, exif, gd, intl, ldap, mcrypt, memcached, mysqli, pcntl, pdo_mysql, pdo_pgsql, pgsql, redis, zip, Zend OPcache
Nextcloud version: 12.0.4 - 12.0.4.3
**Updated from an older Nextcloud/ownCloud or fresh install: fresh docker container
Where did you install Nextcloud from: nextcloud docker
Signing status
Array
List of activated apps
Enabled:
- activity: 2.5.2
- admin_audit: 1.2.0
- audioplayer: 2.2.1
- bookmarks: 0.10.1
- bruteforcesettings: 1.0.3
- calendar: 1.5.7
- comments: 1.2.0
- contacts: 2.0.1
- dav: 1.3.0
- deck: 0.2.8
- documents: 0.16.0
- drawio: 0.8.8
- federatedfilesharing: 1.2.0
- federation: 1.2.0
- files: 1.7.2
- files_accesscontrol: 1.2.5
- files_clipboard: 0.6.4
- files_external: 1.3.0
- files_markdown: 2.0.1
- files_pdfviewer: 1.1.1
- files_reader: 1.0.4
- files_retention: 1.1.2
- files_sharing: 1.4.0
- files_texteditor: 2.4.1
- files_trashbin: 1.2.0
- files_versions: 1.5.0
- files_videoplayer: 1.1.0
- firstrunwizard: 2.1
- gallery: 17.0.0
- issuetemplate: 0.3.0
- logreader: 2.0.0
- lookup_server_connector: 1.0.0
- nextcloud_announcements: 1.1
- notifications: 2.0.0
- oauth2: 1.0.5
- ownbackup: 17.5.0
- password_policy: 1.2.2
- provisioning_api: 1.2.0
- ransomware_protection: 1.0.5
- serverinfo: 1.2.0
- sharebymail: 1.2.0
- spreed: 2.0.2
- survey_client: 1.0.0
- systemtags: 1.2.0
- tasks: 0.9.5
- theming: 1.3.0
- twofactor_backupcodes: 1.1.1
- twofactor_totp: 1.3.1
- updatenotification: 1.2.0
- workflowengine: 1.2.0
Disabled:
- cms_pico
- encryption
- user_external
- user_ldap
Configuration (config/config.php)
{
"memcache.local": "\\OC\\Memcache\\APCu",
"apps_paths": [
{
"path": "\/var\/www\/html\/apps",
"url": "\/apps",
"writable": false
},
{
"path": "\/var\/www\/html\/custom_apps",
"url": "\/custom_apps",
"writable": true
}
],
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "redis",
"port": 6379
},
"instanceid": "oc225mf2bydi",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"xxx-mydomain-xxx"
],
"datadirectory": "\/var\/www\/html\/data",
"overwrite.cli.url": "https:\/\/me.my-gateway.de",
"dbtype": "mysql",
"version": "12.0.4.3",
"dbname": "nextcloud",
"dbhost": "db",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"mail_smtpmode": "smtp",
"mail_smtpauthtype": "LOGIN",
"mail_smtpsecure": "tls",
"mail_from_address": "xxxx",
"mail_domain": "web.de",
"mail_smtpauth": 1,
"mail_smtphost": "smtp.web.de",
"mail_smtpport": "587",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"maintenance": false,
"theme": "",
"loglevel": 2
}
Are you using external storage, if yes which one: local share…
Are you using encryption: no
Are you using an external user-backend, if yes which one: no …
LDAP configuration (delete this part if not used)
With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your Nextcloud installation folder
Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';
Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.
Client configuration
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:57.0) Gecko/20100101 Firefox/57.0
Operating system:
Logs
Nextcloud log
{"reqId":"wLxpyZ9c5gWG97IW6Mch","level":3,"time":"2017-12-23T18:07:56+00:00","remoteAddr":"172.19.0.2","user":"Admin","app":"index","method":"GET","url":"\/settings\/admin\/externalstorages","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"HMAC does not match.\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/Security\\\/CredentialsManager.php(92): OC\\\\Security\\\\Crypto->decrypt(*** sensitive parameters replaced ***)\\n#1 \\\/var\\\/www\\\/html\\\/apps\\\/files_external\\\/lib\\\/Lib\\\/Auth\\\/Password\\\/GlobalAuth.php(55): OC\\\\Security\\\\CredentialsManager->retrieve('', 'password::globa...')\\n#2 \\\/var\\\/www\\\/html\\\/apps\\\/files_external\\\/lib\\\/Settings\\\/Admin.php(71): OCA\\\\Files_External\\\\Lib\\\\Auth\\\\Password\\\\GlobalAuth->getAuth('')\\n#3 \\\/var\\\/www\\\/html\\\/settings\\\/Controller\\\/AdminSettingsController.php(88): OCA\\\\Files_External\\\\Settings\\\\Admin->getForm()\\n#4 \\\/var\\\/www\\\/html\\\/settings\\\/Controller\\\/AdminSettingsController.php(73): OC\\\\Settings\\\\Controller\\\\AdminSettingsController->getSettings('externalstorage...')\\n#5 [internal function]: OC\\\\Settings\\\\Controller\\\\AdminSettingsController->index('externalstorage...')\\n#6 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(160): call_user_func_array(Array, Array)\\n#7 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(90): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OC\\\\Settings\\\\Controller\\\\AdminSettingsController), 'index')\\n#8 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/AppFramework\\\/App.php(114): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OC\\\\Settings\\\\Controller\\\\AdminSettingsController), 'index')\\n#9 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(47): OC\\\\AppFramework\\\\App::main('OC\\\\\\\\Settings\\\\\\\\Con...', 'index', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#10 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#11 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/Route\\\/Router.php(299): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#12 \\\/var\\\/www\\\/html\\\/lib\\\/base.php(1004): OC\\\\Route\\\\Router->match('\\\/settings\\\/admin...')\\n#13 \\\/var\\\/www\\\/html\\\/index.php(48): OC::handleRequest()\\n#14 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/lib\\\/private\\\/Security\\\/Crypto.php\",\"Line\":129}","userAgent":"Mozilla\/5.0 (Windows NT 6.1; WOW64; rv:57.0) Gecko\/20100101 Firefox\/57.0","version":"12.0.4.3"}
{"reqId":"lRnD87KnertiXvOMtrwX","level":3,"time":"2017-12-23T19:33:05+00:00","remoteAddr":"172.19.0.2","user":"Admin","app":"no app in context","method":"GET","url":"\/settings\/admin\/externalstorages","message":"issuetemplate","userAgent":"Mozilla\/5.0 (Windows NT 6.1; WOW64; rv:57.0) Gecko\/20100101 Firefox\/57.0","version":"12.0.4.3"}
{"reqId":"lRnD87KnertiXvOMtrwX","level":3,"time":"2017-12-23T19:33:05+00:00","remoteAddr":"172.19.0.2","user":"Admin","app":"index","method":"GET","url":"\/settings\/admin\/externalstorages","message":"Exception: {\"Exception\":\"Exception\",\"Message\":\"HMAC does not match.\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/Security\\\/CredentialsManager.php(92): OC\\\\Security\\\\Crypto->decrypt(*** sensitive parameters replaced ***)\\n#1 \\\/var\\\/www\\\/html\\\/apps\\\/files_external\\\/lib\\\/Lib\\\/Auth\\\/Password\\\/GlobalAuth.php(55): OC\\\\Security\\\\CredentialsManager->retrieve('', 'password::globa...')\\n#2 \\\/var\\\/www\\\/html\\\/apps\\\/files_external\\\/lib\\\/Settings\\\/Admin.php(71): OCA\\\\Files_External\\\\Lib\\\\Auth\\\\Password\\\\GlobalAuth->getAuth('')\\n#3 \\\/var\\\/www\\\/html\\\/settings\\\/Controller\\\/AdminSettingsController.php(88): OCA\\\\Files_External\\\\Settings\\\\Admin->getForm()\\n#4 \\\/var\\\/www\\\/html\\\/settings\\\/Controller\\\/AdminSettingsController.php(73): OC\\\\Settings\\\\Controller\\\\AdminSettingsController->getSettings('externalstorage...')\\n#5 [internal function]: OC\\\\Settings\\\\Controller\\\\AdminSettingsController->index('externalstorage...')\\n#6 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(160): call_user_func_array(Array, Array)\\n#7 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(90): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OC\\\\Settings\\\\Controller\\\\AdminSettingsController), 'index')\\n#8 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/AppFramework\\\/App.php(114): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OC\\\\Settings\\\\Controller\\\\AdminSettingsController), 'index')\\n#9 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(47): OC\\\\AppFramework\\\\App::main('OC\\\\\\\\Settings\\\\\\\\Con...', 'index', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#10 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#11 \\\/var\\\/www\\\/html\\\/lib\\\/private\\\/Route\\\/Router.php(299): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#12 \\\/var\\\/www\\\/html\\\/lib\\\/base.php(1004): OC\\\\Route\\\\Router->match('\\\/settings\\\/admin...')\\n#13 \\\/var\\\/www\\\/html\\\/index.php(48): OC::handleRequest()\\n#14 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/lib\\\/private\\\/Security\\\/Crypto.php\",\"Line\":129}","userAgent":"Mozilla\/5.0 (Windows NT 6.1; WOW64; rv:57.0) Gecko\/20100101 Firefox\/57.0","version":"12.0.4.3"}