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]
