SQLSTATE[08006] [7] could not translate host name
Hello,
My name is Marwan, and I'm a computer science student at La Rochelle University.
I'm contacting you because I have a group project involving databases. The problem is that I'm the only one experiencing this issue on my computer. I'm using a MacBook M2, unlike the other members of my group who all use Windows computers.
We're programming in PHP, and the code is correct; it works on all machines except mine. I'm using MAMP to run the PHP code.
❌ Supabase connection error: SQLSTATE[08006] [7] unable to translate host name "db.adcerfjdemfvqezmaprq.supabase.co" to address: node name or service name not provided, or not known
I've changed my DNS server, I've tried everything, but nothing works. I'm using the Brave browser.
If you could help me, it would be fantastic and would allow me to get a good grade.
Thank you in advance.
10 Replies
Not sure about mac/windows. But the address you are using is IPv6 only. If your computer/router/network is not IPv6 it won't work. The connection tab at the top also shows IPv4 compatible connections using the session pooler (5432) or transaction pooler (6543).
How i know if my computer is compatible?
One possible way... https://test-ipv6.com/
Test your IPv6.
This will test your browser and connection for IPv6 readiness, as well as show you your current IPv4 and IPv6 address.
it's not good
Then you need to use the IPv4 connection.
for to use a database on supabase i need a ipv4 connection?
The connection you were using is IPv6 only which won't work on your machine/router/network as one of them is not supporting IPv6.
As I said in the connection tab at top of dashboard there are pooler options (probably session 5432 if that is the port you are using) that work with IPv4.
ok i test that
OMGGGGG THAT WORK
THANKS YOU
Merci beaucoup