Owncloud docker exits with error (access deneid for user owncloud)

Mark · June 13, 2019, 1:09pm

Hello,

Recently i have tried to upgrade owncloud from 10.0.1 tot 10.1.1. But the upgrade has faild.
The owncloud docker is booting en exiting after boot.

When I start the docker of owncloud at the command line with:
docker start -a [docker ID]
I see the there is a error at connection to the database:
Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000} {1045] Access deneid for user 'owncloud'@'172.17.0.1

So that would be the problem of failing to start owncloud.

When I try to logon with the user owncloud and password that I remember it would not succeed.

I have tried to uninstall en reinstall owncloud from the Univention webUI, but that was no success.

What must I do to resolve this problem?
I have tried searching for this problem, but not found the right solution.

The Univention server version is 4.3-1 errata112

Mark

Moritz_Bunkus · June 20, 2019, 11:01am

First, check which credentials owncloud actually uses for the database connection. You can find them in owncloud’s config file: /var/lib/univention-appcenter/apps/owncloud/conf/config.php

Next, try connecting to the MySQL server as root with the password from /etc/mysql.secret:

mysql -u root -p$(< /etc/mysql.secret) mysql

If that works, great. Now make sure the database exists via show databases; If it does, continue by making sure the owncloud user actually exists:

select Host, User from user where User = 'owncloud';

This should list one entry with Host set to % (which means “from any IP address other that localhost”).

If the user exists: even better. Now simply reset the password back to what’s in config.php:

set password for 'owncloud'@'%' = password('<the value of dbpassword from config.php>');

Mark · June 21, 2019, 11:35pm

Found it

Succesfull login to MariaDB [mysql]

It listed 4 databases:
information_schema
mysql
owncloud
preformance_schema

Moritz_Bunkus:

If that works, great. Now make sure the database exists via show databases; If it does, continue by making sure the owncloud user actually exists:
select Host, User from user where User = 'owncloud';
This should list one entry with Host set to % (which means “from any IP address other that localhost”).

Moritz_Bunkus:

If the user exists: even better. Now simply reset the password back to what’s in config.php :
set password for 'owncloud'@'%' = password('<the value of dbpassword from config.php>');

Returns:
Host with % and User with owncloud.

Return:

Query OK, 0 rows affected (0.00 sec)

when I start the docker container of owncloud I now get the following ouput:

Administrator@ucs-1385:~$ sudo docker ps -a
CONTAINER ID        IMAGE                                                        COMMAND                  CREATED             STATUS                     PORTS               NAMES
fb465c8d304c        docker.software-univention.de/owncloud_appliance:10.0.10-1   "/usr/bin/entrypoi..."   3 months ago        Exited (1) 2 minutes ago                       ecstatic_keller
Administrator@ucs-1385:~$ sudo docker start fb465c8d304c -a
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
wait-for-it: waiting 180 seconds for 172.17.42.1:3306
wait-for-it: 172.17.42.1:3306 is available after 0 seconds
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing config perms...
Fixing file perms...
Fixing app perms...
Fixing session perms...
Fixing hook perms...
[29.LDAP.sh] Check if UCS data mount is there...
[29.LDAP.sh] Mount found, continuing...
[29.LDAP.sh] Folder declaration
[29.LDAP.sh] checking files folder...
Cecile
Elske
Extern_PC
Fleur
Jeroen
Jos
JoseOost
Karin
avatars
files_external
htaccesstest.txt
index.html
mark
owncloud
owncloud-appcenter.log
owncloud.log
owncloud.log.1
[29.LDAP.sh] no previous installation found
Upgrading server database...
An unhandled exception has been thrown:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('SELECT * FROM `...')
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM `...')
#2 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#3 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#4 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/owncloud/lib/private/AppConfig.php(301): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/owncloud/lib/private/AppConfig.php(80): OC\AppConfig->loadConfigValues()
#7 /var/www/owncloud/lib/private/AppConfig.php(278): OC\AppConfig->getApps()
#8 /var/www/owncloud/lib/private/legacy/app.php(1000): OC\AppConfig->getValues(false, 'installed_versi...')
#9 /var/www/owncloud/lib/private/Server.php(436): OC_App::getAppVersions()
#10 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#11 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('MemCacheFactory')
#12 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')
#13 /var/www/owncloud/lib/private/Server.php(1195): OC\ServerContainer->query('MemCacheFactory')
#14 /var/www/owncloud/lib/private/Server.php(593): OC\Server->getMemCacheFactory()
#15 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#16 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('AppManager')
#17 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#18 /var/www/owncloud/lib/private/Server.php(1411): OC\ServerContainer->query('AppManager')
#19 /var/www/owncloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#20 /var/www/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#21 /var/www/owncloud/lib/base.php(577): OC_App::loadApps(Array)
#22 /var/www/owncloud/lib/base.php(994): OC::init()
#23 /var/www/owncloud/console.php(64): require_once('/var/www/ownclo...')
#24 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#25 {main}

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM `...')
#1 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#2 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#3 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /var/www/owncloud/lib/private/AppConfig.php(301): OC\DB\QueryBuilder\QueryBuilder->execute()
#5 /var/www/owncloud/lib/private/AppConfig.php(80): OC\AppConfig->loadConfigValues()
#6 /var/www/owncloud/lib/private/AppConfig.php(278): OC\AppConfig->getApps()
#7 /var/www/owncloud/lib/private/legacy/app.php(1000): OC\AppConfig->getValues(false, 'installed_versi...')
#8 /var/www/owncloud/lib/private/Server.php(436): OC_App::getAppVersions()
#9 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#10 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('MemCacheFactory')
#11 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')
#12 /var/www/owncloud/lib/private/Server.php(1195): OC\ServerContainer->query('MemCacheFactory')
#13 /var/www/owncloud/lib/private/Server.php(593): OC\Server->getMemCacheFactory()
#14 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#15 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('AppManager')
#16 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#17 /var/www/owncloud/lib/private/Server.php(1411): OC\ServerContainer->query('AppManager')
#18 /var/www/owncloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#19 /var/www/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#20 /var/www/owncloud/lib/base.php(577): OC_App::loadApps(Array)
#21 /var/www/owncloud/lib/base.php(994): OC::init()
#22 /var/www/owncloud/console.php(64): require_once('/var/www/ownclo...')
#23 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#24 {main}

Next Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT * FROM `oc_appconfig`':

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT * FROM `...', Array)
#2 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#3 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#4 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/owncloud/lib/private/AppConfig.php(301): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/owncloud/lib/private/AppConfig.php(80): OC\AppConfig->loadConfigValues()
#7 /var/www/owncloud/lib/private/AppConfig.php(278): OC\AppConfig->getApps()
#8 /var/www/owncloud/lib/private/legacy/app.php(1000): OC\AppConfig->getValues(false, 'installed_versi...')
#9 /var/www/owncloud/lib/private/Server.php(436): OC_App::getAppVersions()
#10 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#11 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('MemCacheFactory')
#12 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')
#13 /var/www/owncloud/lib/private/Server.php(1195): OC\ServerContainer->query('MemCacheFactory')
#14 /var/www/owncloud/lib/private/Server.php(593): OC\Server->getMemCacheFactory()
#15 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#16 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('AppManager')
#17 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#18 /var/www/owncloud/lib/private/Server.php(1411): OC\ServerContainer->query('AppManager')
#19 /var/www/owncloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#20 /var/www/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#21 /var/www/owncloud/lib/base.php(577): OC_App::loadApps(Array)
#22 /var/www/owncloud/lib/base.php(994): OC::init()
#23 /var/www/owncloud/console.php(64): require_once('/var/www/ownclo...')
#24 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#25 {main}Touching log file...
dpkg: error: --compare-versions takes three arguments: <version> <relation> <version>

Type dpkg --help for help about installing and deinstalling packages [*];
Use 'apt' or 'aptitude' for user-friendly package management;
Type dpkg -Dhelp for a list of dpkg debug flag values;
Type dpkg --force-help for a list of forcing options;
Type dpkg-deb --help for help about manipulating *.deb files;

Options marked [*] produce a lot of output - pipe it through 'less' or 'more' !
Writing objectstore config...
Writing php config...
dpkg: error: --compare-versions takes three arguments: <version> <relation> <version>

Type dpkg --help for help about installing and deinstalling packages [*];
Use 'apt' or 'aptitude' for user-friendly package management;
Type dpkg -Dhelp for a list of dpkg debug flag values;
Type dpkg --force-help for a list of forcing options;
Type dpkg-deb --help for help about manipulating *.deb files;

Options marked [*] produce a lot of output - pipe it through 'less' or 'more' !
Writing apache config...
Enabling cron background...
An unhandled exception has been thrown:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('SELECT * FROM `...')
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM `...')
#2 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#3 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#4 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/owncloud/lib/private/AppConfig.php(301): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/owncloud/lib/private/AppConfig.php(80): OC\AppConfig->loadConfigValues()
#7 /var/www/owncloud/lib/private/AppConfig.php(278): OC\AppConfig->getApps()
#8 /var/www/owncloud/lib/private/legacy/app.php(1000): OC\AppConfig->getValues(false, 'installed_versi...')
#9 /var/www/owncloud/lib/private/Server.php(436): OC_App::getAppVersions()
#10 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#11 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('MemCacheFactory')
#12 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')
#13 /var/www/owncloud/lib/private/Server.php(1195): OC\ServerContainer->query('MemCacheFactory')
#14 /var/www/owncloud/lib/private/Server.php(593): OC\Server->getMemCacheFactory()
#15 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#16 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('AppManager')
#17 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#18 /var/www/owncloud/lib/private/Server.php(1411): OC\ServerContainer->query('AppManager')
#19 /var/www/owncloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#20 /var/www/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#21 /var/www/owncloud/lib/base.php(577): OC_App::loadApps(Array)
#22 /var/www/owncloud/lib/base.php(994): OC::init()
#23 /var/www/owncloud/console.php(64): require_once('/var/www/ownclo...')
#24 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#25 {main}

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM `...')
#1 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#2 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#3 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /var/www/owncloud/lib/private/AppConfig.php(301): OC\DB\QueryBuilder\QueryBuilder->execute()
#5 /var/www/owncloud/lib/private/AppConfig.php(80): OC\AppConfig->loadConfigValues()
#6 /var/www/owncloud/lib/private/AppConfig.php(278): OC\AppConfig->getApps()
#7 /var/www/owncloud/lib/private/legacy/app.php(1000): OC\AppConfig->getValues(false, 'installed_versi...')
#8 /var/www/owncloud/lib/private/Server.php(436): OC_App::getAppVersions()
#9 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#10 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('MemCacheFactory')
#11 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')
#12 /var/www/owncloud/lib/private/Server.php(1195): OC\ServerContainer->query('MemCacheFactory')
#13 /var/www/owncloud/lib/private/Server.php(593): OC\Server->getMemCacheFactory()
#14 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#15 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('AppManager')
#16 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#17 /var/www/owncloud/lib/private/Server.php(1411): OC\ServerContainer->query('AppManager')
#18 /var/www/owncloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#19 /var/www/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#20 /var/www/owncloud/lib/base.php(577): OC_App::loadApps(Array)
#21 /var/www/owncloud/lib/base.php(994): OC::init()
#22 /var/www/owncloud/console.php(64): require_once('/var/www/ownclo...')
#23 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#24 {main}

Next Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT * FROM `oc_appconfig`':

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT * FROM `...', Array)
#2 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#3 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#4 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/owncloud/lib/private/AppConfig.php(301): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/owncloud/lib/private/AppConfig.php(80): OC\AppConfig->loadConfigValues()
#7 /var/www/owncloud/lib/private/AppConfig.php(278): OC\AppConfig->getApps()
#8 /var/www/owncloud/lib/private/legacy/app.php(1000): OC\AppConfig->getValues(false, 'installed_versi...')
#9 /var/www/owncloud/lib/private/Server.php(436): OC_App::getAppVersions()
#10 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#11 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('MemCacheFactory')
#12 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')
#13 /var/www/owncloud/lib/private/Server.php(1195): OC\ServerContainer->query('MemCacheFactory')
#14 /var/www/owncloud/lib/private/Server.php(593): OC\Server->getMemCacheFactory()
#15 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#16 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet('AppManager')
#17 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#18 /var/www/owncloud/lib/private/Server.php(1411): OC\ServerContainer->query('AppManager')
#19 /var/www/owncloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#20 /var/www/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#21 /var/www/owncloud/lib/base.php(577): OC_App::loadApps(Array)
#22 /var/www/owncloud/lib/base.php(994): OC::init()
#23 /var/www/owncloud/console.php(64): require_once('/var/www/ownclo...')
#24 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#25 {main}Administrator@ucs-1385:~$

And then it exited.

What I could unterstand from this lines is dat my database is not oke. It is missing tabels or content.

How to repair this problem

Mark

Moritz_Bunkus · June 23, 2019, 3:51pm

Alright, let’s take a look at the DB’s content. First, start the MySQL client again, then post the result of the second line (to be run inside the MySQL client):

# In the shell:
mysql -u root -p$(< /etc/mysql.secret) owncloud
# In the mysql client:
show tables;

Mark · June 25, 2019, 12:55am

Here the result of

0001

Mark

Moritz_Bunkus · June 25, 2019, 8:22am

You connected to the mysql database instead of the owncloud database. Therefore your screenshot shows the tables in the database named mysql.

Either run the mysql command like I said above (mysql -u root -p$(< /etc/mysql.secret) owncloud), or once you’re in the MySQL shell connect to owncloud with the command use owncloud; before running show tables;.

Mark · June 25, 2019, 8:48am

You are right. Did make a type mistake.

Owncloud table is empty. It only shows:

Empy set (0.00 sec)

00001

Moritz_Bunkus · June 25, 2019, 8:51am

That’s obviously not good, but at least we know what’s wrong. Looks like something went seriously wrong during the upgrade, leaving you without your data.

You’ll have to restore that database from backups. Hopefully a dump was created by the upgrade process in /var/lib/univention-appcenter/apps/owncloud/data/backup or /var/lib/univention-appcenter/apps/owncloud/data/backups (I have one in both directories for some reason).

Mark · June 25, 2019, 9:35am

Both

/var/lib/univention-appcenter/apps/owncloud/data/backup

and

/var/lib/univention-appcenter/apps/owncloud/data/backups

contains a databse.sql file.
00003

This file should contain a dump of the database witch is made at the upgrade?

Moritz_Bunkus · June 25, 2019, 9:59am

Which one is newer? Post the output of ls -l database.sql for both files, please.

Mark · June 25, 2019, 10:04am

00004

The backup folder is newer. But it is not the date of when I did the upgrade.

Moritz_Bunkus · June 25, 2019, 10:09am

The one from backups is waaaaay too old. That being said, the one from backup isn’t exactly fresh either file’s date doesn’t look too fresh, either (what does mrt stand for in your language? March?). Do you have other, more recent backups of the database? If so, use those.

If you really don’t have recent backups from the database, you can use the one from the backup directory:

mysql -u root -p$(< /etc/mysql.secret) owncloud < /var/lib/univention-appcenter/apps/owncloud/data/backup/database.sql

That should restore the content of said file into the owncloud database.

Mark · June 25, 2019, 11:00am

mrt is Indeed March.

I did execuut the following line:

mysql -u root -p$(< /etc/mysql.secret) owncloud < /var/lib/univention-appcenter/apps/owncloud/data/backup/database.sql

There was no error giving back
00005

Moritz_Bunkus · June 25, 2019, 11:35am

In this case no output means success.

Mark · June 25, 2019, 11:45am

Ok. That sound good.

Should I now restart the server?

Moritz_Bunkus · June 25, 2019, 11:46am

Restarting the Docker container should suffice.

Mark · June 25, 2019, 12:18pm

After reboot of the server

00006

Docker still exited

Start the docker with

 docker start -a [docker ID]

00007

Keeps hanging.

Mark · July 7, 2019, 8:08am

Just a update.

I have give up to recover the old installation of univention with Owncloud. I have created a new fresh installation and installed owncloud with alll updates.
After this was done, I moved all the files to the new server.

Then I let the clients connect to the new server a sync the file back to the server.

I use the server as a privet cloud and chared it with 5 other friends.

Thanks for the help.

Mark