Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-14202

SQL script provided with openidm to create the auditdb fails

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.0.0.5
    • Fix Version/s: 6.0.0.6
    • Component/s: _Samples
    • Environment:
      IDM 6.0.0.5
    • Target Version/s:
    • Verified Version/s:
    • Support Ticket IDs:
    • Zendesk ID:
      #45350

      Description

      Audit Sample not working with MySQL.

      Chapter 23. Directing Audit Information To a MySQL Database of the IDM 6 Samples Guide allows customers to see how to store audit information to a MySQL database.   

      However, after running  '../samples/audit-jdbc/data/sample_audit_db.mysql' creates the table with `id` as primary key on the auditauthentication table.

      When browsing data from the connector the following error can be observed:

      WARNING: Failed to execute: SELECT * FROM auditauthentication WHERE 1=1  ORDER BY eventId ASC LIMIT 50 OFFSET 0         because: Unknown column 'eventId' in 'order clause' [344] Dec 04, 2019 3:09:03.631 PM org.eclipse.jetty.util.thread.QueuedThreadPool$2 run -- WARNING: Resource exception: 500 Internal Server Error: "Operation QUERY failed with ConnectorException on system object"
      

      This is done to the column name `eventId` and needs to be resolved.

       

        Attachments

          Activity

            People

            • Assignee:
              nena.hunt Nena Hunt
              Reporter:
              simon.wickham Simon Wickham
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: