Here's the update on the issue.
Background:
1. Currently using version 1.61 in production. Version info from Config file:
<PwmConfiguration pwmVersion="1.6.1" pwmBuild="1123" pwmBuildType="release" createTime="2012-01-30 15:26:25 +0000" modifyTime="2012-06-06 16:33:29 +0000" xmlVersion="2">2. Currently using eDirectory and eDirectory attributes for saving pwmResponse. The LDAP attribute name used is pwmResponseSet.
3. New system is using Active Directory and an external SQL database for saving pwmResponse. The SQL database Table is PWM_RESPONSES, it has two columns, id and value.
4. I've tried to simply copy the data that exists in the original attribute pwmResponseSet to the corresponding SQL value for the user.
The issue:
1. I just updated to build: PWM v1.8.0-SNAPSHOT b13038137 r9f802607617def42e749d1392a5389d93d40f5ef
with download: pwm-1.8.0-SNAPSHOT-2016-03-17T10_13_54Z-pwm-bundle.zip
from:
http://www.pwm-project.org/artifacts/pwm/2. I verified that a new user can activate a new account, create a password, and set a PWM_RESPONSE id, value record in the database. Here's that string:
<?xml version="1.0" encoding="UTF-8"?><ResponseSet minRandomRequired="1" locale="en" version="2" chaiVersion="0.6.6" caseInsensitive="true" challengeSetID="PWM-defined v1.8.0-SNAPSHOT b13038137 r9f802607617def42e749d1392a5389d93d40f5ef" time="2016-03-17 19:09:19 +0000"><response adminDefined="true" required="false" minLength="4" maxLength="200"><challenge>Mother’s birth city?</challenge><answer salt="elUmGqpWUEBlyWoCbdEJYWy4LXuT3Xci" format="SHA1_SALT" hashcount="100000">B:POaAuzdo0Wq6ubGktjJTBE62Uc4=</answer></response></ResponseSet>
3. I verified that the user can go through the forgotten password process and reset his password correctly. (The answer for the response listed above is "madison1" without quotes).
4. Next, I tried changing the value for the matching id, value entry in the database to a record that was created in the version 1.61 PWM to the following:
0002#.#.#<?xml version="1.0" encoding="UTF-8"?>
<ResponseSet minRandomRequired="0" locale="en_US" version="2" chaiVersion="0.5.0" caseInsensitive="true" challengeSetID="1437168444017" time="2016-03-17 18:34:15 +0000"><response adminDefined="false" required="true" minLength="2" maxLength="255"><challenge><![CDATA[In what city was your mother born?]]></challenge><answer format="SHA1_SALT" salt="6gV9XvsEVoh6noSs49Xc1dhqOPKbvOjI"><![CDATA[m7yIEChANECG8DyLXxpBsFnrnLg=]]></answer></response></ResponseSet>
(Please note: there is a CR/LF after the first line encoding="UTF-8"?> and another CR/LF at the end of the string after </ResponseSet>)
The answer to this question is also "madison1" without the quotes.
5. Here's the log file entries when I try to login:
2016-03-17T14:22:39Z, INFO , auth.LDAPAuthenticationRequest, {19257} authID=7, successful ldap authentication for UserIdentity{"userDN":"CN=Jean-Luc Picard,OU=Faculty,OU=FacStaff,DC=matc,DC=ts,DC=test","ldapProfile":"default"} (31ms) type: AUTHENTICATED, using strategy BIND, using proxy connection: false, returning bind dn: CN=Jean-Luc Picard,OU=Faculty,OU=FacStaff,DC=matc,DC=ts,DC=test [10.122.76.122]
2016-03-17T14:22:39Z, INFO , event.AuditService, audit event: {"perpetratorID":"jpicard9","perpetratorDN":"CN=Jean-Luc Picard,OU=Faculty,OU=FacStaff,DC=matc,DC=ts,DC=test","perpetratorLdapProfile":"default","sourceAddress":"10.122.76.122","sourceHost":"10.122.76.122","type":"USER","eventCode":"AUTHENTICATE","guid":"3791af52-0962-4985-9ff8-a6fc3d7d7dde","timestamp":"2016-03-17T19:22:39Z","message":"type=AUTHENTICATED, source=LOGIN_FORM"}
2016-03-17T14:22:39Z, FATAL, servlet.AbstractPwmServlet, 5015 ERROR_UNKNOWN (unexpected error reading responses for CN=Jean-Luc Picard,OU=Faculty,OU=FacStaff,DC=matc,DC=ts,DC=test from remote database: too few challenges are required)
6. Possible options
- Do I need to reformat the response in some way to work with the newer version?
- Is this a configuration option on the new PWM that needs to be adjusted?
- Is there a configuration option required to make it read the older pwmResponse format?
- Something else?
Thank you for such an amazing product!
+Jonathan