I am getting a 403 error when using this login module. Does anyone know if you must use Text types for the password or can you use varchar with MySQL?
Do the password need to be encypted in the DB or is plain text ok. Here is my login-config.xml
<application-policy name = "LoginDB">
<login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule"
flag = "required">
<module-option name = "dsJndiName">java:/XAMySqlDS</module-option>
<module-option name = "principalsQuery">select Password from principals where PrincipalID=?</module-option>
<module-option name = "rolesQuery">select Role, RoleGroup from roles where PrincipalID=?</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=XATxCM,name=XAMySqlDS</module-option>
</login-module>
</application-policy>
thanks
Found it! it was the "Roles" only feature in the RolesGroup where the only group supported is "Roles" Great