Re: RE: Big problem with tomcat's security manager and dataSource in the struts_

[re...@verizon.net]

Difficult to say, as I am using the DataSource tag in the struts-config.xml file. I would assume it uses the first call, the one with multiple arguments, but I am not sure. Are you running tomcat with security?

Steve
> 
> From: "Tim Sawyer" <ts...@nildram.co.uk>
> Date: 2002/04/01 Mon AM 08:50:50 CST
> To: "Struts Users Mailing List" <st...@jakarta.apache.org>
> CC: <st...@verizon.net>
> Subject: 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:stephen.chambers@verizon.net]
> > Sent: Monday, April 01, 2002 2:42 PM
> > To: struts-user@jakarta.apache.org
> > 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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> 
> 
> 
> 
> --
> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
> 
> 


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>