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 start.sh 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 "127.0.0.1", 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: 127.0.0.1 libresource postgres trust.

Please help me onto the right path.

A'ight.

Well.

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 start.sh.

Well, I went to the address in the browser (192.168.1.243:9000) 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="main.user.logged.as.root"/> - </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(PageContextImpl.java:854) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791) 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(MembershipServiceBean.java:884) org.objectweb.jonas_gen.org.libresource.membership.interfaces.JOnASMembershipService860227629Remote.getProfile(JOnASMembershipService860227629Remote.java:1078) 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