Questions tagged [cloud-sql-proxy]

243 questions
1
vote
1 answer

Cloud SQL proxy cannot connect to a database using a second service account with same permissions

After following the tutorial Connecting [Postgres] from Kubernetes Engine, I was able to have my app server connect to my Postgres database thru a Cloud SQL Proxy and a service account that grants the "SQL Client", "SQL Editor" and "SQL Admin"…
1
vote
0 answers

cloud SQL proxy initialization actions while creating Dataproc cluster

I am executing the attached script, cloud-sql-proxy.sh, as part of initialization actions while creating Dataproc cluster; it fails with the below error: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet',…
1
vote
2 answers

How to use Service Account to authenticate with Google Cloud SQL Java

I am aware that there is Cloud SQL JDBC Socket Factory. However, that requires Application Default Credentials. What I am trying to do is to use a service Account(Which is the JSON secrets file) to authenticate with the Cloud SQL. Can someone please…
1
vote
1 answer

Sequelize-cli migration with non-standard unix sockets

I'm trying to get sequelize going on GAE. But am struggling with the cloud SQL proxy that uses sockets on non-standard paths. My understanding is that a url would get passed direct to the pg library, and based on this post, it would suggest the…
1
vote
1 answer

Optimal way to access CloudSQL without the clouds_sql proxy

I'm writing a service (Golang) that is meant to access a CloudSQL database. The recommended way to connect to the CloudSQL instance is to use the cloud_sql proxy - to authenticate with the database and handle the SSL. However, for performance and…
Dcompoze
  • 853
  • 1
  • 11
  • 19
1
vote
1 answer

Scaling Cloud SQL instances without cloud_sql_proxy update

The issue targets an SQL scaling problem. For Cloud SQL Proxy there are options and one of them is one to specify instances through instance metadata with -instances_metadata option. Despite -instances flag where we can specify a list of Cloud SQL…
1
vote
1 answer

Invalid grant when trying to connect to google cloud sql with django

I've been following the GAE tutorial for setting up a django project to run on app engine. I've finally gotten it to successfully run to makemigrations for my project, but I get a connection error in my google cloud sql proxy: 2017/06/25 15:12:07…
Kyle B.
  • 389
  • 1
  • 6
  • 22
1
vote
0 answers

ER_ACCESS_DENIED_ERROR when connecting to Cloud SQL using Cloud SQL Proxy on localhost

When I try running an npm init script on terminal to create a SQL table on Cloud SQL using a Cloud SQL Proxy on my localhost I get a: ER_ACCESS_DENIED_ERROR I can connect using Sequel pro but get that error connecting from terminal, would…
1
vote
1 answer

Google Cloud SQL ER_HOST_IS_BLOCKED

i'm getting some issues connecting to Cloud SQL from Container engine... I followed https://cloud.google.com/sql/docs/container-engine-connect tutorial and it all seems to work, though I had to tweak a few things with the password/user stuff being…
1
vote
3 answers

Google cloud dataproc failing to create new cluster with initialization scripts

I am using the below command to create data proc cluster: gcloud dataproc clusters create informetis-dev --initialization-actions…
1
vote
3 answers

Can't connect to Google Cloud SQL from Google Compute Engine with Cloud SQL Proxy

I'm trying to connect a GCE instance to a Cloud SQL instance (2nd gen) with Cloud SQL Proxy. When i ssh to the GCE instance and sudo ./cloud_sql_proxy -dir=/cloudsql I get 2016/07/13 18:59:28 Using gcloud's active project: xxxx-0000 2016/07/13…
0
votes
0 answers

Connecting to Cloud SQL (MySQL) From IPv6 Fails

My ISP uses ipV6 so I'm unable to connect to my CloudSQL instance with MySqlWorkbench. I can connect via gcloud but only after installing a proxy recommended (and only used) by gcloud. I've been told that I can: Install and use a proxy on my…
paiego
  • 3,619
  • 34
  • 43
0
votes
1 answer

running npx prisma migrate inside cloud build using cloud sql and cloud Run (MySql)

I have a remix run application and am using a cloud sql database with a public IP and Prisma as an ORM. I'm also using Cloud Run to host my application and cloud build for the build process. The issue I'm having is the ability to run migrations in…
James Daly
  • 1,357
  • 16
  • 26
0
votes
0 answers

Authentication error via IAM Authentication with GCP Cloud SQL

I am trying to authenticate my IAM user with my GCP Cloud SQL instance via ./cloud-sql-proxy. After the ./cloud-sql-proxy is ran and awaiting connections, I used VSC's SQLTools extension by Matheus Teixeira to add a connection to my DB…
0
votes
0 answers

sqlalchemy.exc.ArgumentError: Can't combine fixed host and multihost URL formats

When Connecting Postgresql db using sqlalchemy and cloud-sql-proxy but getting this error and connection string we used is below given with create_engine. "postgresql+psycopg2://{db_user}:{db_password}@{db_port}/{db_name}?host=cloud-sql-proxy" Any…