importare database mysql dentro un contenitore (docker)

[astros3]

Allora

$ docker-compose up --build -d > output.txt
Building app
tmphbzh6gzgcy_redis_1 is up-to-date
Recreating tmphbzh6gzgcy_mysql_1 ... done
Recreating tmphbzh6gzgcy_app_1 ... done

Se vedi l'allegato ci sono cose strane come DONIG_ESCAPE_UCHAR_COLLISION, ecc.

Poi come al solito

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refused in /usr/local/bin/test.php:4
Stack trace:
#0 /usr/local/bin/test.php(4): PDO->__construct('mysql:host=127....', 'root', 'root2')
#1 {main}
  thrown in /usr/local/bin/test.php on line 4

Inoltre

$ cat docker-compose.yml 
version: '3'
services:
  app:
    build:
      context: .
    image: test-image
    ports:
      - 8080:80
    volumes:
      - .:/srv/app
    links:
      - mysql
      - redis
    environment:
      DB_HOST: mysql
      DB_DATABASE: laravel_docker
      DB_USERNAME: app
      DB_PASSWORD: password
      REDIS_HOST: redis
      SESSION_DRIVER: redis
      CACHE_DRIVER: redis
  mysql:
    image: mysql:5.7
    ports:
      - 13306:3306
    environment:
      MYSQL_DATABASE: test
      MYSQL_ROOT_PASSWORD: root2
  redis:
    image: redis:4.0-alpine
    ports:
      - 16379:6379

[M4V1]

Scusa se sono sparito, ma non ho avuto tempo di guardare i tuoi log.
Se oggi ho un momento ti faccio sapere qualcosa.

[astros3]

E se puoi per favore falla anche tu qualche prova. Io non so più che pesci prendere.

[M4V1]

Fai una prova così:

$pdo = new PDO(
    "mysql:host=mysql;dbname=test",
    'root','root2'
);

Altra cosa, quando installi le estensioni di php ricevi dei warning. pdo e mbstring ci sono già, quindi è inutile rimetterle. Manca solo pdo_mysql quindi:

RUN docker-php-ext-install mbstring pdo pdo_mysql

diventa


RUN docker-php-ext-install pdo_mysql

Ma questo non dovrebbe cambiare nulla ai fini del nostro problema.

[astros3]

Fatal error: Uncaught PDOException: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /usr/local/bin/test.php:5
Stack trace:
#0 /usr/local/bin/test.php(5): PDO->__construct('mysql:host=mysq...', 'root', 'root')
#1 {main}

Next PDOException: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known in /usr/local/bin/test.php:5
Stack trace:
#0 /usr/local/bin/test.php(5): PDO->__construct('mysql:host=mysq...', 'root', 'root')
#1 {main}
  thrown in /usr/local/bin/test.php on line 5

[astros3]

Fatal error: Uncaught PDOException: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /usr/local/bin/test.php:5
Stack trace:
#0 /usr/local/bin/test.php(5): PDO->__construct('mysql:host=mysq...', 'root', 'root')
#1 {main}

Next PDOException: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known in /usr/local/bin/test.php:5
Stack trace:
#0 /usr/local/bin/test.php(5): PDO->__construct('mysql:host=mysq...', 'root', 'root')
#1 {main}
thrown in /usr/local/bin/test.php on line 5