Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Deep Security Manager (DSM) connects to AWS RDS PostgreSQL with SSL enforce

    • Updated:
    • 5 Mar 2020
    • Product/Version:
    • Deep Security 11.0
    • Deep Security 11.1
    • Deep Security 11.2
    • Deep Security 11.3
    • Deep Security 12.0
    • Platform:
Summary

When the PostgreSQL database is configured with enforced SSL connection, you may encounter database connection issues because the DSM cannot verify the certificate.

Details
Public

When the communication encryption is enabled for PostgreSQL database, by doing the following:

  1. Open the \webclient\webapps\ROOT\WEB-INF\dsm.properties file in a text editor.
  2. Add the following line:

    database.PostgreSQL.connectionParameters=ssl=true

Deep Security uses the default Java runtime cacerts to verify the PostgreSQL server certificate. If the certificate is self-signed or from AWS RDS, it requires to import the cacerts. This file will be upgraded when the DSM is upgraded. It is recommended to do the following workaround to avoid this issue.

Use this workaround for Linux:

  1. Download the AWS RDS certificate from this AWS user guide.
  2. Copy the java runtime cacerts to /opt/dsm:

    cp /opt/dsm/jre/lib/security/cacerts /opt/dsm/cacerts

  3. Import certificate to /opt/dsm/cacerts:

    /opt/dsm/jre/bin/keytool -import -alias rds-root -keystore /opt/dsm/cacerts -file rds-ca-2019-root.der -storepass <changeit>

  4. Create a file named dsm_s.vmoptions in the /opt/dsm/ and add the following text in the file:

    -Djavax.net.ssl.trustStore=/opt/dsm/cacerts
    -Djavax.net.ssl.trustStorePassword=<changeit>

Use this workaround for Windows:

  1. Download AWS RDS certificate from this AWS user guide.
  2. Copy the java run time cacerts to C:\Program Files\Trend Micro\Deep Security Manager:

    copy C:\Program Files\Trend Micro\Deep Security Manager\jre\lib\security\cacerts C:\Program Files\Trend Micro\Deep Security\cacerts

  3. Import certificate to C:\Program Files\Trend Micro\Deep Security\cacerts:

    C:\Program Files\Trend Micro\Deep Security Manager\jre\bin\keytool -import -alias rds-root -keystore C:\Program Files\Trend Micro\Deep Security\cacerts
    -file rds-ca-2019-root.der -storepass <changeit>

  4. Create a file named Deep Security Manager.vmoptions in the C:\Program Files\Trend Micro\Deep Security Manager and add the following text in the file:

    -Djavax.net.ssl.trustStore to C:\Program Files\Trend Micro\Deep Security Manager\cacerts
    -Djavax.net.ssl.trustStorePassword=<changeit>

 
  • The workaround provided is only applicable to DSM version 12.0 and below. For DSM 12.5, the JDBC PostgreSQL driver has been upgraded and has a different behavior.
  • When upgrading to DSM 11.x or 12.0, keep the encryption enabled during the upgrade by applying the vmoptions file for the DSM installer:
    • For Linux, copy dsm_s.vmoptions to the same folder with DSM installer and rename it to your installer file name.
      For example, Manager-Linux-12.0.xxx.x64.sh.vmoptions
    • For Windows, copy Deep Security Manager.vmoptions to the same folder with DSM installer and rename it to your installer file name.
      For example, Manager-Windows-12.0.xxx.x64.vmoptions
Premium
Internal
Partner
Rating:
Category:
Configure; Troubleshoot; Deploy; Upgrade
Solution Id:
000245577
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.