- In Chartio’s connection form, copy Chartio’s IP address, which is located under the Hostname or IP field.
- Open a new browser window and go to your Project list in the Google Developers Console.
- Select your Project from the list.
- Choose Cloud SQL from the left navigation, select your Google Cloud SQL instance, then navigate to the Access Control tab.
- Click Add new under the Authorized Networks section of your Access Control settings and add Chartio’s IP address that you copied earlier.
- You’ll see your Google Cloud SQL IP address on this tab as well, which you’ll need to enter into the Chartio connection form.
Google Cloud SQL SSL Connection
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
Chartioas the name of the network with the following CIDR:
Securing SSL Connections in Google Cloud
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 – it will still establish an SSL connection.
Chartio’s Google Cloud SQL connector only supports MySQL at this time. However, you can still connect to PostgreSQL Google Cloud SQL instances using a normal PostgreSQL data source in Chartio.