Hi all - I am new to AirByte and looking for some ...
# ask-community-for-troubleshooting
Hi all - I am new to AirByte and looking for some help. I've searched the troubleshooting forum but didn't have any luck. I am using AirByte cloud and trying to connect to Google Cloud SQL (MySQL 8.0) When I try to connect using my GCP public IP as the host, I get the following error:
Copy code
Could not connect with provided configuration. Error: Cannot create PoolableConnectionFactory (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
Any general support would be appreciated, but here are some specific questions: • Do I need to add an authorized network IP address to my Google Cloud SQL instance? Or use the Cloud SQL Auth proxy? This issue makes me thing the current MySQL connector does not support connecting to a Google Cloud SQL instance • Do I need to use an SSH tunnel? This post makes me thing an SSH tunnel to a MySQL DB on Google Cloud SQL is not possible
If anyone is curious, I was able to solve this issue. I had to add Airbyte cloud's IP address (which I found here: https://airbytehq.slack.com/archives/C01MFR03D5W/p1634585718153700) to my authorized networks in GCP Cloud MySQL. And FWIW, this fivetran documentation did a good job explaining the specific step necessary to connect to MySQL on GCP. https://fivetran.com/docs/databases/mysql/google-cloud-mysql-setup-guide