How to connect from App Platform to Google Cloud SQL?

My backend is running on Digital Ocean App Platform (node js).

I am trying to migrate my database (which the backend uses) from AWS to Google Cloud Platform (Google Cloud SQL).

I am struggling to connect, the connection from DO backend to the GCP database keeps timing out.

GCP has several methods for connecting, I have chosen SSL. Some time ago I was using SSL to connect to a database managed by Digital Ocean. So I think I know how to do it (even though it’s a bit tricky because certificates have to be in environment variables in a very specific format).

I am using Sequelize. The exact error is: [SequelizeConnectionError]: connect ETIMEDOUT 35.237.132.2:5432

This suggests to me that I didn’t even get to the point where certificates could be in a wrong format. I am simply not getting through.

I am out of ideas what to try. Any suggestions how to debug this appreciated.

It is possible that GCP requires both:

• SSL
• The backend’s IP address to be added to the list of “Authorized Networks” on GCP

I do not know how to do the latter. When I try to find the IP of the DO instance my App is running on, I get 10.244.16.191.

When I try to add that address to GCP’s whitelist, it says that it is already allowed by default and won’t let me add it.