New OpenIDM 7.1.0 , JDBC postgres upgrade and PKCS8 vs PKCS12 formats

[lombao]

Hi
I've installed the last version 7.1.0 successfully, however I had an issue related to the upgrade of the JDBC postgres driver from org.postgresql.postgresql-42.7.3.jar to  org.postgresql.postgresql-42.7.11.jar . Of course this is relevant only if you use TLS/SSL from openidm to the postgresql database.

It seems there has been a change in 42.7.9 which I believe is this one: pgjdbc/pgjdbc#3700 , that has cause me some headaches as I was using PKCS8 ( DER ) format with EC algorithm which was working nicely with org.postgresql.postgresql-42.7.3. However this is now NOT accepted by the PEMKeyManager with org.postgresql.postgresql-42.7.11.jar ( which is used in OpenIDM 7.1.0 ),

The solution I've found is to move away finally from PKCS8 fomat and go to PKCS12 . I do not think many people will notice this, it is a really corner case , but just in case , if you upgrade to OpenIDM 7.1.0 and the TLS/SSL no longer works with your postgres database , move to PKCS12 if you were using PKCS8