1 Reply Latest reply on Mar 8, 2007 10:25 AM by Peter Johnson

    JBoss JAAS DatabaseSeverLoginModule problem

    Safwat Eleish Newbie

      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