Database connection error on install

Hello,
I am getting the following error on install (either 2nd screen of GUI or CLI). Any suggestions? The host, username, and password (simple password for a local machine only) are correct.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Connection refused' in /opt/local/apache2/vhosts/orocommerce-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43 Stack trace: #0 /opt/local/apache2/vhosts/orocommerce-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct('mysql:host=127....', 'root', 'mysqlroot', Array) #1 /opt/local/apache2/vhosts/orocommerce-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(45): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=127....', 'root', 'mysqlroot', Array) #2 /opt/local/apache2/vhosts/orocommerce-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'root', 'mysqlroot', Array) #3 /opt/local/apache2/vhosts/orocommerce-application/src/Oro/src/Oro/Bundle/EntityConfigBundle/Config/ConfigModelManager.php(86): Doctrine\DBAL\Connection->connect() #4 /opt/local/apache2/vhosts/ in /opt/local/apache2/vhosts/orocommerce-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 103

Topic

[MichaelKeymaster]

Hi Mark,

Please check whether your MySQL server is accepting connections via a Unix socket, or on a TCP port 3306. If the latter – you have to specify the 3306 port number during installation.

On a Linux machine you can check connectivity with the netstat util like this:


netstat -ln | grep -E '(mysql|3306)'


[Mark BrintonParticipant]

It is using a socket (/opt/local/var/run/mysql56/mysqld.sock) – it is a default Macports install. I can connect to the database without issue using command line or MySQL. Do you have any other suggestions?

[MichaelKeymaster]

You can enter the socket path (/opt/local/var/run/mysql56/mysqld.sock) when asked by composer for database_port.

If you are already past the composer install step – you can edit app/config/parameters.yml, replace

database_port: null

1 2	database_port: null

with

database_port: /opt/local/var/run/mysql56/mysqld.sock

1 2	database_port: /opt/local/var/run/mysql56/mysqld.sock

and clear the cache

sudo rm -rf app/cache/dev app/cache/dist app/cache/prod sudo rm -rf app/cache/sessions

1 2 3

sudo rm -rf app/cache/dev app/cache/dist app/cache/prod sudo rm -rf app/cache/sessions

[Mark BrintonParticipant]

Thank you, I tried your suggestion (edit and clear cache) but no change in the outcome. Also tried changing the database_host to localhost, but that gives a different error:

An Exception was thrown while handling: Internal Server Error

I will try a reinstall which I don’t think will cause a different outcome, but will give it a try.

[Mark BrintonParticipant]

Reinstalled from GitHub using the socket as port during composer install, but still get the same error.

[Author]

Replies