Upon trying the sample code here: https://cloud.google.com/sql/docs/postgres/connect-app-engine-standard#connect-connectors ... And here: https://cloud.google.com/sql/docs/postgres/iam-logins ... The connection times out when using the private IP (but correctly resolves the private IP using the instance name), and the same code with the public IP (by…
I am following this tutorial: Connect to Cloud SQL for MySQL from Google Kubernetes Engine. I have created a cluster. I have created a docker image in the repository. I have created a database. I am able to run my…
The code language I'm using is Terraform (Hashicorp Configuration Language or HCL) as the 'infrastructure as code' to automate the process of GCP creating everything for the server stack, and Helm charts for the M2 application. I've gotten as far…
I'm trying to connect a Google Cloud Function (Gen 2, nodejs 18) to a CloudSQL mySQL database. They are both in the same Project and in the same region in Google Cloud. Frankly, I'm wrapped around the axle trying to…
I'm using Spring Boot App which is deployed on Cloud Run (GCP). The app is establishing the database connection through Cloud SQL Proxy using IAM authentication. The goal is to implement Unix Socket Connection instead of TCP for connecting with…
I'm trying to connect with my Google Cloud Sql db using google.cloud.sql.connector, and this is the code to connect: def getconn(): with Connector() as connector: conn = connector.connect( instance_connection_name, "pg8000", user = db_user, password = db_pass, db = db_name, ip_type…
I'm getting this error when I try and connect caught error @ main Error: connect ENOENT /cloudsql/<PROJECT ID>:us-central1:<DB NAME>/.s.PGSQL.5432 This is what my typeorm config file looks like const config2 = { database: <DB NAME>, entities: Object.values(entities), host: '/cloudsql/<project id>:us-central1:<db…
`db = MySQLdb.connect( host = '12.34.567.891', user = 'root', passwd = '', db = 'testdb', port = "something-that-works")` Very Simple Can I somehow make it so that it connects only to the ip '12.34.567.891'. Google is forwarding the port to…
I have a running CloudSQL instance running in another VPC and a nginx proxy to allow cross-vpc access. I can access the db using a built-in user. But how can I access the DB using a Google Service Account? import…
My application works fine most of the time in GCP's K8's but the weird thing is from time to time it is starts to throw connection not available errors, even though many connections are available. DB connections are set to…