Questions tagged [cloud-sql-proxy]

243 questions
1
vote
0 answers

Cloud SQL Proxy connection timesout occasionaly

We use single-tenant architecture for our instances. Each instance contains 3 Django Apps i.e Django, Celery{worker, beat} and few other things that don't interact with the database. We deploy cloudsql-proxy as a sidecar for these django containers…
1
vote
1 answer

No schema show when logging into iam user via cloud sql proxy

I'm logging into a cloudsql instance via the cloud sql proxy and an iam database user. The authentication succeeds, but doesn't show me any schema / resources or anything in MySQLWorkbench. It's just completely blank. The iam user is a cloudsql…
spierce7
  • 14,797
  • 13
  • 65
  • 106
1
vote
1 answer

Google AppEngine(Flex) + Cloud SQL Auth Proxy — use different accounts for deploy and access Cloud SQL

I'm using maven plugin to deploy to AppEngine. I need to be logged in to gloud to be able to deploy services. I need to be logged in to gcloud to be able to use Cloud SQL Auth Proxy also. Now I don't see any way to set deployer account separately to…
1
vote
1 answer

cloud_sql_proxy gives "error reading config"... how do I fix this?

I have gcloud working in power shell: > gcloud version Google Cloud SDK 375.0.0 bq 2.0.74 core 2022.02.25 gsutil 5.6 I've been trying to follow these directions to get my Sql Management Studio to connect to a Google SQL…
D. A.
  • 3,369
  • 3
  • 31
  • 34
1
vote
1 answer

Authentication failure for Iam Authentication on Postgres Cloud SQL through jdbc Hikari

I am trying to connect to a Postgres Cloud SQL instance using JDBC SocketFactory per the documentation here : https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/blob/main/docs/jdbc-postgres.md HikariDataSource pool =…
user2405589
  • 881
  • 2
  • 14
  • 32
1
vote
3 answers

Unable to Access CloudSQL MYSQL5.7 From Service Account Using CLI

I have simple cloudsql instance for MYSQL_5_7 with enable_iam_authentication flag on. I have added service account or IAM user and want to access the instance using mysql client. I am using cloudsql auth proxy: ./cloud_sql_proxy…
1
vote
0 answers

Connection Refused Cloud SQL Proxy Docker

I am having an issue connecting my Django app to a Google Cloud Postgres database through Cloud SQL proxy when using Docker. The error I keep getting is 'connection refused'. Here's the error output cloud-sql-proxy_1 | 2021/12/30 19:11:30 current…
frelmaster
  • 11
  • 1
1
vote
3 answers

KnexTimeoutError: Knex: Timeout acquiring a connection

I get the following error when connecting to knex: KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? Here's my code: Api.js const Knex = require('knex'); const config =…
samuq
  • 306
  • 6
  • 16
1
vote
0 answers

Cloudsql-proxy error checking scopes and timeout awaiting response headers

I have a kubernetes job on GKE that uses cloudsql-proxy as a sidecar. I am using workloadIdentity for the connection: I have the GSA and KSA setup, and cloudsql-proxy works for the deployment but does not work for the jobs in the same namespaces and…
1
vote
1 answer

Error in establishing connection with GCP, cloud sql proxy through Windows cmd

I am trying to establish a Cloud SQL proxy connection with Google Cloud. Below is my package.json: { "name": "folder-name", "version": "1.0.0", "description": "", "main": "index.js", "scripts": { …
Hari Krishnan U
  • 166
  • 5
  • 16
1
vote
1 answer

Connecting to Google Cloud MySql DB with a changing IP address

I connect to a Google Cloud MySQL DB from my laptop, however my IP address not only changes at home, but also when I travel. I have to specify the allowed public ip address in Google Cloud, but every time I reconnect I have to log in & update google…
1
vote
1 answer

How do I install google cloud jdbc driver manually for the flyway cli?

Looking at this reference: https://docs.kony.com/konylibrary/konyfabric/kony_fabric_manual_install_guide/Content/FlywayNew.htm It says the Google Cloud SQL drivers need to be installed manually for the flyway cli, but how do I install them manually?…
red888
  • 27,709
  • 55
  • 204
  • 392
1
vote
3 answers

Which is the right way to run laravel migrations using Google Cloud Run and Google Cloud SQL

I came here to expose the specific way that i found to run migrations into a Google Cloud Run project using Google Cloud SQL and Laravel, which is simple, i just connect from my .env laravel to Cloud SQL (using Cloud SQL Proxy) and from my local…
1
vote
4 answers

Connecting to public Cloud SQL from a private GKE cluster

I'm trying to connect to a Cloud SQL instance with a public IP from a GKE cluster using cloud-sql-proxy. I created my cluster with the following commands: gcloud services enable compute.googleapis.com gcloud services enable…
1
vote
2 answers

Cloud SQL - PostgreSQL - Import failed due to the lack of superuser permission

I'm migrating all the role from my PostgreSQL hosted in GCE VM to Cloud SQL by generating dump file sudo -Hu postgres pg_dumpall -U postgres --globals-only --file=globals.sql When I import the same(globals.sql) in Cloud SQL I came across below…
Vipin
  • 847
  • 1
  • 10
  • 21