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