Re: first authentication attempt fails - mysql timeout

2008-04-22 Thread Robert Jacobson
Christopher Schultz wrote: Yes, using DataSourceRealm is the preferred configuration. Thank you for confirming that :) [...] By the way, there's no reason not to upgrade to the most recent Connector/J, either. Sorry.. are you referring to the mysql-connector JAR file? In my

first authentication attempt fails - mysql timeout

2008-04-21 Thread Robert Jacobson
Hi, I have an existing Tomcat configuration that is working well. However, it is running version 4.1.31. We are updating the platform, so I thought I'd take the opportunity to update Tomcat. Unfortunately (??) I must stick with the Tomcat 4.1 release. I have a test machine on which I

Re: first authentication attempt fails - mysql timeout

2008-04-21 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robert, Robert Jacobson wrote: | I was authenticating using a mysql database through the JDBCRealm. I | found some posts in the archives ( | http://www.mail-archive.com/[EMAIL PROTECTED]/msg149130.html) | indicating that switching from the

Re: first authentication attempt fails - mysql timeout

2008-04-21 Thread David Smith
The DatasourceRealm will work. Drop the autoReconnect parameter from the database url though as it's not recommended by the MySQL folks. Instead, add a validationQuery to your ResourceParams so database connections are tested briefly before they are borrowed from the pool. The query can be