Resource Menu

RE : Fatal Postgres Connect Error
Hi dear people,

I just did a fresh install on Fedora Core 10 running postgresql 8.2.11. When I run I get the following fatal error

2008-12-26 09:09:51,780 : ConnectionManager.getXAConnection : Could not get Connection on jdbc:postgresql://localhost:5432/libresource: org.postgresql.util.PSQLException: A connection error has occurred: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "", user "postgres", database "libresource", SSL off

my pg_hba.conf file says this:

local all all trust I am suspecting that I need to add the line: libresource postgres trust.

Please help me onto the right path.



The problem was that the pg_hb.conf file had been renamed and replaced with a bad file. I corrected that and started the server up using

Well, I went to the address in the browser ( and it gave me this error in the browser window: org.apache.jasper.JasperException: Exception in JSP: /pages/decorators/main.jsp:57

54: <c:if test="${ls:isSuperUser()}"> 55: <span id="connectedAsRoot"><fmt:message key=""/> - </span> 56: </c:if> 57: <span id="connectedUser">${ls:connectedUser()} - </span> 58: <span id="loginaction"> 59: <% if(request.getSession().getAttribute("security_username")!=null) { %> 60: <c:choose>

The stack trace has two "root cause" sections. One starts: javax.servlet.ServletException: javax.servlet.jsp.el.ELException: An error occurred while evaluating function "ls:connectedUser" org.apache.jasper.runtime.PageContextImpl.doHandlePageException( org.apache.jasper.runtime.PageContextImpl.handlePageException( org.apache.jsp.pages.decorators.main_jsp._jspService(org.apache.jsp.pages.decorators.main_jsp:622)

And the other starts: org.libresource.membership.MembershipServiceException: Error in getProfile : Error in systemGetProfile : The pk fields has not been initialized the ejbCreate method of the bean Node org.libresource.membership.ejb.MembershipServiceBean.getProfile( org.libresource.web.Helper.getConnectedUserProfile(Unknown Source) org.libresource.web.taglibs.JspFunctions.connectedUser(Unknown Source) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

posted by moriger at Dec 26, 2008 10:51 PM