Questions tagged [cloud-sql-proxy]

243 questions
0
votes
0 answers

Unable to connect with Cloud SQL using cloudsql-proxy from another container running NodeJs server

Unable to connect with Cloud SQL using cloudsql-proxy from tenderflow-server. The tenderflow-server container (Nodejs server) fails to connect with cloudsql-proxy. But both of the containers running fine. Here is the docker-compose.yaml version:…
Rwitesh Bera
  • 389
  • 2
  • 3
  • 9
0
votes
0 answers

FATAL: Cloud SQL IAM service account authentication failed for user

I'm trying to access a cloud SQL db using passwordless auth through an IAM user, however, I keep getting FATAL: Cloud SQL IAM service account authentication failed for user. There is another Postgres DB instance that has the same config and auth is…
0
votes
0 answers

What is the best approach to run CRON jon and GCP Cloud SQL Proxy in kubernetes

I hope y'all doing great! I came to a hard time looking for the best way to solve this problem in my project, and finally, I've collected my courage to post this question in Stackoverflow (please don't bully me). I have a cron job that runs the job…
0
votes
0 answers

Google Cloud SQL Proxy issue - tls: server selected unsupported protocol version 303

I've been connecting to Google Cloud SQL Postgres Instance from the CloudSQL Proxy on Windows for years. All of a sudden, I'm unable to connect When I start the proxy using Cloud SDK, it launches fine and says ready for new connections. Then when I…
0
votes
0 answers

run cloud sql proxy in dataflow job and connect using proxy at run time

I am looking to connect to the GCP cloud SQL database using cloud-sql-proxy from the dataflow job. In order for a dataflow worker node to connect cloudsql I need to set up and run a proxy in each worker node as setup.. how to achieve this with…
vkt
  • 1,401
  • 2
  • 20
  • 46
0
votes
1 answer

Unable to Set up connection with Cloud SQL instance via casbin-sequelize-adapter

I am trying to connect my microservice with the CloudSQL instance via casbin-sequelize-adapter. Following is the code - await SequelizeAdapter.newAdapter({ username: process.env.DB_USER, password: process.env.DB_PASS, database:…
0
votes
3 answers

Spring Boot & GCP Cloud SQL Connection Issue

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…
0
votes
0 answers

launch artisan command in Cloud Sql Proxy

I have some problem with launching migration on my cloud sql proxy. I deploy my containeur which is working and after the deploy I start a connection with my cloud-sql-proxy. Cloubuild.yaml - name: "gcr.io/google-appengine/exec-wrapper" args: …
0
votes
2 answers

Unable to Deploy MLFlow On Cloud Run and Connect to CloudSQL via Unix Socket Connection

I am trying to deploy MLflow on Cloud Run. The Cloud Run Service needs to be connected to CloudSQL. I am trying to establish the connection by running CloudSQL proxy in the same docker container and connecting ML flow with the same. In the logs I am…
0
votes
1 answer

Stop Read Replica Instance on GCP CloudSQL

To stop a cloudsql instance gcloud sql instances patch INSTANCE_NAME --activation-policy=NEVER We tried and it failed for read replicas instances ERROR: (gcloud.sql.instances.patch) HTTPError 400: Invalid request: Invalid flag for instance role:…
0
votes
1 answer

Google Application Credential error clod sql proxy

I have created a PostgreSQL cloud instance with public ip. I have added my home ip into whitelist. I have installed the cloud proxy SQL like Google doc. When I run the proxy, I get this error: The proxy has encountered a terminal error: unable to…
dev_
  • 395
  • 1
  • 3
  • 16
0
votes
0 answers

How to DML to a PostgresSQL db in a Private Subnet via GCP Cloud SQL Auth Proxy? Try to connect via Third Party Applications like DBeaver, get stuck

I have a PostgresSQL DB in a private subnet in a VPC. I want to do DML operations from my local environment. I installed Google SDK in order to create a VPN connection to the private instance. And run the command: C:\Program Files (x86)\Google\Cloud…
0
votes
2 answers

"flag provided but not defined: -enable_iam_login" when try to start google cloud sql proxy

I'm trying to connect Public cloud SQL instance using Cloud SQL IAM database authentication. I have enabled "cloudsql_iam_authentication" flag and created a IAM service account granting necessary role I followed this documentation:…
0
votes
0 answers

Datastream in Project-A, CloudSQL in Project-B

I'm trying to configure Datastream to enable streaming data from CloudSQL to the BigQuery. Our CloudSQL instance in the project-A, Datastream in the project -B. Project-A has vpc-A which is peered with vpc-B in the Project-B. vpc-A has cloudsql_auth…
0
votes
0 answers

GCP - Identify which IAM user executes a Cloud SQL connection in the logs

We would like to identify which IAM user executes a Cloud SQL Proxy connection in the logs. However, we can see this message: "textPayload": "2022-11-14 10:41:29.849 UTC [358324]: [1-1] db=[unknown],user=[unknown] LOG: connection received:…