Scenario "Bern": Docker web container can't connect to db container

[fduran]

Discussions about scenario Bern

[erjan]

why is there no canonical solution? i tried to stop and remove wordpress container and run it again using wordpress:sad image.

with this cmd specifying additional env vars:

sudo docker run -d --name wordpress \
  -e WORDPRESS_DB_HOST=mysql \    #this is specifying the container name as db host
  -e WORDPRESS_DB_NAME=wordpress \
  -p 80:80 \
  wordpress:sad

when running test cmd: sudo docker exec wordpress mysqladmin -h mysql -u root -ppassword ping

it gives error:

mysqladmin: connect to server at 'mysql' failed
error: 'Unknown MySQL server host 'mysql' (-2)'
Check that mysqld is running on mysql and that the port is 3306.
You can check this by doing 'telnet mysql 3306'

i think the solution is valid

[erjan]

ok i managed to get it to work, i created my own docker network and restarted both containers with some env vars.

however - should the button "check solution" show green? or is it like jakarta scenario where it has no solution?

or similar to resumable server scenario - where it does not run automated check?

[fduran]

Hello. Sometimes scenarios have multiple ways of being solved, this is not necessarily a bad thing since it reflects real situations.
This scenario, unlike Jakarta, has a solution button and a checker (if the "Check My Solution" button is visible, then it will run the check.sh script). In our case the check is https://github.com/fduran/sadservers/tree/main/scenarios/bern#test and your solution looks correct (pinging - really checking the hostname - the database container from the wordpress container works, it returns "mysqld is alive") . I don't know why in this case the button + check script failed.

If this situation ever happens again, you can run the ~/agent/check.sh script directly to determine if there's a website issue or a script issue, thanks,