Hello - I am trying to connect to a PostgreSQL database hosted on GCP. I am using the PostgreSQL Connector and have entered the Hostname, Database name, username and password as well as the following JDBC parameters: ssl=true, sslfactory=org.postgresql.ssl.NonValidatingFactory. However, I am receiving the following error message: Execute failed: FATAL: connection requires a valid client certificate. Do you know how I connect my client certificate?
1 Like
Hi @kizuka
Welcome to the KNIME Forum! You should be able to pass the SSL Certificates on the JDBC parameters as well by adding the parameters
sslcert=<path to .crt>
sslkey=<path to .pk8>
Regards,
Wali
3 Likes
Hello - would you be able to specify the correct format of the parameters? I tried entering as an example:
C:\Users\username\Documents\client-cert.pem
C:\Users\username\Documents\client-key.pem
But I am still receiving the same error message.
Thanks!
Karen
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.