[owncloud-devel] Owncloud in Ubuntu 16.04 - Failed to connect to the database: Access denied for user ‘root’@’localhost’

Anton Blau Thu, 15 Sep 2016 12:52:40 -0700

Hello,

please excuse my bad english - but I am not a native speaker.

My Problem: After the Dist-Upgrade from Ubuntu 14.04 to 16.04 I get onlya white site on the Browser (https://myserver/owncloud/index.php).


How can I repar this?




     Server configuration

Before the upgrade I run owncloud 9,1,0,15 (owncloud/version.php) + php5+ mysql-server-5.5 (Ubuntu 14.04 LTS). After the dist-upgrade I seeowncloud 9.1.0-1.1 (in deselect) + php 7 + mysql-server-5.7-15


Web server: apache2

sudo -u www-data php occ app:list
An unhandled exception has been thrown:

Doctrine\DBAL\DBALException: Failed to connect to the database: Anexception occured in driver: SQLSTATE[HY000] [1698] Access denied foruser 'root'@'localhost' in/var/www/owncloud-org/lib/private/DB/Connection.php:58

Stack trace:

#0/var/www/owncloud-org/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429):OC\DB\Connection->connect()#1 <https://github.com/owncloud/core/pull/1>/var/www/owncloud-org/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389):Doctrine\DBAL\Connection->getDatabasePlatformVersion()#2 <https://github.com/owncloud/core/issues/2>/var/www/owncloud-org/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328):Doctrine\DBAL\Connection->detectDatabasePlatform()#3 <https://github.com/owncloud/core/issues/3>/var/www/owncloud-org/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621):Doctrine\DBAL\Connection->getDatabasePlatform()#4 <https://github.com/owncloud/core/pull/4>/var/www/owncloud-org/lib/private/DB/Connection.php(141):Doctrine\DBAL\Connection->setTransactionIsolation(2)#5 <https://github.com/owncloud/core/issues/5>/var/www/owncloud-org/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 <https://github.com/owncloud/core/pull/6>/var/www/owncloud-org/lib/private/DB/ConnectionFactory.php(120):Doctrine\DBAL\DriverManager::getConnection(Array,Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))#7 <https://github.com/owncloud/core/pull/7>/var/www/owncloud-org/lib/private/Server.php(410):OC\DB\ConnectionFactory->getConnection('mysql', Array)#8 <https://github.com/owncloud/core/pull/8>/var/www/owncloud-org/3rdparty/pimple/pimple/src/Pimple/Container.php(113):OC\Server->OC{closure}(Object(OC\Server))#9 <https://github.com/owncloud/core/pull/9>/var/www/owncloud-org/lib/private/AppFramework/Utility/SimpleContainer.php(102):Pimple\Container->offsetGet('DatabaseConnect...')#10 <https://github.com/owncloud/core/pull/10>/var/www/owncloud-org/lib/private/ServerContainer.php(87):OC\AppFramework\Utility\SimpleContainer->query('DatabaseConnect...')#11 <https://github.com/owncloud/core/pull/11>/var/www/owncloud-org/lib/private/Server.php(969):OC\ServerContainer->query('DatabaseConnect...')#12 <https://github.com/owncloud/core/pull/12>/var/www/owncloud-org/lib/private/Server.php(215):OC\Server->getDatabaseConnection()#13 <https://github.com/owncloud/core/pull/13>/var/www/owncloud-org/3rdparty/pimple/pimple/src/Pimple/Container.php(113):OC\Server->OC{closure}(Object(OC\Server))#14 <https://github.com/owncloud/core/pull/14>/var/www/owncloud-org/lib/private/AppFramework/Utility/SimpleContainer.php(102):Pimple\Container->offsetGet('OC\Authenticati...')#15 <https://github.com/owncloud/core/pull/15>/var/www/owncloud-org/lib/private/ServerContainer.php(87):OC\AppFramework\Utility\SimpleContainer->query('OC\Authenticati...')#16 <https://github.com/owncloud/core/pull/16>/var/www/owncloud-org/lib/private/Server.php(219):OC\ServerContainer->query('OC\Authenticati...')#17 <https://github.com/owncloud/core/pull/17>/var/www/owncloud-org/3rdparty/pimple/pimple/src/Pimple/Container.php(113):OC\Server->OC{closure}(Object(OC\Server))#18 <https://github.com/owncloud/core/pull/18>/var/www/owncloud-org/lib/private/AppFramework/Utility/SimpleContainer.php(102):Pimple\Container->offsetGet('OC\Authenticati...')#19 <https://github.com/owncloud/core/pull/19>/var/www/owncloud-org/lib/private/ServerContainer.php(87):OC\AppFramework\Utility\SimpleContainer->query('OC\Authenticati...')#20 <https://github.com/owncloud/core/pull/20>/var/www/owncloud-org/lib/private/AppFramework/Utility/SimpleContainer.php(150):OC\ServerContainer->query('OC\Authenticati...')#21 <https://github.com/owncloud/core/pull/21>/var/www/owncloud-org/3rdparty/pimple/pimple/src/Pimple/Container.php(109):OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))#22 <https://github.com/owncloud/core/pull/22>/var/www/owncloud-org/lib/private/AppFramework/Utility/SimpleContainer.php(102):Pimple\Container->offsetGet('OC\Authenticati...')#23 <https://github.com/owncloud/core/pull/23>/var/www/owncloud-org/lib/private/ServerContainer.php(87):OC\AppFramework\Utility\SimpleContainer->query('OC\Authenticati...')#24 <https://github.com/owncloud/core/pull/24>/var/www/owncloud-org/lib/private/Server.php(234):OC\ServerContainer->query('OC\Authenticati...')#25 <https://github.com/owncloud/core/pull/25>/var/www/owncloud-org/3rdparty/pimple/pimple/src/Pimple/Container.php(113):OC\Server->OC{closure}(Object(OC\Server))#26 <https://github.com/owncloud/core/pull/26>/var/www/owncloud-org/lib/private/AppFramework/Utility/SimpleContainer.php(102):Pimple\Container->offsetGet('UserSession')#27 <https://github.com/owncloud/core/pull/27>/var/www/owncloud-org/lib/private/ServerContainer.php(87):OC\AppFramework\Utility\SimpleContainer->query('UserSession')#28 <https://github.com/owncloud/core/pull/28>/var/www/owncloud-org/lib/private/Server.php(846):OC\ServerContainer->query('UserSession')#29 <https://github.com/owncloud/core/pull/29>/var/www/owncloud-org/lib/private/Server.php(454):OC\Server->getUserSession()#30 <https://github.com/owncloud/core/pull/30>/var/www/owncloud-org/3rdparty/pimple/pimple/src/Pimple/Container.php(113):OC\Server->OC{closure}(Object(OC\Server))#31 <https://github.com/owncloud/core/pull/31>/var/www/owncloud-org/lib/private/AppFramework/Utility/SimpleContainer.php(102):Pimple\Container->offsetGet('AppManager')#32 <https://github.com/owncloud/core/pull/32>/var/www/owncloud-org/lib/private/ServerContainer.php(87):OC\AppFramework\Utility\SimpleContainer->query('AppManager')#33 <https://github.com/owncloud/core/pull/33>/var/www/owncloud-org/lib/private/Server.php(1146):OC\ServerContainer->query('AppManager')#34 <https://github.com/owncloud/core/pull/34>/var/www/owncloud-org/lib/private/legacy/app.php(284):OC\Server->getAppManager()#35 <https://github.com/owncloud/core/pull/35>/var/www/owncloud-org/lib/private/legacy/app.php(105):OC_App::getEnabledApps()#36 <https://github.com/owncloud/core/pull/36>/var/www/owncloud-org/lib/base.php(573): OC_App::loadApps(Array)#37 <https://github.com/owncloud/core/pull/37>/var/www/owncloud-org/lib/base.php(967): OC::init()#38 <https://github.com/owncloud/core/pull/38>/var/www/owncloud-org/console.php(50): require_once('/var/www/ownclo...')#39 <https://github.com/owncloud/core/pull/39>/var/www/owncloud-org/occ(11): require_once('/var/www/ownclo...')


*The content of config/config.php:*
<?php
$CONFIG = array (
'instanceid' => '50f2b69bdd312',
'passwordsalt' => '78c33d331f4ddbcb763a26dd5263a3',
'datadirectory' => '/var/www/owncloud/data',
'dbtype' => 'mysql',
'version' => '9.1.0.15',
'installed' => true,
'maintenance' => false,
'theme' => '',
'trusted_domains' =>
array (
0 => 'gustav.duck',
),
'loglevel' => 0,
'mail_from_address' => 'administrator',
'mail_smtpmode' => 'smtp',
'mail_domain' => 'gustav.duck',
'mail_smtphost' => 'gustav.duck',
'mail_smtpport' => '25',

'secret' =>'94112ef32c6fd2ab1c9fc0037114678a12e81c3e28628b0e553a34955492a12eb3110d87cf3838499afcd4f70f46af9e',

'dbname' => 'owncloud',
'dbhost' => '127.0.0.1',
'dbuser' => 'root',
'dbpassword' => '',
'updatechecker' => false,
'overwrite.cli.url' => 'http:/gutstav.duck/owncloud',
'memcache.local' => '\OC\Memcache\APCu',

sudo -u www-data php occ config:list system
An unhandled exception has been thrown:

Stack trace:



     Logs


       Web server error log

|less /var/log/apache2/error.log [Tue Sep 13 21:26:57.305944 2016][core:notice] [pid 5827] AH00094: Command line: '/usr/sbin/apache2' [TueSep 13 21:33:13.357819 2016] [authz_core:error] [pid 10986] [client192.168.1.200:36062] AH01630: client denied by server configuration:/var/www/owncloud/data/htaccesstest.txt The problem was discribed heretoo: https://central.owncloud.org/t/sqlstate-28000-1045-access|


_______________________________________________
Devel mailing list
Devel@owncloud.org
http://mailman.owncloud.org/mailman/listinfo/devel

[owncloud-devel] Owncloud in Ubuntu 16.04 - Failed to connect to the database: Access denied for user ‘root’@’localhost’

Reply via email to