Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 20725 invoked from network); 1 Nov 2001 16:44:47 -0000 Received: from unknown (HELO osaka.betaversion.org) (192.18.49.133) by daedalus.apache.org with SMTP; 1 Nov 2001 16:44:47 -0000 Received: (qmail 26998 invoked from network); 1 Nov 2001 16:47:01 -0000 Received: from nagoya.betaversion.org (192.18.49.131) by osaka.betaversion.org with SMTP; 1 Nov 2001 16:47:01 -0000 Received: (qmail 22767 invoked by uid 97); 1 Nov 2001 16:43:24 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org Received: (qmail 22610 invoked by uid 97); 1 Nov 2001 16:43:22 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 22507 invoked from network); 1 Nov 2001 16:43:20 -0000 Content-Type: text/plain; charset="iso-8859-1" From: David Smith Organization: Cornell University To: "Tomcat Users List" Subject: Re: MySQL jdbc connection url [ + server.xml bug] Date: Thu, 1 Nov 2001 11:48:49 -0500 X-Mailer: KMail [version 1.2] References: In-Reply-To: MIME-Version: 1.0 Message-Id: <01110111484901.09717@NetOps.ento.cornell.edu> Content-Transfer-Encoding: quoted-printable X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N An additional note on the & character in the connection URL for MySQL... XML syntax is going to require the & character be encoded as & so the= =20 real URL should loo something like: jdbc:mysql://localhost/authority?user=3Dtest&password=3Dtest This is how I had to write it in my server.xml file. Works like a charm.= =20 The encoding does not have to be done in regular JSP or java files. Only= XML=20 files like server.xml require this. Everywhere else, just use an & chara= cter. --David Smith On Thursday 01 November 2001 11:16 am, you wrote: > At 1:51 PM +0100 11/1/01, Andrius wrote: > >Hello, > > What's the correct MySQL jdbc connection url? I'm trying to setup > >jdbcRealm on tomcat 4.0.1, > > and using this url pattern : > >connectionURL=3D"jdbc:mysql://localhost/authority?user=3Dtest;password= =3Dtest" > > but it goes wrong - it says "Invalid authorization exception: Acce= ss > >denied for user: 'test;password@host'. > > I've configured server side permissions properly (mySQL accepts u= sing > >another client). thanx for any response. > > > >obj. > > Only very old versions of the MM.MySQL driver accept ; as a parameter > separator character. Current versions accept only & as the separator. > > If any of the Tomcap developers happen to read this: > > Note that the server.xml file that ships with Tomcat 4.0.1 (and probabl= y > earlier versions as well) is mistaken on this point. The relevant > section looks > like this: > > > > The connectionURL line should be fixed to say this instead: > > connectionURL=3D"jdbc:mysql://localhost/authority?user=3Dtest&password=3D= test" > > -- > To unsubscribe: > For additional commands: > Troubles with the list: -- To unsubscribe: For additional commands: Troubles with the list: