du5tball Posted February 21, 2017 Share Posted February 21, 2017 (edited) When I click on "Catalog" -> "Products" in the admin interface, the page stays blank, or rather the webserver answers with Error 500. When I turn on debugging, it works. But who wants to have the debug mode enabled in production? The errorlog reports: [Tue Feb 21 15:33:54.893408 2017] [:error] [pid 10147] [client 188.174.153.178:40826] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Permission denied' in /var/www/domain.tld/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43\nStack trace:\n#0 /var/www/domain.tld/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct('mysql:host=127....', 'user', 'password', Array)\n#1 /var/www/domain.tld/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(45): Doctrine\\DBAL\\Driver\\PDOConnection->__construct('mysql:host=127....', 'user', 'password', Array)\n#2 /var/www/domain.tld/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, 'user', 'password', Array)\n#3 /var/www/domain.tld/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(814): Doctrine\\DBAL\\Connection->connect()\n#4 /var/www/domain.tld/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(712): Doctrine\\DBAL\\Connection->executeQuery('SELECT t0.id AS in /var/www/domain.tld/app/bootstrap.php.cache on line 3216, referer: https://domain.tld/administration/index.php?controller=AdminDashboard&token=a16eb57c3388ded1d9e4fa99ccd08e96&_token=FKYUKJ5xAo5zC5BQRB0NGX0jIBIhW5Fms_1nrlHVQG0 What's suspicious to me is that the host is bogus (127....) although I've set it to localhost whereever applicable. Edit: Turning SELinux off is another thing that apparently works. It's again something I'm not comfortable with. Which SELinux permissions are needed? Edited February 21, 2017 by du5tball (see edit history) Link to comment Share on other sites More sharing options...
du5tball Posted February 22, 2017 Author Share Posted February 22, 2017 I found it: httpd_can_network_connect_db needs to be enabled. It didn't need to be enabled during installation though, so it seems like prestashop is doing something weird... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now