RE: [cobalt-developers] Tomcat/Java Permissions in JSP (RaQ 550)

[travis@xxxxxxxxxxxxxxxx]

You need to modify your catalina.policy file..

some info here: http://java.sun.com/j2se/1.3/docs/guide/security/permissions.html

or may want to read tomcat site for more info.

Travis

---- Original Message ----
From: Jason Levens <jlevens@xxxxxxxxxxxxx>
Sent: 2003-06-18
To: cobalt-developers@xxxxxxxxxxxxxxx
Subject: [cobalt-developers] Tomcat/Java Permissions in JSP (RaQ 550)

This question could be directed to a Java developer forum but if I thought
I'd check here first to see if anyone happens to have a fix for the RaQ 550.
If anyone can suggest any other places to look for help, I would appreciate
it.

I have a JSP that calls a bean that connects to a MySQL db running on the
same machine.
I can write a standalone java program to connect and parse results from the
same db successfully.

However, whenever I put the code into the bean I get the following Stack
trace :

java.sql.SQLException: Unable to connect to any hosts due to exception:
java.security.AccessControlException: access denied
(java.net.SocketPermission localhost resolve)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1564)
        at com.mysql.jdbc.Connection.<init>(Connection.java:485)
        at com.mysql.jdbc.Driver.connect(Driver.java:341)
        at java.sql.DriverManager.getConnection(DriverManager.java:517)
        at java.sql.DriverManager.getConnection(DriverManager.java:199)
        at
eFileCabinet.eFileCabinet_queryManager.<init>(eFileCabinet_queryManager.java
:19)
        at java.lang.Class.newInstance0(Native Method)
        at java.lang.Class.newInstance(Class.java:237)
        at java.beans.Beans.instantiate(Beans.java:207)
        at java.beans.Beans.instantiate(Beans.java:51)
        at
_0002findex_0002ejspindex_jsp_17._jspService(_0002findex_0002ejspindex_jsp_1
7.java:69)
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja
va:130)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:282)
        at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
        at org.apache.tomcat.core.Handler.service(Handler.java:287)
        at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
        at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81
2)
        at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
        at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:166)
        at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
        at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
        at java.lang.Thread.run(Thread.java:484)
java.lang.NullPointerException
        at
eFileCabinet.eFileCabinet_queryManager.getAllDocuments(eFileCabinet_queryMan
ager.java:38)
        at
_0002findex_0002ejspindex_jsp_17._jspService(_0002findex_0002ejspindex_jsp_1
7.java:97)
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja
va:130)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:282)
        at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
        at org.apache.tomcat.core.Handler.service(Handler.java:287)
        at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
        at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81
2)
        at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
        at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:166)
        at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
        at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
        at java.lang.Thread.run(Thread.java:484)

My class generates the NullPointer so I'm not concerned about that one, it's
the AccessControlException that I don't know how to handle.  This problem
should be fixed by modifying security policies of the tomcat installation I
beleive, but where can I make the changes on a RaQ 550 (somewhere in
/usr/java/jakarta-tomcat) and more importantly, what changes do I need to
make.

Thanks for any help,

Jason Levens


_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers