RE: Form based authentication and JDBC Realm with Interbase
Please post your server.xml JDBRealm config, to have a look at it.. Saludos , Ignacio J. Ortega -Mensaje original- De: Nigel Stirzaker [mailto:[EMAIL PROTECTED]] Enviado el: martes 23 de enero de 2001 12:41 Para: '[EMAIL PROTECTED]' Asunto: Form based authentication and JDBC Realm with Interbase Hi I'am try to get form based authentication working with jBoss/Tomcat and interbase 5.6 but I'am getting the following error. Interbase is working fine for the CMP and code and general setup works fine with mySQL (our other trial database). It looks to me like the param being setup for the query by PreparedStatement.setString is Null and hence the error Version used Interclient 1.6 jBoss 2.0 Final Tomcat 3.2 Win 2000 2001-01-23 10:23:17 - ContextManager: JDBCRealm: JDBCRealm.authenticate: SELECT USER_PASS FROM USERS WHERE USER_NAME = ? 2001-01-23 10:23:18 - Ctx( /war ): Exception in: R( /war + /member/test.jsp + null) - java.lang.NullPointerException at interbase.interclient.PreparedStatement.setString(Unknown Source) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:306) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:480) at org.apache.tomcat.core.ContextManager.doAuthenticate(ContextMa nager.java, Compiled Code) at org.apache.tomcat.core.RequestImpl.getRemoteUser(RequestImpl.java:341) at org.apache.tomcat.request.JDBCRealm.authorize(JDBCRealm.java:501) at org.apache.tomcat.core.ContextManager.doAuthorize(ContextManager.java, Compiled Code) at org.apache.tomcat.core.ContextManager.internalService(ContextM anager.java:78 9) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processCo nnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java, Compiled Code) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java, Compiled Code) at java.lang.Thread.run(Thread.java:479) Anybody got any ideas Thanks in advance Nigel Nigel Stirzaker Software Consultant SSA Softwright (01753) 811833 Ext 265 [EMAIL PROTECTED] www.Softwright.co.uk - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
RE: Form based authentication and JDBC Realm with Interbase
Thanks I've posted it onto the list. Here is a copy aswell RequestInterceptor className="org.apache.tomcat.request.JDBCRealm" debug="99" driverName="interbase.interclient.Driver" connectionURL="jdbc:interbase://localhost:3060/D:/Development/DBs/authority. gdb" connectionName="sysdba" connectionPassword="masterkey" userTable="USERS" userNameCol="USER_NAME" userCredCol="USER_PASS" userRoleTable="USER_ROLES" roleNameCol="ROLE_NAME" / RequestInterceptor className="org.apache.tomcat.request.Jdk12Interceptor" debug="0" / thanks Nigel Stirzaker Software Consultant SSA Softwright (01753) 811833 Ext 265 [EMAIL PROTECTED] www.Softwright.co.uk -Original Message- From: Ignacio J. Ortega [mailto:[EMAIL PROTECTED]] Sent: Tuesday 23 January 2001 12:07 To: '[EMAIL PROTECTED]' Subject: RE: Form based authentication and JDBC Realm with Interbase Please post your server.xml JDBRealm config, to have a look at it.. Saludos , Ignacio J. Ortega -Mensaje original- De: Nigel Stirzaker [mailto:[EMAIL PROTECTED]] Enviado el: martes 23 de enero de 2001 12:41 Para: '[EMAIL PROTECTED]' Asunto: Form based authentication and JDBC Realm with Interbase Hi I'am try to get form based authentication working with jBoss/Tomcat and interbase 5.6 but I'am getting the following error. Interbase is working fine for the CMP and code and general setup works fine with mySQL (our other trial database). It looks to me like the param being setup for the query by PreparedStatement.setString is Null and hence the error Version used Interclient 1.6 jBoss 2.0 Final Tomcat 3.2 Win 2000 2001-01-23 10:23:17 - ContextManager: JDBCRealm: JDBCRealm.authenticate: SELECT USER_PASS FROM USERS WHERE USER_NAME = ? 2001-01-23 10:23:18 - Ctx( /war ): Exception in: R( /war + /member/test.jsp + null) - java.lang.NullPointerException at interbase.interclient.PreparedStatement.setString(Unknown Source) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:306) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:480) at org.apache.tomcat.core.ContextManager.doAuthenticate(ContextMa nager.java, Compiled Code) at org.apache.tomcat.core.RequestImpl.getRemoteUser(RequestImpl.java:341) at org.apache.tomcat.request.JDBCRealm.authorize(JDBCRealm.java:501) at org.apache.tomcat.core.ContextManager.doAuthorize(ContextManager.java, Compiled Code) at org.apache.tomcat.core.ContextManager.internalService(ContextM anager.java:78 9) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processCo nnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java, Compiled Code) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java, Compiled Code) at java.lang.Thread.run(Thread.java:479) Anybody got any ideas Thanks in advance Nigel Nigel Stirzaker Software Consultant SSA Softwright (01753) 811833 Ext 265 [EMAIL PROTECTED] www.Softwright.co.uk - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
RE: FORM based Authentication and JDBC Realm
please sendthe excerpt of your server.xml file with the requestinterceptor Thanks Saludos , Ignacio J. Ortega -Mensaje original- De: Vincent Harcq [mailto:[EMAIL PROTECTED]] Enviado el: viernes 5 de enero de 2001 17:45 Para: [EMAIL PROTECTED] Asunto: FORM based Authentication and JDBC Realm Hi! Tomcat 3.2.1 Interbase 6 Database. I have setup JDBCRealm and I am trying to use the /examples/jsp/security/protected/index.jsp that is provided with Tomcat to validate it. So I only change server.xml, I use the original web.xml from the example application. When I go to the I receive Exception 2001-01-05 05:27:31 - ContextManager: JDBCRealm: JDBCRealm.authenticate: SELECT user_pass FROM j2eeusers WHERE user_name= ? 2001-01-05 05:27:31 - Ctx( /vmi ): Exception in: R( /vmi + /jsp/protected/index.html + null) - java.lang.NullPointerException at interbase.interclient.PreparedStatement.setString(PreparedStatement.java :973) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:306) When I first go to the login.jsp, I can log in and then go on the protected resources. Strange. Any ideas ? Vincent HARCQ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]