Upgrade 0.27 issue with Owncloud

tribeoflevi · June 16, 2018, 9:39pm

I’ve upgraded MIAB loads of times but cannot resolve the following error. I’ve restored my data from backup and when I re-run ‘sudo mailinabox’ I get the following error, which is the same as the original error. The backup is from version 0.26 and I’m trying to restore to 0.27 if that makes any difference.

Installing Nextcloud (contacts/calendar)…

FAILED: sudo -u www-data php /usr/local/lib/owncloud/console.php app:disable firstrunwizard

An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [14] unable to open database file in /usr/local/lib/owncloud/lib/private/DB/Connection.php:61
Stack trace:
#0 /usr/local/lib/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(992): OC\DB\Connection->connect()
#1 /usr/local/lib/owncloud/lib/private/DB/Connection.php(213): Doctrine\DBAL\Connection->executeUpdate(‘PRAGMA read_unc…’, Array, Array)
#2 /usr/local/lib/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): OC\DB\Connection->executeUpdate(‘PRAGMA read_unc…’)
#3 /usr/local/lib/owncloud/lib/private/DB/Connection.php(148): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#4 /usr/local/lib/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOSqlite\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#5 /usr/local/lib/owncloud/lib/private/DB/ConnectionFactory.php(150): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /usr/local/lib/owncloud/lib/private/Server.php(588): OC\DB\ConnectionFactory->getConnection(‘sqlite3’, Array)
#7 /usr/local/lib/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#8 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): Pimple\Container->offsetGet(‘OCP\IDBConnecti…’)
#9 /usr/local/lib/owncloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OCP\IDBConnecti…’)
#10 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(163): OC\ServerContainer->query(‘OCP\IDBConnecti…’)
#11 /usr/local/lib/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#12 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): Pimple\Container->offsetGet(‘DatabaseConnect…’)
#13 /usr/local/lib/owncloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘DatabaseConnect…’)
#14 /usr/local/lib/owncloud/lib/private/Server.php(1345): OC\ServerContainer->query(‘DatabaseConnect…’)
#15 /usr/local/lib/owncloud/lib/private/Server.php(309): OC\Server->getDatabaseConnection()
#16 /usr/local/lib/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#17 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#18 /usr/local/lib/owncloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#19 /usr/local/lib/owncloud/lib/private/Server.php(313): OC\ServerContainer->query(‘OC\Authenticati…’)
#20 /usr/local/lib/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#21 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#22 /usr/local/lib/owncloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#23 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(163): OC\ServerContainer->query(‘OC\Authenticati…’)
#24 /usr/local/lib/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#25 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#26 /usr/local/lib/owncloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#27 /usr/local/lib/owncloud/lib/private/Server.php(329): OC\ServerContainer->query(‘OC\Authenticati…’)
#28 /usr/local/lib/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#29 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): Pimple\Container->offsetGet(‘OCP\IUserSessio…’)
#30 /usr/local/lib/owncloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OCP\IUserSessio…’)
#31 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(163): OC\ServerContainer->query(‘OCP\IUserSessio…’)
#32 /usr/local/lib/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#33 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): Pimple\Container->offsetGet(‘UserSession’)
#34 /usr/local/lib/owncloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘UserSession’)
#35 /usr/local/lib/owncloud/lib/private/Server.php(1213): OC\ServerContainer->query(‘UserSession’)
#36 /usr/local/lib/owncloud/lib/private/Server.php(648): OC\Server->getUserSession()
#37 /usr/local/lib/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#38 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): Pimple\Container->offsetGet(‘OC\App\AppManag…’)
#39 /usr/local/lib/owncloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\App\AppManag…’)
#40 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(163): OC\ServerContainer->query(‘OC\App\AppManag…’)
#41 /usr/local/lib/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#42 /usr/local/lib/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): Pimple\Container->offsetGet(‘AppManager’)
#43 /usr/local/lib/owncloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘AppManager’)
#44 /usr/local/lib/owncloud/lib/private/Server.php(1518): OC\ServerContainer->query(‘AppManager’)
#45 /usr/local/lib/owncloud/lib/private/legacy/app.php(315): OC\Server->getAppManager()
#46 /usr/local/lib/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#47 /usr/local/lib/owncloud/lib/base.php(673): OC_App::loadApps(Array)
#48 /usr/local/lib/owncloud/lib/base.php(1086): OC::init()
#49 /usr/local/lib/owncloud/console.php(56): require_once(’/usr/local/lib/…’)
#50 {main}-----------------------------------------

Any help much appreciated.

tribeoflevi · June 17, 2018, 9:53pm

This is now sorted. I managed to re-install 0.26c using another post from here, restored the backup and it now works. I’ll try upgrading to 0.27 again when I have more time.

murgero · June 18, 2018, 2:27am

I would stay away from 0.27, it seems to have broken a LOT of things.

itsbhanusharma · June 18, 2018, 3:15am

I Upgraded 2 days ago and haven’t noticed any such thing … Maybe it’s case by case?

JoshData · June 18, 2018, 12:27pm

Very little actually changed in v0.27. These are existing problems that would affect upgrades between any versions.

github.com

mail-in-a-box/mailinabox/blob/master/CHANGELOG.md#v027-june-14-2018

CHANGELOG
=========

v0.27 (June 14, 2018)
---------------------

* A report of box activity, including sent/received mail totals and logins by user, is now emailed to the box's administrator user each week.
* Update Roundcube to version 1.3.6 and Z-Push to version 2.3.9.
* The undocumented feature for proxying web requests to another server now sets X-Forwarded-For.

v0.26c (February 13, 2018)
--------------------------

Setup:

* Upgrades from v0.21c (February 1, 2017) or earlier were broken because the intermediate versions of ownCloud used in setup were no longer available from ownCloud.
* Some download errors had no output --- there is more output on error now.

Control Panel:

This file has been truncated. show original