Unable to log in after upgrade

NR9 · March 18, 2020, 4:51pm

Steps to reproduce

Attempt to log in via the web page, macOS app, or iOS app
Web page reports “Wrong password. Reset it?”

Expected behaviour

Tell us what should happen

Actual behaviour

Tell us what happens instead

Server configuration

Operating system: Univention VM appliance on ESXi

Web server:

Database:

PHP version:

ownCloud version: 10.3.2

Updated from an older ownCloud or fresh install: I updated via the admin page

Where did you install ownCloud from: Univision virtual appliance

Signing status (ownCloud 9.0 and above):

The requested URL was not found on this server.

The content of config/config.php:

Unable to login to generate config report. From a shell in the owncloud container (univention-app shell owncloud) there is no sudo, and "php occ config:list system" reports "PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104". "find . -name config.php" reports 5 different files so I'm not sure which one to post.

List of activated apps:

This also fails with "PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104"

Are you using external storage, if yes which one: No

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)

Also fails: "An unhandled exception has been thrown:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104"

Client configuration

Tried Safari, and Firefox both in incognito mode

Operating system: macOS 10.15.3, iOS 13.3.1

Logs

Web server error log

/var/log/apache2 is empty in the container, and I'm unable to find documentation as to where the logs are when using the Univention appliance. Can someone provide some guidance?

ownCloud log (data/owncloud.log)

The file is very large, but this last line appears relevant:
{"reqId":"ASzX08SVPGis3Yy1pLji","level":3,"time":"2020-03-18T16:38:34+00:00","remoteAddr":"","user":"--","app":"files","method":"--","url":"--","message":"Exception: {\"Exception\":\"OC\\\\ServerNotAvailableException\",\"Message\":\"Lost connection to LDAP server.\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/LDAP.php(295): OCA\\\\User_LDAP\\\\LDAP->postFunctionCall()\\n#1 \\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/LDAP.php(195): OCA\\\\User_LDAP\\\\LDAP->invokeLDAPMethod(*** sensitive parameters replaced ***)\\n#2 \\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/Access.php(269): OCA\\\\User_LDAP\\\\LDAP->read(Resource id #674, 'uid=greg,cn=use...', 'objectClass=*', Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/Access.php(207): OCA\\\\User_LDAP\\\\Access->executeRead(Resource id #674, 'uid=greg,cn=use...', Array, 'objectClass=*', 500)\\n#4 \\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/Group_LDAP.php(319): OCA\\\\User_LDAP\\\\Access->readAttribute('uid=greg,cn=use...', 'primarygroupid')\\n#5 \\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/Group_LDAP.php(343): OCA\\\\User_LDAP\\\\Group_LDAP->getEntryGroupID('uid=greg,cn=use...', 'primaryGroupID')\\n#6 \\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/Group_LDAP.php(426): OCA\\\\User_LDAP\\\\Group_LDAP->getUserPrimaryGroupIDs('uid=greg,cn=use...')\\n#7 \\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/Group_LDAP.php(463): OCA\\\\User_LDAP\\\\Group_LDAP->getUserPrimaryGroup('uid=greg,cn=use...')\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/Group_Proxy.php(122): OCA\\\\User_LDAP\\\\Group_LDAP->getUserGroups('greg')\\n#9 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Group\\\/Manager.php(321): OCA\\\\User_LDAP\\\\Group_Proxy->getUserGroups('greg')\\n#10 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Group\\\/Manager.php(275): OC\\\\Group\\\\Manager->getUserIdGroups('greg', 'sharing')\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Share20\\\/DefaultShareProvider.php(842): OC\\\\Group\\\\Manager->getUserGroups(Object(OC\\\\User\\\\User), 'sharing')\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Share20\\\/Manager.php(1303): OC\\\\Share20\\\\DefaultShareProvider->getAllSharedWith('greg', NULL)\\n#13 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_sharing\\\/lib\\\/MountProvider.php(72): OC\\\\Share20\\\\Manager->getAllSharedWith('greg', Array, NULL)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Config\\\/MountProviderCollection.php(80): OCA\\\\Files_Sharing\\\\MountProvider->getMountsForUser(Object(OC\\\\User\\\\User), Object(OC\\\\Files\\\\Storage\\\\StorageFactory))\\n#15 [internal function]: OC\\\\Files\\\\Config\\\\MountProviderCollection->OC\\\\Files\\\\Config\\\\{closure}(Object(OCA\\\\Files_Sharing\\\\MountProvider))\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Config\\\/MountProviderCollection.php(81): array_map(Object(Closure), Array)\\n#17 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Filesystem.php(446): OC\\\\Files\\\\Config\\\\MountProviderCollection->getMountsForUser(Object(OC\\\\User\\\\User))\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Filesystem.php(374): OC\\\\Files\\\\Filesystem::initMountPoints('greg')\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/util.php(298): OC\\\\Files\\\\Filesystem::init('greg', '\\\/greg\\\/files')\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Utils\\\/Scanner.php(101): OC_Util::setupFS('greg')\\n#21 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Utils\\\/Scanner.php(137): OC\\\\Files\\\\Utils\\\\Scanner->getMounts('')\\n#22 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files\\\/lib\\\/BackgroundJob\\\/ScanFiles.php(85): OC\\\\Files\\\\Utils\\\\Scanner->backgroundScan('')\\n#23 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files\\\/lib\\\/BackgroundJob\\\/ScanFiles.php(109): OCA\\\\Files\\\\BackgroundJob\\\\ScanFiles->runScanner(Object(OC\\\\User\\\\User))\\n#24 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/BackgroundJob\\\/Job.php(66): OCA\\\\Files\\\\BackgroundJob\\\\ScanFiles->run(NULL)\\n#25 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/BackgroundJob\\\/TimedJob.php(63): OC\\\\BackgroundJob\\\\Job->execute(Object(OC\\\\BackgroundJob\\\\JobList), Object(OC\\\\Log))\\n#26 \\\/var\\\/www\\\/owncloud\\\/core\\\/Command\\\/System\\\/Cron.php(125): OC\\\\BackgroundJob\\\\TimedJob->execute(Object(OC\\\\BackgroundJob\\\\JobList), Object(OC\\\\Log))\\n#27 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Command\\\/Command.php(255): OC\\\\Core\\\\Command\\\\System\\\\Cron->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#28 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(982): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#29 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(255): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\System\\\\Cron), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#30 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(148): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#31 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Console\\\/Application.php(165): Symfony\\\\Component\\\\Console\\\\Application->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#32 \\\/var\\\/www\\\/owncloud\\\/console.php(106): OC\\\\Console\\\\Application->run()\\n#33 \\\/var\\\/www\\\/owncloud\\\/occ(11): require_once('\\\/var\\\/www\\\/ownclo...')\\n#34 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/apps\\\/user_ldap\\\/lib\\\/LDAP.php\",\"Line\":334}"}

Browser log

chacho · March 18, 2020, 9:19pm

are you still in maintenance mode

NR9 · March 18, 2020, 10:00pm

Doesn’t appear that way – I’m not seeing a maintenance mode message. I backed up my files, and am restoring the VM from backups. Then I’ll copy the files back to resync. Then once things are settled I’ll take a snapshot and try the upgrade again. Very disconcerting.

eneubauer · March 19, 2020, 11:54am

You’re saying you did an upgrade, but I don’t see which version is your start version of ownCloud and your final version of ownCloud.

Usually the tables have a prefix so it should say owncloud.oc_appconfig, perhaps log in to your database and double check. Not sure how it should be on the appliance.