Haven't seen this one before.
You might try using the 3.0.16 drivers with MySQL 4.0.22 and seeing if this improves anything. The 3.1.10 drivers have seen more
testing with the 4.1.x. If you're interested in internationalized operation, you should consider moving the server side up to
4.1.x.
You might also be running up against a bug in Tomcat 5.5.7 that could cause
this. It was fixed in 5.5.9.
I think it is bug http://issues.apache.org/bugzilla/show_bug.cgi?id=32646 which
fundamentally
has to do with fixing a bunch of potential leaks due to close() not being in
finally.
Here's some more (possibly) related discusssion
http://marc.theaimsgroup.com/?l=tomcat-user&m=111199890318530&w=2
--a.
----- Original Message -----
From: "Axel" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, July 28, 2005 12:13 PM
Subject: Login/realm problem?
Hi
After a while of running roller, I get the exception listed below.
Roller is still running, but if I would like to login, I get the message:
" Wrong username and password combination"
Tomcat/5.5.7
MySQL 4.0.22 / mysql-connector-java-3.1.10-bin.jar
I've setup the realm as described here for 5.5.X:
http://www.rollerweblogger.org/wiki/Wiki.jsp?page=InstallationGuide#ref-InstallationGuide-5
ERROR 2005-07-28 18:59:34,526 JDBCRealm:getPassword - Exception retrieving passw
ord for "admin"
com.mysql.jdbc.CommunicationsException: Communications link failure due to under
lying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2348)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2858)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:930)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1024)
at org.apache.catalina.realm.JDBCRealm.getPassword(JDBCRealm.java:526)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:399)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:347)
at org.apache.catalina.authenticator.FormAuthenticator.authenticate(Form
Authenticator.java:256)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:391)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:684)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION **