problem with j_security_check

[exkor5000]

Hi

This Tomcat thing is driving me insane, i don't know what else to do after exhausting the google database looking for an answer.

I'm using Tomcat 6.0 with jre1.6.0 and mySQL 5.0.
Everything was installed fine and the systems seem to communicate fine.
I can execute java code in my JSP files with no problem.

The problem is with my login page.
When i want to access a protected page i'm brought to the login page i gave in the web.xml file. I put in the username and the password, and i'm brough back to the login page. No errors in the logs what's so ever.

Does anybody know why this is happening?


I can see that the connector is connected and executing queries:

  
080611  0:25:46     16 Connect     root@localhost on hamula
     16 Query       /* mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect'
     16 Query       SHOW COLLATION
     16 Query       SET NAMES latin1
     16 Query       SET character_set_results = NULL
     16 Query       SET autocommit=1
     16 Query       SET autocommit=0
080611  0:25:59     16 Query       SELECT password FROM users WHERE uid = 'a@b.c'
     16 Query       commit

My WEB-INF/web.xml:

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

    <resource-ref>
        <description>DB Connection</description>
        <res-ref-name>jdbc/hamula</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
 
    <security-constraint>
        <web-resource-collection>
            <web-resource-name>Hamula</web-resource-name>
            <description>Pages accessible by registered users</description>
 
            <!-- PAGES ACCESIBLE ONLY BY REGISTERED USERS SHOULD BE ADDED HERE -->
            <url-pattern>/home.jsp</url-pattern>
            <url-pattern>/events.jsp</url-pattern>
            <url-pattern>/profile.jsp</url-pattern>
            <url-pattern>/community.jsp</url-pattern>
            <!--
            THIS IS AN EXAMPLE OF A PATTERN TO MATCH MANY PAGES
            <url-pattern>/protected/*.jsp</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>FORM</auth-method>
        <form-login-config>
            <form-login-page>/index.jsp</form-login-page>
            <form-error-page>/index.jsp</form-error-page>
        </form-login-config>
    </login-config>
 
    <security-role>
        <description>
            The role that is required to access registered user functions and
            pages
        </description>
        <role-name>admin</role-name>
    </security-role>
</web-app>
  

My DB:

  mysql> select uid, password, role from users;
+----------------+----------------------------------+-------+
| uid            | password                         | role  |
+----------------+----------------------------------+-------+
| a@b.c          | 033bd94b1168d7e4f0d644c3c95e35bf | admin |
| [e-mail] | test                             | admin |
+----------------+----------------------------------+-------+
2 rows in set (0.00 sec)
 
mysql>  

My META-INF/context.xml:

  <?xml version="1.0" encoding="UTF-8"?>
<Context path="/hamula" reloadable="true" crossContext="true" debug="99">
 
    <Logger className="org.apache.catalina.logger.FileLogger"
             prefix="localhost_hamula_log." suffix=".txt"
             timestamp="true"/>
 
    <Resource name="jdbc/hamula"
              auth="Container"
              type="javax.sql.DataSource"
              driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://localhost:3306/hamula?autoReconnect=true"/>
              username="root"
              password="skywalker"
      digest="MD5"
              logAbandoned="true"
              removeAbandoned="true"
              removeAbandonedTimeout="10"
              maxActive="20"
              maxIdle="10"
              maxWait="-1"/>
 

    <Realm className="org.apache.catalina.realm.JDBCRealm"
           driverName="com.mysql.jdbc.Driver"
           connectionURL="jdbc:mysql://localhost:3306/hamula"
           connectionName="root"
           connectionPassword="skywalker"
   digest="MD5"
           userTable="users" userNameCol="uid"
           userCredCol="password"
           userRoleTable="users" roleNameCol="role"/>
</Context>

[exkor5000]

and my form in index.jsp is:

<form name="input" action="j_security_check" method="post">
                    <table align="center">
                        <tr>
                            <td>
                                <b>email:</b>
                            </td>
    
                            <td>
                                <input type="text" name="j_username" class="textInput" />
                            </td>
                        </tr>
    
                        <tr>
                            <td>
                                <b>password:</b>
                            </td>
    
                            <td>
                                <input type="text" name="j_password" class="textInput" />
                            </td>
                        </tr>
    
                        <tr>
                            <td></td>
                            <td>
                                <input type="submit" value="Login" class="button" />
                            </td>
                        </tr>
                    </table>
                </form>

[Bear Bibeault]

"exkor5000", please check your private messages for an important administrative matter.