SQLSTATE HY000 2002 php network getaddresses getaddrinfo failed Name or service not known

Question

I download from https   github com luciddreamz laravel Laravel for openshift then upload over my repository over github  This code for connect to database not work  The problem is that load variable from  env file that locate in root of project  for solve this problem change env      local environment only     for production  see  openshift  env  APP ENV APPLICATION ENV APP DEBUG true APP URL OPENSHIFT APP DNS APP KEY OPENSHIFT SECRET TOKEN  DB DRIVER mysql DB HOST OPENSHIFT MYSQL DB HOST DB PORT OPENSHIFT MYSQL DB PORT DB DATABASE OPENSHIFT APP NAME DB USERNAME OPENSHIFT MYSQL DB USERNAME  DB PASSWORD OPENSHIFT MYSQL DB PASSWORD  CACHE DRIVER apc SESSION DRIVER file   my error  SQLSTATE HY000   2002  php network getaddresses  getaddrinfo failed  Name or service not known  createConnection  mysql host OPENSHIFT MYSQL DB HOST port OPENSHIFT MYSQL DB PORT dbname OPENSHIFT APP NAME    array  driver    gt   mysql           host    gt   OPENSHIFT MYSQL DB HOST           port    gt   OPENSHIFT MYSQL DB PORT           database    gt   OPENSHIFT APP NAME           username    gt   OPENSHIFT MYSQL DB USERNAME           password    gt   OPENSHIFT MYSQL DB PASSWORD           charset    gt   utf8            collation    gt   utf8 unicode ci           prefix    gt              strict    gt  false          name    gt   mysql     array  0    2    0   false   0    in MySqlConnector php line 20

User · Answer

In my case  everything was set up correctly  but my Docker infrastructure needed more RAM  I m using Docker for Mac  where default RAM was around 1 GB  and as MySQL uses around 1 5Gb of RAM   and probably was crashing        changing the Docker RAM utilization level to 3-4 Gb solved the issue

User · Answer

I m using Laravel with Docker  I solved this problem by changing the value of DB HOST from localhost to mysql   DB HOST mysql

User · Answer

Please try this code  npm install

User · Answer

In my case  it had absolute nothing to do with network issues  I had been using my local laravel testing environment using laradock  Because laradock runs the mysql server in a different container  you have to set your mysql host in the  env file to the name of the docker mysql container  which by default is mysql  When I switched back to using homestead  it was trying to connect to a host named mysql  when in fact is should be looking on localhost  What a DUH moment

User · Answer

It looks like you did not add a MySQL database to your application  OR you added it after you installed laravel   In that case  you need to stop  amp  start  not restart  your application so that it will pick up your environment variables   rhc app stop   rhc app start    If you did not add a database yet  you will need to add one of the mysql cartridges  and then stop  amp  start your application using the previously shown commands

User · Answer

If you are on production server and the  env file doesn t work at all  go to  bootstrap cache config php and on the line 230 more or less you will find the database data that is beeing cached from the  env file    mysql    gt     array        driver    gt   mysql        host    gt   127 0 0 1        port    gt   3306        database    gt   yorDBname        username    gt   YOURUSERNAME        password    gt   yourpass        unix socket    gt           charset    gt   utf8mb4        collation    gt   utf8mb4 unicode ci        prefix    gt           strict    gt  true       engine    gt   InnoDB ROW FORMAT DYNAMIC

User · Answer

I was having the same problem and everyone was talking about this is related to DNS configuration  which make sense  since your container maybe isn t knowing how to resolve the name of the domain where your database is   I guess your can configure that at the moment you start your container  but I think it s better to config this once and for all   I m using Windows 10 and in this case docker s gui give us some facilities   Just right click on docker s icon in the tray bar and select  Settings  item     Then  on the Docker s window  select the  Network  section and change the DNS option from  Automatic  to  Fixed  and hit  Apply   Docker will restart itself after that  I putted the Google s DNS  8 8 8 8  and it worked fine to me     Hope it helps

User · Answer

If you are in a network with multiple docker containers  make sure they are all up and running  One of my containers was down  pretty obvious if you know where to check

User · Answer

Check your DB HOST on your  env file  DB HOST http   localhost  -- gt  DB HOST localhost     php artisan config clear it will help you  clear cached config

User · Answer

In my case  when laravel generated the  env configuration file  laravel also generated two uncommented   quot DB HOST quot  lines at line 11 and 12  delete the one that says  quot mysql quot  and uncomment  if yours it s commented  the other one  the one with the localhost ip 127 0 0 1  and it worked   In my case   Have a great day

User · Answer

First line of the error message describes the error type   PDOException   The next line displays PDO  errorInfo  i e         SQLSTATE error code  a five characters alphanumeric identifier defined in the ANSI SQL standard       Driver-specific error code      Driver-specific error message           HY000  is a general server error  see Server Error Codes and Messages in MySQL docs    2002  is MySQL Client Error Code meaning  Can t connect to local MySQL server through socket   see  Client Error Codes and Messages in MySQL docs   The driver specific error code and message   php network getaddresses  getaddrinfo failed  Name or service not known   tell you that PDO is not able to resolve the host name    The stack trace you attached  line 3  reveals that you did not specify the database connection parameters in the configuration file  The error show up when you test on local  right  You need to update   env with the actual database connection parameters

User · Answer

Another reason this can sometimes come up is due to a misconfiguration in your docker-compose  if you re using it  whereby the mysql container is not on the same network that your app servers are on  If the network flag is forgotten or incorrect docker won t add the mysql to the DNS for the app server and therefore throw an error like this

User · Answer

We re using symfony with doctrine and we are in the process of automating deployment  I got this error when I simply hadn t provided the correct db creds in parameters yml  I was running doctrine migrations migrate   This thread has sent me on a bit of a wild goose chase  so I m leaving this here so others might not have to

User · Answer

If you are using Shopware with docker then you need to first run   psh phar ssh then any bin console command will work

User · Answer

If someone is facing this issue in the hosting services like hostgator or any thing else then you should have  to change the value of  quot localhost quot   to the relative values which is provided by the hosting provider  In my case it is available in the   quot phpmyadmin quot  tab of  quot cpanel quot  at the top right corner as   quot localhost 3302 quot

User · Answer

Just as on FYI to others suddenly experiencing this on an otherwise  previously  working Laravel installation   My Laravel environment is on a Ubuntu VirtualBox hosted on a Win-10 laptop   I used my phone to share Internet via USB and suddenly started experiencing this issue   I changed to using the phone as wireless hotspot and the issue went away   This is a nameserver networking issue and is not specific to Laravel or MySQL

User · Answer

If someone facing this problem when using Docker  be sure if you are using your version of SQL  In my case  MYSQL VERSION latest changing to MYSQL VERSION 5 7  Then you need to remove your unused Docker images with docker system prune -a  docs   Also  in your  env you need to change DB HOST mysql  And run php artisan config clear  I think it will help someone

[mysql] SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known

Examples related to mysql

Examples related to laravel

Examples related to laravel-5

Examples related to openshift