Network error in DBeaver mysql connection: `unable to find valid certification path to requested target`

Question

I have this message in my DBeaver Can you help me to fix the problem?

Network error

Motif:

Network unavailable:

javax.net.ssl.SSLHandshakeException:PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Answer 1

I have similar error the first time that i open a DB:

Network error

Reason: Network unavailable due to certificate issue. Try changing the setting Use Windows trust store in Preferences->Connections and restart DBeaver. It might help if you haven't overridden trust store. javax.net.ssl.SSLHandshakeException:PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

I try 'bAsK' solution but not work for me.

The solution for me is remove check in the setting Use Windows trust store in Preferences->Connections and restart DBeaver

I also installed JRE 8 (Java)

Answer 2

For macOS:

Edit:

/Applications/DBeaver.app/Contents/Eclipse/dbeaver.ini

add the line:

-Djavax.net.ssl.trustStoreType=KeychainStore

Restart the DBeaver application to resolve this problem.