tomcat4 + postgresql jdbc
I'm attempting to install tomcat4 + postgresql jdbc under Debian linux. I've put the jdbc jar at /usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar When I attempt to connect to a database via jsp, I get java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve) I've put a file "test2.jsp" at /var/lib/tomcat4/webapps/ROOT, with the following contents: - <[EMAIL PROTECTED] import="java.sql.*"%> <% // Define the connection Connection con = null; // Check that the DB2Driver class is available Class.forName("org.postgresql.Driver"); try { // Attempt to connect to the Database con = DriverManager.getConnection("jdbc:postgresql:demodb","oege","xxx"); out.println("The test is complete, your Database has been contacted"); } // Make sure to catch any exceptions catch (SQLException e) { out.println(e.getMessage()); } %> --- When I point my web browser at http://localhost:8180/test2.jsp, the above exception occurs. The full stack trace is appended below. I've attempted adding this line to the security policy file in /etc/tomcat4/policy.d/99examples.policy: grant codeBase "file:/usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar!/-" { permission java.security.AllPermission; }; Any help would be much appreciated! -Oege Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve) Stack Trace: java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve) at java.security.AccessControlContext.checkPermission(AccessControlContext.java:269) at java.security.AccessController.checkPermission(AccessController.java:401) at java.lang.SecurityManager.checkPermission(SecurityManager.java:524) at java.lang.SecurityManager.checkConnect(SecurityManager.java:1023) at java.net.InetAddress.getAllByName0(InetAddress.java:1000) at java.net.InetAddress.getAllByName0(InetAddress.java:981) at java.net.InetAddress.getAllByName(InetAddress.java:975) at java.net.InetAddress.getByName(InetAddress.java:889) at java.net.InetSocketAddress.(InetSocketAddress.java:114) at java.net.Socket.(Socket.java:124) at org.postgresql.core.PGStream.(PGStream.java:47) at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:197) at org.postgresql.Driver.connect(Driver.java:139) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.jsp.test2_jsp._jspService(test2_jsp.java:51) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:51) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:129) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:125) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116) at
RE: tomcat4 + postgresql jdbc
Hi, Is it possible that the database connection credentials are not right? Have you tried connecting to the database from the standard client with the same username and password? Regards Carlos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor Sent: terça-feira, 18 de Janeiro de 2005 16:27 To: tomcat-user@jakarta.apache.org Subject: tomcat4 + postgresql jdbc I'm attempting to install tomcat4 + postgresql jdbc under Debian linux. I've put the jdbc jar at /usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar When I attempt to connect to a database via jsp, I get java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve) I've put a file "test2.jsp" at /var/lib/tomcat4/webapps/ROOT, with the following contents: - <[EMAIL PROTECTED] import="java.sql.*"%> <% // Define the connection Connection con = null; // Check that the DB2Driver class is available Class.forName("org.postgresql.Driver"); try { // Attempt to connect to the Database con = DriverManager.getConnection("jdbc:postgresql:demodb","oege","xxx"); out.println("The test is complete, your Database has been contacted"); } // Make sure to catch any exceptions catch (SQLException e) { out.println(e.getMessage()); } %> --- When I point my web browser at http://localhost:8180/test2.jsp, the above exception occurs. The full stack trace is appended below. I've attempted adding this line to the security policy file in /etc/tomcat4/policy.d/99examples.policy: grant codeBase "file:/usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar!/-" { permission java.security.AllPermission; }; Any help would be much appreciated! -Oege Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve) Stack Trace: java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve) at java.security.AccessControlContext.checkPermission(AccessControlContext.java:269) at java.security.AccessController.checkPermission(AccessController.java:401) at java.lang.SecurityManager.checkPermission(SecurityManager.java:524) at java.lang.SecurityManager.checkConnect(SecurityManager.java:1023) at java.net.InetAddress.getAllByName0(InetAddress.java:1000) at java.net.InetAddress.getAllByName0(InetAddress.java:981) at java.net.InetAddress.getAllByName(InetAddress.java:975) at java.net.InetAddress.getByName(InetAddress.java:889) at java.net.InetSocketAddress.(InetSocketAddress.java:114) at java.net.Socket.(Socket.java:124) at org.postgresql.core.PGStream.(PGStream.java:47) at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:197) at org.postgresql.Driver.connect(Driver.java:139) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.jsp.test2_jsp._jspService(test2_jsp.java:51) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:51) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:129) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:125) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133) at
RE: tomcat4 + postgresql jdbc
Thanks for the suggestion! I can successfully connect with a normal Java program. In pg_hba.conf, I've got the line hostall all 127.0.0.1 255.255.255.255 trust hostall all 192.168.53.2 255.255.255.0 trust so all IP connections from the local network (192.168.53.xx) should be accepted, even without a password... -Oege On Tue, 18 Jan 2005, Carlos Martins wrote: > Hi, > > Is it possible that the database connection credentials are not right? Have > you tried connecting to the database from the standard client with the same > username and password? > > Regards > Carlos > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > Sent: terça-feira, 18 de Janeiro de 2005 16:27 > To: tomcat-user@jakarta.apache.org > Subject: tomcat4 + postgresql jdbc > > I'm attempting to install tomcat4 + postgresql jdbc under Debian linux. > I've put the jdbc jar at /usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar > > When I attempt to connect to a database via jsp, I get > java.security.AccessControlException: access denied > (java.net.SocketPermission localhost resolve) > > I've put a file "test2.jsp" at /var/lib/tomcat4/webapps/ROOT, > with the following contents: > > - > > <[EMAIL PROTECTED] import="java.sql.*"%> > <% >// Define the connection >Connection con = null; >// Check that the DB2Driver class is available >Class.forName("org.postgresql.Driver"); >try { >// Attempt to connect to the Database >con = > DriverManager.getConnection("jdbc:postgresql:demodb","oege","xxx"); >out.println("The test is complete, your Database has been > contacted"); >} >// Make sure to catch any exceptions >catch (SQLException e) { > out.println(e.getMessage()); >} > %> > --- > > When I point my web browser at http://localhost:8180/test2.jsp, > the above exception occurs. The full stack trace is appended below. > > I've attempted adding this line to the security policy file > in /etc/tomcat4/policy.d/99examples.policy: > > grant codeBase "file:/usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar!/-" > { > permission java.security.AllPermission; > }; > > > Any help would be much appreciated! > > -Oege > > > Something unusual has occured to cause the driver to fail. Please report > this exception: Exception: java.security.AccessControlException: access > denied (java.net.SocketPermission localhost resolve) Stack Trace: > java.security.AccessControlException: access denied > (java.net.SocketPermission localhost resolve) at > java.security.AccessControlContext.checkPermission(AccessControlContext.java:269) > at > java.security.AccessController.checkPermission(AccessController.java:401) > at java.lang.SecurityManager.checkPermission(SecurityManager.java:524) at > java.lang.SecurityManager.checkConnect(SecurityManager.java:1023) at > java.net.InetAddress.getAllByName0(InetAddress.java:1000) at > java.net.InetAddress.getAllByName0(InetAddress.java:981) at > java.net.InetAddress.getAllByName(InetAddress.java:975) at > java.net.InetAddress.getByName(InetAddress.java:889) at > java.net.InetSocketAddress.(InetSocketAddress.java:114) at > java.net.Socket.(Socket.java:124) at > org.postgresql.core.PGStream.(PGStream.java:47) at > org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:197) > at org.postgresql.Driver.connect(Driver.java:139) at > java.sql.DriverManager.getConnection(DriverManager.java:512) at > java.sql.DriverManager.getConnection(DriverManager.java:171) at > org.apache.jsp.test2_jsp._jspService(test2_jsp.java:51) at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92) at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187) at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) > at > org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:51) > at > org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:129) > at java.security.AccessController.doPrivileged(Native Method) at > org.apache.catalina.core.ApplicationFilter
RE: tomcat4 + postgresql jdbc
If you are running Tomcat with a security manager, you will need to make sure the catalina.policy file includes permission for your webapp to connect to the server in question. The examples found in the comments at the end of the default catalina.policy file are examples of such a permission. Cheers, Larry > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > Sent: Tuesday, January 18, 2005 11:54 AM > To: Tomcat Users List > Subject: RE: tomcat4 + postgresql jdbc > > > Thanks for the suggestion! > > I can successfully connect with a normal Java program. > In pg_hba.conf, I've got the line > > hostall all 127.0.0.1 > 255.255.255.255 trust > hostall all 192.168.53.2 > 255.255.255.0 trust > > so all IP connections from the local network (192.168.53.xx) should > be accepted, even without a password... > > -Oege > > On Tue, 18 Jan 2005, Carlos Martins wrote: > > > Hi, > > > > Is it possible that the database connection credentials are > not right? Have you tried connecting to the database from the > standard client with the same username and password? > > > > Regards > > Carlos > > > > -Original Message- > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > > Sent: terça-feira, 18 de Janeiro de 2005 16:27 > > To: tomcat-user@jakarta.apache.org > > Subject: tomcat4 + postgresql jdbc > > > > I'm attempting to install tomcat4 + postgresql jdbc under > Debian linux. > > I've put the jdbc jar at > /usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar > > > > When I attempt to connect to a database via jsp, I get > > java.security.AccessControlException: access denied > > (java.net.SocketPermission localhost resolve) > > > > I've put a file "test2.jsp" at /var/lib/tomcat4/webapps/ROOT, > > with the following contents: > > > > - > > > > <[EMAIL PROTECTED] import="java.sql.*"%> > > <% > >// Define the connection > >Connection con = null; > >// Check that the DB2Driver class is available > >Class.forName("org.postgresql.Driver"); > >try { > >// Attempt to connect to the Database > >con = > > DriverManager.getConnection("jdbc:postgresql:demodb","oege","xxx"); > >out.println("The test is complete, your Database has been > > contacted"); > >} > >// Make sure to catch any exceptions > >catch (SQLException e) { > > out.println(e.getMessage()); > >} > > %> > > --- > > > > When I point my web browser at http://localhost:8180/test2.jsp, > > the above exception occurs. The full stack trace is appended below. > > > > I've attempted adding this line to the security policy file > > in /etc/tomcat4/policy.d/99examples.policy: > > > > grant codeBase > "file:/usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar!/-" > > { > > permission java.security.AllPermission; > > }; > > > > > > Any help would be much appreciated! > > > > -Oege > > > > > > Something unusual has occured to cause the driver to fail. > Please report > > this exception: Exception: > java.security.AccessControlException: access > > denied (java.net.SocketPermission localhost resolve) Stack Trace: > > java.security.AccessControlException: access denied > > (java.net.SocketPermission localhost resolve) at > > > java.security.AccessControlContext.checkPermission(AccessContr > olContext.java:269) > > at > > > java.security.AccessController.checkPermission(AccessControlle > r.java:401) > > at > java.lang.SecurityManager.checkPermission(SecurityManager.java:524) at > > java.lang.SecurityManager.checkConnect(SecurityManager.java:1023) at > > java.net.InetAddress.getAllByName0(InetAddress.java:1000) at > > java.net.InetAddress.getAllByName0(InetAddress.java:981) at > > java.net.InetAddress.getAllByName(InetAddress.java:975) at > > java.net.InetAddress.getByName(InetAddress.java:889) at > > java.net.InetSocketAddress.(InetSocketAddress.java:114) at > > java.net.Socket.(Socket.java:124) at > > org.postgresql.core.PGStream.(PGStream.java:47) at > > > org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(Ab > stractJdbc1Connection.java:197) > >
RE: tomcat4 + postgresql jdbc
Do you mean I should add something like: grant codeBase "file:/var/lib/tomcat4/webapps/-" { permission java.net.SocketPermission "127.0.0.1:5432", "connect"; permission java.net.SocketPermission "127.0.0.1:5432", "resolve"; }; Unfortunately that still doesn't work... On Tue, 18 Jan 2005, Larry Isaacs wrote: > If you are running Tomcat with a security manager, you will need > to make sure the catalina.policy file includes permission for > your webapp to connect to the server in question. The examples > found in the comments at the end of the default catalina.policy > file are examples of such a permission. > > Cheers, > Larry > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > > Sent: Tuesday, January 18, 2005 11:54 AM > > To: Tomcat Users List > > Subject: RE: tomcat4 + postgresql jdbc > > > > > > Thanks for the suggestion! > > > > I can successfully connect with a normal Java program. > > In pg_hba.conf, I've got the line > > > > hostall all 127.0.0.1 > > 255.255.255.255 trust > > hostall all 192.168.53.2 > > 255.255.255.0 trust > > > > so all IP connections from the local network (192.168.53.xx) should > > be accepted, even without a password... > > > > -Oege > > > > On Tue, 18 Jan 2005, Carlos Martins wrote: > > > > > Hi, > > > > > > Is it possible that the database connection credentials are > > not right? Have you tried connecting to the database from the > > standard client with the same username and password? > > > > > > Regards > > > Carlos > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > > > Sent: terça-feira, 18 de Janeiro de 2005 16:27 > > > To: tomcat-user@jakarta.apache.org > > > Subject: tomcat4 + postgresql jdbc > > > > > > I'm attempting to install tomcat4 + postgresql jdbc under > > Debian linux. > > > I've put the jdbc jar at > > /usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar > > > > > > When I attempt to connect to a database via jsp, I get > > > java.security.AccessControlException: access denied > > > (java.net.SocketPermission localhost resolve) > > > > > > I've put a file "test2.jsp" at /var/lib/tomcat4/webapps/ROOT, > > > with the following contents: > > > > > > - > > > > > > <[EMAIL PROTECTED] import="java.sql.*"%> > > > <% > > >// Define the connection > > >Connection con = null; > > >// Check that the DB2Driver class is available > > >Class.forName("org.postgresql.Driver"); > > >try { > > >// Attempt to connect to the Database > > >con = > > > DriverManager.getConnection("jdbc:postgresql:demodb","oege","xxx"); > > >out.println("The test is complete, your Database has been > > > contacted"); > > >} > > >// Make sure to catch any exceptions > > >catch (SQLException e) { > > > out.println(e.getMessage()); > > >} > > > %> > > > --- > > > > > > When I point my web browser at http://localhost:8180/test2.jsp, > > > the above exception occurs. The full stack trace is appended below. > > > > > > I've attempted adding this line to the security policy file > > > in /etc/tomcat4/policy.d/99examples.policy: > > > > > > grant codeBase > > "file:/usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar!/-" > > > { > > > permission java.security.AllPermission; > > > }; > > > > > > > > > Any help would be much appreciated! > > > > > > -Oege > > > > > > > > > Something unusual has occured to cause the driver to fail. > > Please report > > > this exception: Exception: > > java.security.AccessControlException: access > > > denied (java.net.SocketPermission localhost resolve) Stack Trace: > > > java.security.AccessControlException: access denied > > > (java.net.SocketPermission localhost resolve) at > > > > > java.security.AccessControlContext.checkPermission(AccessCont
Re: tomcat4 + postgresql jdbc
Laba diena. Dėkojame, kad mums parašėte. Jūsų atsiųsta žinutė išsaugota mūsų duomenų bazėje. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: tomcat4 + postgresql jdbc
Test without security manager so that we can isolate the problem. -Original Message- From: Oege de Moor [mailto:[EMAIL PROTECTED] Sent: January 18, 2005 12:24 PM To: Tomcat Users List Subject: RE: tomcat4 + postgresql jdbc Do you mean I should add something like: grant codeBase "file:/var/lib/tomcat4/webapps/-" { permission java.net.SocketPermission "127.0.0.1:5432", "connect"; permission java.net.SocketPermission "127.0.0.1:5432", "resolve"; }; Unfortunately that still doesn't work... On Tue, 18 Jan 2005, Larry Isaacs wrote: > If you are running Tomcat with a security manager, you will need to > make sure the catalina.policy file includes permission for your webapp > to connect to the server in question. The examples found in the > comments at the end of the default catalina.policy file are examples > of such a permission. > > Cheers, > Larry > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > > Sent: Tuesday, January 18, 2005 11:54 AM > > To: Tomcat Users List > > Subject: RE: tomcat4 + postgresql jdbc > > > > > > Thanks for the suggestion! > > > > I can successfully connect with a normal Java program. > > In pg_hba.conf, I've got the line > > > > hostall all 127.0.0.1 > > 255.255.255.255 trust > > hostall all 192.168.53.2 > > 255.255.255.0 trust > > > > so all IP connections from the local network (192.168.53.xx) should > > be accepted, even without a password... > > > > -Oege > > > > On Tue, 18 Jan 2005, Carlos Martins wrote: > > > > > Hi, > > > > > > Is it possible that the database connection credentials are > > not right? Have you tried connecting to the database from the > > standard client with the same username and password? > > > > > > Regards > > > Carlos > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > > > Sent: terça-feira, 18 de Janeiro de 2005 16:27 > > > To: tomcat-user@jakarta.apache.org > > > Subject: tomcat4 + postgresql jdbc > > > > > > I'm attempting to install tomcat4 + postgresql jdbc under > > Debian linux. > > > I've put the jdbc jar at > > /usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar > > > > > > When I attempt to connect to a database via jsp, I get > > > java.security.AccessControlException: access denied > > > (java.net.SocketPermission localhost resolve) > > > > > > I've put a file "test2.jsp" at /var/lib/tomcat4/webapps/ROOT, with > > > the following contents: > > > > > > - > > > > > > <[EMAIL PROTECTED] import="java.sql.*"%> > > > <% > > >// Define the connection > > >Connection con = null; > > >// Check that the DB2Driver class is available > > >Class.forName("org.postgresql.Driver"); > > >try { > > >// Attempt to connect to the Database > > >con = > > > DriverManager.getConnection("jdbc:postgresql:demodb","oege","xxx"); > > >out.println("The test is complete, your Database has been > > > contacted"); > > >} > > >// Make sure to catch any exceptions > > >catch (SQLException e) { > > > out.println(e.getMessage()); > > >} > > > %> > > > --- > > > > > > When I point my web browser at http://localhost:8180/test2.jsp, > > > the above exception occurs. The full stack trace is appended > > > below. > > > > > > I've attempted adding this line to the security policy file in > > > /etc/tomcat4/policy.d/99examples.policy: > > > > > > grant codeBase > > "file:/usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar!/-" > > > { > > > permission java.security.AllPermission; > > > }; > > > > > > > > > Any help would be much appreciated! > > > > > > -Oege > > > > > > > > > Something unusual has occured to cause the driver to fail. > > Please report > > > this exception: Exception: > > java.security.AccessControlException: access > > > denied (ja
RE: tomcat4 + postgresql jdbc
Basically yes. I forget whether "connect" implies "resolve", but it is possible to use one permission regardless, i.e. permission java.net.SocketPermission ":", "connect, resolve"; Just "connect" may be enough. Also, what you specify for the host name can vary depending on what is used by the code that tries to connect. Your error below suggests you will need "localhost" as the host name. It has been a while, so I don't recall whether the IP address would satisfy the permission check. A little trial-and-error should be able to determine what host name is needed. I believe you will need a permission for each different host name used, if code happens to be inconsistent. You can also restrict the permission to just that webapp by specifying the codeBase to be the full path to the base of your webapp, i.e. something like: codeBase "file:/var/lib/tomcat4/webapps/myapp/-" Larry > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > Sent: Tuesday, January 18, 2005 12:24 PM > To: Tomcat Users List > Subject: RE: tomcat4 + postgresql jdbc > > > Do you mean I should add something like: > > grant codeBase "file:/var/lib/tomcat4/webapps/-" { > permission java.net.SocketPermission "127.0.0.1:5432", > "connect"; > permission java.net.SocketPermission "127.0.0.1:5432", > "resolve"; > }; > > Unfortunately that still doesn't work... > > On Tue, 18 Jan 2005, Larry Isaacs wrote: > > > If you are running Tomcat with a security manager, you will need > > to make sure the catalina.policy file includes permission for > > your webapp to connect to the server in question. The examples > > found in the comments at the end of the default catalina.policy > > file are examples of such a permission. > > > > Cheers, > > Larry > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > > > Sent: Tuesday, January 18, 2005 11:54 AM > > > To: Tomcat Users List > > > Subject: RE: tomcat4 + postgresql jdbc > > > > > > > > > Thanks for the suggestion! > > > > > > I can successfully connect with a normal Java program. > > > In pg_hba.conf, I've got the line > > > > > > hostall all 127.0.0.1 > > > 255.255.255.255 trust > > > hostall all 192.168.53.2 > > > 255.255.255.0 trust > > > > > > so all IP connections from the local network > (192.168.53.xx) should > > > be accepted, even without a password... > > > > > > -Oege > > > > > > On Tue, 18 Jan 2005, Carlos Martins wrote: > > > > > > > Hi, > > > > > > > > Is it possible that the database connection credentials are > > > not right? Have you tried connecting to the database from the > > > standard client with the same username and password? > > > > > > > > Regards > > > > Carlos > > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > > > > Sent: terça-feira, 18 de Janeiro de 2005 16:27 > > > > To: tomcat-user@jakarta.apache.org > > > > Subject: tomcat4 + postgresql jdbc > > > > > > > > I'm attempting to install tomcat4 + postgresql jdbc under > > > Debian linux. > > > > I've put the jdbc jar at > > > /usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar > > > > > > > > When I attempt to connect to a database via jsp, I get > > > > java.security.AccessControlException: access denied > > > > (java.net.SocketPermission localhost resolve) > > > > > > > > I've put a file "test2.jsp" at /var/lib/tomcat4/webapps/ROOT, > > > > with the following contents: > > > > > > > > - > > > > > > > > <[EMAIL PROTECTED] import="java.sql.*"%> > > > > <% > > > >// Define the connection > > > >Connection con = null; > > > >// Check that the DB2Driver class is available > > > >Class.forName("org.postgresql.Driver"); > > > >try { > > > >// Attempt to connect to the Database > > > >con = > > > > > Driv
RE: tomcat4 + postgresql jdbc
I should have said it works without the security manager. On Tue, 18 Jan 2005, Phillip Qin wrote: > Test without security manager so that we can isolate the problem. > > -Original Message- > From: Oege de Moor [mailto:[EMAIL PROTECTED] > Sent: January 18, 2005 12:24 PM > To: Tomcat Users List > Subject: RE: tomcat4 + postgresql jdbc > > > > Do you mean I should add something like: > > grant codeBase "file:/var/lib/tomcat4/webapps/-" { > permission java.net.SocketPermission "127.0.0.1:5432", "connect"; > permission java.net.SocketPermission "127.0.0.1:5432", "resolve"; }; > > Unfortunately that still doesn't work... > > On Tue, 18 Jan 2005, Larry Isaacs wrote: > > > If you are running Tomcat with a security manager, you will need to > > make sure the catalina.policy file includes permission for your webapp > > to connect to the server in question. The examples found in the > > comments at the end of the default catalina.policy file are examples > > of such a permission. > > > > Cheers, > > Larry > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > > > Sent: Tuesday, January 18, 2005 11:54 AM > > > To: Tomcat Users List > > > Subject: RE: tomcat4 + postgresql jdbc > > > > > > > > > Thanks for the suggestion! > > > > > > I can successfully connect with a normal Java program. > > > In pg_hba.conf, I've got the line > > > > > > hostall all 127.0.0.1 > > > 255.255.255.255 trust > > > hostall all 192.168.53.2 > > > 255.255.255.0 trust > > > > > > so all IP connections from the local network (192.168.53.xx) should > > > be accepted, even without a password... > > > > > > -Oege > > > > > > On Tue, 18 Jan 2005, Carlos Martins wrote: > > > > > > > Hi, > > > > > > > > Is it possible that the database connection credentials are > > > not right? Have you tried connecting to the database from the > > > standard client with the same username and password? > > > > > > > > Regards > > > > Carlos > > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Oege de Moor > > > > Sent: terça-feira, 18 de Janeiro de 2005 16:27 > > > > To: tomcat-user@jakarta.apache.org > > > > Subject: tomcat4 + postgresql jdbc > > > > > > > > I'm attempting to install tomcat4 + postgresql jdbc under > > > Debian linux. > > > > I've put the jdbc jar at > > > /usr/share/tomcat4/common/lib/pg74.215.jdbc3.jar > > > > > > > > When I attempt to connect to a database via jsp, I get > > > > java.security.AccessControlException: access denied > > > > (java.net.SocketPermission localhost resolve) > > > > > > > > I've put a file "test2.jsp" at /var/lib/tomcat4/webapps/ROOT, with > > > > the following contents: > > > > > > > > - > > > > > > > > <[EMAIL PROTECTED] import="java.sql.*"%> > > > > <% > > > >// Define the connection > > > >Connection con = null; > > > >// Check that the DB2Driver class is available > > > >Class.forName("org.postgresql.Driver"); > > > >try { > > > >// Attempt to connect to the Database > > > >con = > > > > DriverManager.getConnection("jdbc:postgresql:demodb","oege","xxx"); > > > >out.println("The test is complete, your Database has been > > > > contacted"); > > > >} > > > >// Make sure to catch any exceptions > > > >catch (SQLException e) { > > > > out.println(e.getMessage()); > > > >} > > > > %> > > > > --- > > > > > > > > When I point my web browser at http://localhost:8180/test2.jsp, > > > > the above exception occurs. The full stack trace is appended > > > > below. > > > > > > > > I've attempted adding this line to the security policy file in > > > > /etc/tomcat4/poli
Re: tomcat4 + postgresql jdbc
This only enable connections from 192.168.53.2 and not the network 192.168.53.x To enable the network, you need to write 192.168.53.0 as the ip address BTJ >Thanks for the suggestion! > >I can successfully connect with a normal Java program. >In pg_hba.conf, I've got the line > >hostall all 127.0.0.1 255.255.255.255 trust >hostall all 192.168.53.2 255.255.255.0 trust > >so all IP connections from the local network (192.168.53.xx) should >be accepted, even without a password... > >-Oege > -- --- Bjørn T Johansen (BSc,MNIF) Executive Manager [EMAIL PROTECTED] Havleik Consulting Phone : +47 21 69 15 20 Bjørnebærstien 57 Fax : +47 41 13 09 15 N-1348 Rykkinn Cellular : +47 926 93 298 http://www.havleik.no --- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows" --- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]