Questions tagged [cloud-sql-proxy]
243 questions
1
vote
1 answer
sequelize connection timeout with cloud sql proxy in node.js
Running a local config, the connection works fine. I've installed and have a cloud_sql_proxy running and ready for new connections.
Here's my sequelize connection code:
const sequelize = new Sequelize(DB_NAME, DB_USER, DB_PASS, {
dialect:…
jct
- 69
- 3
- 11
1
vote
0 answers
Cloud-sql-proxy go binary returns 404
I am trying to run cloud_sql_proxy installed as a binary from go get, but I always get a 404 Error.
I have followed the instructions at https://github.com/GoogleCloudPlatform/cloudsql-proxy, but with no luck.
$GOPATH/go/bin/cloud_sql_proxy…
Cristian Ciobotea
- 447
- 6
- 16
1
vote
1 answer
Can I use the cloudsql-proxy to connect to a custom VM running postgres?
I have a custom Postgres instance running on a GCE VM. I am not using CloudSQL. I'd like to use the functionality provided by the cloudsql-proxy, but when I specify my custom instance the proxy fails.
googleapi: Error 404: The Cloud SQL instance…
dk.
- 2,030
- 1
- 22
- 22
1
vote
1 answer
CloudSQL Proxy intermittently refuses connection
I'm using a Cloud SQL proxy sidecar on my nodejs API service.
It appears to work great, except that approximately 1% of my API requests come back with an error indicating that the DB connection failed with:
connect ECONNREFUSED 127.0.0.1:3306
My…
user684934
1
vote
1 answer
Comparison of ways to connect to Google Cloud SQL database from GKE
I have been exploring ways to securely connect to Google Cloud SQL database. We use Google Kubernetes Engine for deployment of our Java Spring application.
So, https://cloud.google.com/sql/docs/mysql/connect-kubernetes-engine mentions of two methods…
user5155835
- 4,392
- 4
- 53
- 97
1
vote
1 answer
Unable to connect CloudRun service to CloudSQL instance ( Nodejs-Express-Typeorm ) server
I'm having issues connecting my node-express-typeorm server with CloudSQL Postgres instance using CloudRun.
I have successfully added the database proxy based on the official doc: https://cloud.google.com/run/docs/configuring/connect-cloudsql
And…
slovakyan
- 41
- 5
1
vote
0 answers
How to execute PostgreSQL SELECT query using cloud sql in cloud composer's airflow?
I am new to cloud composer & I want to execute one PostgreSQL SELECT query using gcp_cloud_sql hook in cloud composer's airflow. I tried with CloudSqlQueryOperator but it doesn't work with SELECT queries.
I want to create DAGs on basis of results I…
Aniruddha Dwivedi
- 91
- 1
- 2
- 13
1
vote
1 answer
How to Spin up a cloud proxy in cloud composer cluster
How to spin up cloud proxy for cloud composer cluster
Currently we use airflow to manage jobs and dynamic DAG creation. For this, one separate Dag is written to check database table in PostgreSQL for existing rules & if rule is active/inactive in…
Aniruddha Dwivedi
- 91
- 1
- 2
- 13
1
vote
3 answers
GKE private cluster and cloud sql proxy connection
I have 2 GKE cluster both private and public and using cloudproxy as sidecar container for gke app to access cloudsql instance.
public cluster setup for development/testing
Cloud SQL is enabled with both private and public IP.
GKE app is using…
Neeraj Kumar
- 836
- 1
- 10
- 29
1
vote
1 answer
Google cloud_sql_proxy keep my connection alive
I'm making a connection between a Google Compute Engine instance and a Google Cloud SQL instance, using the Cloud SQL Proxy.
Using this tutorial, I have managed to establish a connection by running this command:
./cloud_sql_proxy…
Makamu Evans
- 491
- 1
- 10
- 25
1
vote
3 answers
How to connect to cloud sql from containered application in gcloud?
I'm using GCloud, I have a kubernate cluster and a cloud sql instance.
I have a simple node.js app, that uses database. When I deploy with gcloud app deploy it has an access to a database. However, when I build a dockerimage and expose it, it cannot…
Rico
- 362
- 1
- 4
- 18
1
vote
2 answers
cloud-sql-proxy for GCP Dataproc fails, nc: connect to localhost port 3306 (tcp) failed: Connection refused
I am using Terraform to create a dataproc cluster that uses a GCP cloudsql instance as the hivemetastore, the terrafrm project creates the cluster and all its prerequisites (network, service account, cloudsql instance & user,…
jamiet
- 10,501
- 14
- 80
- 159
1
vote
1 answer
How to use Cloud SQL Proxy with a regular user account?
Google's Cloud SQL Proxy uses service accounts to login.
That's nice, but does not give you visibility as to who is the actual user that accessing the DB, for security purposes.
How can I use "regular" users credentials with Cloud SQL proxy?…
kalugny
- 1,309
- 1
- 9
- 9
1
vote
0 answers
Connecting to Google cloud mysql instance from GKE cluster using cloudsqlproxy
I have two projects in GCP viz. project1 and project2
I have setup mysql instance in project1.
I have also setup cloudsqlproxy (pod) and mypod in a GKE cluster in project2.
I want to access mysql instance frommypodthroughcloudsqlproxy`.
I have the…
kosta
- 4,302
- 10
- 50
- 104
1
vote
3 answers
When connecting using Cloud SQL Proxy, ERROR 2013 (HY000): Lost connection to MySQL server at error occurs
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 "Internal error/check (Not system error)"
· The OS is debian 8.
· Cloud SQL and Compute Engine are identical projects.
· The Compute…
o.fuji
- 11
- 4