Managing the JDBC Access Log Publishers

Use dsconfig to create a log field mapping table.

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

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

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.

Enter a name for the new field mapping.

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

Enter f to save and apply the changes.

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

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

Copy the database .JAR files to the <server-root>/lib directory, and then restart the PingDirectory server.

Launch the dsconfig tool in interactive command-line mode.

Example:

$ bin/dsconfig

Enter the connection parameters to bind to the PingDirectory server.

In the main menu, enter the number corresponding to Log Publisher.

In the Log Publisher management menu, enter the option to create a new log publisher.

In the Log Publisher template menu, enter n to create a new Log Publisher.

In the Log Publisher Type menu, enter the option to create a new JDBC-Based Access Log Publisher.

Enter a name for the JDBC Access Log Publisher.

In the Enabled Property menu, enter the option to enable the log publisher.

In the Server Property menu, enter the option to create a new JDBC External Server.

Enter the name for the JDBC External Server.

In the JDBC Driver Type Property menu, enter the number corresponding to the type of JDBC database driver type.

Enter a name for the database-name property.

Enter the host name or IP address (server-host-name) of the external server.

Enter the server listener port.

Review the properties for the external server, and then enter f to apply the changes.

If you need to supply your own JDBC URL, enter a for advanced properties to open the jdbc-driver-url property and supply the appropriate URL.

Example:

>>>> Configure the properties of the JDBC External Server

Property	Value(s)
-----------------------------------------------------
1) description	-
2) jdbc-driver-type oraclethin
3) jdbc-driver-url jdbc:oracle:thin@myhost:1541:my_SID
4) database-name	jdbc-test
5) server-host-name localhost
6) server-port	1541
7) user-name	-
8) password	-

?) help
f) finish - create the new JDBC External Server
a) hide advanced properties of the JDBC External Server
d) display the equivalent dsconfig arguments to create this object
b) back
q) quit

Enter choice [b]: f

Result:

JDBC External Server was created successfully

Import the DDL file to your database.

Use dsconfig with the --no-prompt option to create the JDBC external server.

Example:

$ bin/dsconfig --no-prompt create-external-server \
  --server-name jdbc-external \ --type jdbc \
  --set jdbc-driver-type:oraclethin \
  --set database-name:ubid_access_log \
  --set server-host-name:localhost --set server-port:1541

Use dsconfig to create the log publisher.

Example:

$ bin/dsconfig --no-prompt create-log-publisher \
  --publisher-name jdbc-test \
  --type jdbc-based-access \
  --set enabled:true \
  --set server:jdbc-external \
  --set "log-field-mapping:Simple JDBC Access Log Field Mappings"

Result:

Import the DDL file to your database.

$ bin/dsconfig --no-prompt create-log-publisher \
--publisher-name jdbc-error-test \
--type jdbc-based-error \
--set enabled:true \
--set server:jdbc-external \
--set "log-field-mapping:Simple JDBC Access Log Field Mappings"