CODEWITHSUNDEEP
google-cloud-sqlgoogle-cloud-runprisma
Roman Mahotskyi
Roman Mahotskyi

Reputation: 6625

Prisma DATABASE_URL error (Cloud Run + Cloud SQL)

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`."

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

Upvotes: 4

Views: 4584

Answers (1)

Roman Mahotskyi
Roman Mahotskyi

Reputation: 6625

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

Upvotes: 9

Related Questions