By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,255 Members | 2,575 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,255 IT Pros & Developers. It's quick & easy.

postgresql..

P: 4
We set up a new system with the OS and database below.
Now some pages are not loading in browser.

redhat el 5.3
postgresql 8.1.11
the error is:
javax.servlet.ServletException: Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: FATAL: no pg_hba.conf entry for host "172.16.16.167", user "postgres", database "nampetdb", SSL off

Stack Trace:

java.sql.SQLException: FATAL: no pg_hba.conf entry for host "172.16.16.167", user "postgres", database "nampetdb", SSL off

at org.postgresql.Connection.openConnection(Connectio n.java:178)
at org.postgresql.Driver.connect(Driver.java:149)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at org.apache.jsp.idea_005fforum_jsp._jspService(idea _005fforum_jsp.java:91)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:311)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:301)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:248)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:257)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.StandardContextValve.invo keInternal(StandardContextValve.java:245)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:199)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:195)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:164)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:149)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:156)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:972)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(Co yoteAdapter.java:206)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
End of Stack Trace

org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:800)
org.apache.jsp.idea_005fforum_jsp._jspService(idea _005fforum_jsp.java:461)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
root cause

Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: FATAL: no pg_hba.conf entry for host "172.16.16.167", user "postgres", database "nampetdb", SSL off

Stack Trace:

java.sql.SQLException: FATAL: no pg_hba.conf entry for host "172.16.16.167", user "postgres", database "nampetdb", SSL off

at org.postgresql.Connection.openConnection(Connectio n.java:178)
at org.postgresql.Driver.connect(Driver.java:149)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at org.apache.jsp.idea_005fforum_jsp._jspService(idea _005fforum_jsp.java:91)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:311)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:301)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:248)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:257)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.StandardContextValve.invo keInternal(StandardContextValve.java:245)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:199)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:195)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:164)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:149)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:156)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:972)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(Co yoteAdapter.java:206)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
End of Stack Trace

org.postgresql.Driver.connect(Driver.java:166)
java.sql.DriverManager.getConnection(DriverManager .java:512)
java.sql.DriverManager.getConnection(DriverManager .java:171)
org.apache.jsp.idea_005fforum_jsp._jspService(idea _005fforum_jsp.java:91)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
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


Expand|Select|Wrap|Line Numbers
  1. # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
  2.  
  3. # "local" is for Unix domain socket connections only
  4. local   all         all                               trust
  5. # IPv4 local connections:
  6.  
  7. host    all         all         172.16.16.167       255.255.255.255   trust
  8. host    all         all         172.16.16.88        255.255.255.255   trust
  9. host    all         all         172.16.52.9         255.255.255.255   trust
  10. host    all         all         172.16.16.76        255.255.255.255   trust
  11. host    all         all         127.0.0.1/32          trust
  12. # IPv6 local connections:
  13. host    all         all         ::1/128               trust
  14. local  all    all             ident   sameuser
  15. hostssl all all 127.0.0.1/32 trust
  16. hostssl all all 172.16.16.167 255.255.255.255 trust
give some suggestion ....

thanks..
Jan 11 '10 #1

✓ answered by nampet

Problem solved by updating the driver.

Share this Question
Share on Google+
1 Reply


P: 4
Problem solved by updating the driver.
Jan 12 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.