Hi
I have configured Apache 2.0 with Tomcat 6.0 and MySQL 5.0.
When i try to login using the following form:
<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="password" name="j_password" class="textInput" />
</td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" value="Login" class="button" />
</td>
</tr>
</table>
</form>
I get back to the login page, even though the username + password are correct.
I can see the connector connecting to the database and quering the right table via the mysql logs:
15 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'
15 Query SHOW COLLATION
15 Query SET NAMES latin1
15 Query SET character_set_results = NULL
15 Query SET autocommit=1
15 Query SET autocommit=0
080610 23:47:39 15 Query SELECT password FROM users WHERE uid = 'a@b.c'
15 Query commit
080610 23:57:12 15 Query SELECT password FROM users WHERE uid = 'a@b.c'
15 Query commit
080610 23:58:04 15 Query SELECT password FROM users WHERE uid = 'admin'
15 Query commit
however nothing is happening!!
Any suggestions on where to look? Did I forget something?
I did not configure SSL so might this be a problem? (my intention is to avoid SSL for now but maybe it's a requirement for j_security_check)
Thanks
Edited by: exkor5000 on Jun 11, 2008 4:11 PM