Uploaded image for project: 'Identity Gateway'
  1. Identity Gateway
  2. OPENIG-2675

JDBC audit event handler example tableMappings causes errors on Tomcat

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 4.5.0, 5.5.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      https://backstage.forgerock.com/docs/ig/5.5/reference/#JdbcAuditEventHandler

      The example tableMappings has a line:
      "client/host": "client_host",

      With default settings on Apache 7.0.57 or 8.0.39, this results in.

      [http-bio-8080-exec-1] ERROR o.f.a.h.j.BaseDatabaseStatementProvider - Unable to get type for filed /client/host
      [http-bio-8080-exec-1] ERROR o.f.a.h.jdbc.JdbcAuditEventHandler - Unable to create audit entry for access
      org.forgerock.json.resource.InternalServerErrorException: Unknown audit event property: /client/host
      at org.forgerock.audit.events.AuditEventHelper.getPropertyType(AuditEventHelper.java:70)
      Wrapped by: org.forgerock.audit.AuditException: Unable to get type for filed /client/host
      at org.forgerock.audit.handlers.jdbc.BaseDatabaseStatementProvider.getParameterType(BaseDatabaseStatementProvider.java:128)
      [http-bio-8080-exec-1] WARN o.forgerock.audit.AuditServiceImpl - Failure in publishing audit event to access : Unable to create audit entry for access

      Possibly there's a way to make this work through Tomcat (enableLookups?) or IG configuration , but can we either document how to do this or just remove client/host from the example?
      Is client/ip not enough for most use cases?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              andrew.dunn Andrew Dunn [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: