Prisma•2y ago

Can't reach database server at `aws-0-ap-south-1.pooler.supabase.com:5432`

DATABASE_URL="postgres://postgres.tdaudbkvlopqsbzesmau:password123@aws-0-ap-south-1.pooler.supabase.com:6543/postgres"
DIRECT_URL="postgres://postgres.tdaudbkvlopqsbzesmau:password123@aws-0-ap-south-1.pooler.supabase.com:5432/postgres"

Using supabase + prisma.

This problem is haunting me. Please help me.

AbhinavOP•6/7/24, 11:20 PM

2 days

jonfanz•6/7/24, 11:57 PM

@Abhinav if you followed that link, change your passwords immediately. That individual was not associated with Prisma.

AbhinavOP•6/8/24, 1:07 AM

yes, I figured out. Thanks a lot!

AbhinavOP•6/8/24, 5:02 AM

Someone please help with the question

Jan Piotrowski (janpio)•6/8/24, 8:45 AM

Did you follow Supabase's instructions?
https://supabase.com/partners/integrations/prisma

Supabase

Prisma | Works With Supabase

Next-generation Node.js and TypeScript ORM.

AbhinavOP•6/8/24, 10:45 AM

yes, followed.

AbhinavOP•6/8/24, 10:46 AM

but still same error

Jan Piotrowski (janpio)•6/8/24, 10:58 AM

What command exactly are you running?
And what is the output and full error message you are getting?

AbhinavOP•6/8/24, 11:04 AM

AbhinavOP•6/8/24, 11:05 AM

.env file

Jan Piotrowski (janpio)•6/8/24, 11:12 AM

would need to be to actually work, but that connection string is not used in the command

Jan Piotrowski (janpio)•6/8/24, 11:12 AM

I just created a new project:

Jan Piotrowski (janpio)•6/8/24, 11:13 AM

Which region is ?

Jan Piotrowski (janpio)•6/8/24, 11:16 AM

Singapore it seems, I also just created a database there and everything works.

AbhinavOP•6/8/24, 11:31 AM

I have different regions too. I wonder what the problem is?

Jan Piotrowski (janpio)•6/8/24, 11:32 AM

It happens every time?

Jan Piotrowski (janpio)•6/8/24, 11:32 AM

Maybe try this:

Jan Piotrowski (janpio)•6/8/24, 11:32 AM

That would tell Prisma to wait longer when trying to connect when you run .

JJan Piotrowski (janpio)It happens every time?

AbhinavOP•6/8/24, 11:41 AM

Yes. Haven't been able to run a project.

AbhinavOP•6/8/24, 11:42 AM

it was working fine earlier (3-4 months back). then it was paused. Now it doesn't work.

JJan Piotrowski (janpio)Maybe try this: ``` DIRECT_URL="postgres://postgres.ydwxvgrxrvchtdabfjde:passwor...

AbhinavOP•6/8/24, 11:42 AM

yes trying

AbhinavOP•6/8/24, 11:48 AM

yes the issue still persists.

AbhinavOP•6/8/24, 11:49 AM

seems like the database is not working? how can I test it?

Jan Piotrowski (janpio)•6/8/24, 11:49 AM

I sent you a DM.

Jan Piotrowski (janpio)•6/8/24, 11:49 AM

Generally you can use any other database tool to try these credentials.

AbhinavOP•6/8/24, 11:50 AM

AbhinavOP•6/8/24, 11:52 AM

will something like tableplus work?

Jan Piotrowski (janpio)•6/8/24, 11:54 AM

Yes.

Jan Piotrowski (janpio)•6/8/24, 11:54 AM

Ok, now we have a mysery:

Jan Piotrowski (janpio)•6/8/24, 11:54 AM

I used your connection string twice. First time it failed, second time it worked.

Jan Piotrowski (janpio)•6/8/24, 11:54 AM

In between these two I connected via DBeaver (a tool similar to tableplus).

Jan Piotrowski (janpio)•6/8/24, 11:54 AM

Can you try again if it works for your with Prisma now as well?

AbhinavOP•6/8/24, 11:57 AM

nopes doesn't work : (

AbhinavOP•6/8/24, 11:57 AM

let me try tableplus

Jan Piotrowski (janpio)•6/8/24, 11:59 AM

For me it keeps working.

AbhinavOP•6/8/24, 11:59 AM

do you think it's a network issue?

Jan Piotrowski (janpio)•6/8/24, 12:00 PM

I am not sure.
I am confused now why it didn't work for me initially, but now consistently works.

AbhinavOP•6/8/24, 12:00 PM

AbhinavOP•6/8/24, 12:00 PM

it doesn't go after this

Jan Piotrowski (janpio)•6/8/24, 12:02 PM

That, plus that you can not use the credentials I shared via DM, indicates a networking problem indeed.

Jan Piotrowski (janpio)•6/8/24, 12:03 PM

Somehow your computer or network can not connect to Supabase's databases.

AbhinavOP•6/8/24, 12:05 PM

cool I will try changing DNS and other stuff. Will let you know. Thanks a lot! Big big help.

AbhinavOP•6/8/24, 7:14 PM

AbhinavOP•6/8/24, 7:14 PM

tried everything

AbhinavOP•6/8/24, 7:36 PM

FINALLY WORKED

AbhinavOP•6/8/24, 7:36 PM

USED VPN and worked

AbhinavOP•6/8/24, 7:36 PM

it's so weird

AbhinavOP•6/8/24, 7:36 PM

even with VPN it didn't work first time

AbhinavOP•6/8/24, 7:37 PM

Thanks a lot for your time, big help!

K1|ller•6/8/24, 9:40 PM

I'm using supabase too and it works