postgresql..

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nampet
    New Member
    • Jan 2010
    • 4

    postgresql..

    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.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)
    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


    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
    give some suggestion ....

    thanks..
  • nampet
    New Member
    • Jan 2010
    • 4

    #2
    Problem solved by updating the driver.

    Comment

    Working...