Hello i’m trying to login into a new install of Nextcloud v 26.0.1.1 I installed in last week and it ran fine I tried to log into it today and all it would do is flash the login screen. it have an Apache virtual server and is sitting behind an Apache reverse proxy to use it with Open ID Connect 2 if we can figure this out. below are some of my config files.
Nextcloud config:
<?php $CONFIG = array ( 'instanceid' => 'ocpfm8rdlc8j', 'passwordsalt' => '2DZunr7mrCiftXIyEDdibCiZ2TaU3I', 'secret' => 'PUNyeEtsig3mzIomNyLIF4F0ixdej4TyuhSGqthC0Uf1Mkeo', 'auth.bruteforce.protection.enabled' => false, 'ratelimit.protection.enabled' => true, 'auth.webauthn.enabled' => false, 'loglevel' => 0, 'loglevel_frontend' => 0, 'log_query' => true, 'trusted_domains' => array ( 0 => 'nextcloudportal.gary-springfield-mo.net', 1 => 'localhost:8181', ), 'datadirectory' => '/nextclouddata', 'dbtype' => 'mysql', 'version' => '26.0.1.1', 'overwrite.cli.url' => 'https://nextcloudportal.gary-springfield-mo.net', 'dbname' => 'nextcloud', 'dbhost' => 'localhost', 'dbport' => '', 'dbtableprefix' => 'oc_', 'mysql.utf8mb4' => true, 'dbuser' => 'oc_nextcloudadmi', 'dbpassword' => 'yx0/&/UvIqM]XmjqDj|ilbH1_LZx|/', 'installed' => true, 'maintenance' => false, ); Apache Reverse Proxy Config: irectory> SSLEngine on SSLProtocol +TLSv1.2 +TLSv1.3 SSLCipherSuite HIGH SSLHonorCipherOrder on SSLCipherSuite "EECDH+ECDSA+AESGCM EECDH+ECDSA+SHA384 !aNULL !eNULL !LOW !3DES !MD5 !EXP !PSK !SRP !DSS !RC4 !CBC !SHA256 !AES128" SSLCertificateFile /etc/ssl/certs/servercert.pem SSLCertificateKeyFile /etc/ssl/private/server.key SSLCACertificateFile /etc/ssl/certs/USERTrust_ECC_Certification_Authority.crt SSLVerifyClient optional ProxyPreserveHost on SSLProxyCheckPeerCN off SSLProxyCheckPeerExpire off SSLProxyCheckPeerName off SSLProxyEngine on ProxyVia on SSLProxyVerify none ProxyPass /nextcloud/ ! ProxyPassReverse /nextcloud/ ! ProxyPass /Autodiscover/ ! ProxyPassReverse /Autodiscover/ ! ProxyPass /autodiscover/ ! ProxyPassReverse /autodiscover/ ! ProxyPass /autodiscover/ ! ProxyPassReverse /autodiscover/ ! ProxyPass / https://localhost:8181/ ProxyPassReverse / https://localhost:8181/ LogLevel debug Nextcloud Apache virtual server config: DocumentRoot "/var/www/nextcloud" ServerName nextcloudportal.gary-springfield-mo.net Require all granted Options FollowSymlinks MultiViews AllowOverride All SSLEngine on SSLProtocol +TLSv1.2 +TLSv1.3 SSLCertificateFile /etc/ssl/certs/servercert.pem SSLCertificateKeyFile /etc/ssl/private/server.key SSLCACertificateFile /etc/ssl/certs/USERTrust_ECC_Certification_Authority.crt SSLVerifyClient optional LogLevel debug Nextcloud log file snippet {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT * FROM `*PREFIX*authtoken` WHERE (`token` = :dcValue1) AND (`version` = :dcValue2)' with parameters: dcValue1 => 'e926bc00911dd5f36f874d9fac0ca8844f7bfb4e42ab9b426a2751d55aa0edb0dfa5e30c72093c909046cb981711fcc18c5db3851fe6ca95de9e5554255dc0ec', dcValue2 => '2'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT * FROM `*PREFIX*authtoken` WHERE (`token` = :dcValue1) AND (`version` = :dcValue2)' with parameters: dcValue1 => '853aeea8b46b79981d5f5650abd662806f9f83c079c4bf4b9a5d5ac8459fe14767abefdbf4aad4e4ab93fe651e224561d7d724dd802367b97744819ea0eed201', dcValue2 => '2'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT COUNT(`uid`) FROM `*PREFIX*users`'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT `userid` FROM `*PREFIX*preferences` WHERE (`appid` = :dcValue1) AND (`configkey` = :dcValue2) AND (CAST(`configvalue` AS CHAR) = :dcValue3) ORDER BY `userid` ASC' with parameters: dcValue1 => 'core', dcValue2 => 'enabled', dcValue3 => 'false'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT COUNT(*) FROM `*PREFIX*preferences` WHERE (`appid` = :dcValue1) AND (`configkey` = :dcValue2)' with parameters: dcValue1 => 'login', dcValue2 => 'lastLogin'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT COUNT(*) FROM `*PREFIX*preferences` WHERE (`appid` = :dcValue1) AND (`configkey` = :dcValue2)' with parameters: dcValue1 => 'login', dcValue2 => 'lastLogin'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT `id`, `numeric_id`, `available`, `last_checked` FROM `*PREFIX*storages` WHERE `id` = :dcValue1' with parameters: dcValue1 => 'local::/nextclouddata/'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)' with parameters: dcValue1 => '2', dcValue2 => 'c987e512e69e9dfc75aa035e9b7d2e5d'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT `id`, `mimetype` FROM `*PREFIX*mimetypes`'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)' with parameters: dcValue1 => '2', dcValue2 => 'e5220e8dcddc6dd1ed923e5e7ec0d2e4'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"tIzbZWgkUotsZwvQgxOa","level":0,"time":"2023-05-07T21:10:13+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/login","message":"DB QueryBuilder: 'SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)' with parameters: dcValue1 => '2', dcValue2 => '66e92a6ad37d20298f162659a3c47e4c'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"fFjIGapz1Woaijui5zDB","level":0,"time":"2023-05-07T21:10:14+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/js/core/merged-template-prepend.js?v=8b7dde9d-0","message":"DB QueryBuilder: 'SELECT * FROM `*PREFIX*appconfig`'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"d8zPuwiSOFg9DTK9UI8y","level":0,"time":"2023-05-07T21:10:14+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/apps/theming/theme/default.css?plain=1&v=b6589fc6","message":"DB QueryBuilder: 'SELECT * FROM `*PREFIX*appconfig`'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"fFjIGapz1Woaijui5zDB","level":0,"time":"2023-05-07T21:10:14+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/js/core/merged-template-prepend.js?v=8b7dde9d-0","message":"DB QueryBuilder: 'SELECT `class`, `entity`, CAST(`events` AS CHAR) AS `events` FROM `*PREFIX*flow_operations` WHERE `events` <> :dcValue1 GROUP BY `class`, `entity`, CAST(`events` AS CHAR)' with parameters: dcValue1 => '[]'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"fFjIGapz1Woaijui5zDB","level":0,"time":"2023-05-07T21:10:14+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/js/core/merged-template-prepend.js?v=8b7dde9d-0","message":"DB QueryBuilder: 'SELECT * FROM `*PREFIX*authtoken` WHERE (`token` = :dcValue1) AND (`version` = :dcValue2)' with parameters: dcValue1 => 'e926bc00911dd5f36f874d9fac0ca8844f7bfb4e42ab9b426a2751d55aa0edb0dfa5e30c72093c909046cb981711fcc18c5db3851fe6ca95de9e5554255dc0ec', dcValue2 => '2'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"fFjIGapz1Woaijui5zDB","level":0,"time":"2023-05-07T21:10:14+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/js/core/merged-template-prepend.js?v=8b7dde9d-0","message":"DB QueryBuilder: 'SELECT * FROM `*PREFIX*authtoken` WHERE (`token` = :dcValue1) AND (`version` = :dcValue2)' with parameters: dcValue1 => '853aeea8b46b79981d5f5650abd662806f9f83c079c4bf4b9a5d5ac8459fe14767abefdbf4aad4e4ab93fe651e224561d7d724dd802367b97744819ea0eed201', dcValue2 => '2'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"jfncUBfyyTc3seEEzgPM","level":0,"time":"2023-05-07T21:10:14+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/apps/theming/theme/light.css?plain=1&v=b6589fc6","message":"DB QueryBuilder: 'SELECT * FROM `*PREFIX*appconfig`'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"d8zPuwiSOFg9DTK9UI8y","level":0,"time":"2023-05-07T21:10:14+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/apps/theming/theme/default.css?plain=1&v=b6589fc6","message":"DB QueryBuilder: 'SELECT `class`, `entity`, CAST(`events` AS CHAR) AS `events` FROM `*PREFIX*flow_operations` WHERE `events` <> :dcValue1 GROUP BY `class`, `entity`, CAST(`events` AS CHAR)' with parameters: dcValue1 => '[]'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}} {"reqId":"d8zPuwiSOFg9DTK9UI8y","level":0,"time":"2023-05-07T21:10:14+00:00","remoteAddr":"192.168.2.1","user":"--","app":"core","method":"GET","url":"/nextcloud/index.php/apps/theming/theme/default.css?plain=1&v=b6589fc6","message":"DB QueryBuilder: 'SELECT * FROM `*PREFIX*authtoken` WHERE (`token` = :dcValue1) AND (`version` = :dcValue2)' with parameters: dcValue1 => 'e926bc00911dd5f36f874d9fac0ca8844f7bfb4e42ab9b426a2751d55aa0edb0dfa5e30c72093c909046cb981711fcc18c5db3851fe6ca95de9e5554255dc0ec', dcValue2 => '2'","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.1.1","data":{"app":"core"}}
is important, it creates a “