JDBC Relam and Form Based Authentication

[Awais Bajwa]

Hi folks,
I am having problem when I moved my application from tomcat 4 to tomcat 5.
Using the Form Based authentication with JDBC Relam.

here is my server.xml entry ..

    
 <Context className="org.apache.catalina.core.StandardContext" 
    cachingAllowed="true" 
    charsetMapperClass="org.apache.catalina.util.CharsetMapper" 
    cookies="true" 
    crossContext="false" 
    debug="0" 
    mapperClass="org.apache.catalina.core.StandardContextMapper" 
    path="/otengo-web" privileged="false" 
    reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
   </Context>
       <Realm  className="org.apache.catalina.realm.JDBCRealm"
             driverName="org.gjt.mm.mysql.Driver"
          connectionURL="jdbc:mysql://server1/otengo"
          connectionName="root" connectionPassword="e2esp"
          debug="0"  userTable="node" userNameCol="email" userCredCol="hashed_password"
          userRoleTable="node_roles" roleNameCol="role_id" />

and here is my web.xml .

<security-constraint>
<display-name>Otengo Security Constraint</display-name>
<web-resource-collection>
<web-resource-name>Protected Area</web-resource-name>
<url-pattern>/*</url-pattern>
</web-resource-collection>
<auth-constraint>
<role-name>1</role-name>
</auth-constraint>
</security-constraint>
 
 
<login-config>
<auth-method>FORM</auth-method>
<realm-name>Example Form-Based Authentication Area</realm-name>
<form-login-config>
<form-login-page>/login.do</form-login-page>
<form-error-page>/login.do?message="Login failed to"</form-error-page>
</form-login-config>
</login-config>
 
<security-role>
<description>Role</description>
<role-name>1</role-name>
</security-role>
 
 

If any idea clicks in your mind then write your reply


Regards

Awais Bajwa

[ May 29, 2006: Message edited by: Awais Bajwa ]
[ May 29, 2006: Message edited by: Awais Bajwa ]

[Awais Bajwa]

well, i am able to figure it out.
the problem was in the RDMS tables... foreign key constraint ..it has been resolved.

All above configurations are perfect.

A.B