PostgreSQL SSL error when connecting with DataIKU

stephen

Hello hello,

When trying to connect a local postgreSQL database to DataIKU, I obtain the error "Server does not support SSL".

I also tried the method bypassing the certificates by adding the parameters sslfactory, org.postgresql.ssl.NonValidatingFactory but the outcome remains the same.

As the SSL has been activated on my database and the certificates generated, I do not understand what this error means.

Here is my configuration

- Windows 11
- PostgreSQL 11 installed on my C drive
- DataIKU 9.0.1 installed on Oracle VM

Any help on solving this issue will be appreciated.

Thank you

---

Operating system used: Windows 11

---

Operating system used: Windows 11

Alexandru

Hi,

Can you confirm the exact properties you added to the connection in DSS?

Can you try the following :

ssl = true
sslfactory=org.postgresql.ssl.NonValidatingFactory

sslmode=require may not work on the current version of the JDBC driver.

Thanks

stephen

Hello,

Apologize for the late answer.

Here are the properties I added in the connection:

ssl --> true

sslfactory --> org.postgresql.ssl.NonValidatingFactory

I also tested without the sslfactory property, but the results remain unchanged

Moreover, we tested with sslmode = require, prefer, allow.

Still, the error stays the same

Thank you in advance for your assistance

Alexandru

Hi Stephen,

Would be able to open a chat or support ticket: https://doc.dataiku.com/dss/latest/troubleshooting/obtaining-support.html

With the backend.log after reproducing the issue to see if that provides more information perhaps.

Thanks,

Alex