Can't connect to mysql in docker container from phpbb

Question

My docker container is working nicely, and I can connect to my database using my graphical sql client.

However when I try to connect to my phpbb instance, I get this error:

General Error SQL ERROR [ mysqli ]

No such file or directory [2002]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

The phpbb config looks like this:

$dbms = 'mysqli';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'xxxxx_xxxx';
$dbuser = 'xxxxxxxxx';
$dbpasswd = 'xxxxxx';

Would the file or directory it can't find relate to the mysql.so? If so where would I set this in the docker configs?

It not then does anyone know what's going on?

Edit for clarity:

My docker-compose.yml looks like the below and I am running it with 'docker-compose up'

php: image: webdevops/php-nginx links: - db:database volumes: - "/home/xxx/code/mytest:/mytest-now" ports: - 80:80 environment: - WEB_DOCUMENT_ROOT=/mytest/public

db:
  image: mariadb:latest
  volumes:
    - "mytest-db:/var/lib/mysql"
  ports:
    - "3306:3306"
  environment:
    MYSQL_ROOT_PASSWORD: admin
    MYSQL_DATABASE: dbname
    MYSQL_USER: user
    MYSQL_PASSWORD: password

How are you running the container? Are there multiple containers? — Sergiu, Sep 17 '17 at 11:58
@Sergiu - This is my dev machine, so I run it with 'docker compose up'. I have posted my docker-compose.yml above for clarity. — Positonic, Sep 18 '17 at 20:29

score 2 · Answer 1 · answered Sep 17 '17 at 13:49

The reason your connection is not working is the use of localhost. I assume you ran your mysql container either through docker-compose or docker and mapped port 3306 form host to 3306 on container.

Now using the graphical GUI you use localhost:3306 and it works, this is because your forwarded the docker port to the host port.

But your phpbb container the localhost refers to the container itself and hence the connection cannot be made. So there few ways to get it working

Host IP

Use the host IP which where you have mapped the port 3306

$dbhost = '192.168.0.102';

This is not a recommended approach as your host IP will change when you connect to different networks

Use mysql container name

Run your mysql container with a --name mysqldb and use the this name in the connection

$dbhost = 'mysqldb';

Use mysql service name

If you use docker-compose and added mysql as a service

version: '3'
services:
  mysqldb2:
    image: mysql
    environment:
      - MYSQL_ROOT_PASSWORD=root
  phpbb:
    .....

Then you can use the service name in your connection settings

$dbhost = 'mysqldb2';

thanks! I ran docker inspect and see a host ip of 0.0.0.0, when I try use that I get 'Connection refused [2002]'. Otherwise I'm not using a service yet. This is my dev machine and my first attempt at docker, do I need a service? I have posted my docker-composer.yml above, I hope there is a simple way... thanks for your help!! — Positonic, Sep 18 '17 at 20:28

score 0 · Answer 2 · answered Sep 18 '17 at 20:39

0

After running 'docker inspect containername' I noticed an ip address under: NetworkSettings.Networks.bridge.gateway.

When I tried that, it worked!

answered Sep 18 '17 at 20:39

Positonic

9,151
14
57
84

Can't connect to mysql in docker container from phpbb

2 Answers2