tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pascal" <pas...@carat-hosting.com>
Subject Re: Newbie: Deploying .war file, getting it working with MySQL
Date Mon, 08 May 2006 15:31:42 GMT
Hello

Do you tried to connect to your databse normaly (I mean without tomcat) to 
see if your user/pwd and database are set correctly in Mysql

Like this for example
#mysql -uUSER -pPASSWORD DATABASE

Are you sure the user have access authority to this databse from localhost ?

I know this is very simple but sometimes....

Pascal
----- Original Message ----- 
From: "Hugh Morgan" <hughbedo@gmail.com>
To: "Tomcat Users List" <users@tomcat.apache.org>
Sent: Monday, May 08, 2006 5:16 PM
Subject: Re: Newbie: Deploying .war file, getting it working with MySQL


> 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