Prisma SASL authentication failed

Support
1

I am migrating over from railway and did all the pg_restore stuff properly as I can view the data in the Neon console. However when I try to connect, even when copy/pasting the given prisma env strings, I get

Invalid `prisma.function.findMany()` invocation:

Error querying the database: db error: ERROR: SASL authentication failed

My envs look like this. I have already changed the passwords, but those are the old nonfunctional ones. I have also tried without schema=public, same result.

DATABASE_URL=postgres://postgres:x6dy0ZKBmevA@ep-morning-frost-16595280-pooler.us-west-2.aws.neon.tech/neondb?schema=public&pgbouncer=true&connect_timeout=10
DIRECT_URL=postgres://postgres:x6dy0ZKBmevA@ep-morning-frost-16595280.us-west-2.aws.neon.tech/neondb?schema=public&connect_timeout=10
2

I made a new db and role and it works. Maybe the pg_dumped railway one is bad.

2 Likes
3

Hey @DonkeyBlaster! Glad to hear that the issue is resolved :smile:

1 Like