Richard, In your context file change
userName="ltojsw" to username="ltojsw" (and of course change your passwd now that it's on the 'net ;-) This is why you see the error: Access denied for user ''@'kingfishS11' I just tried to find some docs to make sure I'm right but I can't see anything under the 5.5 documentation :-S Hope this helps.... Tom. On Mon, 21 Feb 2005 07:32:29 -0700, Richard Mixon (qwest) <[EMAIL PROTECTED]> wrote: > > -----Original Message----- > From: Richard Mixon (qwest) [mailto:[EMAIL PROTECTED] > Sent: 21 February, 2005 7:53 AM > To: tomcat-user@jakarta.apache.org > Subject: Tomcat 5.5.7 cannot connect to mysql datasource - what changed? > > We have been using Sun Java 1.4.2, Tomcat 5.0.19, MySQL 4.1.7, MySQL > Connector/J 3.0.15 with Hibernate 2.1.7c with no problems. This is on > both Windows XP Pro SP2 (development) and SuSE Linux SLES9 (test and > production). > > In order to get failover to work the way we wanted we upgraded to Tomcat > 5.5.7 and Sun Java 1.5. The main change in our application was the new > format for data soruces in the application context. No problem on > Windows XP. We've tried to install on one of our Linux servers and are > having no end of grief getting a DB connection to properly happen. > > Any help or ideas would be much appreciated. I've included the > application context and the catalina log error messages below. > > Thanks in advance - Richard > > ***-> APPLICATION CONTEXT: > <Context path="/stars" docBase="stars" debug="99" reloadable="true" > privileged="true" antiResourceLocking="false" antiJARLocking="true" > > > <Logger className="org.apache.catalina.logger.FileLogger" > prefix="stars." suffix=".log" timestamp="true"/> > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="com.mysql.jdbc.Driver" > connectionURL="jdbc:mysql://192.168.11.3:3306/ltojsw?autoReconnec > t=true&autoCommit=true" > connectionName="ltojsw" connectionPassword="586579" > userTable="PoAssociate" userNameCol="userid" > userCredCol="password" > userRoleTable="PoUserRole" roleNameCol="roleName" /> > <Resource name="jdbc/stars" > type="javax.sql.DataSource" > auth="Container" > maxActive="100" > maxIdle="10" > maxWait="10000" > defaultAutoCommit="true" > userName="ltojsw" > password="586579" > driverClassName="com.mysql.jdbc.Driver" > url="jdbc:mysql://192.168.11.3:3306/ltojsw?aut > oReconnect=true&autoCommit=true" > removeAbandoned="true" > removeAbandonedTimeout="60" > logAbandoned="true" > /> > </Context> > > ***-> CATALINA ERROR MESSAGES: > > <SNIP> > 19:37:27,642 INFO [http-8080-Processor25] > DatasourceConnectionProvider:51 - Using datasource: > java:comp/env/jdbc/stars > 19:37:27,648 INFO [http-8080-Processor25] > TransactionManagerLookupFactory:33 - No TransactionManagerLookup > configured (in JTA environment, use of process level read-write cache is > not recommended) > AbandonedObjectPool is used > ([EMAIL PROTECTED]) > LogAbandoned: true > RemoveAbandoned: true > RemoveAbandonedTimeout: 60 > 19:37:41,696 WARN [http-8080-Processor25] SettingsFactory:107 - Could > not obtain connection metadata > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (Server connection failure during transaction. > Due to underlying exception: 'java.sql.SQLException: Access denied for > user ''@'kingfishS11' (using password: YES)'. > > ** BEGIN NESTED EXCEPTION ** > > java.sql.SQLException > MESSAGE: Access denied for user ''@'kingfishS11' (using password: YES) > > STACKTRACE: > > java.sql.SQLException: Access denied for user ''@'kingfishS11' (using > password: YES) > <SNIP> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
