[jboss-user] [Beginners Corner] - JBoss JAAS DatabaseSeverLoginModule problem

I have the same problem. authentication fails and i am being redirected to the error page without any log indicating the error that happened. My configurations are as follows: I added the following entry to the login-config.xml <application-policy name = "jbossdatabaseBilling"> <login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule" flag = "required"> <module-option name = "unauthenticatedIdentity">guest</module-option> <module-option name = "dsJndiName">java:/myDS</module-option> <module-option name = "principalsQuery">SELECT PASSWORD passwd FROM USERS WHERE USERNAME=?</module-option> <module-option name = "rolesQuery">SELECT ROLENAME userRoles, 'Roles' FROM DUMMYROLES WHERE USERNAME =?</module-option> </login-module> </application-policy> By the way my database is oracle. and i jave defined myDS in oracle-ds.xml in the deploy directory of my server. I have the jboss-web.xml in the same directory of the web.xml of my web application. It has the following entry <security-domain>java:/jaas/jbossdatabaseBilling</security-domain> finally in the web.xml file i added the following sections <security-role> <role-name>users</role-name> </security-role> <login-config> <auth-method>FORM</auth-method> <form-login-config> <form-login-page>/login.jsp</form-login-page> <form-error-page>/error.jsp</form-error-page> </form-login-config> </login-config> <security-constraint> <web-resource-collection> <web-resource-name>whatever</web-resource-name> <url-pattern>/*</url-pattern> <http-method>POST</http-method> <http-method>GET</http-method> </web-resource-collection> <auth-constraint> <role-name>users</role-name> </auth-constraint> </security-constraint> <security-constraint> ----- I am still being redirected to the error page. Any hint ? Please i need help. I am posting this as a new post. I have corrected my typing mistake in the previous post View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4026180#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...