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
Best answer by rory.smith
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
+7Hi,
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
