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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
