PingDirectory

Configuring the log field mapping tables

About this task

The log field mapping table associates access log fields with the database column names. Configure the log field mapping table using the dsconfig tool, which generates a DDL file that you can import into your database. The DDL file is generated when you create the JDBC Log Publisher.

To uniquely identify a log record, you should map the following fields:

  • timestamp

  • startupid

  • message-type

  • connection-id

  • operation-type

  • instance-name

The table name is not part of this mapping.

The PingDirectory server also provides these options that you can select for creating a log field mapping table:

Complete JDBC Access Log Field Mappings

Maps all 52 object properties.

Complete JDBC Error Log Field Mappings

Maps all 8 object properties.

Simple JDBC Access Log Field Mappings

Maps a common set of object properties.

Custom JDBC Access Log Field Mappings

Create a custom set of JDBC log field mappings.

Custom JDBC Error Log Field Mappings

Create a custom set of JDBC error log field mappings.

Steps

  1. Use dsconfig to create a log field mapping table.

  2. In the main menu, enter o to change to the Standard Object menu, and enter the number corresponding to Log Field Mapping.

  3. In theLog Field Mapping management menu, enter the option to create a new Log Field Mapping.

  4. In theLog Field Mapping template menu, enter the option to select a complete JDBC Access Log Field mapping to use as a template for your new field mapping.

  5. Enter a name for the new field mapping.

    For this example, enter my-jdbc-test.

  6. In the Access Log Field Mapping Properties menu, select a property for which you want to change the value.

    Any property that is undefined is not logged by the JDBC Access Log Publisher.

  7. Enter f to save and apply the changes.

  8. In the Log Field Mapping Management menu, enter q to exit the menu.

  9. View the existing Log Mappings on the system.

    Example:

    $ bin/dsconfig list-log-field-mappings

    Result:

    Log Field Mapping	                   : Type
----------------------------------------:-------
Complete JDBC Access Log Field Mappings : access
Complete JDBC Error Log Field Mappings  : error
my-jdbc-test                            : access
Simple JDBC Access Log Field Mappings   : access