Discussoes de Programacao e Tecnologia

Postgres: java.security.AccessControlException: access denied

5 respostas
A
asterus

Pessoal:

Estou há 2 semanas tentando entender algo inintendível:

Temos um sistema desenvolvido em Jsp, Servetls e JAVA, nosso problema constitui-se numa negação de acesso do Driver ao Bd postgreSQL quando o sistema está rodando de plataforma Linux (Ubuntu Edgy), sendo que em plataforma Windows ele funciona normalmente, e um outro programa teste (feito em Java, sem JSP nem Servlets) que utiliza o mesmo BD e a mesma classe de acesso ao BD, funciona neste mesmo servidor. Já certificamos que ambas plataformas possuem a mesma versão do JDK e JRE em execução.

Segue abaixo o log do erro no Linux

Using CATALINA_BASE:   /var/lib/tomcat5.5
Using CATALINA_HOME:   /usr/share/tomcat5.5
Using CATALINA_TMPDIR: /var/lib/tomcat5.5/temp
Using JRE_HOME:       /usr/lib/jvm/java-1.5.0-sun
Using Security Manager
18/10/2007 18:01:11 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-1.5.0-sun-1.5.0.08/jre/lib/i386/client:/usr/lib/jvm/java-1.5.0-sun-1.5.0.08/jre/lib/i386:/usr/lib/jvm/java-1.5.0-sun-1.5.0.08/jre/../lib/i386
18/10/2007 18:01:11 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8180
18/10/2007 18:01:11 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1471 ms
18/10/2007 18:01:11 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
18/10/2007 18:01:11 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5
18/10/2007 18:01:11 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
18/10/2007 18:01:12 org.apache.catalina.startup.HostConfig deployDescriptor
WARNING: A docBase /usr/share/tomcat5.5/webapps/balancer inside the host appBase has been specified, and will be ignored
18/10/2007 18:01:12 org.apache.catalina.core.ApplicationContext log
INFO: org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]]
18/10/2007 18:01:13 org.apache.catalina.startup.HostConfig deployDescriptor
WARNING: A docBase /usr/share/tomcat5.5/webapps/tomcat-docs inside the host appBase has been specified, and will be ignored
18/10/2007 18:01:13 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive SACG.war
18/10/2007 18:01:14 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
18/10/2007 18:01:14 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
18/10/2007 18:01:14 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
18/10/2007 18:01:14 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
18/10/2007 18:01:14 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8180
18/10/2007 18:01:14 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
18/10/2007 18:01:14 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/42  config=null
18/10/2007 18:01:15 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
18/10/2007 18:01:15 org.apache.catalina.startup.Catalina start
INFO: Server startup in 3669 ms
ConexaoBD.conectar(): Erro se conectando ao banco de dados.
[b]org.postgresql.util.PSQLException: Alguma coisa anormal ocorreu para causar a falha do driver. Por favor reporte essa exceção: Exception: java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve)[/b]
Stack Trace:

java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve)
	at java.security.AccessControlContext.checkPermission(AccessControlContext.java:264)
	at java.security.AccessController.checkPermission(AccessController.java:427)
	at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)
	at java.lang.SecurityManager.checkConnect(SecurityManager.java:1031)
	at java.net.InetAddress.getAllByName0(InetAddress.java:1117)
	at java.net.InetAddress.getAllByName0(InetAddress.java:1098)
	at java.net.InetAddress.getAllByName(InetAddress.java:1061)
	at java.net.InetAddress.getByName(InetAddress.java:958)
	at java.net.InetSocketAddress.<init>(InetSocketAddress.java:124)
	at java.net.Socket.<init>(Socket.java:179)
	at org.postgresql.core.PGStream.<init>(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:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:171)
	at SACG.ConexaoBD.conectar(ConexaoBD.java:65)
	at SACG.EgressoDAO.<init>(EgressoDAO.java:27)
	at SACG.AutenticacaoMgr.consultar(AutenticacaoMgr.java:55)
	at SACG.TelaAutenticacao.doPost(TelaAutenticacao.java:371)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245)
	at org.apache.catalina.core.ApplicationFilterChain.access$0(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)
End of Stack Trace

	at org.postgresql.Driver.connect(Driver.java:159)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:171)
	at SACG.ConexaoBD.conectar(ConexaoBD.java:65)
	at SACG.EgressoDAO.<init>(EgressoDAO.java:27)
	at SACG.AutenticacaoMgr.consultar(AutenticacaoMgr.java:55)
	at SACG.TelaAutenticacao.doPost(TelaAutenticacao.java:371)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245)
	at org.apache.catalina.core.ApplicationFilterChain.access$0(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)
Erro conectando ao banco de dados em EgressoDAO.
java.lang.NullPointerException
	at SACG.ConexaoBD.isConectado(ConexaoBD.java:320)
	at SACG.EgressoDAO.consultar(EgressoDAO.java:197)
	at SACG.AutenticacaoMgr.consultar(AutenticacaoMgr.java:56)
	at SACG.TelaAutenticacao.doPost(TelaAutenticacao.java:371)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245)
	at org.apache.catalina.core.ApplicationFilterChain.access$0(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)
ConexaoBD.conectar(): Erro se conectando ao banco de dados.
org.postgresql.util.PSQLException: Alguma coisa anormal ocorreu para causar a falha do driver. Por favor reporte essa exceção: 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:264)
	at java.security.AccessController.checkPermission(AccessController.java:427)
	at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)
	at java.lang.SecurityManager.checkConnect(SecurityManager.java:1031)
	at java.net.InetAddress.getAllByName0(InetAddress.java:1117)
	at java.net.InetAddress.getAllByName0(InetAddress.java:1098)
	at java.net.InetAddress.getAllByName(InetAddress.java:1061)
	at java.net.InetAddress.getByName(InetAddress.java:958)
	at java.net.InetSocketAddress.<init>(InetSocketAddress.java:124)
	at java.net.Socket.<init>(Socket.java:179)
	at org.postgresql.core.PGStream.<init>(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:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:171)
	at SACG.ConexaoBD.conectar(ConexaoBD.java:65)
	at SACG.DiscenteDAO.<init>(DiscenteDAO.java:14)
	at SACG.AutenticacaoMgr.consultar(AutenticacaoMgr.java:34)
	at SACG.TelaAutenticacao.doPost(TelaAutenticacao.java:315)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245)
	at org.apache.catalina.core.ApplicationFilterChain.access$0(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)
End of Stack Trace

Gostaria que alguém se possível me ajudasse sobre como devo proceder.

Obrigado.

Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

5 Respostas

A
asterus

Nem sugestões sobre o que posso tentar fazer?

ramilani12
ramilani12

Esse banco de dados esta remoto? , possui algum firewall na rede?
Como esta a url de conexao?

O
oyama
  • Chute 1: veja se no seu arquivo /etc/hosts tem uma entrada
127.0.0.1                   localhost
  • Chute 2: use 127.0.0.1 ao inves de localhost na sua String de conexão.
Dieval_Guizelini
Dieval_Guizelini

Como estamos chutando as possibilidades…

o usuário que iniciou os processos do tomcat por acaso foi o root? caso contrario tente com o usuário root.

Se não tiver a senha do root, faça imediatamente o uso do:
sudo passwd root
e defina nova senha… o Ubuntu é um verdadeiro fenômeno ao tentar criar contas auxiliares e tentar evitar o uso do root.

outro chute, sua police do iptable não está em DROP para INPUT/OUTPUT?

fw

[editado]
171 . java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve)

A
asterus

Primeiro gostaria de pedir desculpas por reviver posts antigos, é que eu fiz uma cirurgia na vista e só agora estou podendo voltar a usar computador.

Eu tentei tudo isso que o pessoal falou, nada deu certo. Formatei e instalei o ubuntu do 0, o java da sun, postgres e tomcat. Mandei rodar e funcionou. Fiqueis em entender, mas o procedimento funcionou, fica aqui para colaborar com quem tiver problema semelhante.

Abraços.

Criado 18 de outubro de 2007
Ultima resposta 20 de fev. de 2008
Respostas 5
Participantes 4

Topicos relacionados

Como saber se um mes tem 4 ou 5 semanas?[RESOLVIDO] 31 respostas Como converter inteiro para string! 13 respostas Comando SELECT para selecionar intervalo de data SQL SERVER 12 respostas &, &&, |, ||. Qndo usar? 6 respostas O método split 12 respostas
Alura O que são algoritmos e lógica de programação e como aprender? Entenda o que são algoritmos e lógica de programação e qual é a importância desses conceitos para começar a programar
Casa do Codigo Desbravando SOLID: Praticas avancadas para codigos de... Por Alexandre Aquiles — Casa do Codigo