No host port mapping after creating container

[kursph]

I noticed when creating a new MySQLContainer like so

protected function setUp(): void
{
      $this->container = MySQLContainer::make();
      $this->container->withMySQLDatabase('pimcore');
      $this->container->withMySQLUser('pimcore_user', 'pimcore');
      try {
          $this->container->run();
      } catch (JsonException $e) {
          $this->fail($e->getMessage());
      }
}

but when checking out the docker container with docker ps and docker inspect there is no port mapped to the host (localhost). And then when I try to connect to it like so

$this->pdo = new PDO(
      sprintf('mysql:host=%s;port=3306', $this->container->getAddress()),
      'pimcore_user',
      'pimcore',
);

host missing when inspecting the container

"Ports": {
      "3306/tcp": null,
      "33060/tcp": null
},

I get this timeout error

1) Tests\App\journey\ContactIntegrationTest::testGetAllAction
PDOException: SQLSTATE[HY000] [2002] Operation timed out

here the container in Docker Desktop

[shyim]

In which environment are you running PHPUnit? We use the internal IP of the container right now, so we don't have to do any port mapping :)

[hantsy]

Testcontainer Java uses random ports if it is not set, this way can avoid port conflict. After container is started, we can get the real exposed port.

[shyim]

Do you have an link to the implementation? What do they use as "IP", that would be interesting 🤔, hard-code 127.0.0.1 🤔

[hantsy]

I used Testcontainers Java in projects for years, and by default when declaring a container, it will expose all ports, and map to random ports of clients(your machine), it has APIs to get the mapped ports, and first mapping port, etc.

see: https://github.com/hantsy/spring-r2dbc-sample/blob/master/testcontainers/src/test/java/com/example/demo/PostRepositoryWithTestcontainersAnnotationsAndDynamicPropertySourceTest.java#L35

[MaxDaten]

In which environment are you running PHPUnit? We use the internal IP of the container right now, so we don't have to do any port mapping :)

Same problem here. I think it's macOS-specific because docker is running differently. If no exposed port maps to the host, you can't connect to the container from the host where the PHPUnit is running.

Workaround, use withPort and localhost/127.0.0.1

For example, should be easily adaptable to plain PDO:

abstract class DatabaseTestCase extends TestCase
{

    protected Zend_Db_Adapter_Abstract $db;
    protected MySQLContainer $container;

    /**
     * @throws \Zend_Db_Exception
     */
    protected function setUp(): void
    {
        $container = MySQLContainer::make('8.0');
        $container->withMySQLDatabase('foo');
        $container->withMySQLUser('bar', 'baz');
        $randomPort = rand(3300, 3400);
        $container->withPort($randomPort, 3306);

        $container->run();

        $params = [
            'host' => '127.0.0.1',
            'port' => $randomPort,
            'dbname' => 'foo',
            'username' => 'bar',
            'password' => 'baz',
            'driver_options' => [
                PDO::ATTR_TIMEOUT => 2,
                PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            ],
        ];

        $this->db = Zend_Db::factory(
            "pdo_mysql",
            $params
        );
        Zend_Db_Table_Abstract::setDefaultAdapter($this->db);
    }
}