Level 3
@Synch did you resolve this? How? Thanks!
Aug 17, 2017
4
Level 1
php_network_getaddresses: getaddrinfo failed: Name or service not known
I'm having a problem with my database connection which doesn't work half of the time. If I try to do anything with the database the page will generate the following error:
SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known (SQL: select * from `users` where `email` = [email protected] limit 1)
After a couple of reloads the page loads fine again...
I know the database settings are correct as sometimes the connections works fine. The database is located on another server which is connected through a local network. I tried to find an answer to this problem for the past two days but I'm a bit lost. Google gives me no clear answer. I suspect that there is some problem with the DNS lookup of the other database server, but I'm not sure (I already tried changing the DB address to a direct local address instead of the public DNS record's domain). I also tried restarting FPM, the DB and refreshing the database.
The database is running on MariaDB. Laravel version is 5.4. PHP version 7.1.7.
Does anyone have any experience with this error message?
Level 1
I vaguely remember there was some problem with the local network configuration and that using the FQDN of the DB server resolved the issue. But I'm not sure, sorry.
1 like
Level 1
this problem relates to DB_HOST which, should be like: DB_HOST=localhost
5 likes
Level 2
I ran php artisan config:cache which seemed to fix it for me...
Please or to participate in this conversation.