database problem during repo upgrade

Ask all your questions regarding OC 8.2 Please read the Support Forum Rules
Forum rules
The forums were migrated over to https://central.owncloud.org which is based on the forum software Discourse. The forums here is put into read-only mode starting from today.

More background information about this move and the reasoning behind it is available in this blogpost:

https://daniel.molkentin.net/2016/07/20 ... d-central/
pdwalker
Newbie
Posts: 1
Joined: Thu Oct 22, 2015 9:20 am
ownCloud version: 8.1.3
Webserver: Apache
Database: MySQL
OS: Linux
PHP version: 5.5.9

database problem during repo upgrade

Postby pdwalker » Thu Oct 22, 2015 9:30 am

Just a datapoint:

I tried updating via repo from 8.1.3 to the new repo to 8.2, but the process failed.

Code: Select all

An unhandled exception has been thrown:
exception 'Doctrine\DBAL\DBALException' with message 'Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1043] Bad handshake' in /var/www/owncloud/lib/private/db/connection.php:52
Stack trace:
#0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/owncloud/lib/private/db/connection.php(135): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/owncloud/lib/private/db/connectionfactory.php(118): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/owncloud/lib/private/server.php(327): OC\DB\ConnectionFactory->getConnection('mysql', Array)
#8 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(112): OC\Server->OC\{closure}(Object(OC\Server))
#9 /var/www/owncloud/lib/private/appframework/utility/simplecontainer.php(104): Pimple\Container->offsetGet('DatabaseConnect...')
#10 /var/www/owncloud/lib/private/server.php(764): OC\AppFramework\Utility\SimpleContainer->query('DatabaseConnect...')
#11 /var/www/owncloud/lib/private/db.php(66): OC\Server->getDatabaseConnection()
#12 /var/www/owncloud/lib/private/user/database.php(210): OC_DB::prepare('SELECT `uid`, `...')
#13 /var/www/owncloud/lib/private/user/database.php(258): OC_User_Database->loadUser('')
#14 /var/www/owncloud/lib/private/user/manager.php(133): OC_User_Database->userExists('')
#15 /var/www/owncloud/lib/private/user/session.php(158): OC\User\Manager->get('')
#16 /var/www/owncloud/lib/private/log.php(237): OC\User\Session->getUser()
#17 /var/www/owncloud/lib/public/util.php(154): OC\Log->log(3, 'User backend OC...', Array)
#18 /var/www/owncloud/lib/private/user.php(196): OCP\Util::writeLog('core', 'User backend OC...', 3)
#19 /var/www/owncloud/lib/base.php(613): OC_User::setupBackends()
#20 /var/www/owncloud/lib/base.php(1061): OC::init()
#21 /var/www/owncloud/console.php(42): require_once('/var/www/ownclo...')
#22 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#23 {main}


)

I replaced MySQL package with MariaDB and the mysql error went away and I was able to continue the upgrade.

Ubuntu 14.04.3
mysql-server 5.5.44-0ubuntu0.14.04.1
mariadb-server 5.5.44-1ubuntu0.14.04.1

The mysql clients (both versions) had no problem connecting, only the owncloud php server code did.

0wnCl0ud
Beginner
Posts: 27
Joined: Wed Sep 30, 2015 12:20 pm
ownCloud version: 8.1.3
Webserver: Apache
Database: MySQL
OS: Linux
PHP version: 5.4

Re: Upgrade 8.1.3 to 8.2 via repo possible?

Postby 0wnCl0ud » Thu Oct 22, 2015 9:51 am

@pdwalker how do you change the repo?

RealRancor
ownCloud master
Posts: 17381
Joined: Sat May 26, 2012 3:00 pm
ownCloud version: 9.0.2
Webserver: nginx
Database: MySQL
OS: Linux
PHP version: 7.0.x

Re: database problem during repo upgrade

Postby RealRancor » Thu Oct 22, 2015 9:55 am

There have been similar issues reported here like:

viewtopic.php?f=31&t=26337
viewtopic.php?f=31&t=26919

Maybe have a look at the bugtracker if some one managed to report this there.
*gone*


  • Similar Topics
    Replies
    Views
    Last post

Return to “ownCloud Server 8.2”

Who is online

Users browsing this forum: No registered users and 2 guests