Questions tagged [cloud-sql-proxy]

243 questions
0
votes
2 answers

how to shut down cloud-sql-proxy in a helm chart pre-install hook

I am running a django application in a Kubernetes cluster on gcloud. I implemented the database migration as a helm pre-intall hook that launches my app container and does the database migration. I use cloud-sql-proxy in a sidecar pattern as…
0
votes
1 answer

Unable to connect to CloudSql from my Kuberernetes Cluster through cloudsqlproxy sidecar

while trying to connect to my cloudsql instance I am getting this error { errorno: "ETIMEDOUT", code: "ETIMEDOUT", syscall: "connect", fatal: true } this is the log from my cloudsqlproxy container 2020/06/09 15:53:04 current FDs rlimit set to…
0
votes
1 answer

Cloud SQL Proxy: occasional connection timeouts under load

Problem Under high load, our Cloud SQL Proxy occasionally hits this: 2020/06/05 13:35:47 couldn't connect to "my-cloudsql-instance": dial tcp xx.xx.xx.xx:3307: connect: connection timed out Context Kubernetes cluster with an Airflow pod that starts…
0
votes
2 answers

Storing Application Default Credentials securely in KMS

We have a Java app which uses Google Auth to allow uses in. The app needs to connect to a Google Cloud SQL database which is locked down behind IP restrictions. We need to use Cloud SQL Socket Factory with Cloud SQL Proxy to get access to the…
0
votes
1 answer

MySql: ERROR 1045 (28000): Access denied for user using passwrod YES using cloud_sql_proxy

I need to execute a sql file using the mysql client in a python script (I can not execute the queries using a python mysql module), the database is a MySQL instance on GCloud, I'm connecting to that instance using cloud_sql_proxy. I launched…
Hrabal
  • 2,403
  • 2
  • 20
  • 30
0
votes
1 answer

SQL Server Management Studio Ignores Windows Proxy for connection

I'm using corporate VPN when connecting to Azure SQL Server DB. When I'm trying to establish the connection using SQL Server Management Studio 2019, the 'Connect to server' dialogue is showing me that I'm trying to connect using my original Dynamic…
0
votes
1 answer

Access Denied for user in MySql while connection through sqoop

For self learning purpose,I am trying to create a end to end dataflow in Google cloud: 1.Creating a mysql table using cloud sql 2.Using dataproc to create a temporary cluster to run the sqoop job using template. 3.Put the extracted data in BQ from…
Durga
  • 127
  • 11
0
votes
0 answers

how to connect to cloud sql of another project in gcp

"; echo "IdFirstnameLastname"; class TableRows extends RecursiveIteratorIterator { function __construct($it) { …
0
votes
1 answer

Access a postgresql instance set up on GCE from local host via proxy

Can I access a PostgreSQL instance set up on Google Cloud Engine from my local host via Cloud SQL Proxy or another way? I'm trying to move a PostgreSQL database from Cloud SQL to Compute Engine for testing purposes. So far, I 've been using Cloud…
0
votes
1 answer

Why won't mysql-client connect to the GCP cloud_sql_proxy via a docker-forwarded tcp port?

The Gist I have an application that wants to connect to a mysql database via a tcp port. I'm building a docker container which stages cloud sql instances for it to connect to (the databases contain test cases imported from elsewhere). I expect to…
MatrixManAtYrService
  • 8,023
  • 1
  • 50
  • 61
0
votes
1 answer

How to configure communication between standard env app-engine & cloudsql instance with internal ip

I configure a serverless vpc,& launch the app with following app.yaml. But unable to communicate the private sql instance. runtime: python37 service: xxxx entrypoint: gunicorn main:app --bind 0.0.0.0:$PORT --worker-class…
0
votes
1 answer

Google Cloud, Kubernetes and Cloud SQL proxy: default Compute Engine service account issue

I have Google Cloud projects A, B, C, D. They all use similar setup for Kubernetes cluster and deployment. Projects A,B and C have been build months ago. They all use Google Cloud SQL proxy to connect to Google Cloud SQL service. Now when recently I…
0
votes
3 answers

Unable to connect to CloudSQL instance that is part of a VPC network

I have created a CloudSQL instance which was part of a VPC I have created. I'm able to connect to this CloudSQL using CloudSQL Proxy service. But I'm unable to connect to this instance using public IP of the instance though I added the firewall…
Nandakishore
  • 981
  • 1
  • 9
  • 22
0
votes
1 answer

Goroutine opening a new connection to database after each request (sqlx) and ticker

Let's consider the following goroutine: func main(){ ... go dbGoRoutine() ... } And the func: func dbGoRoutine() { db, err := sqlx.Connect("postgres", GetPSQLInfo()) if err != nil { panic(err) } defer…
0
votes
2 answers

Can't connect to Cloud SQL using node-postgres

I've been trying to connect to my Cloud SQL instance using the pg module but haven't been successful so far. I've looked around a lot online but couldn't understand much on the topic. I also would like to deploy my Express app on Cloud Run at some…