tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul DuBois <p...@snake.net>
Subject Re: MySQL jdbc connection url [ + server.xml bug]
Date Thu, 01 Nov 2001 16:47:16 GMT
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 &amp; so the
>real URL should loo something like:
>
>jdbc:mysql://localhost/authority?user=test&amp;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:
>>
>>         <!--
>>         <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
>>                driverName="org.gjt.mm.mysql.Driver"
>>
>>  connectionURL="jdbc:mysql://localhost/authority?user=test;password=test"
>>                 userTable="users" userNameCol="user_name"
>>  userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name"
>>  />
>>         -->
>>
>>  The connectionURL line should be fixed to say this instead:
>>
>  > connectionURL="jdbc:mysql://localhost/authority?user=test&password=test"


--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message