SSL Postgresql #568

New issue

Open

opened 2026-03-04 10:26:12 -05:00 by deekerman · 0 comments

deekerman commented

2026-03-04 10:26:12 -05:00

Owner

Originally created by @GaetanColenoTiime on GitHub (Aug 8, 2023).

Hi ! I try to use SSL for Postgresql, i use cloudbeaver 23.1.4 (so as i read on other issues, it should be implemented)
I try to add my ssl keys. i mapped on my docker compose all my files, and use the path in the container to read the files, but with the error when trying to test the connection, i don't know if it's the keys, or if it's missing something
I tried with the same conf on dbeaver and it works perfectly

Error is :
Error connecting to database: Connection failed: Loading the SSL root certificate /opt/cloudbeaver/workspace/.metadata/.plugins/io.cloudbeaver.server/security/postgres-jdbc-postgres-jdbc-189d56fab84-7a62aaed048253f27472579677853312398.cert into a TrustManager failed. java.security.cert.CertificateException: No certificate data found at java.base/sun.security.provider.X509Factory.parseX509orPKCS7Cert(Unknown Source) at java.base/sun.security.provider.X509Factory.engineGenerateCertificates(Unknown Source) at java.base/java.security.cert.CertificateFactory.generateCertificates(Unknown Source) at org.postgresql.ssl.LibPQFactory.<init>(LibPQFactory.java:158) at org.postgresql.core.SocketFactoryFactory.getSslSocketFactory(SocketFactoryFactory.java:61) at org.postgresql.ssl.MakeSSL.convert(MakeSSL.java:34) at org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:584) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:168) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:247) at org.postgresql.Driver.makeConnection(Driver.java:434) at org.postgresql.Driver.access$100(Driver.java:61) at org.postgresql.Driver$ConnectThread.run(Driver.java:344) at java.base/java.lang.Thread.run(Unknown Source)

Thanks in advance to help me with it ! Working on a toolbox with docker ^^

Originally created by @GaetanColenoTiime on GitHub (Aug 8, 2023). Hi ! I try to use SSL for Postgresql, i use cloudbeaver 23.1.4 (so as i read on other issues, it should be implemented) I try to add my ssl keys. i mapped on my docker compose all my files, and use the path in the container to read the files, but with the error when trying to test the connection, i don't know if it's the keys, or if it's missing something I tried with the same conf on dbeaver and it works perfectly Error is : `Error connecting to database: Connection failed: Loading the SSL root certificate /opt/cloudbeaver/workspace/.metadata/.plugins/io.cloudbeaver.server/security/postgres-jdbc-postgres-jdbc-189d56fab84-7a62aaed048253f27472579677853312398.cert into a TrustManager failed. java.security.cert.CertificateException: No certificate data found at java.base/sun.security.provider.X509Factory.parseX509orPKCS7Cert(Unknown Source) at java.base/sun.security.provider.X509Factory.engineGenerateCertificates(Unknown Source) at java.base/java.security.cert.CertificateFactory.generateCertificates(Unknown Source) at org.postgresql.ssl.LibPQFactory.<init>(LibPQFactory.java:158) at org.postgresql.core.SocketFactoryFactory.getSslSocketFactory(SocketFactoryFactory.java:61) at org.postgresql.ssl.MakeSSL.convert(MakeSSL.java:34) at org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:584) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:168) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:247) at org.postgresql.Driver.makeConnection(Driver.java:434) at org.postgresql.Driver.access$100(Driver.java:61) at org.postgresql.Driver$ConnectThread.run(Driver.java:344) at java.base/java.lang.Thread.run(Unknown Source)` Thanks in advance to help me with it ! Working on a toolbox with docker ^^

Rows
Columns