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

Backport OPENIDM-12804: uuid token expiry doesn't work with jdbc repo

    XMLWordPrintable

Details

    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

              emanuel.brici Emanuel Brici [X] (Inactive)
              mark.offutt Mark Offutt [X] (Inactive)
              Michal Orlik Michal Orlik
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: