Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [google-cloud-sql]

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that operate from Google's Cloud Platform.

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that operate from Google's Cloud Platform.

133 questions
8
votes
5 answers

Cannot connect to Cloud SQL Postgres from GKE via Private IP

I am having trouble accessing a Cloud SQL instance running Postgres from a GKE cluster using the database's private IP. All the documentation I've found suggests using a VPC-enabled cluster to accomplish this, but I am still having trouble reaching…
Chathan Driehuys
  • 181
  • 1
  • 6
6
votes
3 answers

Access Google Cloud SQL via VPN tunnel

We have a VPN tunnel from the office to the Google Cloud. It's working correctly, we are able to hit VMs and containers (kubernetes). The problem is that the SQL instance can't be accessed using this tunnel. You can jump through a VM instance but…
ModMed SysAdmin
  • 73
  • 1
  • 5
6
votes
2 answers

Am I doing Google Cloud deployment wrong?

I've previously used Heroku and AWS and am now setting up a service on the Google Cloud platform using App Engine and Cloud SQL (Postgres). We've tried to build the app using 12 factor principles. The setup has been proving so tedious that I'm…
ChrisJ
  • 295
  • 1
  • 10
5
votes
1 answer

Issue Connecting to Cloud SQL Postgres using Private IP from GKE

Steps I have followed: 1. Create VPC network gcloud compute networks create stg-vpc \ --subnet-mode custom 2. Create IP range for VPC Peering for this network gcloud beta compute addresses create google-managed-services-stg-vpc \ --global \ …
Subhash Chandran
  • 211
  • 2
  • 6
4
votes
1 answer

How to configure Cloud SQL Postgres to require SSL but not client certificates?

Is there a way to create a Cloud SQL Postgres instance that Enforces SSL/TLS, but that does not require the use of client certificates? In pg_hba.conf, this would be a line containing hostssl but not clientcert=1. I have tried Enforcing SSL/TLS…
yonran
  • 797
  • 2
  • 11
  • 22
4
votes
1 answer

Google cloud SQL: error during import of Postgresql dump with extensions

I'm trying to import dump with extensions it it, excerpt from SQL: CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA…
Олексій Донога
  • 171
  • 1
  • 5
4
votes
2 answers

"Could not complete the operation" when trying to add an authorized network to Cloud SQL instance

I'm trying to add an authorized network to our cloud sql instance, but each time I click Save I get told Could not complete the operation. That's it unfortunately, there's no explanation as to what the problem might be. Any ideas?
norgepaul
  • 171
  • 5
4
votes
3 answers

Google Cloud SQL authorize Auto Scale Instance Groups

I have an instance group set up with Auto Scaling and Load Balancing. I'm also using Google Cloud SQL for the MySQL server. Whenever instance group scales up and adds another instance, the instance gets a new IP address. The problem is that this…
Dxx
  • 161
  • 1
  • 5
3
votes
2 answers

Giving friendly names to authorised networks via gcloud command

I'm authorising instances access to PostgreSQL via the gcloud command: gcloud sql instances patch blah-sql-dev --authorized-networks 10.1.1.2/32,10.1.1.3/32,..... What I'm seeing under Cloud SQL's Authorised Networks is just the IP addresses…
Jan Vladimir Mostert
  • 553
  • 5
  • 19
3
votes
1 answer

Passwordless user for Google Cloud SQL (MySQL) using Cloud SQL Proxy?

The documentation About the Cloud SQL Proxy contains a line, “[B]ecause the proxy always connects from a hostname that cannot be accessed except by the proxy, you can create a user account that can be used only by the proxy. The advantage of doing…
yonran
  • 797
  • 2
  • 11
  • 22
2
votes
3 answers

How to call pg_dump from Google Cloud SQL

I am looking for a solution to backup my Cloud SQL schemas (and Cloud Storage files). At first I tried using Cloud Scheduler to call the googleapis (https://cloud.google.com/sql/docs/postgres/import-export/exporting) in order to make an export of…
Jasper
  • 121
  • 1
  • 2
2
votes
2 answers

Can't Connect from GCP AppEngine to GCP Cloud SQL

I have a simple Java servlet app, deployed to the GCP AppEngine. Under the same GCP, I have created a MySQL instance of GCP Cloud SQL. I would like to save the value on MySQL server when someone makes an HTTP Post request. However, my Java App…
Creed
  • 21
  • 1
  • 3
2
votes
3 answers

Centos7 systemctl start unit not found

I look everywhere and just for the life of me figure out why systemctl would not start my unit. I am trying to start GCP's cloud-sql-proxy as a systemd service. This is what my cloud-sql-proxy.service looks…
Mickey
  • 143
  • 1
  • 1
  • 4
2
votes
3 answers

GCP Private IP CloudSQL

I have configured private Service Access for CloudSql from my VPC. My VPC has 2 subnets in regions us-west1 and us-central1. The issue is: My app is NOT able to connect to the CloudSQL instance from us-west1 (subnet) but is able to connect from…
Pratap
  • 21
  • 3
2
votes
1 answer

How to connect to Cloud SQL MySQL database from App Engine?

I am currently setting up an open-source marketing software called Mautic on App Engine Flexible Environment. However, I'm having trouble with connecting the App Engine to the Cloud SQL MySQL database using MySQLi. Mautic is a PHP application built…
Elisha Lai
  • 21
  • 3
1
2 3
…
8 9