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?