Questions tagged [cloud-sql-proxy]

243 questions
0
votes
1 answer

Docker image with Spring boot fails to connect to CloudSQL

I want to create web services with Spring boot, add it to docker image, connect to cloud sql and then run on Compute Engine. I am using docker compose to combine the image for project and cloud sql proxy image. However, no matter what jdbc URL I…
0
votes
1 answer

Cloud SQL Proxy in a Kubernetes cluster: What Service-account Permissions are needed?

I'm following a guide by google (https://github.com/GoogleCloudPlatform/cloudsql-proxy/blob/master/Kubernetes.md) to setup a Cloud SQL Proxy in a Kubernetes cluster. The documentation says: You need a service-account token with "Project Editor"…
0
votes
2 answers

Failed to connect to cloud SQL using proxy despite following the documentation

I'm using doctrine ORM with Symfony, the PHP framework. I'm getting bizarre behaviour when trying to connect to cloud SQL using GKE. I'm able to get a connection to the DB via doctrine on command line, for example php bin/console…
0
votes
1 answer

GKE pods not connecting to Cloudsql

My app can't seem to connect to the proxy thus my Cloudsql Database. Below are my setup: my-simple-app.yaml apiVersion: extensions/v1beta1 kind: Deployment metadata: labels: name: web name: web spec: replicas: 2 selector: …
0
votes
1 answer

How can I store JSON in Drone and write it to a file without it getting malformed?

Here's the context of what I'm trying to do. I would like have a Drone step to run database migrations against a Google Cloud SQL Postgres instance. I need to use Cloud SQL Proxy in order to access the database. Cloud SQL Proxy requires you provide…
RayB
  • 2,096
  • 3
  • 24
  • 42
0
votes
1 answer

Kubernetes Engine Cloud SQL proxy Lost connection to MySQL server at 'reading initial communication packet'

I have Django application deployed on Kubernetes Engine following this tutorial - https://cloud.google.com/python/django/kubernetes-engine. When I'm trying to make database request I'm getting this error: OperationalError at /admin/login/ (2013,…
0
votes
1 answer

gcp cloud sql proxy "wsarecv: An existing connection was forcibly closed by the remote host."

I have developed django with gcp cloud sql proxy not in trouble. But suddenly I can 't connect cloud sql with this message. console message: 2019/03/15 11:48:41 Ready for new connections 2019/03/15 11:48:50 New connection for…
0
votes
1 answer

Connect to CloudSQL using Private IP from a desktop client

I connect to our CloudSQL instances via CloudSQL proxy from my desktop. But all the instances are currently using Public IP (with SSL) If we configure Private IP on CLoudSQL, can we still use the Proxy to connect from desktop clients (i.e. outside…
Molenpad
  • 833
  • 2
  • 14
  • 34
0
votes
1 answer

In GCP CloudSQL how do I reset credentials for GKE after deleting secrets

While bringing up a new cluster I accidentally deleted the secrets for cloudsql-oauth-credentials in a staging cluster/project. Is there a way to re-obtain and install these from "gcloud" or the console for cloudSQL? I may have a copy of the…
0
votes
2 answers

Is there a way to disable the Public IP for cloud_sql , while using Private IP via Deployment Manager

I am using deployment manager to deploy cloud_sql with private-ip, by default public IP is enabled for those deployment. Is there a way to disable public IP using Deployment Manager ?
0
votes
1 answer

How to start Cloud SQL proxy with supervisor

I tried to start a CloudSQL proxy on supervisor, however I have no idea what is wrong with it. The documentation does not show any clues to this issue. Any ideas would be much appreciated. I tried the setup on a clean Ubuntu 16 and then installed…
cwlau
  • 428
  • 3
  • 13
0
votes
3 answers

Kubernetes app with GCP Cloud SQL does not accept any connections. Full source available on Github

I've created an example Rails 5 app that uses Google Cloud PostgreSQL. I'm able to run the app locally with docker-compose up, but I'm not able to connect to it remote when I deploy it to GCP. I tried to replicate…
0
votes
0 answers

Cloud SQL Connection with Kubernetes/Proxy Side Car

Ive got a Pod with a Golang binary running an REST API. There's a side car in the pod for the gce cloud SQL proxy. I'm constantly getting a "dial tcp 127.0.0.1:3306: connect: connection refused" error The Proxy to CloudSQL connectivity is working, I…
0
votes
0 answers

secure https with wordpress on google compute engine , cloud sql proxy and cloud SQL

I am setting up a ecommerce site with following configuration. 1. wordpress on ubuntu on google compute engine VM 2. Database on Cloud SQL in the same google cloud project. Wordpress connects to localhost and is routed to cloud SQL through cloud…
0
votes
1 answer

Manage models with cloudsql (mysql instance google cloud platform)

I have an app engine project and I want to use MySQL instance (google cloud platform) to store my datas. I can connect to my instance by using this tuto. So now I want to know how to create a model like : app = Flask(__name__) db =…