Datastream To On Premise MySQL Database Connection Failure

[Oyugi-Collins]

Hi,

I am new to  GCP. I am trying to establish a connection from the Datastream console to the on-premise MYSQL database. I am using a private connection. I have already created a VPN tunnel it seems to be working since I connected to the same database via a VM in the GCP. But when I try to connect through the Datastream it fails with a timeout connection error. Please the screenshot below

Is there a way I can solve this?

Is there a way I can see logs or something more detailed from the GCP environment to know exactly what's causing the error?

[abdelfettah]

Hi,

When you have setup your private connection according to the doc [1]. you had to pick an IP Range to use with Datastream, you need to make sure your onPrem firewall doesn't block this IP Range. This could explain why you are able to connect from a VM on GCP and not from Datastream and these are probably using two different IP ranges

[1] https://cloud.google.com/datastream/docs/create-a-private-connectivity-configuration

[Oyugi-Collins · Accepted solution]

Thank you @abdelfettah for the reply but the solution unfortunately didn't work in my situation. I had to use the ssh tunnel option which worked well though I have to pay a little for the extra resources used 😊

[Iwark]

I ran into the same problem and could solve it.

It seems you need to configure your cloud router to advertise the ip range you use in Datastream VPC peering.

https://cloud.google.com/network-connectivity/docs/router/how-to/advertising-overview

Hope it helps people run into the same issue.