Page created: 6 Nov 2019
|
Page updated: 25 Mar 2020
| 1 min read
8.0 Product PingDirectory Product documentation Content Type Administration User task IT Administrator Administrator Audience Software Deployment Method Configuration Directory Capability
-
Use dsconfig with the --no-prompt option to
create the JDBC external server.
$ 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.
$ 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"
-
When the JDBC Log Publisher is created, the Directory Server
automatically generates a DDL file of the Log Field Mappings in the
<server-root>/logs/ddls/<name-
of-logger>.sql file. Import the DDL file to your database.
The procedure to configure the JDBC-Based Error Log Publisher is similar to creating a JDBC-Based Access Log Publisher. You can run the previous dsconfig command with the --type jdbc-based-error as follows:
$ 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"