What is the Postgres DATABASE_URL to connect cloud run to postgres on cloud SQL

Question

I am trying to connect my cloud run app to cloud sql, here is my cloudbuild.yaml

steps:
- name: 'gcr.io/cloud-builders/npm'
  env:
    - DATABASE_URL=$_DATABASE_URL
  entrypoint: npx
  dir: './server'
  args:
    - 'prisma'
    - 'migrate'
    - 'deploy'

However, I keep on getting the error Please make sure your database server is running at '/cloudsql/learninfra001:us-central1:learninfra001-postgres':'5432'. Here is the _DATABASE_URL I use for substitution variable postgresql://postgres:password@localhost/db?schema=public&host=/cloudsql/learninfra001:us-central1:learninfra001-postgres I have made sure the following:

The default cloud run service account has Cloud SQL Client role
The database db is created
Within the cloudrun service, under connections, the Cloud SQL connections is pointing to the correct instance (learninfra001:us-central1:learninfra001-postgres)

Using white-listed public IP, I am able to connect to the DB. However, I just can't seem to get cloud run to work. Is there anything else I could check? Or is there a way to get more logging to see why it is not connecting?

Does this answer your question? Prisma DATABASE_URL error (Cloud Run + Cloud SQL) — Robert G
– Robert G, Commented Nov 14, 2022 at 21:25
Hey @RobertG I updated my question. Unfortunately that didn't work for me. Do you have any other ideas I could try? — Max Yuan
– Max Yuan, Commented Nov 18, 2022 at 3:11
for mysql for my database_url secret/env variable - I had to add the query string ?socket=/cloudsql/{connectionname} connection name being the instance name you can copy from the console in cloud sql — James Daly
– James Daly, Commented Aug 17, 2023 at 16:50

enocom · Accepted Answer · 2022-11-19 15:57:46Z

3

In short, you'll need to enable a Cloud SQL connection to your Cloud SQL instance from Cloud Build.

See https://cloud.google.com/sql/docs/mysql/connect-build for details.

edited Nov 19, 2022 at 15:57

answered Nov 14, 2022 at 22:39

enocom

1,8861 gold badge18 silver badges24 bronze badges

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

7 Comments

Max Yuan Over a year ago

I tried to use this but it still unable to connect. This is the link that I tried to use.

postgresql://postgres:password@localhost/db?schema=public&host=/cloudsql/learninfra001:us-central1:learninfra001-postgres

I have made sure service account has cloud sql client role and that cloud run cloudsql connections is pointing to the right cloud sql instance. During cloud build, I am still getting Please make sure your database server is running at '/cloudsql/learninfra001:us-central1:learninfra001-postgres':'5432'. What else should I look into? @enocom

enocom Over a year ago

Looks like you're trying to connect to Cloud SQL from Cloud Build (not Cloud Run). Your URL will work for Cloud Run. For Cloud Build see cloud.google.com/sql/docs/mysql/connect-build where you can enable the Cloud SQL Proxy as part of your migrate step.

Conrad747 Jun 27 at 10:06

This is a very useful comment. Thanks for sharing.

Max Yuan Over a year ago

Got it to work! You are amazing! cloud.google.com/sql/docs/mysql/connect-build is exactly what I needed!

Kromel Over a year ago

@MaxYuan can you share your solution?

Max Yuan Over a year ago

- id: 'migrate-socket-and-migrate-db' name: '${_IMAGE_NAME}-proxy' dir: './server' entrypoint: '/bin/bash' args: - '-c' - | set -a source .env set +a /cloudsql/cloud_sql_proxy -instances=$$SQL_INSTANCE_CONNECTION_NAME -dir=/cloudsql & sleep 2; npx prisma migrate deploy

|

Collectives™ on Stack Overflow

What is the Postgres DATABASE_URL to connect cloud run to postgres on cloud SQL

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related