cert/config related exception from windows os client
Hi,
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?
Thanks!
---- 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)
Please sign in to leave a 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