11
  • I setup PhpStorm: PHP, PHPUnit with Docker
  • I see schema in PhpStorm/Database viewer
  • I can use database in my application: register etc.
  • I can run phpunit in PhpStorm
  • But if I would like use database in tests, then I get the following error:

Illuminate\Database\QueryException : SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name does not resolve (SQL: select * from tablename)

The test working in container but broken in IDE. Do you have any ideas what is the problem in PhpStorm?

Improve this question
4
  • 1
    Have you found a solution to this? Commented Sep 22, 2018 at 14:52
  • I m also looking for a solution Commented Mar 31, 2020 at 19:28
  • i finally resolved this problem. A nbsp character was in the hostname.... Commented Jul 30, 2020 at 9:39
  • "getaddrinfo failed: Name does not resolve" - did you check the hostname? Commented Dec 5, 2024 at 7:25

4 Answers 4

Reset to default
14

I ran into this exact issue. Assuming you already have the Docker container and PHP interpreter set up, this is how I got it to connect to the MySQL container:

  1. Run docker network ls from the CLI and saw the "lighthouse_default" network
  2. Went to PHP > Test Frameworks and edited (clicked the folder) on my Docker container
  3. Set Network mode to "lighthouse_default"
  4. Added the lighthouse_mysql_1 image to the Links section

Obviously, in your situation the network name will likely be different. The real point is that I had to make sure I was using the right network and make sure the database image is in the Container Links.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

That solved it for me as well for laradock (steps 1-3, skipped step 4). The network name is "laradock_backend"
6

Do you use docker-compose (and is your db running in a different container)?

Check if your CLI Interpreter is running with docker-compose settings

Improve this answer

2 Comments

Yes, I use docker-compose and a DB in different container.
make sure that your mysql container is running. It seems Phpstorm does not start the mysql container on its own
2

I have a same problem and found solution:

Go to:

Settings > Languages & Frameworks > PHP > Test Frameworks

Open:

Edit docker container settings (you need push on folder icon)

Inside opened window, you will find "links" section, add from list your database container and after saving all works perfect!

If you get error for different network configuration, update your docker-compose.yml with adding this sentence on each container:

network_mode: bridge
Improve this answer

1 Comment

I think this won't work anymore with current docker version since "link" is now a legacy feature as far as I read. When I do it on PHPStorm I get "Loading container names..." "for ever" and I can not select anything. @Jason Adams' solution worked for me though.
0

I have solved the same issue as @jason-adams said here, but you have to be careful with the network name, just in case you want to use the network name you have used in your docker-compose file.

In this file I have something like:

networks:
  backend_blablabla:

...but when I ran docker network ls I saw a slightly different network name, in my case, it was something like {PROJECT_NAME}_backend_blablabla

So I had to use it on Settings > PHP > Test Frameworks > (clicked the folder) on my Docker container > Network mode because the network name of the docker-compose file won't work.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.