Uploaded image for project: 'EJBCA'
  1. EJBCA
  2. ECA-4677

Audit log: Only show valid conditions for each search column

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: EJBCA 6.3.2.5
    • Fix Version/s: EJBCA 6.5.0
    • Component/s: None
    • Labels:
      None
    • Issue discovered during:
      Customer

      Description

      Only contains searches for details return results.

      This is of course due to the fact that details are stored as serialized XML objects, like

      <?xml version="1.0" encoding="UTF-8"?>
      <java version="1.7.0_91" class="java.beans.XMLDecoder">
      <object class="org.cesecore.util.Base64PutHashMap">
      <void method="put">
      <string>msg</string>
      <string>Generated new keypair in CryptoToken 1630042679</string>
      </void>
      <void method="put">
      <string>keyAlias</string>
      <string>encryptKey</string>
      </void>
      <void method="put">
      <string>keySpecification</string>
      <string>1024</string>
      </void>
      </object>
      </java>

      Using a conditions like:
      Details Contains Base64PutHashMap
      returns all results.

      From a database perspective, there is no way around doing %searchstring%-queries.

      Option 1: Remove invalid conditions for "Details" (especially less than greater than makes no sense)
      Option 2: Transform conditions to contains queries, e.g.

      • "starts with ABC" → "%<string>ABC%"
      • "ends with ABC" → "%ABC</string>%"
      • "equals ABC=DEF" → "%<string>ABC</string>\n <string>DEF</string>%"
        Option 3:
      • Load results using non-details filter first into memory and process with Java code.
      • If not sufficient results are found after filtering, load some more.
      • Contains query for details should be rewritten as "%<string>querystring</string>%" to avoid that for example Base64PutHashMap matches.

      It has been decided that this issue will be used to clean out invalid choices.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                johan Johan Eklund
                Reporter:
                mikek Mike Agrenius Kushner
                Verified by:
                Mike Agrenius Kushner
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: