4 Replies Latest reply on Jan 16, 2003 7:01 PM by Jon Ferguson

    DatabaseServerLoginModule in JBoss-3.0.5RC1_tomcat-4.1.18

    Jochen Cordes Novice

      Hi !

      I'm experiencing a problem using DatabaseServerLoginModule. I've added the following section to login-config.xml :

      <application-policy name = "CatalogDomain">

      <login-module code ="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag = "required">
      <module-option name ="unauthenticatedIdentity">Anyone</module-option>
      <module-option name="dsJndiName">java:/CatalogDS</module-option>
      <module-option name="test">test</module-option>
      <module-option name="principalsQuery">SELECT password FROM user WHERE login=?</module-option>
      <module-option name="rolesQuery">SELECT role_name, role_group FROM role, user, user_role WHERE user.login=? AND user.id = user_role.user_id AND user_role.role_id = role.id</module-option>
      <module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySQLDS</module-option>
      </login-module>

      </application-policy>

      I'm using it in combination with form-based login in tomcat. The settings have been done in jboss-web.xml, but it's not working. What I can see through jmx-console is that CatalogDomain is not bound to jndi. Strangely, no errors have showed up in the server logs. What happened, because this used to work in jboss-3.0.4 with exactly the same configuration ?

      Any help would be greatly appreciated !!!

      TIA,

      Jochen.