Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

Access Google Cloud SQL via VPN tunnel

General Tech Bugs & Fixes

Max. 2000 characters
Replies

usr_profile.png

User

( 6 months 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?

usr_profile.png

User

( 6 months 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.

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif