Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 25929 invoked from network); 1 Nov 2001 16:50:12 -0000 Received: from unknown (HELO osaka.betaversion.org) (192.18.49.133) by daedalus.apache.org with SMTP; 1 Nov 2001 16:50:12 -0000 Received: (qmail 1544 invoked from network); 1 Nov 2001 16:52:27 -0000 Received: from nagoya.betaversion.org (192.18.49.131) by osaka.betaversion.org with SMTP; 1 Nov 2001 16:52:27 -0000 Received: (qmail 5669 invoked by uid 97); 1 Nov 2001 16:47:30 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org Received: (qmail 5595 invoked by uid 97); 1 Nov 2001 16:47:26 -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 5344 invoked from network); 1 Nov 2001 16:47:21 -0000 Mime-Version: 1.0 X-Sender: paul@central.snake.net Message-Id: In-Reply-To: <01110111484901.09717@NetOps.ento.cornell.edu> References: <01110111484901.09717@NetOps.ento.cornell.edu> Date: Thu, 1 Nov 2001 10:47:16 -0600 To: "Tomcat Users List" From: Paul DuBois Subject: Re: MySQL jdbc connection url [ + server.xml bug] Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N At 11:48 AM -0500 11/1/01, David Smith wrote: >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 >real URL should loo something like: > >jdbc:mysql://localhost/authority?user=test&password=test > >This is how I had to write it in my server.xml file. Works like a charm. >The encoding does not have to be done in regular JSP or java files. Only XML >files like server.xml require this. Everywhere else, just use an & character. > >--David Smith Quite right. I neglected to mention that. Thanks for pointing it iout. > >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="jdbc:mysql://localhost/authority?user=test;password=test" >> > but it goes wrong - it says "Invalid authorization exception: Access >> >denied for user: 'test;password@host'. >> > I've configured server side permissions properly (mySQL accepts using >> >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 probably >> 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="jdbc:mysql://localhost/authority?user=test&password=test" -- To unsubscribe: For additional commands: Troubles with the list: