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
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:
Open the Terminal and execute the following command:
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.