Forums

Resolved
0 votes
Hi,

My Owncloud is not working any more. I'm not sure how this happened, if the update to 7.6 did something wrong... i just don't know.

When i go to owncloud i get this error message

Exception occurred while logging exception: Failed to connect to the database: An exception occurred while executing 'PRAGMA journal_mode = WAL': SQLSTATE[HY000]: General error: 14 unable to open database file
#0 /usr/share/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(992): OC\DB\Connection->connect()
#1 /usr/share/owncloud/lib/private/DB/Connection.php(210): Doctrine\DBAL\Connection->executeUpdate('PRAGMA read_unc...', Array, Array)
#2 /usr/share/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): OC\DB\Connection->executeUpdate('PRAGMA read_unc...')
#3 /usr/share/owncloud/lib/private/DB/Connection.php(145): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#4 /usr/share/owncloud/lib/composer/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/share/owncloud/lib/private/DB/ConnectionFactory.php(145): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /usr/share/owncloud/lib/private/Server.php(526): OC\DB\ConnectionFactory->getConnection('sqlite3', Array)
#7 /usr/share/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#8 /usr/share/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Container->offsetGet('DatabaseConnect...')
#9 /usr/share/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('DatabaseConnect...')
#10 /usr/share/owncloud/lib/private/Server.php(1211): OC\ServerContainer->query('DatabaseConnect...')
#11 /usr/share/owncloud/lib/private/Server.php(402): OC\Server->getDatabaseConnection()
#12 /usr/share/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#13 /usr/share/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Container->offsetGet('AppConfig')
#14 /usr/share/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('AppConfig')
#15 /usr/share/owncloud/lib/private/Server.php(1140): OC\ServerContainer->query('AppConfig')
#16 /usr/share/owncloud/lib/private/Server.php(580): OC\Server->getAppConfig()
#17 /usr/share/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#18 /usr/share/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Container->offsetGet('AppManager')
#19 /usr/share/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#20 /usr/share/owncloud/lib/private/Server.php(1410): OC\ServerContainer->query('AppManager')
#21 /usr/share/owncloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#22 /usr/share/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#23 /usr/share/owncloud/lib/base.php(586): OC_App::loadApps(Array)
#24 /usr/share/owncloud/lib/base.php(1004): OC::init()
#25 /usr/share/owncloud/index.php(54): require_once('/usr/share/ownc...')
#26 {main}
Thursday, May 02 2019, 01:44 PM
Share this post:

Accepted Answer

Thursday, May 02 2019, 03:23 PM - #Permalink
Resolved
0 votes
Nick,

I have restored an old config.php (3 days old) file in /etc/owncloud and now i'm getting the owncloud screen again and can login :)
The reply is currently minimized Show
Responses (4)
  • Accepted Answer

    Thursday, May 02 2019, 04:02 PM - #Permalink
    Resolved
    0 votes
    Nick Howitt wrote:

    Weird. I wonder what went wrong, but we may never know now unless you backed up your config before you did a restore. I was really going to struggle to help as I don't have or know Ownlcoud and I know little about mysql/mariadb apart from some rudimentary knowledge of the tools.

    I've no clue what heppend, but on the etc/owncloud there a huge amount of old config files.
    Therefor i was easy to use an old config.pfp file.

    Something has changed during an update, because i see that 2-times the config file had been changed after the updates (nightly).
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, May 02 2019, 03:43 PM - #Permalink
    Resolved
    0 votes
    Weird. I wonder what went wrong, but we may never know now unless you backed up your config before you did a restore. I was really going to struggle to help as I don't have or know Ownlcoud and I know little about mysql/mariadb apart from some rudimentary knowledge of the tools.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, May 02 2019, 02:55 PM - #Permalink
    Resolved
    0 votes
    Hello Nick,

    I need a little bit more support if possible.
    How can i check this ?
    Password is found in /var/clearos/system_database
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, May 02 2019, 02:49 PM - #Permalink
    Resolved
    0 votes
    It does look like php went through an upgrade to php-5.4.16-46 from php-5.4.16-43, but I would have thought this was trivial. Webconfig-php did the same. Are you able to connect successfully to the database manually? I don't have Owncloud but most system database passwords seem to be in /var/clearos/system_database.
    The reply is currently minimized Show
Your Reply