CODEWITHSUNDEEP
phpmysqlphalcon
Liam Martens
Liam Martens

Reputation: 741

Phalcon, Docker MySQL connection fails

So I have 3 docker containers, one with PHP+PhalconPHP, one with MySQL and another with the webserver. Now on my host system I can connect to the MySQL in the docker container and I can also connect with PDO using the following code

new PDO('mysql:host=mysql;port=1024;dbname=database', 'root', 'password');

But for some reason the phalcon framework is unable to connect to the MySQL database using the config.php file like so

return new \Phalcon\Config([
    'database' => [
        'adapter'     => 'mysql',
        'port'        => 1024,
        'host'        => 'mysql',
        'username'    => 'root',
        'password'    => 'password',
        'dbname'      => 'database',
        'charset'     => 'utf8',
    ],
]);

In this case, for some reason I am getting a Can't connect to MySQL server on 'mysql' (111 "Connection refused) even though I am 100% sure I can actually connect (as proven before with the PDO connection). I also tried hardcoding the actual MySQL container ip address but no luck either.

Any ideas?

Upvotes: 2

Views: 995

Answers (1)

Liam Martens
Liam Martens

Reputation: 741

So it appeared to be kind of a stupid "mistake" but here's the solution. Apparently when you use the Phalcon Developer Tools to scaffold your project, it does not initialize the database with the port configuration as it outright ignores it. You can easily fix this by going into the app/config/services.php file and changing the db service to also include the port configuration.

$connection = new $class([
    'host'     => $config->database->host,
    'port'     => $config->database->port,
    'username' => $config->database->username,
    'password' => $config->database->password,
    'dbname'   => $config->database->dbname,
    'charset'  => $config->database->charset
]);

Upvotes: 1

Related Questions