Tom, thanks - finally figured out the "username" error. And thanks on the password. - Richard
Tom A wrote: > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]