Re: [cobalt-developers] Tomcat error on a 550

[java <java@xxxxxxxxxx>]

Richard,
You must grant accessrigths to the servlet which tries to connect to the 
mysqlserver. In the tomcat.policy / catalina.policy (depending the 
version you running) you should include

grant codeBase <<codebase>> {
   java.net.SocketPermission "127.0.0.1:3360", "connect,resolve";
}

also  possible

grant codeBase <<codebase>> {
   java.net.SocketPermission "127.0.0.1:1024-", "connect,resolve";
}

last one meaning you granting rigths to resolve and connect to ports 
over 1024. Replace <<codebase>> with the codebase you granting rigths to.

Johan

Richard Drent (Drent IT BV) wrote:

> Hi guys,
>
> There is at the momment an error buging me as hell. And The solutions that I
> found on the net are not solving the problem
>
> The message I receive is copy/past at the bottom.
>
> I found at the sun forum that some one had made a new tomcat.policy, I tryed
> that one. But is not solving the problem.
>
>
> I like to here some sugestions,... To solve this pain in my ass  (:-)
>
>
> Greetz richard
>
>
>
> Location: /test.jsp
> Internal Servlet Error:
>
> javax.servlet.ServletException: Unable to connect to any hosts due to
> exception: java.security.AccessControlException: access denied
> (java.net.SocketPermission 127.0.0.1:3306 connect,resolve)
> 	at
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
> l.java:459)
> 	at
> _0002ftest_0002ejsptest_jsp_1._jspService(_0002ftest_0002ejsptest_jsp_1.java
> :88)
> 	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)
>
> Root cause: 
> java.sql.SQLException: Unable to connect to any hosts due to exception:
> java.security.AccessControlException: access denied
> (java.net.SocketPermission 127.0.0.1:3306 connect,resolve)
> 	at com.mysql.jdbc.Connection.createNewIO(Connection.java:1622)
> 	at com.mysql.jdbc.Connection.(Connection.java:491)
> 	at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
> 	at java.sql.DriverManager.getConnection(DriverManager.java:517)
> 	at java.sql.DriverManager.getConnection(DriverManager.java:199)
> 	at
> _0002ftest_0002ejsptest_jsp_1._jspService(_0002ftest_0002ejsptest_jsp_1.java
> :72)
> 	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)
>
>
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
>
>
>  


--
Nilling Software Design
Postbus 43
2280 AA  Rijswijk ZH
w: http://www.nilling.nl