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

Create a technical support case if you need further support.

Configuring database connections socket timeout between Database and Deep Security

    • Updated:
    • 31 Mar 2020
    • Product/Version:
    • Deep Security All
    • Platform:
    • N/A
Summary

This article describes how to change the default timeout value of connections between a database management system and Deep Security Manager.

Details
Public

To change default timeout value, you need to edit dsm.properties file located in the <install_path>\Trend Micro\Deep Security Manager\webclient\webapps\ROOT\WEB-INF\ folder.

  1. Create a backup of the dsm.properties for restore purpose.
  2. Follow the formats below to edit the timeout for the database management system you use.

    Microsoft SQL server

    • Format:

      database.SqlServer.parameter1=value1

    • Examples:

      database.SqlServer.socketTimeout=720000
      database.SqlServer.queryTimeout=660000

    Also refer to the section of a Microsoft article: Setting the connection properties for more details.

    PostgreSQL

    • Format:

      database.PostgreSQL.connectionParameters=parameter1=value1&parameter2=value2

    • Example:

      database.PostgreSQL.connectionParameters=loginTimeout=150&sockettimeout=720000

    Also refer to the section of a PostgreSQL article: Initializing the Driver for more details.

    Oracle

    • Format:

      database.Oracle.parameter1=value1

    • Example:

      database.Oracle.oracle.jdbc.ReadTimeout=120000

    Also refer to a section of the Oracle User's Guide for more details.

Premium
Internal
Partner
Rating:
Category:
Configure; Troubleshoot
Solution Id:
000249217
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.