Determining the SQL Database Location for Forcepoint Components

Determining the SQL Database Location for Forcepoint Components

Summary
Describes options for finding the SQL server connection details from the Forcepoint Management Server.
Problem

While troubleshooting an issue, Technical Support may request to investigate the SQL database of a Forcepoint product. If the IP/hostname of the machine where the SQL database or instance is located is unknown, there are some methods available to obtain this information.

Solution

In most cases, the database location used across components is the SQL Server specified in the Forcepoint Management Infrastructure installer to be used for connection by the overarching Infrastructure web UI.

To find this information, perform the following:

  1. Access the Forcepoint Management Server.
  2. Open Forcepoint Security Setup (the installer).
  3. Run a Modify of the Forcepoint Management Infrastructure.
  4. Select the Modify option.
  5. Confirm the information presented in the SQL Server page for validity and click on Next to test the connection. If any changes need to be made, complete the modify process.

Alternatively, the value should be in the following file or registry location:

  • Websense\EIP Infra\EIPSettings.xml:
    • <HOST>SQL IP or Hostname<HOST>
  • HKLM\SOFTWARE\Wow6432Node\Websnese\EIPInfra
    • JDBConnectionString

Forcepoint Web Security

The SQL Server location is configurable under the Forcepoint Web UI within the Settings > Reporting > Log Server page. Refer to Changing the SQL Server Account Used to Connect to the Log Database for more information.

Alternatively, the ODBC Data Source (32-bit) configuration can be checked to find the connection details. This is also available in the following registry location:

 

Forcepoint DLP (Data Security)

Forcepoint DLP pulls its SQL connection information from the Forcepoint Management Infrastructure. Please refer to the steps above.

The location is also available in the following files:

  • %DSS_HOME%tomcat\conf\Catalina\localhost\dlp.xml

Line 14: <Resource name="jdbc/PaDS" auth="Container" type="javax.sql.DataSource" driverClassName="net.sourceforge.jtds.jdbcx.JtdsDataSource" url="jdbc:jtds:sqlserver://<SQL IP or Hostname>:1433

  • %JETTY_HOME%service-container\container\webapps\*.xml

<Set name="jdbcUrl">

 

Forcepoint Email Security

The SQL Server location is configurable under the Forcepoint Email Security UI within the Settings > Reporting > Log Server page. Please refer to Configuring Log Database Options for more information.

Alternatively, the ODBC Data Source (32-bit) configuration can be checked to find the connection details. This is also available in the following registry locations:

  • HKLM\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\esglogdb76
  • HKLM\SOFTWARE\Wow6432Node\Websense\Email Security\ESG Log Server > DBIP

For general Log Database configuration information, please refer to Log Server and Log Database **Featured Article**.

    • Related Articles

    • Log Database Cleanup (Web and Email)

      In order to resolve the issue for Web and Email products, follow the steps below. Log on to the Forcepoint Security Manager (formerly Triton). Click Settings > Reporting > Log Database. Scroll down to the particular partitions you want to Delete or ...

    • Forcepoint DLP backup

      How do I back up and restore Forcepoint DLP? Backup and Restore | Forcepoint DLP | 29-Apr-2022 Back up your Forcepoint DLP system periodically to safeguard your policies, forensics, configuration data, fingerprints, encryption keys, and more. ...

    • Troubleshooting Forcepoint ONE's Active Directory Sync Agent

      Summary Solutions to common troubleshooting scenarios with AD sync Agent Problem The Bitglass DirSync AD Agent is a program that syncs Active Directory users to the Forcepoint ONE user database. An AD user (typically an admin) would download the tool ...

    • HTTP Status 404" Error Occurs within the Forcepoint Security Manager

      Problem When logging on to the Forcepoint Manager web UI, why do I see the following error message? "HTTP status 404 The requested resource (/mng/) is not available." OR "HTTP status 404 - /manager/lgon/pages/login.page.jsf Type: Status Report ...

    • (-3) General (unknown) error" Encountered During Forcepoint DLP Secondary Server Registration

      Summary Restart the Websense Data Security Fingerprinting Database to resolve the issue. Problem When attempting to complete a Modify of the Forcepoint DLP installer on a Secondary Windows Server to register the machine to a DLP Management Server, an ...