[jboss-user] [JBoss Portal] - DatabaseServerLoginModule

[ekszer]

I wanted to use a Database for authentication in Jboss Portal. I modified
the login-config.xml file in the jboss-portal.sar/conf directory in the 
following way:

<policy>
  |    <!-- For the JCR CMS -->
  |    <application-policy name="cms">
  |       <authentication>
  |          <login-module code="org.apache.jackrabbit.core.security.SimpleLoginModule" flag="required"/>
  |       </authentication>
  |    </application-policy>
  |    
  |    <application-policy name="portal">
  |       <authentication>
  | <!--
  |          <login-module code="org.jboss.portal.identity.auth.IdentityLoginModule" flag="required">
  |             <module-option name="unauthenticatedIdentity">guest</module-option>
  |             <module-option name="userModuleJNDIName">java:/portal/UserModule</module-option>
  |             <module-option name="roleModuleJNDIName">java:/portal/RoleModule</module-option>
  |             <module-option name="additionalRole">Authenticated</module-option>
  |             <module-option name="password-stacking">useFirstPass</module-option>
  |          </login-module>
  | -->
  |          <login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required">
  |             <module-option name="dsJndiName">java:/PortalDS</module-option>
  |             <module-option name="principalsQuery">SELECT passwd FROM users WHERE username=?</module-option>
  |             <module-option name="rolesQuery">SELECT role, 'Roles' FROM  roles WHERE username=?</module-option>
  |             <module-option name="additionalRole">Authenticated</module-option>
  | <!--
  |             <module-option name="hashAlgorithm">MD5</module-option>
  |             <module-option name="hashEncoding">HEX</module-option>
  | -->
  |          </login-module>                 
  |       </authentication>
  | 
  |    </application-policy>
  | </policy>
Additionally I created two tables in the default database (PortalDS):

  |       users                                       roles
  | ------------------------                 ------------------------
  | username | passwd       |                | username | role      |
  | ------------------------                 ------------------------
  | admin    | admin        |                | admin    | Admin     |
  | ------------------------                -------------------------
  | user     | user         |                | user     | User      |
  | ------------------------                -------------------------
  | student1 | tomcat       |                |student1  | student   |
  | -----------------------                  ------------------------
The problem: Nobody of the users can login. Help me please!


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4047619#4047619

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4047619