Network Connectivity Issues
Ensure that the Chartio IP address has been whitelisted to access the Google Cloud SQL instance. To do this, in the Google Cloud console:
- Navigate to the SQL server instance
- View the Connections tab
- Ensure the Public option is selected and click Add Network
- Enter Chartio as the name of the network with the following CIDR 184.108.40.206/32
Google Cloud SQL generates a custom certificate authority to generate per-client certificates. However, Chartio doesn’t support configuring client certificates at this time. In order to connect to Google Cloud SQL, you must allow insecure SSL connections.
This will disable Google Cloud SQL from only allowing connections from known client certificates but if configured properly in Chartio, will still establish an SSL connection.
Chartio’s Google Cloud SQL connector only supports MySQL at this time. However, you can still connect to Postgres Google Cloud SQL instances using a normal Postgres data source in Chartio.