i don't know much about this but you mention the things that are different like dollar in password .. but have you tried setting the password to how it was when you used to use it? and putting appBase back as it was. You say you changed nothing but you've changed several things. Did you also upgrade your driver JAR?
Allistair > -----Original Message----- > From: e-Denton Subscriber [mailto:[EMAIL PROTECTED] > Sent: 26 October 2004 16:04 > To: Tomcat Users List > Subject: MySQL upgrade Problem > > > Hi, > > I just upgraded from MySql 3.x to 4.0 and now I can't make > connections work > from Tomcat. I have read a bunch of stuff on the Web about > this or similar > problems, but, even though it worked before, I can't make it > work now. > > I specify my connection info in server.xml and context.xml > just like I used > to (below). The only difference is (?) the new MySql, and the > fact that I am > trying to use a new, different password (with a dollar sign > in it). (Oh, > and, I set appBase outside the Tomcat home directory.) On > Tomcat startup, I > get: > > "JDBCRealm[Catalina]: > Exception opening database connection > java.sql.SQLException: Invalid authorization specification: > Access denied > for user: '[EMAIL PROTECTED]' (Using password: YES) > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:659)..." > > I can login manually to MySql using the same user and password. > I can access the database directly from Java programs which > make their own > connection. > > Any ideas what's going wrong? > > web.xml: > --------- > <Realm className="org.apache.catalina.realm.JDBCRealm" > debug="99" > driverName="com.mysql.jdbc.Driver" > connectionURL="jdbc:mysql://127.0.0.1:3306/xxx" > connectionName="yyy" > connectionPassword="$zzz" > userTable="portal_user" > userNameCol="clientName" > userCredCol="clientPassword" > userRoleTable="portal_role" > roleNameCol="clientRole" > digest="md5" /> > > conext.xml: > ----------- > <Resource name="jdbc/portal" auth="Container" > type="javax.sql.DataSource"/> > > <ResourceParams name="jdbc/portal"> > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>username</name> > <value>yyy</value> > </parameter> > <parameter> > <name>password</name> > <value>$zzz</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>com.mysql.jdbc.Driver</value> > </parameter> > <parameter> > <name>url</name> > > <value>jdbc:mysql://127.0.0.1:3306/xxx?autoReconnect=true</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>10</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>5</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>10000</value> > </parameter> > </ResourceParams> > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > <FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE> ------------------------------------------------------- QAS Ltd. Developers of QuickAddress Software <a href="http://www.qas.com";>www.qas.com</a> Registered in England: No 2582055 Registered in Australia: No 082 851 474 ------------------------------------------------------- </FONT> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
