Importing CA certificates from your local Java into DBeaver
Note: This article is relevant for you if you work behind the corporate firewall with a different root certificates set. In other cases, your issues can be caused by the incorrect SSL Configuration.
Table of contents
It's possible that your system administrator has installed a local Java and imported the required certificates to its keystore. We can use them to fix the issue.
Step 1 - locate your Java
Windows
Press Windows + R to open the Run window. Type cmd in the prompt and press OK. It will open the command prompt. In the command prompt, type the
following and press Enter:
where java
macOS
Open the Terminal and execute the following command:
/usr/libexec/java_home -V
Linux
Open a terminal and execute the following command:
readlink -e /usr/bin/java
Step 2 - Find the JRE in DBeaver installation
It's pretty easy. Just find the path where you installed DBeaver and open the jre folder there.
Step 3 - Copy the cacerts
Open the folder with the Java you found in step 1. Locate the cacerts files under /lib/security, then copy-paste it into <PATH_FROM_STEP_2>/lib/security, replacing the old file. Restart DBeaver and you are ready to go.