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

Password reset fails using explicit tables

    Details

    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      3
    • Sprint:
      OpenIDM Sprint 90, OpenIDM Sprint 6.5-1, OpenIDM Sprint 6.5-2

      Description

      A regression test for a user with no security questions fails when the user attempts to reset their password, but only using MySQL and explicit tables. It passes using MySQL without explicit tables.

      The regression test log shows:

      KEYWORD PasswordResetWithoutLockout . Password Reset Of User Without Security Question
      Start / End / Elapsed:	20180411 23:19:09.201 / 20180411 23:19:09.671 / 00:00:00.470
      23:19:09.202	DEBUG	Test timeout 7 minutes active. 419.997 seconds left.	
      23:19:09.202	INFO	*** GIVEN: admin creates a managed user with no security question ***
      23:19:09.202	DEBUG	Executing function create_managed_user_rick_sutter(security_questions=False) for 10s every 1s	
      23:19:09.202	DEBUG	Attempt: 0	
      23:19:09.205	DEBUG	Starting new HTTP connection (1): localhost	
      23:19:09.593	DEBUG	http://localhost:8080 "PUT /openidm/managed/user/ricksutter HTTP/1.1" 201 1558	
      23:19:09.595	DEBUG	curl -H "Content-Type: application/json" -H "X-OpenIDM-Password: openidm-admin" -H "X-OpenIDM-Username: openidm-admin" -X  PUT --data '{"userName": "rsutter", "telephoneNumber": "6669876987", "givenName": "first_rick", "description": "User created by Admin", "sn": "first_sutter", "mail": "first_rick@example.com", "password": "Th3Password"}' http://localhost:8080/openidm/managed/user/ricksutter	
      23:19:09.595	INFO	*** WHEN: user provides its userName to reset its password ***
      23:19:09.595	INFO	User asks for password reset	
      23:19:09.597	DEBUG	Starting new HTTP connection (1): localhost	
      23:19:09.668	DEBUG	http://localhost:8080 "POST /openidm/selfservice/reset?_action=submitRequirements HTTP/1.1" 500 79	
      23:19:09.669	DEBUG	curl -H "Content-type: application/json" -H "X-OpenIDM-Password: anonymous" -H "X-OpenIDM-Username: anonymous" -X  POST --data '{"input": {"queryFilter": "userName eq \"rsutter\""}}' http://localhost:8080/openidm/selfservice/reset?_action=submitRequirements	
      23:19:09.670	DEBUG	{u'reason': u'Internal Server Error', u'code': 500, u'message': u'Exception intercepted'}	
      23:19:09.671	FAIL	500 != 400	
      23:19:09.671	DEBUG	Traceback (most recent call last):
        File "/Users/garyl/sandbox/pyforge/PyBot/OpenIDM/testcases/functional/self_service/password_reset/PasswordResetWithoutLockout.py", line 148, in password_reset_of_user_without_security_question
          self.assertEqual(result.status_code, 400)
        File "/usr/local/Cellar/python/2.7.13/Frameworks/Python.framework/Versions/2.7/lib/python2.7/unittest/case.py", line 513, in assertEqual
          assertion_func(first, second, msg=msg)
        File "/usr/local/Cellar/python/2.7.13/Frameworks/Python.framework/Versions/2.7/lib/python2.7/unittest/case.py", line 506, in _baseAssertEqual
          raise self.failureException(msg)
      

      When the test passes, the expected response to the "POST /openidm/selfservice/reset?_action=submitRequirements HTTP/1.1" is

      {u'reason': u'Bad Request', u'code': 400, u'message': u'Insufficient number of questions. Minimum number of questions user must answer: 1, Questions available: 0'}
      

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                emanuel.brici Emanuel Brici
                Reporter:
                GErickson Garyl Erickson
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: