Greetings:
I am having the same problem referenced here.
- Omeka classic is also installed on this server and running perfectly (connecting to mysql database fine)
- Running Ubuntu 14.04 LTS
- Everything in /var/www & below is readable by the server (other omeka install running fine)
When I enter the URL, the page responds with "The omeka.xxx.edu page isn’t working. omeka.xxx.edu is currently unable to handle this request. HTTP ERROR 500 reload ". However, when I change the password in the database.ini file to a WRONG password for the MySQL user then the URL page to omeka-s site responds with the following error:
Omeka S encountered an error
Zend\ServiceManager\Exception\ServiceNotCreatedException
Service with name “Omeka\ModuleManager” could not be created. Reason: An exception occured in driver: SQLSTATE[28000] [1045] Access denied for user ‘suser’@‘localhost’ (using password: YES)
Details:
exception ‘PDOException’ with message ‘SQLSTATE[28000] [1045] Access denied for user ‘suser’@‘localhost’ (using password: YES)’ in /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
Stack trace:
#0 /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct(‘mysql:host=loca…’, ‘suser’, ‘Crank-tape’, Array)
#1 /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(45): Doctrine\DBAL\Driver\PDOConnection->__construct(‘mysql:host=loca…’, ‘suser’, ‘Crank-tape’, Array)
#2 /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, ‘suser’, ‘Crank-tape’, Array)
#3 /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(780): Doctrine\DBAL\Connection->connect()
#4 /var/www/omeka-s/application/src/Service/ModuleManagerFactory.php(87): Doctrine\DBAL\Connection->prepare(‘SELECT * FROM m…’)
#5 /var/www/omeka-s/vendor/zendframework/zend-servicemanager/src/ServiceManager.php(747): Omeka\Service\ModuleManagerFactory->__invoke(Object(Zend\ServiceManager\ServiceManager), ‘Omeka\ModuleMan…’, NULL)
#6 /var/www/omeka-s/vendor/zendframework/zend-servicemanager/src/ServiceManager.php(195): Zend\ServiceManager\ServiceManager->doCreate(‘Omeka\ModuleMan…’)
#7 /var/www/omeka-s/application/src/Mvc/Application.php(32): Zend\ServiceManager\ServiceManager->get(‘Omeka\ModuleMan…’)
#8 /var/www/omeka-s/index.php(17): Omeka\Mvc\Application::init(Array)
#9 {main}
I have confirmed that the pdo_mysql.ini and pdo.ini extensions are in the correct location on the server /etc/php5/mods-available) and LOADING correctly by running the following command:
php -r “new PDO(‘mysql:host=localhost;port=3306;charset=utf8;dbname=dbname’, ‘suser’, ‘passwd’);”
In the database.ini file, I’ve also tried changing the host= from localhost to IP Address to DNS name, to 127.0.0.1. This does change the error from the HTTP 500 error to "Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server. Followed advice of many Google,stackoverflow,geekstuff forums on fixing this error, but still no joy.
Please advise.
Many thanks for suggestions!