Hola Jeff:
Some people has reported problems that lookclose to yours..no solutions
... please test against latest code on CVS for 3.2 branch...3.3 code (m2
is known to be broken in auth ...get it from CVS until m3 arrives..)..
or 4.0 Beta2...to give that problem another shake.. in different
flavours of tomcat..to se if that makes a difference ( i dont believe
that's wil be true but who knows ..)
For me until now...with one more code review done after reading your
message...this problem relates to the MySql JDBC Driver...so change you
Driver jar version to see if that makes a difference..
Sorry for trying to augment your problems ... not solve them..:)))
TIA.
( Please do not use HTML mail ....makes hard to chat, thanks)
Saludos ,
Ignacio J. Ortega
-----Mensaje original-----
De: Jeff Kilbride [mailto:[EMAIL PROTECTED]]
Enviado el: lunes 23 de abril de 2001 23:29
Para: [EMAIL PROTECTED]
Asunto: JDBC Realm problem
I'm using JDBC Realm with MySQL to protect an area of my website. I've
got everything configured correctly and it works. However, I've noticed
that if the protected area is accessed and then *not* accessed again for
a period longer than my MySQL connection timeout value (default of 8
hours), JDBC Realm is unable to recover and all users are sent to my
login error page.
Here's the entryfrom my tomcat.log:
----------------------------------
2001-04-23 12:51:27 - ContextManager: JDBCRealm: The database connection
is null or was found to be closed. Trying to re-open it.
2001-04-23 12:51:27 - ContextManager: JDBCRealm: There was an
SQLException while in authenticate: null
2001-04-23 12:51:27 - ContextManager: JDBCRealm: SQLException:
java.sql.SQLException: Invalid authorization specification: Access
denied for user: 'nobody@localhost' (Using password: NO)
----------------------------------
I suppose I could up the timeout value in MySQL, but isn't it a little
strange that JDBC Realm can't open a new connection to recover?
Anyone else had this problem? I'm using Tomcat 3.2.1 on Linux with
IBMJava2-13.
Thanks,
--jeff
