Skip to main content
Solved

how to activate ssl on postgresql cdataconnection

  • 16 July 2024
  • 2 replies
  • 27 views

Hi,

I have a postgresql cd connector which works well with SSL set to false, we activated a self signed SSL certificate on the database server side, but connecting with tx setting ssl to true is not working

the owner of the database mentioned i should accept the certificate but from TX there is no prompt to accept the SSL certificate, how do I need to proceed? Do we need to install anything on our end (tx server), it should not as it is a self signed certificate.

 

Thanks your help!

Linda Monincx

2 replies

Userlevel 6
Badge +7

Hi,

Just because it is self-signed does not mean it will work without any further configuration. The CData Postgres connector does not have a “trust server certificate” flag like SQL Server does: you need to either embed or refer to the certificate using the https://cdn.cdata.com/help/FPJ/ado/RSBPostgresql_p_SSLServerCert.htm parameter, or need to install your self-signed certificate in your trusted certificate store on the machine: ttps://cdn.cdata.com/help/FPJ/ado/RSBPostgresql_p_UseSSL.htm

Userlevel 6
Badge +5

Hi @linda.monincx did you manage to install or embed the certificate as suggested by Rory above?

Reply