Help server error owncloud not accesible


#1

Please help me on this error

owncloud.log tell

{"reqId":"7757a47a8ff5767d2f998ec723ec470b","remoteAddr":"93.34.134.128","app":"index","message":"Exception: {\"Message\":\"An exception occurred while executing 'PRAGMA journal_mode = WAL':\n\nSQLSTATE[HY000]: General error: 26 file is encrypted or is not a database\",\"Code\":0,\"Trace\":\"#0 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(973): OC\\DB\\Connection->connect()\n#1 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/db\\/connection.php(132): Doctrine\\DBAL\\Connection->executeUpdate('PRAGMA read_unc...', Array, Array)\n#2 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(621): OC\\DB\\Connection->executeUpdate('PRAGMA read_unc...')\n#3 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/db\\/connection.php(66): Doctrine\\DBAL\\Connection->setTransactionIsolation(2)\n#4 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/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))\n#5 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/db\\/connectionfactory.php(107): Doctrine\\DBAL\\DriverManager::getConnection(Array, Object(Doctrine\\DBAL\\Configuration), Object(Doctrine\\Common\\EventManager))\n#6 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/server.php(243): OC\\DB\\ConnectionFactory->getConnection('sqlite3', Array)\n#7 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/3rdparty\\/pimple\\/pimple\\/src\\/Pimple\\/Container.php(112): OC\\Server->OC\\{closure}(Object(OC\\Server))\n#8 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/appframework\\/utility\\/simplecontainer.php(91): Pimple\\Container->offsetGet('DatabaseConnect...')\n#9 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/server.php(540): OC\\AppFramework\\Utility\\SimpleContainer->query('DatabaseConnect...')\n#10 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/db.php(33): OC\\Server->getDatabaseConnection()\n#11 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/server.php(178): OCDB::getConnection()\n#12 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/3rdparty\\/pimple\\/pimple\\/src\\/Pimple\\/Container.php(112): OC\\Server->OC\\{closure}(Object(OC\\Server))\n#13 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/appframework\\/utility\\/simplecontainer.php(91): Pimple\\Container->offsetGet('AppConfig')\n#14 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/server.php(488): OC\\AppFramework\\Utility\\SimpleContainer->query('AppConfig')\n#15 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/app.php(218): OC\\Server->getAppConfig()\n#16 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/app.php(71): OC_App::getEnabledApps()\n#17 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/base.php(542): OC_App::loadApps(Array)\n#18 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/base.php(1026): OC::init()\n#19 \\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/index.php(34): require_once('\\/web\\/htdocs\\/www...')\n#20 {main}\",\"File\":\"\\/web\\/htdocs\\/www.gb-consulting.it\\/home\\/fabi\\/cloudfabi\\/lib\\/private\\/db\\/connection.php\",\"Line\":33}","level":4,"time":"2017-05-21T08:41:03+00:00"}

i don't know how solve this problem


#2

Hi,

what was changed in your environment to get to this state?


#3

Nothing.
I had only create a new folder for photos and share it with link, and all was ok.
My sister look the photos and then she read this message.
Then it reimain on this way. :persevere:


#4

As you're running SQLite some general advises:

  1. Revert to a previous working backup
  2. Install MySQL / PostgreSQL
  3. Migrate your database to MySQL / PostgreSQL: https://doc.owncloud.org/server/latest/admin_manual/configuration_database/db_conversion.html

SQLite is nothing what you should run on a productive system, especially if using more then one single user.