cert/config related exception from windows os client



We were able to easily successfully implement the datagrip client on a Mac OS to call a postgres instance, but when I tried to implement the same configuration on a Windows OS laptop I get the following error during a select (from any table) after connecting and getting successful table listing.

Upon executing a select statement I get the error below.  I have loaded and pointed to all the same files as i did on the Mac (which workd). Any recommendations on what it could be? 


note: using pem file for windows, maybe that format not accepted in Windows OS?


---- Error msg after attempting a SELECT stmt :

[08006] SSL error: java.security.cert.CertificateException: No trusting managers found for ECDHE_RSA

                                                                java.security.cert.CertificateException: No trusting managers found for ECDHE_RSA

                                                                at com.intellij.security.CompositeX509TrustManager.checkServerTrusted(CompositeX509TrustManager.java:52)

                                                                at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:985)

                                                                at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1496)

                                                                at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216)

                                                                at sun.security.ssl.Handshaker.processLoop(Handshaker.java:1026)

                                                                at sun.security.ssl.Handshaker.process_record(Handshaker.java:961)

                                                                at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1072)

                                                                at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385)

                                                                at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413)

1 comment

Looks like you should update your Redshift certificate, see some details in this thread https://youtrack.jetbrains.com/issue/DBE-5414#comment=27-2524667


Please sign in to leave a comment.