tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Smith <d...@cornell.edu>
Subject Re: Newbie: Deploying .war file, getting it working with MySQL
Date Mon, 08 May 2006 15:28:26 GMT
Yes, authority in the url is the name of the database being accessed. 
URL syntax looks something like this:

jdbc:mysql//[DNS_name|IP][:portNum]/database

portNum is 3306 if not specified and you can add a ? and connect options
after the database name as needed.

Hugh Morgan wrote:

> Franck Borel wrote:
>
>> 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>
>
>
> Same error (after changing paramater ;) ).  Did make me think though,
> what is authority?  Should I have cganged this (to the name of the
> database for example)?
>
> Thanks again,
>
> Hugh
>
>>
>> -- 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
>>>
>>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message