Nextcloud version 20.0.7
Operating system and version Ubuntu 18.04
Apache or nginx version Apache 2.4.29
PHP version 7.4
The issue you are facing:
I am completely stuck. Been at it for days… any help or tips would be greatly appreciated.
I upgraded MariaDB to 10.5. shortly after upgrading to Nextcloud 20.0.7, and now I am unable to log in.
I was able to login to Nextclound 20.0.7 before the MariaDB upgrade without issues.
Both the upgrade to Nextcloud 20.0.7 and MariaDB 10.5 seems to go smoothly.
Database is up and running, and everything seems to check out ok.
I was logged in to the web ui, and refreshed the page after the upgrade. That worked first time, then on second refresh I got the enter you updater.secret in plaintext message, and couldn’t do anything else. I followed the suggested procedure to replace that, and now cannot login at all. The logs seem to give no indication of what the problem is.
Other things I’ve tried:
- enabling and disabling users
- adding a new admintest user
- resetting user passwords
- running maintenece:repair
Is this the first time you’ve seen this error? Y:
Steps to replicate it:
- Go to Login page
- Enter correct user credentials
- Login page says “Wrong username or password.”
The output of your Nextcloud log in Admin > Logging:
{"reqId":"L2MbbfaN3K9zNtpNihwp","level":2,"time":"2021-02-20T17:40:19+00:00","remoteAddr":"192.168.1.1","user":"--","app":"no app in context","method":"POST","url":"/index.php/login","message":"Login failed: admintest (Remote IP: 192.168.1.1)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36","version":"20.0.7.1"}
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'xxx',
'passwordsalt' => 'xxx',
'secret' => 'xxx',
'trusted_domains' =>
array (
0 => 'cloud.xxx.com',
),
'datadirectory' => '/var/www/cloud.xxx.com/data',
'dbtype' => 'mysql',
'version' => '20.0.7.1',
'overwrite.cli.url' => 'https://cloud.xxx.com',
'dbname' => 'nextclouddb',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'dbuser' => 'nextcloud',
'dbpassword' => 'xxx',
'installed' => true,
'mail_smtpdebug' => true,
'maintenance' => false,
'theme' => '',
'loglevel' => 0,
'mail_from_address' => 'xxx',
'mail_smtpmode' => 'smtp',
'updater.secret' => 'xxxxxxxxx',
'mail_sendmailmode' => 'smtp',
'mail_domain' => 'xxx.com',
);
The output of your Apache/nginx/system log in /var/log/____
:
192.168.1.1 - - [20/Feb/2021:09:42:49 -0500] "OPTIONS /remote.php/dav/principals/users/yyy/ HTTP/1.1" 401 557
192.168.1.1 - - [20/Feb/2021:09:42:49 -0500] "PROPFIND /remote.php/dav/principals/users/yyy/ HTTP/1.1" 401 557
192.168.1.1 - - [20/Feb/2021:11:08:13 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 122
192.168.1.1 - - [20/Feb/2021:11:08:13 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 123
192.168.1.1 - - [20/Feb/2021:11:20:13 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 122
192.168.1.1 - - [20/Feb/2021:11:32:13 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 122
192.168.1.1 - - [20/Feb/2021:11:44:13 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 121
192.168.1.1 - - [20/Feb/2021:11:56:13 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 122
192.168.1.1 - - [20/Feb/2021:12:01:12 -0500] "POST /index.php/login HTTP/1.1" 303 -
192.168.1.1 - - [20/Feb/2021:12:01:27 -0500] "GET /index.php/apps/dashboard/ HTTP/1.1" 303 -
192.168.1.1 - - [20/Feb/2021:12:01:27 -0500] "GET /index.php/login?redirect_url=/index.php/apps/dashboard/ HTTP/1.1" 200 4954
192.168.1.1 - - [20/Feb/2021:12:01:30 -0500] "GET /index.php/apps/theming/icon?v=0 HTTP/1.1" 200 24609
192.168.1.1 - - [20/Feb/2021:12:01:36 -0500] "POST /index.php/login HTTP/1.1" 303 -
192.168.1.1 - - [20/Feb/2021:12:01:39 -0500] "GET /index.php/login?user=xxx@xxx.com&redirect_url=/index.php/apps/dashboard/ HTTP/1.1" 200 4998
192.168.1.1 - - [20/Feb/2021:12:13:40 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 122
192.168.1.1 - - [20/Feb/2021:12:25:40 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 121
192.168.1.1 - - [20/Feb/2021:12:37:40 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 122
192.168.1.1 - - [20/Feb/2021:12:38:34 -0500] "GET / HTTP/1.1" 302 -
192.168.1.1 - - [20/Feb/2021:12:38:34 -0500] "GET /index.php/login HTTP/1.1" 200 4918
192.168.1.1 - - [20/Feb/2021:12:40:01 -0500] "GET / HTTP/1.1" 302 -
192.168.1.1 - - [20/Feb/2021:12:40:01 -0500] "GET /index.php/login HTTP/1.1" 200 4921
192.168.1.1 - - [20/Feb/2021:12:40:02 -0500] "GET /core/img/background.png?v=2 HTTP/1.1" 200 9621
192.168.1.1 - - [20/Feb/2021:12:40:02 -0500] "GET /core/img/logo/logo.svg?v=1 HTTP/1.1" 200 321
192.168.1.1 - - [20/Feb/2021:12:40:01 -0500] "GET /index.php/apps/theming/styles?v=0 HTTP/1.1" 200 468
192.168.1.1 - - [20/Feb/2021:12:40:02 -0500] "GET /core/img/background.png?v=0 HTTP/1.1" 304 -
192.168.1.1 - - [20/Feb/2021:12:40:02 -0500] "GET /index.php/apps/theming/manifest?v=0 HTTP/1.1" 200 188
192.168.1.1 - - [20/Feb/2021:12:40:16 -0500] "POST /index.php/login HTTP/1.1" 303 -
192.168.1.1 - - [20/Feb/2021:12:40:23 -0500] "GET /index.php/login?user=admintest HTTP/1.1" 200 4960
192.168.1.1 - - [20/Feb/2021:12:49:40 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 122
192.168.1.1 - - [20/Feb/2021:12:50:35 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 122
192.168.1.1 - - [20/Feb/2021:12:52:23 -0500] "GET /index.php/csrftoken HTTP/1.1" 200 122