Jump to: navigation, search

Configuration of the LFMT Database

For each LFMT Indexer/Collector pair, a LFMT database is required. This section describes how to initialize a LFMT Database. The configuration of a Database Access Point (DAP) for a LFMT Database is also covered.

Important
The LFMT Database is not the GAX Database. The GAX database is still required for proper GAX functionality.

Initializing the LFMT Database

  1. Navigate to the <LFMT Collector Install Directory>\utilities\dbscripts directory.
  2. Locate the LFMT Database initialization script that corresponds to your DBMS. The following table lists database types and their corresponding script names.
    DBMS Script
    PostgreSQL lfmdb_8.500.XX_postgres.sql
    Oracle lfmdb_8.500.XX_ora.sql
    Microsoft SQL lfmdb_8.500.XX_mssql.sql
  3. In your DBMS interface, load and execute the initialization script that corresponds to your DBMS.

Provisioning a Database Access Point for the LFMT Database

  1. Log into GAX, and navigate to Configuration Manager.
  2. From the Environment section, select Application Templates.
  3. In the Application Templates section, enter a name for the DAP Template in the Name text field.
  4. Choose Database Access Point as the template type from the Type dropdown.
  5. Enter 8.5 for the DAP version in the Version text field.
  6. Select the Save button to save the new application template.
  7. Once the application template has been created, navigate to Configuration Manager.
  8. From the Environment section, select Applications.
  9. In the Applications section, select New.
  10. In the New Properties pane, select the General tab. Complete the following:
    1. In the General tab, enter a name for the LFMT DAP in the Name field.
    2. Click on the Template field and navigate to the application template created above.
    3. Click on the Host field and navigate to the host where LFMT Database resides.
    4. Choose JDBC as the connection type from the Connection Type dropdown.
    5. Choose Any as the case conversion type from the Case Conversion dropdown.
    6. Choose Main as the role from the Role dropdown.
    7. Choose False as the role from the Debug dropdown.
    8. Enter 15 for the DB timeout in the JDBC Query Timeout text field.
    9. Choose your DBMS type from the DBMS Type dropdown.
    10. Enter the LFMT Database name in the Database Name text field.
    11. Enter the LFMT Database username in the Username text field.
    12. Enter the LFMT Database user password in the User Password text field.
  11. Select the Ports tab. Complete the following:
    1. Set the value of the default communication port to the listening port of your DBMS. Default ports are listed below:
      • For PostgreSQL the default listening port is 5432.
      • For Oracle the default listening port is 1521.
      • For MSSQL the default listening port is 1433.
  12. Select the Application Options tab. Review and configure the LFMT DAP options.
    1. Create the section lfmt.
    2. Create the option site.
    3. Set the value of the site option to a unique identifier for the LFMT Database.
  13. Important
    Ensure that the site option for each LFMT DAP in the LFMT solution is different.
    Tip
    For more information on the LFMT DAP configuration options, please refer to the LFMT DAP Configuration Options section.

Configuring connections to the LFMT Database

The LFMT Database stores information accessed by the LFMT Client (GAX), the LFMT Indexer, and the LFMT Collector. To that, each application requires a connection the LFMT DAP. This section describes how to configure connections to the LFMT database.

Configuring GAX for use with the LFMT Database

  1. Log into GAX, and navigate to Configuration Manager.
  2. From the Environment section, select Applications.
  3. In the Applications section, select the GAX Application configured for use with the LFMT Client.
  4. In the Application Properties pane, select the Connections tab.
  5. In the Connections tab, add a connection to the LFMT DAP to which GAX will connect.
  6. Important
    A single GAX may have connections to more than one LFMT DAP instances.
  7. Select the Save button to save changes to the application.
  8. Restart GAX.

Configuring LFMT Indexer for use with the LFMT Database

  1. Log into GAX, and navigate to Configuration Manager.
  2. From the Environment section, select Applications.
  3. In the Applications section, select the LFMT Indexer that will access the LFMT Database.
  4. In the Application Properties pane, select the Connections tab.
  5. In the Connections tab, add a connection to the LFMT DAP to which LFMT Indexer will connect.
  6. Important
    A LFMT Indexer may have only one connection to a LFMT DAP instance.
  7. Select the Save button to save changes to the application.
  8. Restart LFMT Indexer.

Configuring LFMT Collector for use with the LFMT Database

  1. Log into GAX, and navigate to Configuration Manager.
  2. From the Environment section, select Applications.
  3. In the Applications section, select the LFMT Collector that will access the LFMT Database.
  4. In the Application Properties pane, select the Connections tab.
  5. In the Connections tab, add a connection to the LFMT DAP to which LFMT Collector will connect.
  6. Important
    A LFMT Collector may have only one connection to a LFMT DAP instance.
  7. Select the Save button to save changes to the application.
  8. Restart LFMT Collector.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 15 March 2016, at 08:05.