AW: TC 3.3 JDBCRealm: Authentication unsuccessful

2001-11-27 Thread Lichtmannegger Manfred 

Any ideas/proposals how I can to proceed to find the problem?

I have downloaded the source code and inserted additional log
statements (*)

It was a my problem - i.e. a user problem. 

When I filled the oracle database I supposed a autocommit.

But there was no autocommit and therefore the inserted rows
are not visible to the servlet container :-(

 manfred

(*) and I have seen that indeed the servlet container computes
the digest and no browser is involved :-)

--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]

TC 3.3 JDBCRealm: Authentication unsuccessful

2001-11-26 Thread Lichtmannegger Manfred 

I am trying to use JDBCRealm on Tomcat 3.3, but after fixing my first
problems CLASSPATH, driver etc. I always get 

2001-11-26 17:04:24 - DecodeInterceptor: Charset from session ISO-8859-1
2001-11-26 17:04:41 - DecodeInterceptor: Charset from session ISO-8859-1
2001-11-26 17:04:42 - JDBCRealm: 
 JDBCRealm.authenticate: SELECT user_pass FROM admin_users WHERE user_name = ?
2001-11-26 17:04:42 - JDBCRealm: Authentication unsuccessful for user try12
2001-11-26 17:06:11 - DecodeInterceptor: Charset from session ISO-8859-1
2001-11-26 17:06:22 - DecodeInterceptor: Charset from session ISO-8859-1
2001-11-26 17:06:22 - JDBCRealm: Authentication unsuccessful for user try12

I have first tried with MD5, but also without a digest attribute I got the
same Authentication unsuccessful.

My entry in server.xml:

JDBCRealm
 debug=99 
 driverName=oracle.jdbc.driver.OracleDriver 
 connectionURL=jdbc:oracle:thin:@...
 connectionName=scott
 connectionPassword=tiger 
 userTable=admin_users 
 userNameCol=user_name 
 userCredCol=user_pass 
 userRoleTable=admin_user_roles 
 roleNameCol=role_name 
/

I have not removed

   SimpleRealm  filename=conf/users/global-users.xml /

My test examples was derived from examples/security and runs with SimpleRealm.

Any ideas/proposals how I can to proceed to find the problem?

 manfred

btw: I have used Netscape Communicator 4.5. and IE 5.50, but I guess 
 the digest is computed in the servlet container and compared with the 
 digest in the database, and on the browser no digest are computed - 
 JDBCRealm-howto.html is not very explicit about this point.

mailto:[EMAIL PROTECTED]   Tel +49 89 722 59708
Siemens AG Information and Communication Mobile  mobile 0172 8591307
Solutions Customer Projects Project Engineering  Fax +49 89 722 54725
Hofmannstr. 51, D-81359 München (Mch H/Ge15 18600/339)
 

--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]