1 Reply Latest reply on Nov 21, 2004 9:40 PM by infectedrhythms

    Setting up login from DB.

    infectedrhythms Nov 21, 2004 9:36 PM

      Hey am still having problems this time I decided to use dault values...

      login-config.xml...

       <application-policy name = "Mamoth">
 <authentication>
 <login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule"
 flag = "required">
 <module-option name = "unauthenticatedIdentity">guest</module-option>
 <module-option name = "dsJndiName">java:/jdbc/MamothDB</module-option>
 </login-module>
 </authentication>
 </application-policy>


      jboss-web.xml... 
      <jboss-web>
 <context-root>/mamoth</context-root>
 <security-domain>java:/jaas/Mamoth</security-domain>
 <resource-ref>
 <res-ref-name>jdbc/MamothDB</res-ref-name>
 <jndi-name>java:/jdbc/MamothDB</jndi-name>
 </resource-ref>
</jboss-web>


      web.xml... 
      <web-app>
 <display-name>mamoth Blue</display-name>
 <description>mamoth Blue web site</description>


 <security-constraint>
 <web-resource-collection>
 <web-resource-name>Mamoth</web-resource-name>
 <description>Mamoth Blue security</description>
 <url-pattern>/*</url-pattern>
 <http-method>GET</http-method>
 <http-method>POST</http-method>
 </web-resource-collection>
 <auth-constraint>
 <role-name>Admin</role-name>
 </auth-constraint>
 </security-constraint>


 <login-config>
 <auth-method>BASIC</auth-method>
 <realm-name>Mamoth Blue</realm-name>
 </login-config>

 <security-role>
 <role-name>Admin</role-name>
 </security-role>



 <welcome-file-list>
 <welcome-file>index.jsp</welcome-file>
 </welcome-file-list>

 <resource-ref>
 <description>DB Connection</description>
 <res-ref-name>jdbc/MamothDB</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
 </resource-ref>


 <!--
 //-->
</web-app>


      db structure... 
      # Host: localhost
# Database: mamoth
# Table: 'principals'
#
CREATE TABLE `principals` (
 `PrincipalID` varchar(64) NOT NULL default '',
 `Password` varchar(64) NOT NULL default '',
 PRIMARY KEY (`PrincipalID`)
) TYPE=MyISAM;

# Host: localhost
# Database: mamoth
# Table: 'roles'
#
CREATE TABLE `roles` (
 `PrincipalID` varchar(64) NOT NULL default '',
 `Role` varchar(32) NOT NULL default '',
 `RoleGroup` varchar(32) NOT NULL default '',
 PRIMARY KEY (`PrincipalID`)
) TYPE=MyISAM;


      • 2452 Views
      • Tags: