Questions tagged [cloud-sql-proxy]

243 questions
0
votes
1 answer

Can Cloud SQL Proxy connect a VM and Instance on different VPCs?

I have a Cloud SQL instance with a private IP located on a VPC. I have a Compute Engine (VM) located on a different VPC. When I login to the VM and try to establish a Cloud SQL Proxy connection it appears to be successful. It displays: [root@mr-vm…
0
votes
1 answer

connectiong to a cloudSQL private IP instance without creating a new VM instance

I was wondering if there's any possible solution to connect a GCP AIP tunnel to a DB (Cloud SQL Proxy) when the DB has no public IP. I don't want to create a new VM for this purpose so I'm only interested in solutions that don't require me to use a…
0
votes
2 answers

Sqlcmd error while connecting with SQL Server instance on a VM using SQL Server proxy

I have created a private SQL Server instance and trying to access it on Virtual Machine instance using SQL Server proxy using the link (https://cloud.google.com/sql/docs/sqlserver/connect-instance-private-ip) on GCP platform It worked well but today…
0
votes
1 answer

GKE Django MySQL is not accessible during rolling update

I have Django application deployed in GKE. (Done with this tutorial) My configuration file: myapp.yaml apiVersion: apps/v1 kind: Deployment metadata: name: myapp labels: app: myapp spec: replicas: 3 selector: matchLabels: app:…
0
votes
2 answers

SSL connection required for plugin "mysql_clear_password". Check if 'sslMode' is enabled

While connecting to Cloudsql DB via auth proxy from java application I am getting below error. Caused by: java.sql.SQLException: SSL connection required for plugin "mysql_clear_password". Check if 'sslMode' is enabled. Not able to get through mysql…
0
votes
1 answer

Cloud SQL Server connection

I have Cloud SQL instance(16 vCPUs, Memory 128 GB, SSD storage 300 GB). Db size 110GB. When I execute a complex query from the cloud windows VM using SQL Server Management Studio(this vm is in the same VPC as SQL Server), it always takes on average…
Daria
  • 51
  • 5
0
votes
1 answer

Cant connect to Cloud SQL from Cloud Composer

I am trying to retrieve data from Cloud SQL via Cloud Composer DAG to GCS. I tried giving the public/private ip of the cloud sql instance in the airflow mysql_conn connection. MySQLdb._exceptions.OperationalError: (2003, "Can't connect to…
0
votes
1 answer

How can I revoke a PostgreSQL connection access to a database

So far I have a user called test_user as shown in the image below, this user owns test_db: I want to revoke the user's privileges from another database I have, let's call it main_db. Revoke all on database main_db from test_user; why connected as a…
floormind
  • 1,868
  • 5
  • 31
  • 85
0
votes
1 answer

GKE networkpolicy for cloudsql_proxy

I tried to use NetworkPolicy on GKE. My pod api has API application and cloudSql proxy image: myapi name: myapi ports: - containerPort: 3001 - command: - /cloud_sql_proxy -…
Ryo
  • 485
  • 1
  • 8
  • 26
0
votes
1 answer

GCP using VM to connect to Cloud SQL via Cloud SQL Auth Proxy Private IP

I am having problems connecting a GCP Compute Engine VM to a Cloud SQL instance configured with private IP (no public) via Cloud SQL Auth Proxy. After executing $ ./cloud_sql_proxy -instances=INSTANCE_CONN_NAME=tcp:3306 I see the following…
0
votes
1 answer

GCP Cloud SQL Proxy times out: connectex

So I have been using the cloud_sql_proxy for a while now for a local development environment and never had any issues (over a year). I tried to connect today, and it authenticates fine. Yet, connecting to the local port gives a connectex error: A…
0
votes
2 answers

I can't connect in GCP by sql auth proxy from cloudrun to cloud sql by springboot application. Somebody have an example stepbystep?

I can configure connection from local machine using sql auth proxy but I can't from cloud run springboot application with hikaricp to a cloud sql with public ip using unix socket. Somebody have a complete example? I read in gcp doc that I don't need…
0
votes
1 answer

Running nodejs Script to create table from local machine terminates Cloud SQL connection

I am trying to run the command node createTable.js $DB_USER $DB_PW $DB_NAME $CLOUD_SQL_CONNECTION_NAME from windows power shell as it is indicated in the Google cloud Platform nodejs samples for connecting to cloudsql from cloudrun using knex in…
Urchboy
  • 725
  • 2
  • 12
  • 26
0
votes
0 answers

Why do my cloudsql postgres users have access to all databases?

I'm trying to follow the docs for setting up the IAM postgres integration with cloudsql: https://cloud.google.com/sql/docs/postgres/create-manage-iam-users#grant-db-privileges But this is tripping me up. I create a user like this: gcloud alpha sql…
red888
  • 27,709
  • 55
  • 204
  • 392
0
votes
1 answer

can't connect to MySQL with GCP VM Instance docker ERROR 2002 (HY000)

I have a VM instance booting on container optimised OS and with the following Startup script: docker pull gcr.io/cloudsql-docker/gce-proxy:1.16 docker run -d \ -p 0.0.0.0:3306:3306 \ gcr.io/cloudsql-docker/gce-proxy:1.16 /cloud_sql_proxy \ …