GCP Cloud Run Cloud - Cloud SQL instance "${process.env.INSTANCE_CONNECTION_NAME}" is not reachable

Question

I am getting the above error when trying to connect to a cloud sql instance that is sitting in another project. This then also throws the following error in the logs:

ENOENT /cloudsql/${process.env.INSTANCE_CONNECTION_NAME}/.s.PGSQL.5432

The connections in Cloud Run have been set up and points to the instance in the other project:

Cloud run connections

Additionally the service account used for this deployment has Cloud SQL Client permissions in both its own project and the one where the SQL instance is.

Finally the environmental variable is also set in cloud run and has the correct instance connection name.

I originally tried to get this working on an existing deployement with no luck and then also deployed it from scratch, but the same errors keep occuring.

The application is node.js based with sequelize as ORM.

Any help would be much appreciated.

One thing to make sure is that you have the Cloud SQL Admin API enabled within both Google Cloud projects. — Jack Wotherspoon
– Jack Wotherspoon, Commented Jul 6, 2022 at 17:32
@JackWotherspoon I had checked that too and the API is enabled in both projects — nm_machine89
– nm_machine89, Commented Jul 7, 2022 at 6:21
@nm_machine89 is the Cloud SQL instance setup for public or private IP? — Jack Wotherspoon
– Jack Wotherspoon, Commented Jul 7, 2022 at 13:03

nm_machine89 · Accepted Answer · 2022-08-18 14:50:26Z

0

I've manged to solve this, the problem was in the config.js with the connection strings.

Intially the connection string was like:

username: process.env.DB_USER,
password: process.env.DB_PASS,
database: process.env.DB_NAME,
host: '/cloudsql/${process.env.INSTANCE_CONNECTION_NAME}',
dialect: 'postgres',
dialectOptions: {
  socketPath: '/cloudsql/${process.env.INSTANCE_CONNECTION_NAME}'
}

It seems that Cloud Run was not able to read the INSTANCE_CONNECTION_NAME. I changed this to:

username: process.env.DB_USER,
password: process.env.DB_PASS,
database: process.env.DB_NAME,
host: process.env.INSTANCE_CONNECTION_NAME,
dialect: 'postgres',
dialectOptions: {
  socketPath: process.env.INSTANCE_CONNECTION_NAME
}

and set the INSTANCE_CONNECTION_NAME to include the /cloudsql/ portion and voila it worked.

answered Aug 18, 2022 at 14:50

nm_machine89

112 bronze badges

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

1 Comment

gsouf Feb 23 at 13:16

It's because you used single quotes instead of backquotes. You have to use backquotes to have string interpolation developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/…

Collectives™ on Stack Overflow

GCP Cloud Run Cloud - Cloud SQL instance "${process.env.INSTANCE_CONNECTION_NAME}" is not reachable

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