We set up a new system with the OS and database below.
Now some pages are not loading in browser.
the error is:
but the same code is no problem with old server..
i can also insert the data into database with some pages.
i have done the necessery changes in pg_hba.cong file...
but the problem is still occur.
i also attach the file pg_hba.conf
give some suggestion ....
thanks..
Now some pages are not loading in browser.
redhat el 5.3
postgresql 8.1.11
postgresql 8.1.11
javax.servlet.S ervletException : Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLExc eption: FATAL: no pg_hba.conf entry for host "172.16.16.167" , user "postgres", database "nampetdb", SSL off
Stack Trace:
java.sql.SQLExc eption: FATAL: no pg_hba.conf entry for host "172.16.16.167" , user "postgres", database "nampetdb", SSL off
at org.postgresql. Connection.open Connection(Conn ection.java:178 )
at org.postgresql. Driver.connect( Driver.java:149 )
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
at org.apache.jsp. idea_005fforum_ jsp._jspService (idea_005fforum _jsp.java:91)
at org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:133)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 311)
at org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
at org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:284)
at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:204)
at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:257)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardContextValve .invokeInternal (StandardContex tValve.java:245 )
at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:199)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:19 5)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:16 4)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:149)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:156)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:972)
at org.apache.coyo te.tomcat5.Coyo teAdapter.servi ce(CoyoteAdapte r.java:206)
at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:828)
at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.processConn ection(Http11Pr otocol.java:700 )
at org.apache.tomc at.util.net.Tcp WorkerThread.ru nIt(PoolTcpEndp oint.java:584)
at org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n(ThreadPool.ja va:683)
at java.lang.Threa d.run(Thread.ja va:534)
End of Stack Trace
org.apache.jasp er.runtime.Page ContextImpl.doH andlePageExcept ion(PageContext Impl.java:867)
org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:800)
org.apache.jsp. idea_005fforum_ jsp._jspService (idea_005fforum _jsp.java:461)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:133)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 311)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
root cause
Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLExc eption: FATAL: no pg_hba.conf entry for host "172.16.16.167" , user "postgres", database "nampetdb", SSL off
Stack Trace:
java.sql.SQLExc eption: FATAL: no pg_hba.conf entry for host "172.16.16.167" , user "postgres", database "nampetdb", SSL off
at org.postgresql. Connection.open Connection(Conn ection.java:178 )
at org.postgresql. Driver.connect( Driver.java:149 )
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
at org.apache.jsp. idea_005fforum_ jsp._jspService (idea_005fforum _jsp.java:91)
at org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:133)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 311)
at org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
at org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:284)
at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:204)
at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:257)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardContextValve .invokeInternal (StandardContex tValve.java:245 )
at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:199)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:19 5)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:16 4)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:149)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:156)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:972)
at org.apache.coyo te.tomcat5.Coyo teAdapter.servi ce(CoyoteAdapte r.java:206)
at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:828)
at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.processConn ection(Http11Pr otocol.java:700 )
at org.apache.tomc at.util.net.Tcp WorkerThread.ru nIt(PoolTcpEndp oint.java:584)
at org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n(ThreadPool.ja va:683)
at java.lang.Threa d.run(Thread.ja va:534)
End of Stack Trace
org.postgresql. Driver.connect( Driver.java:166 )
java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
org.apache.jsp. idea_005fforum_ jsp._jspService (idea_005fforum _jsp.java:91)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:133)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 311)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
Stack Trace:
java.sql.SQLExc eption: FATAL: no pg_hba.conf entry for host "172.16.16.167" , user "postgres", database "nampetdb", SSL off
at org.postgresql. Connection.open Connection(Conn ection.java:178 )
at org.postgresql. Driver.connect( Driver.java:149 )
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
at org.apache.jsp. idea_005fforum_ jsp._jspService (idea_005fforum _jsp.java:91)
at org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:133)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 311)
at org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
at org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:284)
at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:204)
at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:257)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardContextValve .invokeInternal (StandardContex tValve.java:245 )
at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:199)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:19 5)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:16 4)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:149)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:156)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:972)
at org.apache.coyo te.tomcat5.Coyo teAdapter.servi ce(CoyoteAdapte r.java:206)
at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:828)
at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.processConn ection(Http11Pr otocol.java:700 )
at org.apache.tomc at.util.net.Tcp WorkerThread.ru nIt(PoolTcpEndp oint.java:584)
at org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n(ThreadPool.ja va:683)
at java.lang.Threa d.run(Thread.ja va:534)
End of Stack Trace
org.apache.jasp er.runtime.Page ContextImpl.doH andlePageExcept ion(PageContext Impl.java:867)
org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:800)
org.apache.jsp. idea_005fforum_ jsp._jspService (idea_005fforum _jsp.java:461)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:133)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 311)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
root cause
Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLExc eption: FATAL: no pg_hba.conf entry for host "172.16.16.167" , user "postgres", database "nampetdb", SSL off
Stack Trace:
java.sql.SQLExc eption: FATAL: no pg_hba.conf entry for host "172.16.16.167" , user "postgres", database "nampetdb", SSL off
at org.postgresql. Connection.open Connection(Conn ection.java:178 )
at org.postgresql. Driver.connect( Driver.java:149 )
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
at org.apache.jsp. idea_005fforum_ jsp._jspService (idea_005fforum _jsp.java:91)
at org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:133)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 311)
at org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
at org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:284)
at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:204)
at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:257)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardContextValve .invokeInternal (StandardContex tValve.java:245 )
at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:199)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:19 5)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:16 4)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:149)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:156)
at org.apache.cata lina.core.Stand ardValveContext .invokeNext(Sta ndardValveConte xt.java:151)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:564)
at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:972)
at org.apache.coyo te.tomcat5.Coyo teAdapter.servi ce(CoyoteAdapte r.java:206)
at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:828)
at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.processConn ection(Http11Pr otocol.java:700 )
at org.apache.tomc at.util.net.Tcp WorkerThread.ru nIt(PoolTcpEndp oint.java:584)
at org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n(ThreadPool.ja va:683)
at java.lang.Threa d.run(Thread.ja va:534)
End of Stack Trace
org.postgresql. Driver.connect( Driver.java:166 )
java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
org.apache.jsp. idea_005fforum_ jsp._jspService (idea_005fforum _jsp.java:91)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:133)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 311)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
i can also insert the data into database with some pages.
i have done the necessery changes in pg_hba.cong file...
but the problem is still occur.
i also attach the file pg_hba.conf
Code:
# TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 172.16.16.167 255.255.255.255 trust host all all 172.16.16.88 255.255.255.255 trust host all all 172.16.52.9 255.255.255.255 trust host all all 172.16.16.76 255.255.255.255 trust host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust local all all ident sameuser hostssl all all 127.0.0.1/32 trust hostssl all all 172.16.16.167 255.255.255.255 trust
thanks..
Comment