Questions tagged [cloud-sql-proxy]

243 questions
2
votes
1 answer

Connecting to Cloud SQL from Azure Data Studio using an IAM user

Following the instructions here, I'm having problem connecting to the DB from Azure Data Studio using the token I generate. It connects to the DB successfully, but as soon as I want to run a simple query ( I already gave my user read access there),…
2
votes
1 answer

Cloud SQL Proxy - Message: Insufficient Permission

I am facing below connectivity problem using cloud SQL proxy. I have followed detailed steps from this link https://codelabs.developers.google.com/codelabs/cloud-sql-connectivity-gce-private#0 Connecting SQL using private IP & service account. And I…
2
votes
1 answer

Unable to Bind Google Service Account to Kubernetes Service Account

I am trying to bind my Google Service Account (GSA) to my Kubernetes Service Account (KSA) so I can connect to my Cloud SQL database from the Google Kubernetes Engine (GKE). I am currently using the follow guide provided in Google's documentation…
2
votes
2 answers

Connectivity between Cloud Run and Cloud SQL (Internal IP)

I have created my organisation infrastructure in GCP following the Cloud Foundation Toolkit using the Terraform modules provided by Google. The following table list the IP ranges for all environments: Now I am in the process of deploying my…
2
votes
0 answers

Cannot connect to PostgresSQL through Google-Cloud-Proxy

I'm running a test Python script that uploads a small amount of data to a PostgreSQL database using SQL Alchemy. Apache Airflow (hosted by Google Cloud Composer) is running this script on a schedule. The script always runs totally fine whenever I…
Matt
  • 1,368
  • 1
  • 26
  • 54
2
votes
1 answer

GKE / Cloud IAM workload Identity setup error 403

We have setup a CloudSQL proxy as a sidecar container for one of our Java / Tomcat based app. Here's how we setup workload identity to enable our app to connect to CloudSQL through cloudsql proxy: Created Cloud IAM Service Account and gave it SQL…
2
votes
1 answer

What is the recomended way to connect spring boot application and google Cloud SQL?

When I read google documentation I see that the recommended way is using cloud sql proxy: To connect securely to Cloud SQL from Google Kubernetes Engine using a public IP address, you must use the Cloud SQL Proxy. From other side when I read…
2
votes
0 answers

Connecting SpringBoot to Cloud SQL in Cloud Run error, connection refused

I'm deploying my Maven Springboot project to Google Cloud Run and trying to connect to Cloud SQL from Cloud Run. I'm using https://github.com/spring-cloud/spring-cloud-gcp/tree/master/spring-cloud-gcp-samples/spring-cloud-gcp-data-jpa-sample as a…
2
votes
1 answer

Connect from Spring boot app running on Google Cloud Run to a Cloudsql without GCP starter

I have a Spring boot app running on Google Cloud Run, and I want to connect to a postgres instance running on Google Cloudsql. I am able to connect using Spring Cloud GCP starter project.
2
votes
1 answer

Cloud Composer issue loading DAG connecting to Cloud SQL

I've made a DAG which connects to Cloud SQL (MySQL) through a Cloud SQL Proxy installed on a GCE. It reads a list of tables and generates a number of tasks based on these. I've run this DAG in Airflow locally on my machine with success, but once I…
2
votes
1 answer

"new ephemeral certificate expires too soon: current time:"M

I've been connecting to Google Cloud Platform MySQL from the CloudSQL Proxy on Windows for years. All of a sudden, I'm unable to connect. When I start the proxy using PowerShell, it launches fine and says ready for new connections. Then when I try…
2
votes
4 answers

Is it possible to connect to Cloud SQL Proxy via Host Compute Engine VM's Internal or External IP?

I am testing the following configuration. Cloud SQL (tetsql-1) in Region X Zone A A Compute Engine VM (TestVM-1) in the same Region X Zone A. OS is Centos 7 Compute Engine VM is running cloud SQL proxy on non default port (9090) With the above…
Cyac
  • 447
  • 3
  • 15
2
votes
1 answer

Google API Insufficient authentication scope for MySQL proxy on Google Cloud

I am having a problem starting proxy for Google SQL. I installed proxy like this: $ wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 $ mv cloud_sql_proxy.linux.amd64 cloud_sql_proxy $ chmod +x cloud_sql_proxy $ sudo mkdir…
2
votes
1 answer

Connection between Private GKE and Cloud SQL

I have a Private GKE Cluster with a public master endpoint, which has jobs that needs access Cloud SQL. I have a cloud SQL proxy DaemonSet receiving on 3307, which connects to actual DB on 3306. My network doesn't have outbound internet, neither any…
2
votes
1 answer

GKE with gcloud sql postgres: the sidecar proxy setup does not work

I am trying to setup a node.js app on GKE with a gcloud SQL Postgres database with a sidecar proxy. I am following along the docs but do not get it working. The proxy does not seem to be able to start (the app container does start). I have no idea…