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

• Step 1 - locate your Java
  • Windows
  • macOS
  • Linux
• Step 2 - Find the JRE in DBeaver installation
• Step 3 - Copy the cacerts

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.