tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Franck Borel <bo...@ub.uni-freiburg.de>
Subject Re: Newbie: Deploying .war file, getting it working with MySQL
Date Mon, 08 May 2006 14:48:02 GMT
Try this:

<Context path="/minimal"
               docBase="minimal"
               debug="0"
                reloadable="false"
                crossContext="true">

<Resource name="jdbc/authority" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/authority">
    <parameter><name>username</name><value>root</value></parameter>
    <paramater><name>password</name><value>ROOT_PASSWORD</value></parameter>
   
<parameter><name>driverClassName</name><value>com.mysql.jdbc.Driver</value></parameter>
   
<parameter><name>url</name><value>jdbc:mysql://localhost/authority</value></parameter>
</ResourceParams>
</Context>

-- Franck

> Franck Borel wrote:
>> Where did you place your Realm block?
>>
>> It must be placed inside the context block like this:
>>
>> <Context ..>
>>     <Realm ...../>
>> </Context..>
>
> I did not have it here, I had it in the Engine tag.  I have now
> changed it, and stoped and restarted the server.  I still get the same
> error. The relavent bit of my server.xml file looks like this -
>
>     <Engine name="Catalina" defaultHost="localhost">
> ...
>       <!--
>       <Realm  className="org.apache.catalina.realm.JDBCRealm"
>              driverName="com.mysql.jdbc.Driver"
>           connectionURL="jdbc:mysql://localhost/authority"
>          connectionName="root" connectionPassword="ROOT_PASSWORD"
>               userTable="users" userNameCol="user_name"
> userCredCol="user_pass"
>           userRoleTable="user_roles" roleNameCol="role_name" />
>       -->
> ...
>       <Host name="localhost" appBase="webapps"
>        unpackWARs="true" autoDeploy="true"
>        xmlValidation="false" xmlNamespaceAware="false">
>         <Context path="/minimal" docBase="minimal" debug="0"
>                 reloadable="false" crossContext="true">
>           <Realm  className="org.apache.catalina.realm.JDBCRealm"
>                   driverName="com.mysql.jdbc.Driver"
>                   connectionURL="jdbc:mysql://localhost/authority"
>                   connectionName="root"
> connectionPassword="ROOT_PASSWORD"
>                   userTable="users" userNameCol="user_name"
> userCredCol="user_pass"
>                   userRoleTable="user_roles" roleNameCol="role_name" />
>         </Context>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>


-- 
====================================================================
Dipl.-Hyd. Franck Borel               Universitaetsbibliothek Freiburg
EMail: borel@ub.uni-freiburg.de       EDV-Dezernat
Tel. : +49-761 / 203-3908             Werthmannplatz 2 | Postfach 1629
Fax  : +49-761 / 203-3987             79098 Freiburg   | 79016 Freiburg



Mime
View raw message