RE: JDBCReamls Still freeze after 24 hours wokrs
So know i have some strange reaction. Firstly i have a double Identification asked - 1 through the basic form (windowed) - 1 through the html form (which is the one I set up) After a night use, I have really strange reaction : Firstly I have connection refused, then I try again later and manage to be authentify. I try again, I log out and retry, and this time I got Error: 500 Location: /capimmo/my/index.jsp Internal Servlet Error: java.lang.NullPointerException at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java:251) at org.apache.tomcat.modules.aaa.JDBCRealm.checkPassword(JDBCRealm.java:278) at org.apache.tomcat.modules.aaa.JDBCRealm.authenticate(JDBCRealm.java:441) at org.apache.tomcat.core.Request.getRemoteUser(Request.java:476) at org.apache.tomcat.modules.aaa.AccessInterceptor.authorize(AccessInterceptor.java:313) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:773) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:701) at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:143) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:424) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:497) at java.lang.Thread.run(Thread.java:484) So I have no real answer yet. Still using Tomcat : jakarta-tomcat-3.3-m2 Mysql : Mysql Ver 11.12 Distrib 3.23.32 JDBC driver : mm.mysql-2.0.4-bin.jar. OS : Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686 java: java version "1.3.0" Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0) Java HotSpot(TM) Client VM (build 1.3.0, mixed mode) yours sincerely,
RE: JDBCReamls Still freeze after 24 hours wokrs
I think this was a problem introduced by me, when trying to solve the FORM auht with no cookies, i will sendyou a recently made set of jar for TC3.3..( when the CVS update got done, it's slow today ) .. Sorry.., It's a problem to be able to reproduce the problem early.., and not evry 24 hours. i will continue trying to help you... Saludos , Ignacio J. Ortega -Mensaje original- De: Kaneda K [mailto:[EMAIL PROTECTED]] Enviado el: mircoles 11 de abril de 2001 12:30 Para: [EMAIL PROTECTED] Asunto: RE: JDBCReamls Still freeze after 24 hours wokrs So know i have some strange reaction. Firstly i have a double Identification asked - 1 through the basic form (windowed) - 1 through the html form (which is the one I set up) After a night use, I have really strange reaction : Firstly I have connection refused, then I try again later and manage to be authentify. I try again, I log out and retry, and this time I got Error: 500 Location: /capimmo/my/index.jsp Internal Servlet Error: java.lang.NullPointerException at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatem ent.java:251) at org.apache.tomcat.modules.aaa.JDBCRealm.checkPassword(JDBCReal m.java:278) at org.apache.tomcat.modules.aaa.JDBCRealm.authenticate(JDBCRealm .java:441) at org.apache.tomcat.core.Request.getRemoteUser(Request.java:476) at org.apache.tomcat.modules.aaa.AccessInterceptor.authorize(Acce ssInterceptor.java:313) at org.apache.tomcat.core.ContextManager.internalService(ContextM anager.java:773) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:701) at org.apache.tomcat.modules.server.Http10Interceptor.processConn ection(Http10Interceptor.java:143) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi nt.java:424) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run( ThreadPool.java:497) at java.lang.Thread.run(Thread.java:484) So I have no real answer yet. Still using Tomcat : jakarta-tomcat-3.3-m2 Mysql : Mysql Ver 11.12 Distrib 3.23.32 JDBC driver : mm.mysql-2.0.4-bin.jar. OS : Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686 java: java version "1.3.0" Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0) Java HotSpot(TM) Client VM (build 1.3.0, mixed mode) yours sincerely,
RE: JDBCReamls Still freeze after 24 hours wokrs
Here are the logs : 2001-04-05 08:02:18 - ContextManager: JDBCRealm: The database connection is null or was found to be closed. Trying to re-open it. 2001-04-05 08:02:18 - ContextManager: JDBCRealm: Auth ok, first role=cap_acheteur _conn != null Sql query : select * from role 2001-04-06 09:43:29 - ContextManager: Error mapping the request R( /capimmo + /my/ + null) 302 2001-04-06 09:43:29 - Ctx( /capimmo ): Handler tomcat.redirectHandler(null/null) tomcat.redirectHandler 2001-04-06 09:43:29 - ContextManager: Authorize status 401 2001-04-06 09:43:29 - ContextManager: Authorize error R( /capimmo + /my/index.jsp + null) 401 2001-04-06 09:43:29 - Ctx( /capimmo ): Handler tomcat.formAuthHandler(null/null) tomcat.formAuthHandler 2001-04-06 09:43:29 - Ctx( /capimmo ): Handler tomcat.redirectHandler(null/null) tomcat.redirectHandler 2001-04-06 09:43:29 - ContextManager: Authorize status 401 2001-04-06 09:43:29 - ContextManager: Authorize status 401 2001-04-06 09:43:29 - ContextManager: Authorize status 401 2001-04-06 09:43:29 - ContextManager: Authorize status 401 2001-04-06 09:43:36 - Ctx( /capimmo ): Handler tomcat.redirectHandler(null/null) tomcat.redirectHandler 2001-04-06 09:43:36 - ContextManager: JDBCRealm: The database connection is null or was found to be closed. Trying to re-open it. java.io.IOException: Broken pipe at java.net.SocketOutputStream.socketWrite(Native Method) at java.net.SocketOutputStream.write(SocketOutputStream.java:83) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:72) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:130) at java.io.DataOutputStream.flush(DataOutputStream.java:104) at org.gjt.mm.mysql.MysqlIO.send(MysqlIO.java) at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java) at org.gjt.mm.mysql.Connection.execSQL(Connection.java) at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:299) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:453) at org.apache.tomcat.core.ContextManager.doAuthenticate(ContextManager.java:837) at org.apache.tomcat.core.RequestImpl.getRemoteUser(RequestImpl.java:341) at org.apache.tomcat.request.JDBCRealm.authorize(JDBCRealm.java:475) at org.apache.tomcat.core.ContextManager.doAuthorize(ContextManager.java:855) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:789) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Thread.java:484) 2001-04-06 09:43:36 - ContextManager: JDBCRealm: There was an SQLException while in authenticate: testAll 2001-04-06 09:43:36 - ContextManager: JDBCRealm: SQLException: java.sql.SQLException: Communication link failure: java.io.IOException 2001-04-06 09:43:36 - ContextManager: Authorize status 401 2001-04-06 09:43:36 - ContextManager: Authorize error R( /capimmo + /my/index.jsp + null) 401 2001-04-06 09:43:36 - Ctx( /capimmo ): Handler tomcat.formAuthHandler(null/null) tomcat.formAuthHandler 2001-04-06 09:43:36 - Ctx( /capimmo ): Handler tomcat.redirectHandler(null/null) tomcat.redirectHandler 2001-04-06 09:43:37 - ContextManager: Authorize status 401 2001-04-06 09:43:37 - ContextManager: Authorize status 401 2001-04-06 09:43:37 - ContextManager: Authorize status 401 2001-04-06 09:43:37 - ContextManager: Authorize status 401 I wonder, in my project I use a database Pooling from tableGenerator (http://freespace.virgin.net/joe.carter/TableGen/index.html) that use 2 class : DbGlobal And DatabaseAccess that use org.ewin.sql.* pakadges; the line " _conn != null Sql query : select * from role" came from my debugge variable, it means that theis was a sql query It seams to me that the session never ends. and that it broke the pipe in the end. Could you help me ?? At 13:13 04/04/2001 +0200, you wrote: Please some logs, config files..every bit of info you can send will be useful trying to find that.. attached files better.. Versions of JDBC drivers db too TIA Saludos , Ignacio J. Ortega -Mensaje original- De: Kaneda K [mailto:[EMAIL PROTECTED]] Enviado el: mircoles 4 de abril de 2001 13:02 Para: [EMAIL PROTECTED] Asunto: JDBCReamls Still freeze after 24 hours wokrs Hello, I upgrade my tomcat to 3.2.2 beta 6 (BTW how to check version when you did not downloaded it yourself ?) and the JDBCReamls still freeze after 24 hours. on
RE: JDBCReamls Still freeze after 24 hours wokrs
Please some logs, config files..every bit of info you can send will be useful trying to find that.. attached files better.. Versions of JDBC drivers db too TIA Saludos , Ignacio J. Ortega -Mensaje original- De: Kaneda K [mailto:[EMAIL PROTECTED]] Enviado el: mircoles 4 de abril de 2001 13:02 Para: [EMAIL PROTECTED] Asunto: JDBCReamls Still freeze after 24 hours wokrs Hello, I upgrade my tomcat to 3.2.2 beta 6 (BTW how to check version when you did not downloaded it yourself ?) and the JDBCReamls still freeze after 24 hours. on redhat 6.2 jdk sun 1.3.0 256 mo Ram the package I download was at this url : http://jakarta.apache.org/builds/jakarta-tomcat/release/v3.2.2 -beta-2/bin/jakarta-tomcat-3.2.2b2.zip
RE: JDBCReamls Still freeze after 24 hours wokrs
At 13:13 04/04/2001 +0200, you wrote: Please some logs, config files..every bit of info you can send will be useful trying to find that.. attached files better.. Versions of JDBC drivers db too TIA Saludos , Ignacio J. Ortega server.xml : RequestInterceptor className="org.apache.tomcat.request.JDBCRealm" debug="99" driverName="org.gjt.mm.mysql.Driver" connectionURL="jdbc:mysql://192.168.111.20/capimmo" connectionName="javaCheck" connectionPassword="" userTable="utilisateur" userNameCol="IdUtilisateur" userCredCol="Password" userRoleTable="userRole" roleNameCol="NomRoleFK" / web.xml : security-constraint web-resource-collection web-resource-nameProtected Area/web-resource-name !-- Define the context-relative URL(s) to be protected -- url-pattern/admin/*/url-pattern url-pattern/my/*/url-pattern !-- If you list http methods, only those methods are protected -- http-methodDELETE/http-method http-methodGET/http-method http-methodPOST/http-method http-methodPUT/http-method /web-resource-collection auth-constraint !-- Anyone with one of the listed roles may access this area -- role-namecap_acheteur/role-name role-namecap_vendeur/role-name role-namecap_agence/role-name role-namecap_admin/role-name /auth-constraint /security-constraint login-config auth-methodFORM/auth-method realm-namePlease identify yourself/realm-name form-login-config form-login-page/security/login/Login.jsp/form-login-page form-error-page/security/login/Error.jsp/form-error-page /form-login-config /login-config the database is Mysql Ver 11.12 Distrib 3.23.32, JDBC Driver is mm.mysql-2.0.2-bin.jar (I recently upgrade to mm.mysql-2.0.4-bin.jar) but it did not change anything. I don't have logs because I un comment the logger action. but I set it back and send you the Logs has soon has I got them (next 24 hours). Thanks. -Mensaje original- De: Kaneda K [mailto:[EMAIL PROTECTED]] Enviado el: mircoles 4 de abril de 2001 13:02 Para: [EMAIL PROTECTED] Asunto: JDBCReamls Still freeze after 24 hours wokrs Hello, I upgrade my tomcat to 3.2.2 beta 6 (BTW how to check version when you did not downloaded it yourself ?) and the JDBCReamls still freeze after 24 hours. on redhat 6.2 jdk sun 1.3.0 256 mo Ram the package I download was at this url : http://jakarta.apache.org/builds/jakarta-tomcat/release/v3.2.2 -beta-2/bin/jakarta-tomcat-3.2.2b2.zip
