Cannot Get Android App to Login

Android
#1

Actual behaviour

I have OC 10.9.1.2 running on Ubuntu Bionic with apache2.
The configuration includes Redis caching.
It has been working fine for a very long time with TOTP 2nd factor authorisation.
I wanted to go mobile so I installed OAuth2 on the server and the Android app on my phone … running Android 10.
Running the app, I entered my credentials ant the TOTP 6 digit code and was presented with the ‘Authorise’ screen. I then get presented with the initial screen saying “Wrog Username or Password”

Expected behaviour

  • Tell us what should happen
    The android app should be allowed to login and show whatever it shows (never got that far)

Steps to reproduce

  1. On an OC installation with TOTP previously setup install Oauth2
  2. Install owncloud android app on Android 10
  3. Follow the instructions on the android app by entering username/password… TOTP code, authorise app access as requested.

Can this problem be reproduced with the official owncloud server?
(url: https://demo.owncloud.org, user: test, password: test)
No but the test server does not have TOTP

Environment data

Android version: 10

Device model: Moto G8 Plus

Stock or customized system: Stock

ownCloud app version: 2.20

ownCloud server version: 10.9.1.2

Logs

Web server error log

Insert your webserver log here

x.x.x.x - - [14/Mar/2022:12:08:11 +0000] “POST /index.php/apps/oauth2/authorize?redirect_uri=oc%3A%2F%2Fandroid.owncloud.com&client_id=e4rAsNUSIUs0lF4nbv9FmCeUkTlV9GdgTLDH1b5uie7syb90SzEVrbN7HIpmWJeD&response_type=code&scope=&code_challenge=Jtp6lN9lAOS3GGFaDaIUDzMyQFlVZcUa87B-HilH4UQ&code_challenge_method=S256&state=SO5YnNKeFr-aV3p13DPM HTTP/1.1” 303 920 “-” “Mozilla/5.0 (Linux; Android 10; moto g(8) plus) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.58 Mobile Safari/537.36”
x.x.x.x - e4rAsNUSIUs0lF4nbv9FmCeUkTlV9GdgTLDH1b5uie7syb90SzEVrbN7HIpmWJeD [14/Mar/2022:12:08:11 +0000] “POST /index.php/apps/oauth2/api/v1/token HTTP/1.1” 200 1689 “-” “Mozilla/5.0 (Android) ownCloud-android/2.20”
x.x.x.x - - [14/Mar/2022:12:08:11 +0000] “PROPFIND /remote.php/dav/files/ HTTP/1.1” 401 1869 “-” “Mozilla/5.0 (Android) ownCloud-android/2.20”
x.x.x.x - - [14/Mar/2022:12:08:12 +0000] “PROPFIND /remote.php/dav/files/ HTTP/1.1” 401 1293 “-” “Mozilla/5.0 (Android) ownCloud-android/2.20”
x.x.x.x - - [14/Mar/2022:12:08:12 +0000] “PROPFIND /remote.php/dav/files/ HTTP/1.1” 401 1869 “-” “Mozilla/5.0 (Android) ownCloud-android/2.20”
x.x.x.x - - [14/Mar/2022:12:08:12 +0000] “GET /ocs/v2.php/apps/notifications/api/v1/notifications?format=json HTTP/1.1” 200 1512 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36”
x.x.x.x - - [14/Mar/2022:12:08:12 +0000] “PROPFIND /remote.php/dav/files/ HTTP/1.1” 401 1869 “-” “Mozilla/5.0 (Android) ownCloud-android/2.20”
x.x.x.x - - [14/Mar/2022:12:08:13 +0000] “PROPFIND /remote.php/dav/files/ HTTP/1.1” 401 1869 “-” “Mozilla/5.0 (Android) ownCloud-android/2.20”

ownCloud log (data/owncloud.log)


Insert your ownCloud log here
{"reqId":"8kbzJkqKyuoupwYFKmTL","level":3,"time":"2022-03-11T15:19:07+00:00","remoteAddr":"x.x.x.x","user":"--","app":"index","method":"GET","url":"\/index.php","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\TableNotFoundException\",\"Message\":\"An exception occurred while executing 'SELECT * FROM `oc_appconfig`':\\n\\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(182): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException()\\n#1 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(159): Doctrine\\\\DBAL\\\\DBALException::wrapException()\\n#2 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(2225): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery()\\n#3 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1312): Doctrine\\\\DBAL\\\\Connection->handleExceptionDuringQuery()\\n#4 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/Connection.php(191): Doctrine\\\\DBAL\\\\Connection->executeQuery()\\n#5 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(212): OC\\\\DB\\\\Connection->executeQuery()\\n#6 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(312): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#8 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(80): OC\\\\AppConfig->loadConfigValues()\\n#9 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(289): OC\\\\AppConfig->getApps()\\n#10 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(133): OC\\\\AppConfig->getValues()\\n#11 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(154): OC\\\\App\\\\AppManager->getInstalledAppsValues()\\n#12 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(352): OC\\\\App\\\\AppManager->getInstalledApps()\\n#13 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(108): OC_App::getEnabledApps()\\n#14 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(590): OC_App::loadApps()\\n#15 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(1070): OC::init()\\n#16 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/index.php(53): require_once('\\\/var\\\/www\\\/html\\\/c...')\\n#17 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":61}"}
{"reqId":"8kbzJkqKyuoupwYFKmTL","level":3,"time":"2022-03-11T15:19:07+00:00","remoteAddr":"x.x.x.x","user":"--","app":"index","method":"GET","url":"\/index.php","message":"Caused by: {\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":\"42S02\",\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOConnection.php(143): Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception::new()\\n#1 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOQueryImplementation.php(38): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->doQuery()\\n#2 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1308): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->query()\\n#3 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/Connection.php(191): Doctrine\\\\DBAL\\\\Connection->executeQuery()\\n#4 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(212): OC\\\\DB\\\\Connection->executeQuery()\\n#5 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(312): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(80): OC\\\\AppConfig->loadConfigValues()\\n#8 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(289): OC\\\\AppConfig->getApps()\\n#9 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(133): OC\\\\AppConfig->getValues()\\n#10 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(154): OC\\\\App\\\\AppManager->getInstalledAppsValues()\\n#11 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(352): OC\\\\App\\\\AppManager->getInstalledApps()\\n#12 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(108): OC_App::getEnabledApps()\\n#13 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(590): OC_App::loadApps()\\n#14 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(1070): OC::init()\\n#15 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/index.php(53): require_once('\\\/var\\\/www\\\/html\\\/c...')\\n#16 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDO\\\/Exception.php\",\"Line\":18}"}
{"reqId":"8kbzJkqKyuoupwYFKmTL","level":3,"time":"2022-03-11T15:19:07+00:00","remoteAddr":"x.x.x.x","user":"--","app":"index","method":"GET","url":"\/index.php","message":"Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":\"42S02\",\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOConnection.php(141): PDO->query()\\n#1 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOQueryImplementation.php(38): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->doQuery()\\n#2 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1308): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->query()\\n#3 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/Connection.php(191): Doctrine\\\\DBAL\\\\Connection->executeQuery()\\n#4 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(212): OC\\\\DB\\\\Connection->executeQuery()\\n#5 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(312): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(80): OC\\\\AppConfig->loadConfigValues()\\n#8 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(289): OC\\\\AppConfig->getApps()\\n#9 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(133): OC\\\\AppConfig->getValues()\\n#10 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(154): OC\\\\App\\\\AppManager->getInstalledAppsValues()\\n#11 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(352): OC\\\\App\\\\AppManager->getInstalledApps()\\n#12 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(108): OC_App::getEnabledApps()\\n#13 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(590): OC_App::loadApps()\\n#14 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(1070): OC::init()\\n#15 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/index.php(53): require_once('\\\/var\\\/www\\\/html\\\/c...')\\n#16 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOConnection.php\",\"Line\":141}"}
{"reqId":"8kbzJkqKyuoupwYFKmTL","level":3,"time":"2022-03-11T15:19:07+00:00","remoteAddr":"x.x.x.x","user":"--","app":"core","method":"GET","url":"\/index.php","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\TableNotFoundException\",\"Message\":\"An exception occurred while executing 'SELECT * FROM `oc_appconfig`':\\n\\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(182): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException()\\n#1 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(159): Doctrine\\\\DBAL\\\\DBALException::wrapException()\\n#2 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(2225): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery()\\n#3 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1312): Doctrine\\\\DBAL\\\\Connection->handleExceptionDuringQuery()\\n#4 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/Connection.php(191): Doctrine\\\\DBAL\\\\Connection->executeQuery()\\n#5 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(212): OC\\\\DB\\\\Connection->executeQuery()\\n#6 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(312): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#8 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(80): OC\\\\AppConfig->loadConfigValues()\\n#9 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(289): OC\\\\AppConfig->getApps()\\n#10 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(133): OC\\\\AppConfig->getValues()\\n#11 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(154): OC\\\\App\\\\AppManager->getInstalledAppsValues()\\n#12 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(352): OC\\\\App\\\\AppManager->getInstalledApps()\\n#13 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(108): OC_App::getEnabledApps()\\n#14 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(590): OC_App::loadApps()\\n#15 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(1070): OC::init()\\n#16 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/index.php(53): require_once('\\\/var\\\/www\\\/html\\\/c...')\\n#17 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":61}"}
{"reqId":"8kbzJkqKyuoupwYFKmTL","level":3,"time":"2022-03-11T15:19:07+00:00","remoteAddr":"x.x.x.x","user":"--","app":"core","method":"GET","url":"\/index.php","message":"Caused by: {\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":\"42S02\",\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOConnection.php(143): Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception::new()\\n#1 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOQueryImplementation.php(38): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->doQuery()\\n#2 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1308): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->query()\\n#3 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/Connection.php(191): Doctrine\\\\DBAL\\\\Connection->executeQuery()\\n#4 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(212): OC\\\\DB\\\\Connection->executeQuery()\\n#5 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(312): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(80): OC\\\\AppConfig->loadConfigValues()\\n#8 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(289): OC\\\\AppConfig->getApps()\\n#9 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(133): OC\\\\AppConfig->getValues()\\n#10 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(154): OC\\\\App\\\\AppManager->getInstalledAppsValues()\\n#11 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(352): OC\\\\App\\\\AppManager->getInstalledApps()\\n#12 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(108): OC_App::getEnabledApps()\\n#13 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(590): OC_App::loadApps()\\n#14 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(1070): OC::init()\\n#15 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/index.php(53): require_once('\\\/var\\\/www\\\/html\\\/c...')\\n#16 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDO\\\/Exception.php\",\"Line\":18}"}
{"reqId":"8kbzJkqKyuoupwYFKmTL","level":3,"time":"2022-03-11T15:19:07+00:00","remoteAddr":"x.x.x.x","user":"--","app":"core","method":"GET","url":"\/index.php","message":"Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":\"42S02\",\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOConnection.php(141): PDO->query()\\n#1 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOQueryImplementation.php(38): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->doQuery()\\n#2 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1308): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->query()\\n#3 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/Connection.php(191): Doctrine\\\\DBAL\\\\Connection->executeQuery()\\n#4 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(212): OC\\\\DB\\\\Connection->executeQuery()\\n#5 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(312): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(80): OC\\\\AppConfig->loadConfigValues()\\n#8 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(289): OC\\\\AppConfig->getApps()\\n#9 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(133): OC\\\\AppConfig->getValues()\\n#10 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/App\\\/AppManager.php(154): OC\\\\App\\\\AppManager->getInstalledAppsValues()\\n#11 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(352): OC\\\\App\\\\AppManager->getInstalledApps()\\n#12 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/app.php(108): OC_App::getEnabledApps()\\n#13 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(590): OC_App::loadApps()\\n#14 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/base.php(1070): OC::init()\\n#15 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/index.php(53): require_once('\\\/var\\\/www\\\/html\\\/c...')\\n#16 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOConnection.php\",\"Line\":141}"}
{"reqId":"8kbzJkqKyuoupwYFKmTL","level":3,"time":"2022-03-11T15:19:07+00:00","remoteAddr":"x.x.x.x","user":"--","app":"core","method":"GET","url":"\/index.php","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\TableNotFoundException\",\"Message\":\"An exception occurred while executing 'SELECT * FROM `oc_appconfig`':\\n\\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(182): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException()\\n#1 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(159): Doctrine\\\\DBAL\\\\DBALException::wrapException()\\n#2 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(2225): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery()\\n#3 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1312): Doctrine\\\\DBAL\\\\Connection->handleExceptionDuringQuery()\\n#4 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/Connection.php(191): Doctrine\\\\DBAL\\\\Connection->executeQuery()\\n#5 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(212): OC\\\\DB\\\\Connection->executeQuery()\\n#6 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(312): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#8 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(122): OC\\\\AppConfig->loadConfigValues()\\n#9 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AllConfig.php(185): OC\\\\AppConfig->getValue()\\n#10 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/util.php(542): OC\\\\AllConfig->getAppValue()\\n#11 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/util.php(461): OC_Util::loadVersion()\\n#12 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/public\\\/Util.php(75): OC_Util::getVersion()\\n#13 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/defaults.php(61): OCP\\\\Util::getVersion()\\n#14 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/template.php(97): OC_Defaults->__construct()\\n#15 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/template.php(373): OC_Template->__construct()\\n#16 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/index.php(76): OC_Template::printExceptionErrorPage()\\n#17 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":61}"}
{"reqId":"8kbzJkqKyuoupwYFKmTL","level":3,"time":"2022-03-11T15:19:07+00:00","remoteAddr":"x.x.x.x","user":"--","app":"core","method":"GET","url":"\/index.php","message":"Caused by: {\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":\"42S02\",\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOConnection.php(143): Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception::new()\\n#1 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOQueryImplementation.php(38): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->doQuery()\\n#2 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1308): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->query()\\n#3 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/Connection.php(191): Doctrine\\\\DBAL\\\\Connection->executeQuery()\\n#4 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(212): OC\\\\DB\\\\Connection->executeQuery()\\n#5 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(312): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(122): OC\\\\AppConfig->loadConfigValues()\\n#8 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AllConfig.php(185): OC\\\\AppConfig->getValue()\\n#9 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/util.php(542): OC\\\\AllConfig->getAppValue()\\n#10 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/util.php(461): OC_Util::loadVersion()\\n#11 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/public\\\/Util.php(75): OC_Util::getVersion()\\n#12 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/defaults.php(61): OCP\\\\Util::getVersion()\\n#13 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/template.php(97): OC_Defaults->__construct()\\n#14 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/template.php(373): OC_Template->__construct()\\n#15 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/index.php(76): OC_Template::printExceptionErrorPage()\\n#16 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDO\\\/Exception.php\",\"Line\":18}"}
{"reqId":"8kbzJkqKyuoupwYFKmTL","level":3,"time":"2022-03-11T15:19:07+00:00","remoteAddr":"x.x.x.x","user":"--","app":"core","method":"GET","url":"\/index.php","message":"Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":\"42S02\",\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOConnection.php(141): PDO->query()\\n#1 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOQueryImplementation.php(38): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->doQuery()\\n#2 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1308): Doctrine\\\\DBAL\\\\Driver\\\\PDOConnection->query()\\n#3 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/Connection.php(191): Doctrine\\\\DBAL\\\\Connection->executeQuery()\\n#4 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(212): OC\\\\DB\\\\Connection->executeQuery()\\n#5 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(312): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AppConfig.php(122): OC\\\\AppConfig->loadConfigValues()\\n#8 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/AllConfig.php(185): OC\\\\AppConfig->getValue()\\n#9 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/util.php(542): OC\\\\AllConfig->getAppValue()\\n#10 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/util.php(461): OC_Util::loadVersion()\\n#11 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/public\\\/Util.php(75): OC_Util::getVersion()\\n#12 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/defaults.php(61): OCP\\\\Util::getVersion()\\n#13 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/template.php(97): OC_Defaults->__construct()\\n#14 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/private\\\/legacy\\\/template.php(373): OC_Template->__construct()\\n#15 \\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/index.php(76): OC_Template::printExceptionErrorPage()\\n#16 {main}\",\"File\":\"\\\/var\\\/www\\\/html\\\/cloud.myserver.net\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOConnection.php\",\"Line\":141}"}
{
#2

Subsequently, the table oc_appconfig does exist in the owncloud database
Also, ‘Android’ is shown as an authorised application in my user security settings

mysql> select * from owncloud.oc_appconfig;
±-----------------------±--------------------------±--------------------------------+
| appid | configkey | configvalue |
±-----------------------±--------------------------±--------------------------------+
| activity | enabled | yes |
| activity | installed_version | 2.7.0 |
| activity | signed | true |
| activity | types | filesystem |
| backgroundjob | lastjob | 21 |
| brute_force_protection | enabled | yes |
| brute_force_protection | installed_version | 1.1.0 |
| brute_force_protection | signed | true |
| brute_force_protection | types | prelogin |
| calendar | enabled | yes |
| calendar | installed_version | 1.6.4 |
| calendar | signed | true |
| calendar | types | |
| comments | enabled | yes |
| comments | installed_version | 0.3.0 |
| comments | types | logging,dav |
| configreport | enabled | yes |
| configreport | installed_version | 0.2.0 |
| configreport | types | filesystem |
| core | backgroundjobs_mode | cron |
| core | enable_external_storage | yes |
| core | first_install_version | 10.9.1.2 |
| core | installedat | 1647012611.4124 |
| core | lastcron | 1647267306 |
| core | lastupdateResult | [] |
| core | lastupdatedat | 1647267354 |
| core | oc.integritycheck.checker | [] |
| core | public_files | files_sharing/public.php |
| core | public_webdav | dav/appinfo/v1/publicwebdav.php |
| dav | enabled | yes |
| dav | installed_version | 0.7.0 |
| dav | types | filesystem |
| drawio | enabled | yes |
| drawio | installed_version | 0.0.9 |
| drawio | signed | true |
| drawio | types | |
| federatedfilesharing | enabled | yes |
| federatedfilesharing | installed_version | 0.5.0 |
| federatedfilesharing | types | filesystem |
| federation | enabled | yes |
| federation | installed_version | 0.1.0 |
| federation | types | authentication |
| files | cronjob_scan_files | 500 |
| files | enabled | yes |
| files | installed_version | 1.5.2 |
| files | types | filesystem |
| files_external | enabled | yes |
| files_external | installed_version | 0.8.0 |
| files_external | types | filesystem |
| files_mediaviewer | enabled | yes |
| files_mediaviewer | installed_version | 1.0.5 |
| files_mediaviewer | types | |
| files_pdfviewer | enabled | yes |
| files_pdfviewer | installed_version | 1.0.1 |
| files_pdfviewer | types | |
| files_sharing | enabled | yes |
| files_sharing | installed_version | 0.14.0 |
| files_sharing | types | filesystem |
| files_texteditor | enabled | yes |
| files_texteditor | installed_version | 2.4.1 |
| files_texteditor | types | |
| files_textviewer | enabled | yes |
| files_textviewer | installed_version | 1.0.3 |
| files_textviewer | signed | true |
| files_textviewer | types | |
| files_trashbin | enabled | yes |
| files_trashbin | installed_version | 0.9.1 |
| files_trashbin | types | filesystem |
| files_versions | enabled | yes |
| files_versions | installed_version | 1.3.0 |
| files_versions | types | filesystem |
| firstrunwizard | enabled | yes |
| firstrunwizard | installed_version | 1.2.0 |
| firstrunwizard | types | |
| gallery | enabled | yes |
| gallery | installed_version | 16.1.2 |
| gallery | signed | true |
| gallery | types | |
| market | enabled | yes |
| market | installed_version | 0.6.3 |
| market | signed | true |
| market | types | |
| music | enabled | yes |
| music | installed_version | 1.5.1 |
| music | signed | true |
| music | types | filesystem |
| notifications | enabled | yes |
| notifications | installed_version | 0.5.4 |
| notifications | types | logging |
| oauth2 | enabled | yes |
| oauth2 | installed_version | 0.5.2 |
| oauth2 | signed | true |
| oauth2 | types | authentication |
| provisioning_api | enabled | yes |
| provisioning_api | installed_version | 0.5.0 |
| provisioning_api | types | prevent_group_restriction |
| systemtags | enabled | yes |
| systemtags | installed_version | 0.3.0 |
| systemtags | types | logging |
| templateeditor | enabled | yes |
| templateeditor | installed_version | 0.4.0 |
| templateeditor | types | |
| twofactor_totp | enabled | yes |
| twofactor_totp | installed_version | 0.7.4 |
| twofactor_totp | signed | true |
| twofactor_totp | types | |
| updatenotification | enabled | yes |
| updatenotification | installed_version | 0.2.1 |
| updatenotification | types | |
±-----------------------±--------------------------±--------------------------------+
109 rows in set (0.00 sec)

#3

Any help anyone?

I would like to get this resolved as soon as possible

#4

BUMP.

Has anyone got any suggestions on how to fix this?

#5

Settings > Security (personal) > App Token > Generate one and use that as your password.

1 Like
#6
  • What’s the version of the oauth app?
  • Do you have redis properly set up?

I think with oAuth enabled it is also generally recommended to use Redis for session management:

#7

No, this didn’t work.
Created App password for ‘Android’ “Wrong username or password”

#8

oauth is whatever the current market version is which i think is 0.5.2
Android app is version 2.20

Redis is set up as per the owncloud installation notes
‘memcache.local’ => ‘\OC\Memcache\Redis’,
‘redis’ =>
array (
‘host’ => ‘localhost’,
‘port’ => 6379,
),
‘memcache.locking’ => ‘\OC\Memcache\Redis’,

Telnetting to port 6379 allows you to execute Redis commands at it seems to be working.

Added " redis.session.locking_enabled = 1" to end of php.ini in /etc/php/7.4/apache2/php.ini

Still not working even after re-installing the android app and restarting the server.

On the server, in ‘Security’ for the user, ‘Android’ is shown as an Oauth 2 authorised application.

The android app sees the server, lets me authorise the android app but returns “wrong username or password”

#9

And so the owncloud server log has this in it… (I substituted MY_SERVER into my server’s URL)

Invalid OAuth request with invalid redirect_uri: oc://android.owncloud.com !== oc://android.cloud.MY_SERVER.net"}

Updating the Android settings using occ udo -u www-data ./occ oauth2:modify-client Android redirect-url oc://android.cloud.MY_SERVER.net changes the response on the Android app to “Request not valid Please contact the administrator of ‘Android’ if this error persists”

Which it does.

#10

session.save_handler set to redis .

How do I set that properly?

#11

Redis will not work. Totally removed it and now using APCu
Still no joy

#12

So… completely fresh install
Did not install Oauth2 but instead used app password as suggested by @joerg.giencke above
All works fine

So why bother with Oauth2?

#13

This works on our server:

config.php

'filelocking.enabled' => 'true',
'memcache.local' => '\\OC\\Memcache\\APCu',
'memcache.distributed' => '\\OC\\Memcache\\Redis',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' => [
  'host' => 'localhost',
  'port' => 6379,
  'timeout' => 0
],

phpinfo()

image
image955×1118 53.2 KB

#14

Brilliant, that works for me too. though I have memcache.local set as redis

Thanks for your help

#15

Glad I could help.

Quote from the ownCloud documentation:

“APCu is faster at local caching than Redis. If you have enough memory, use APCu for memory caching and Redis for file locking. If you are low on memory, use Redis for both.”

1 Like