Symptoms
When you enter the URL of a TLS secured PostgreSQL database when you configure your database node, an error similar to the following is displayed in the Event Processing UI:
Invalid JDBC URL
Contact your system administrator to provide the backend logs if you encounter this above issue. The following error is displayed in the logs for the backend container in the Event Processing pod:
io.vertx.core.eventbus.ReplyException: Could not open SSL root certificate file //.postgresql/root.crt.
Causes
The URL of the secured PostgreSQL database does not include sslfactory=org.postgresql.ssl.DefaultJavaSSLFactory.
Resolving the problem
Ensure that the configuration parameters in the URL for the secured PostgreSQL database contains the configuration parameter sslfactory=org.postgresql.ssl.DefaultJavaSSLFactory. For example:
jdbc:postgresql://<host>:<port>/<database>?sslfactory=org.postgresql.ssl.DefaultJavaSSLFactory&<additional-configuration>
Note: Ensure that you have correctly mounted the truststore and password into both the Event Processing and the IBM Operator for Apache Flink instances as the administrator.