0 Replies Latest reply on Jul 10, 2014 2:01 AM by hamith

    How to authenticate encrypted password in database using Picketlink IDP?

    hamith

      i m trying to authenticate the password encrypted in database using picketlink idp on JBoss 7 server.

       

      <security-domain name="idp" cache-type="default">

                          <authentication>

                                   <login-module code="Database" flag="required">

                                           <module-option name="password-stacking" value="useFirstPass"/>

                                           <module-option name="dsJndiName" value="java:jboss/datasources/MyDS"/>

                                           <module-option name="principalsQuery" value="select PASSWORD from USERS where LOGIN=?"/>

                                           <module-option name="rolesQuery" value="select ROLE, 'Roles' from ROLES where LOGIN=?"/>

                                   </login-module>

                           </authentication>

                      </security-domain>

       

      If it is plain text(ASCII) password stored in database, able to authenticate the user. but if the password is encrypted and stored in database, unable to authenticate it.

       

      Is there any way to before authentication encrypt password  or decrypt the database password and authenticate it?