Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sqlstate driver error owncloud installation #31177

Closed
popsy700 opened this issue Apr 17, 2018 · 5 comments
Closed

sqlstate driver error owncloud installation #31177

popsy700 opened this issue Apr 17, 2018 · 5 comments

Comments

@popsy700
Copy link

Steps to reproduce

Expected behaviour

Tell us what should happen

Actual behaviour

Tell us what happens instead

Server configuration

Operating system:

Web server:

Database:

PHP version:

ownCloud version: (see ownCloud admin page)

Updated from an older ownCloud or fresh install:

Where did you install ownCloud from:

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

Log in to the web-UI with an administrator account and click on
'admin' -> 'Generate Config Report' -> 'Download ownCloud config report'
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.

or 

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder

*ATTENTION:* Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove *all* host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: yes/no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

LDAP configuration (delete this part if not used)

With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';


Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

Client configuration

Browser:

Operating system:

Logs

Web server error log

Insert your webserver log here

ownCloud log (data/owncloud.log)

Insert your ownCloud log here

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...
@popsy700
Copy link
Author

Exception occurred while logging exception: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1044] Access denied for user ''@'localhost' to database 'veritascloud'
#0 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/DB/Connection.php(145): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/composer/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 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/DB/ConnectionFactory.php(146): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/Server.php(493): OC\DB\ConnectionFactory->getConnection('mysql', Array)
#8 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#9 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Container->offsetGet('DatabaseConnect...')
#10 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('DatabaseConnect...')
#11 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/Server.php(1160): OC\ServerContainer->query('DatabaseConnect...')
#12 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/Server.php(370): OC\Server->getDatabaseConnection()
#13 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#14 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Container->offsetGet('AppConfig')
#15 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('AppConfig')
#16 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/Server.php(1089): OC\ServerContainer->query('AppConfig')
#17 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/Server.php(547): OC\Server->getAppConfig()
#18 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#19 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Container->offsetGet('AppManager')
#20 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#21 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/Server.php(1359): OC\ServerContainer->query('AppManager')
#22 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#23 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#24 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/base.php(579): OC_App::loadApps(Array)
#25 /Applications/XAMPP/xamppfiles/htdocs/owncloud/lib/base.php(998): OC::init()
#26 /Applications/XAMPP/xamppfiles/htdocs/owncloud/index.php(54): require_once('/Applications/X...')
#27 {main}

@ownclouders
Copy link
Contributor

GitMate.io thinks possibly related issues are #26902 (error), #28840 (-Error-), #3248 (Owncloud Error), #3261 (Owncloud errors), and #11426 (ownCloud Error After Install).

@patrickjahns
Copy link
Contributor

Please fill in the template from the first post

@DeepDiver1975
Copy link
Member

This is a configuration issue. Not a bug in the software. Please search the web for this error message.

Furthermore: owncloud is not supported in Mac

@lock
Copy link

lock bot commented Jul 30, 2019

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.

@lock lock bot locked as resolved and limited conversation to collaborators Jul 30, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

4 participants