Return-Path: 
 <tomcat-user-return-113533-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 6530 invoked from network); 26 Oct 2004 15:05:26 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 26 Oct 2004 15:05:26 -0000
Received: (qmail 68578 invoked by uid 500); 26 Oct 2004 15:03:49 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 68539 invoked by uid 500); 26 Oct 2004 15:03:49 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 68497 invoked by uid 99); 26 Oct 2004 15:03:48 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from [209.11.145.3] (HELO mars.webappcabaret.net) (209.11.145.3)
  by apache.org (qpsmtpd/0.28) with SMTP; Tue, 26 Oct 2004 08:03:45 -0700
Received: (qmail 11219 invoked by uid 5130); 26 Oct 2004 15:03:37 -0000
Received: from subscriber@e-denton.com by d7000 by uid 5080 with
 qmail-scanner-1.20rc1
 (spamassassin: 2.x.  Clear:RC:0:SA:0(0.0/10.0):.
 Processed in 0.235663 secs); 26 Oct 2004 15:03:37 -0000
X-Spam-Status: No, hits=0.0 required=10.0
Received: from unknown (HELO hardpc) (subscriber:e-denton.com@68.191.217.38)
  by 172.16.1.3 with SMTP; 26 Oct 2004 15:03:37 -0000
Message-ID: <002e01c4bb6d$01f55060$6400a8c0@hardpc>
Reply-To: "e-Denton Subscriber" <subscriber@e-denton.com>
From: "e-Denton Subscriber" <subscriber@e-denton.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
References: <002101c4bb5b$6d920280$0201a8c0@sjklaptop>
Subject: MySQL upgrade Problem
Date: Tue, 26 Oct 2004 10:03:52 -0500
Organization: e-Denton.com
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

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: 'xxx@localhost' (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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org