Loading

Unable to connect to Google Cloud SQL Postgres with SSL Enabled

Publiseringsdato: Feb 4, 2025
Beskrivelse

Unable to connect to Google Cloud SQL Postgres with SSL enabled.

 

Cause

When SSL is enabled in Google Cloud SQL, it requires a mutual SSL handshake, therefore Tableau Desktop is requested to provide the Client Certificate.

Google Cloud SQL connector allows to add the Client Certificate but it uses the MySQL driver, even when connecting to Postgresql via port 5432.

The Tableau Desktop Postgres native connector does not allow to add the client certificate.

 

Løsning

1. Download the Server-ca, the Client Certificate and Client Key from Google Cloud SQL Postgres Database.
2. Copy the attached TDC file to "My Tableau Repository/Datasources".
3. Edit the TDC file to configure correctly the path to the downloaded Certificate files (please note that a double backslash is required).
4. Connect from Tableau Desktop using the Postgres native connector.

 

Flere ressurser

When connecting to Google Cloud SQL Postgres with SSL, the following error might occur if there is an error in the TDC file specifying the file path of the certificates:
 

Error Code: BC43EF73

libpq connection parameter error:missing "=" after "Files\\PostgreSQL\\11\\cert\\server-client-ca.pem" in connection info string
Unable to connect to the PostgreSQL server "xxx". Check that the server is running and that you have access privileges to the request database.
 
 
In the TDC file, be sure to use double-quotes (") to enclose the file path when there is a space in the file path specification of the certificates.
 
Also see:
 
Knowledge-artikkelnummer

001471893

Vedlegg

postgres-ssl_new.tdc

0 KB

 
Laster
Salesforce Help | Article