Access Google Cloud SQL via VPN tunnel

General Tech Bugs & Fixes 2 years ago

0 2 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 16 Aug 2022, this text provides information on Bugs & Fixes related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago

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 you can't connect directly. Apparently the problem is that the SQL instances are not directly connected to a VPC subnet. We tried forcing the route on the "Cloud Router" for the VPC but that didn't work. We tried adding an "allow-all" firewall rule for all the VPC range, it wasn't that either.

Any idea on how to reach the SQL instances through the VPN tunnel?

profilepic.png
manpreet 2 years ago

As per the official documentation1:

You cannot access a Cloud SQL instance on its private IP addresses from another network using a Cloud VPN tunnel, instance based VPN, or Cloud Interconnect. This limit applies to both on-premises networks and other VPC networks.

There is a feature request to get this implemented2.

My suggestion is to use Cloud SQL Proxy3, so the on-prem communicates with the proxy with the standard database protocol used by your database and then the proxy uses a secure tunnel to communicate with its companion process running on the server.

This official documentationp4 may serve you well.


0 views   0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.