Questions tagged [cloud-sql-proxy]

243 questions
0
votes
1 answer

Error while connection cloudsql instance using Cloud SQL Auth proxy

I am trying to connect my CloudSQL(MySQL 8.0) database instance having private ip which in GCP using Automatic IAM database authentication and Cloud SQL Auth proxy Iam getting this error access denied for user when accessing db using Heidisql…
0
votes
1 answer

GCP: Connection to Cloud SQL

I have an architectural issue with Cloud SQL. We have an API that is running in a GKE cluster in a network A and a cloud SQL instance in a network B. The current network config doesn't allow peering between these 2 networks. Is there any possibility…
Max
  • 175
  • 1
  • 8
0
votes
1 answer

GCP SQL proxy Unable to generate access token; IAM returned 403 Forbidden: The caller does not have permission

I'm having a k8s deployment on GCP, and I'm connecting to the SQL database with SQL proxy. I'm deploying with a service account. I gave the service account owner permissions (it's just a test project), and CloudSQL client, CloudSQL instance user,…
Gergő Horváth
  • 3,195
  • 4
  • 28
  • 64
0
votes
0 answers

I want to connect multiple cloud sql instance having private ip to my local machine or locally on Mysql workbench then how can i do that..?

I want multiple sql cloud instances to be connected to be connected to msql workbench and if possible without the use of virtual machine even if the solution is there by using virtual machine then do let me know I have connected one cloud sql…
0
votes
0 answers

GCP Cloud SQL, accidentally granted perms from IAM account to Postgres account, now locked out

Ran this while trying to manage some permissions with Cloud SQL IAM users: GRANT "****@*****.iam" to postgres; Now it appears that my postgres account is an IAM user in the DB. And I can't change it back because I can't log in with my original…
0
votes
1 answer

Google cloud sql proxy can't find service account

I'm trying to connect to google cloud SQL using cloud_sql_proxy, I've followed the steps that google provided. I have a service account in the directory I'm running my commands on and I ran this command first: export…
Turgut
  • 711
  • 3
  • 25
0
votes
2 answers

GKE with CloudSQL using Cloud proxy job is not in COMPLETED status

I am trying to connect CloudSQL from Kubernetes cluster using Cloud proxy with Sidecar container pattern. Both the proxy and Cloudsql containers are in a same pod and they both are successfully running. But the cloudproxy container is always…
0
votes
1 answer

GCE Metada not defined

Im trying to set up a Postgresql prometheus exporter running a cloud sql auth proxy sidecar on my GKE cluster, however my auth proxy fails with the following error. So far, I've tried giving the workload identity more access (i was using the…
0
votes
1 answer

CloudSQL auth proxy as a service instead of sidecar in Kubernetes cluster

I am trying to move away from cloudsql proxy using it as a sidecar to separate service. Followed all the steps mentioned in here https://github.com/GoogleCloudPlatform/cloud-sql-proxy/tree/main/examples/k8s-serviceafter deploying in kubernetes…
0
votes
1 answer

cloud_sql_proxy uses unspecified credential file instead of gcloud auth login

My computer rebooted and for some reasons I ignore, cloud_sql_proxy tries to use a credential file instead of my gcloud auth login: cloud_sql_proxy --instances=instance:region:orcadb=tcp:54321 2022/09/06 12:43:07 Rlimits for file descriptors set to…
0
votes
1 answer

Network Policy for GCP Cloud MySQL Proxy

I am trying to write some Network Policies for my App, but the database connection fails as soon as I add my policy. Here is said that the MySQL Proxy uses Ports TCP:3307 and 443 https://cloud.google.com/sql/docs/mysql/sql-proxy#how-works kind:…
Tim Schwalbe
  • 1,588
  • 4
  • 19
  • 37
0
votes
1 answer

cloud sql(proxy) very slow in php codeigneiter

i have a mysql connection using clud sql from Googlle cloud platform that i am using in my php(codeigneiter) application and i connect through cloud sql proxy. this instance has the following resources : 4 vcpu and 16 RAM. the problem i have is that…
0
votes
2 answers

Unable to uninstall / install / use the gcloud cli

I had been happily using the gcloud cli on my macbook running on macOS Monterey version 12.4 I did a brew upgrade which seems to have broken the gcloud cli, its either the brew upgrade or a python install which I did, any info on how to narrow this…
0
votes
0 answers

Google Cloud SQL — irregular authentication failures

I have an App Engine Flex java service (REST backend, 1 instance, always up) which connects to Cloud SQL instance using IAM authentication (service account). Everything seems to work fine most of the time but sometimes I'm having timeouts on REST…
0
votes
1 answer

Google Cloud SQL shared or individual database user accounts when using cloud-sql-proxy

Since the cloud-sql-proxy already forces individual user authentication with the database through a users iam account, and allows specifying read / write permissions, it seems potentially pointless to also have an individual database accounts for…
spierce7
  • 14,797
  • 13
  • 65
  • 106