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

Column definitions for postgresql auditaccess table have wrong length

    Details

      Description

      The postgresql schema script declares audit access as follows:

      CREATE TABLE openidm.auditaccess (
      ...
      resource_method VARCHAR(10) DEFAULT NULL,
      ...
      http_querystring VARCHAR(255) DEFAULT NULL,
      ...
      );

      However, resource_method should be varchar(14). See https://bugster.forgerock.org/jira/browse/OPENIDM-4118

      And http_querystring is too small as query strings can be much longer. For example, openidm attempts to store this value, which results in an error:

      page=1&rows=10&_queryId=reconResults&source=system%2Fpeopledb%2Faccount&target=managed%2Fuser&sourceProps=username%2Cforename%2Csurname%2Cemail&targetProps=userName%2CgivenName%2Csn%2Cmail&reconId=dadd014d-b137-4707-bc49-fb6ba3093047-90&situations=SOURCE_IGNORED%2CMISSING%2CFOUND%2CAMBIGUOUS%2CUNQUALIFIED%2CCONFIRMED%2CSOURCE_MISSING%2CABSENT%2CTARGET_IGNORED%2CUNASSIGNED%2CFOUND_ALREADY_LINKED&mapping=sourceScriptedsqlAccount_managedUser

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jason Jason Lemay
                Reporter:
                max.spicer Max Spicer
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: