Big problem with tomcat's security manager and dataSource in the struts_config.xml file
All,
I have been migrating a smaller Tomcat/MySQL application to Struts and
have
run into a problem.
I have completely converted the app to Struts and hit a snag when I
inserted
the DataSource tag into the struts-config.xml. It began to generate
Cannot
find ActionMappings errors in the html and in the logs it could not find
the database, asking Is there a MySQL database running on this server?
My Tomcat 4.0 (on RH 7.1) is running with security and I added these lines
to the conf/catalina.policy file, each on as nothing else seemed to work:
grant CodeBase file:${catalina.home}/webapps/myapp/- {
permission java.security.AllPermission;
};
grant CodeBase file:${catalina.home}/webapps/myapp/WEB-INF/classes/- {
permission java.security.AllPermission;
};
grant CodeBase file:${catalina.home}/webapps/myapp/WEB-INF/lib- {
permission java.security.AllPermission;
};
grant CodeBase
file:${catalina.home}/webapps/myapp/WEb-INF/lib/mm.mysql-2.0.11-bin.jar!/-
{
permission java.security.AllPermission;
};
None of these worked either. When I commented out the datasource tag
everything except the database started working and then when I commented
it
back in, nothing. I finally turned off the security manager and everything
including the database works now, with the datasource tag in the
struts-config.xml in there as it should be. Has anyone else had this
problem? In the local user's group, someone else had the same problem on a
WIN2K box with MySQL (and a different version of the mm.mysql.driver as
well) and they still haven't solved it either.
The appropriate section of the struts-config.xml looks like the following:
data-sources
data-source
autoCommit=false
autoReconnect=true
description=Data Source
driverClass=org.gjt.mm.mysql.Driver
maxCount=4
minCount=2
password=whatever
url=jdbc:mysql://myserver:3306/4po
user=servlet
/
/data-sources
What is the conflict with the security manager or am I messing something
up
myself?
Steve
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Big problem with tomcat's security manager and dataSource in the struts_config.xml file
This might be completely unrelated, but I'll mention it anyway.
This weekend I had a quick play with accessing MySQL through JDBC (I've
never done anything with JDBC before). Latest stable version of MySQL on
Win2k, latest stable JDBC driver. I was running on Orion 1.5.2. I found
that if I did this:
DriverManager.getConnection(jdbc:mysql://localhost/mydatabase, webuser,
password);
it didn't work, but this:
DriverManager.getConnection(jdbc:mysql://localhost/mydatabase?user=webuser
password=password);
did. Just wonder if your problem is related?
Tim.
-Original Message-
From: stephen.chambers [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 2:42 PM
To: [EMAIL PROTECTED]
Subject: Big problem with tomcat's security manager and dataSource in
the struts_config.xml file
All,
I have been migrating a smaller Tomcat/MySQL application to Struts and
have
run into a problem.
I have completely converted the app to Struts and hit a snag when I
inserted
the DataSource tag into the struts-config.xml. It began to generate
Cannot
find ActionMappings errors in the html and in the logs it
could not find
the database, asking Is there a MySQL database running on this server?
My Tomcat 4.0 (on RH 7.1) is running with security and I added
these lines
to the conf/catalina.policy file, each on as nothing else
seemed to work:
grant CodeBase file:${catalina.home}/webapps/myapp/- {
permission java.security.AllPermission;
};
grant CodeBase file:${catalina.home}/webapps/myapp/WEB-INF/classes/- {
permission java.security.AllPermission;
};
grant CodeBase file:${catalina.home}/webapps/myapp/WEB-INF/lib- {
permission java.security.AllPermission;
};
grant CodeBase
file:${catalina.home}/webapps/myapp/WEb-INF/lib/mm.mysql-2.0.11-b
in.jar!/-
{
permission java.security.AllPermission;
};
None of these worked either. When I commented out the datasource tag
everything except the database started working and then when I commented
it
back in, nothing. I finally turned off the security manager and everything
including the database works now, with the datasource tag in the
struts-config.xml in there as it should be. Has anyone else had this
problem? In the local user's group, someone else had the same problem on a
WIN2K box with MySQL (and a different version of the mm.mysql.driver as
well) and they still haven't solved it either.
The appropriate section of the struts-config.xml looks like the following:
data-sources
data-source
autoCommit=false
autoReconnect=true
description=Data Source
driverClass=org.gjt.mm.mysql.Driver
maxCount=4
minCount=2
password=whatever
url=jdbc:mysql://myserver:3306/4po
user=servlet
/
/data-sources
What is the conflict with the security manager or am I messing something
up
myself?
Steve
--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Problem with tomcat's security manager and dataSource in the struts_config.xml file
All,
I have been migrating a smaller Tomcat/MySQL application to Struts and have
run into a problem.
I have completely converted the app to Struts and hit a snag when I inserted
the DataSource tag into the struts-config.xml. It began to generate Cannot
find ActionMappings errors in the html and in the logs it could not find
the database, asking Is there a MySQL database running on this server?
My Tomcat 4.0 (on RH 7.1) is running with security and I added these lines
to the conf/catalina.policy file, each on as nothing else seemed to work:
grant CodeBase file:${catalina.home}/webapps/myapp/- {
permission java.security.AllPermission;
};
grant CodeBase file:${catalina.home}/webapps/myapp/WEB-INF/classes/- {
permission java.security.AllPermission;
};
grant CodeBase file:${catalina.home}/webapps/myapp/WEB-INF/lib- {
permission java.security.AllPermission;
};
grant CodeBase
file:${catalina.home}/webapps/myapp/WEb-INF/lib/mm.mysql-2.0.11-bin.jar!/-
{
permission java.security.AllPermission;
};
None of these worked either. When I commented out the datasource tag
everything except the database started working and then when I commented it
back in, nothing. I finally turned off the security manager and everything
including the database works now, with the datasource tag in the
struts-config.xml in there as it should be. Has anyone else had this
problem? In the local user's group, someone else had the same problem on a
WIN2K box with MySQL (and a different version of the mm.mysql.driver as
well) and they still haven't solved it either.
The appropriate section of the struts-config.xml looks like the following:
data-sources
data-source
autoCommit=false
autoReconnect=true
description=Data Source
driverClass=org.gjt.mm.mysql.Driver
maxCount=4
minCount=2
password=whatever
url=jdbc:mysql://myserver:3306/4po
user=servlet
/
/data-sources
What is the conflict with the security manager or am I messing something up
myself?
Steve
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
