Error: P1000: Authentication failed against database server at ...

[alpsla]

Hello,

Can anyone advise on getting Error: P1000: Authentication failed against database server at ...

Prisma ORM (v6.1.0) database connection to Supabase PostgreSQL
Error message:
Authentication failed against database server at db.xxxxxxxxxxxxxf.supabase.co the provided database credentials for postgres are not valid.

We've tried multiple connection string formats and configurations but continue to receive authentication errors. We need guidance on the correct connection string format and credentials to use with Prisma ORM when connecting to Supabase PostgreSQL.

Steps to reproduce:

Configure Prisma with Supabase connection URL
Run prisma generate
Attempt prisma db push
Receive authentication error

[GaryAustin1]

Not sure if that is a generic error for any connection issue or just for credentials.
You are using the ipv6 only dataport. Does it work using the Supavisor ipv4 ports?
Make sure your password has no special characters or you URL encode it.

Guide: https://supabase.com/partners/integrations/prisma

The dashboard also has a connection UI for many apps including Prisma.

[alpsla]

Hi Gary, You got my problem and offered the right solution, my password contained special characters and wasn't handled properly now after changing the password, everything works fine. Thanks a lot, Rosti

…

________________________________ From: GaryAustin1 ***@***.***> Sent: Sunday, January 5, 2025 12:21 PM To: supabase/supabase ***@***.***> Cc: alpsla ***@***.***>; Author ***@***.***> Subject: Re: [supabase/supabase] Error: P1000: Authentication failed against database server at ... (Discussion #32576) Not sure if that is a generic error for any connection issue or just for credentials. You are using the ipv6 only dataport. Does it work using the Supavisor ipv4 ports? Make sure your password has no special characters or you URL encode it. Guide: https://supabase.com/partners/integrations/prisma The dashboard also has a connection UI for many apps including Prisma. — Reply to this email directly, view it on GitHub<#32576 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ACC5CONCONTP6OFVVPBGBFL2JFSZ7AVCNFSM6AAAAABUUJTDE6VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNZUGA3DOMI>. You are receiving this because you authored the thread.