0000257: JdbcAuthenticator Problem

257

minor

always

06-12-05 00:00

01-27-06 14:39

Reporter:

user243

Platform:

Assigned To:

ferg

OS:

Priority:

low

OS Version:

Status:

closed

Product Version:

Product Build:

3.0.13

Resolution:

unable to reproduce

Projection:

none

ETA:

none

Fixed in Version:

Summary:

0000257: JdbcAuthenticator Problem

Description:

RSN-280
I can seem to get the JdbcAuthenticator to work. XmlAuthenticator works fine but JDBC does not. The <host> fragment from my resin.conf and the login page are listed below. I have confirmed that the <password-query> is being executed because I see it showing up in the MySQL logs, I have executed the query by hand substituting the '?' for a value signon. After submitting the login, I get the login page redisplaced and the URL is listed as:
http://localhost:8080/j_security_check [^]

Thanks for the help.

From resin.conf:
----------------
    <host id="" root-directory=".">
      
      <web-app id="/" document-directory="webapps/ROOT">
        <authenticator type='com.caucho.server.security.JdbcAuthenticator'>
        
           <init>
           
                   <data-source>jdbc/mysql/pm</data-source>
                   <password-query>SELECT ifnull(password,'hollow') as Password FROM pm.Person WHERE LastName = ?</password-query>
                   <cookie-auth-query>SELECT LastName FROM pm.Person WHERE cookie=?</cookie-auth-query>
                   <cookie-auth-update>UPDATE pm.Person SET cookie=? WHERE LastName=?</cookie-auth-update>
                   <role-query>SELECT role FROM pm.Person WHERE LastName=?</role-query>
               </init>
            </authenticator>
           <login-config auth-method='form'>
               <form-login-config form-login-page='/pm/login.jsp' form-error-page='/pm/Login.jsp?login=failed' internal-forward='true' form-uri-priority='true'/>
           </login-config>
           <security-constraint url-pattern='/pm/*' role-name='admin'/>
       </web-app>

    </host>
---------------------------------
login.jsp
----------------------------------
<html>
<head><title>Login</title></head>
<script type="text/javascript">
function resize()
{
    window.moveTo(100,150);
    window.resizeTo(500,300);
}
</script>
<body onload='resize()'>
<center>
<form action='j_security_check' method='POST'>
<table>
<tr><td>User:<td><input name='j_username' value='admin'/>
<tr><td>Password:<td><input type=password name='j_password'/>
<tr><td><input type=submit value='login'/>
<td>hint: the password is 6 letters and completes the phase "fox _ _ _ _ _ _"
<td><input type=hidden name='j_uri' value='/pm/login2.jsp'/>
</table>
</form>
</center>
</body>
</html>

Steps To Reproduce:

Additional Information:

Windows XP, MySQL

Relationships

Attached Files:

Mantis - Resin
Viewing Issue Advanced Details

ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
257		minor	always	06-12-05 00:00	01-27-06 14:39

Reporter:	user243	Platform:
Assigned To:	ferg	OS:
Priority:	low	OS Version:
Status:	closed	Product Version:
Product Build:	3.0.13	Resolution:	unable to reproduce
Projection:	none
ETA:	none	Fixed in Version:

Summary:	0000257: JdbcAuthenticator Problem
Description:	RSN-280 I can seem to get the JdbcAuthenticator to work. XmlAuthenticator works fine but JDBC does not. The <host> fragment from my resin.conf and the login page are listed below. I have confirmed that the <password-query> is being executed because I see it showing up in the MySQL logs, I have executed the query by hand substituting the '?' for a value signon. After submitting the login, I get the login page redisplaced and the URL is listed as: http://localhost:8080/j_security_check [^] Thanks for the help. From resin.conf: ---------------- <host id="" root-directory="."> <!-- - configures an explicit root web-app matching the - webapp's ROOT --> <web-app id="/" document-directory="webapps/ROOT"> <authenticator type='com.caucho.server.security.JdbcAuthenticator'> <!-- authenticator type="com.caucho.server.security.XmlAuthenticator"--> <init> <!-- <user>admin:iiiii0:admin,user</user> <user>guest:hollow:user</user> <password-digest>none</password-digest> --> <data-source>jdbc/mysql/pm</data-source> <password-query>SELECT ifnull(password,'hollow') as Password FROM pm.Person WHERE LastName = ?</password-query> <cookie-auth-query>SELECT LastName FROM pm.Person WHERE cookie=?</cookie-auth-query> <cookie-auth-update>UPDATE pm.Person SET cookie=? WHERE LastName=?</cookie-auth-update> <role-query>SELECT role FROM pm.Person WHERE LastName=?</role-query> </init> </authenticator> <login-config auth-method='form'> <form-login-config form-login-page='/pm/login.jsp' form-error-page='/pm/Login.jsp?login=failed' internal-forward='true' form-uri-priority='true'/> </login-config> <security-constraint url-pattern='/pm/*' role-name='admin'/> </web-app> </host> --------------------------------- login.jsp ---------------------------------- <html> <head><title>Login</title></head> <script type="text/javascript"> function resize() { window.moveTo(100,150); window.resizeTo(500,300); } </script> <body onload='resize()'> <center> <form action='j_security_check' method='POST'> <table> <tr><td>User:<td><input name='j_username' value='admin'/> <tr><td>Password:<td><input type=password name='j_password'/> <tr><td><input type=submit value='login'/> <td>hint: the password is 6 letters and completes the phase "fox _ _ _ _ _ _" <td><input type=hidden name='j_uri' value='/pm/login2.jsp'/> </table> </form> </center> </body> </html>
Steps To Reproduce:
Additional Information:	Windows XP, MySQL
Relationships
Attached Files: