Versions Compared

Old Version 8

changes.mady.by.user Ricardo Pires

Saved on

compared with

New Version Current

changes.mady.by.user Bruno Gomes

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Applies to Write-Back Server

Table of Contents
minLevel1
maxLevel3

Summary

It is possible to enable encryption with the SQL Server connection allowing to have a secure connection to the database.

...

Code Block
languagebash
keytool -import -v -trustcacerts -alias sqlserver -file yourSQLServerCertificate.cer -keystore <installation_folder>\Write-Back\openJDK-jre\lib\security\cacerts.jks
Info

Notes:

  1. cacerts is the Java truststore that is bundled with Write-Back, located in <installation_folder>\Write-Back\openJDK-jre\lib\security

  2. The keytool utility can be found in <installation_folder>\Write-Back\openJDK-jre\bin\

  3. Make sure to replace the bold and underline sections of the command with your appropriate settings.

  4. When keytool prompts for password, it is “changeit” (no quotes), as that is the default password of cacerts.

Step 2: Restart the Write-Back Manager service

...

Step 2: Configure the Write-Back server to read the truststore

  1. Navigate to: <installation_folder>\apache-tomcat\bin

  2. Double click on WriteBackServerw.exe

    1. Go to the Java tab

  3. Under Java options, scroll to the bottom and add these two lines (changing the installation path to your own):

    1. (again, by default, the cacerts password is changeit)

      - Djavax.net.ssl.trustStore=<installation_folder>\openJDK-jre\lib\security\cacerts

      - Djavax.net.ssl.trustStorePassword=changeit

  4. It should look similar to this:

  5. Instruct Tomcat to read that truststoreImage Modified

  6. Click Apply and OK.

  7. Repeat the same process for the Write-Back Manager server, located at <installation_folder>\manager\apache-tomcat\bin\WriteBackManagerServerw.exe

Step 3: Restart the Write-Back Manager service and test the connection

...