Prisma DATABASE_URL error (Cloud Run + Cloud SQL)

Question

I use Prisma with Cloud Run & Cloud SQL. After providing DATABASE_URL to the prisma.schema it throws me an error in runtime.

Can't reach database server at `(/cloudsql/project-name:us-east1:database-id)`:`5432`
Please make sure your database server is running at `(/cloudsql/project-name:us-east1:database-id)`:`5432`."

Database: Postgres
Provided url DATABASE_URL: postgresql://username:password@localhost/databasename?host=(/cloudsql/project-name:us-east1:database-id)

What is wrong with connection? Do I failed to construct DATABASE_URL correctly?

@JohnHanley I was able to manage this issue on my own. The problem was in brackets around the host parameter in the connection URL. I posted my solution as an answer to the question. — Roman Mahotskyi
– Roman Mahotskyi, Commented Jun 14, 2021 at 21:14

Roman Mahotskyi · Accepted Answer · 2021-06-14 21:13:26Z

9

I removed brackets () around host parameter /cloudsql/project-name:us-east1:database-id and everything start to work as expected.

Before (with brackets)

postgresql://username:password@localhost/databasename?host=(/cloudsql/project-name:us-east1:database-id)

After (without brackets)

postgresql://username:password@localhost/databasename?host=/cloudsql/project-name:us-east1:database-id

answered Jun 14, 2021 at 21:13

Roman Mahotskyi

6,9099 gold badges53 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nomadoda Over a year ago

For anyone who still has an error, my issue was incorrectly trying to connect to the "postgres" database. Create a new database for application data as suggested here

Collectives™ on Stack Overflow

Prisma DATABASE_URL error (Cloud Run + Cloud SQL)

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related