MySQL connection to remote server on Amazon stopped working DataGrip
[2019-11-26 09:22:06] [08][-1] Could not connect to 123xxx.rds.amazonaws.com:3306 : sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[2019-11-26 09:22:06] java.lang.RuntimeException: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[2019-11-26 09:22:06] at sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141)
[2019-11-26 09:22:06] at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126)
[2019-11-26 09:22:06] at java.security.cert.CertPathBuilder.build(CertPathBuilder.java:280)
[2019-11-26 09:22:06] at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:392)
[2019-11-26 09:22:06] at sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:302)
[2019-11-26 09:22:06] at sun.security.validator.Validator.validate(Validator.java:260)
[2019-11-26 09:22:06] at sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:324)
[2019-11-26 09:22:06] at sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:229)
[2019-11-26 09:22:06] at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:124)
[2019-11-26 09:22:06] at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1496)
[2019-11-26 09:22:06] at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216)
[2019-11-26 09:22:06] at sun.security.ssl.Handshaker.processLoop(Handshaker.java:1026)
[2019-11-26 09:22:06] at sun.security.ssl.Handshaker.process_record(Handshaker.java:961)
[2019-11-26 09:22:06] at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1072)
[2019-11-26 09:22:06] at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385)
[2019-11-26 09:22:06] at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413)
[2019-11-26 09:22:06] at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1397)
[2019-11-26 09:22:06] at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:715)
[2019-11-26 09:22:06] at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:412)
[2019-11-26 09:22:06] at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1124)
[2019-11-26 09:22:06] at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
[2019-11-26 09:22:06] at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:174)
[2019-11-26 09:22:06] at org.mariadb.jdbc.Driver.connect(Driver.java:92)
[2019-11-26 09:22:06] at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:27)
[2019-11-26 09:22:06] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[2019-11-26 09:22:06] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[2019-11-26 09:22:06] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[2019-11-26 09:22:06] at java.lang.reflect.Method.invoke(Method.java:498)
[2019-11-26 09:22:06] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:346)
[2019-11-26 09:22:06] at sun.rmi.transport.Transport$1.run(Transport.java:200)
[2019-11-26 09:22:06] at sun.rmi.transport.Transport$1.run(Transport.java:197)
[2019-11-26 09:22:06] at java.security.AccessController.doPrivileged(Native Method)
[2019-11-26 09:22:06] at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
[2019-11-26 09:22:06] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
[2019-11-26 09:22:06] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
[2019-11-26 09:22:06] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683)
[2019-11-26 09:22:06] at java.security.AccessController.doPrivileged(Native Method)
[2019-11-26 09:22:06] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
[2019-11-26 09:22:06] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[2019-11-26 09:22:06] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[2019-11-26 09:22:06] at java.lang.Thread.run(Thread.java:745) (no stack trace)
Please sign in to leave a comment.
I tried few solutions from Stackoverflow but nothing worked
I've updated the DataGrip and solved the problem thanks
@...
Could you specify version you've got a problem and a version that fixed it?
Version with problems was 2018.1.5 and fixed one is 2019.2.6