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

uuid token expiry doesn't work with jdbc repo

    Details

    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      5
    • Sprint:
      OpenIDM Sprint 7.0-5
    • Support Ticket IDs:
    • Zendesk ID:
      37971

      Description

      With the fix for OPENIDM-11862, uuid token expiry works for embedded DJ repo, but it doesn't seem to work with JDBC repo such as MySQL and Oracle database.

      To reproduce this

      1. Set up IDM 6.0.0.4 with MySQL repo, configure selfservice registration to use uuid token, set jsonstore.json to 

      {
        "cleanupDwellSeconds" : 10,
        "entryExpireSeconds" : 60
      }
      

      2. Do a self registration

      3. Wait at least 60 seconds. One can observe that the json storage entries in genericobjects table are not cleared: 

      | id    | objecttypes_id | objectid                             | rev | fullobject
      | 46763 |             19 | bb25f5b9-2c20-4cee-a847-2566f3db046f | 0   | {"json":{},"timestamp":1552366530669,"_id":"bb25f5b9-2c20-4cee-a847-2566f3db046f","_rev":"0"}  |
      | 46764 |             19 | c5c28da2-6484-49c3-af28-3df01afe8c94 | 0   |
      {"json":{"stageIndex":2,"versionKey":-6850451,"stageTag":"validateCode","processState":{"mail":"test15@example.com","user":{"userName":"test15","givenName":"test15","sn":"user","mail":"test15@example.com","password":"Welcome1","preferences":{"updates":false,"marketing":false}},"code":"bb25f5b9-2c20-4cee-a847-2566f3db046f"}},"timestamp":1552366530683,"_id":"c5c28da2-6484-49c3-af28-3df01afe8c94","_rev":"0"}

      4. Click on the link in email, the user is created successfully, and the uuid token related genericobjects entries are cleared.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                travis.haagen Travis Haagen
                Reporter:
                yinyan.cao Yinyan Cao
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: