Resource Menu


RE : Fatal Postgres Connect Error
Hi Sebastien, thank you for your time! I installed LibreSource from the Libresource-2.2-installer.jar. I did not not install Tigase since it was optional and I do not intend to use Jabber.

I do not think that LibreSource is having trouble with the postgres database. What are some possible things to look for?

If I am missing something obvious please let me know.

Here is what I see in Firefox when I go to the machine 192.168.1.230:9000 

org.apache.jasper.JasperException: javax.servlet.jsp.el.ELException: An error occurred while evaluating function "ls:connectedUser"
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:616)
	org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	java.security.AccessController.doPrivileged(Native Method)
	javax.security.auth.Subject.doAsPrivileged(Subject.java:537)
	org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
	java.security.AccessController.doPrivileged(Native Method)
	java.security.AccessController.doPrivileged(Native Method)
	com.opensymphony.module.sitemesh.filter.PageFilter.applyDecorator(PageFilter.java:156)
	com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:59)
	org.libresource.web.filters.SiteMeshFilter.doFilter(Unknown Source)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:616)
	org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	java.security.AccessController.doPrivileged(Native Method)
	javax.security.auth.Subject.doAsPrivileged(Subject.java:537)
	org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:217)
	java.security.AccessController.doPrivileged(Native Method)
	org.libresource.web.filters.SecurityFilter.doFilter(Unknown Source)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:616)
	org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	java.security.AccessController.doPrivileged(Native Method)
	javax.security.auth.Subject.doAsPrivileged(Subject.java:537)
	org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:217)
root cause
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)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:616)
	org.apache.commons.el.FunctionInvocation.evaluate(FunctionInvocation.java:172)
	org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:263)
	org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:190)
	org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:932)
	org.apache.jsp.pages.decorators.main_jsp._jspService(org.apache.jsp.pages.decorators.main_jsp:201)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:616)
	org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	java.security.AccessController.doPrivileged(Native Method)
	javax.security.auth.Subject.doAsPrivileged(Subject.java:537)
	org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
	java.security.AccessController.doPrivileged(Native Method)
	java.security.AccessController.doPrivileged(Native Method)
	com.opensymphony.module.sitemesh.filter.PageFilter.applyDecorator(PageFilter.java:156)
	com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:59)
	org.libresource.web.filters.SiteMeshFilter.doFilter(Unknown Source)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:616)
	org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	java.security.AccessController.doPrivileged(Native Method)
	javax.security.auth.Subject.doAsPrivileged(Subject.java:537)
	org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:217)
	java.security.AccessController.doPrivileged(Native Method)
	org.libresource.web.filters.SecurityFilter.doFilter(Unknown Source)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:616)
	org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	java.security.AccessController.doPrivileged(Native Method)
	javax.security.auth.Subject.doAsPrivileged(Subject.java:537)
	org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:217)

Here is the output from my JONAS log: 

2008-12-29 07:03:12,798 : INFO : main : Server.<init> :    JVM used is 1.6.0 version of Sun Microsystems Inc. vendor on Linux 2.6.25-14.fc9.i686/i386 OS.
2008-12-29 07:03:12,831 : INFO : main : PolicyProvider.init :    Using JOnAS PolicyConfigurationFactory provider and JOnAS Policy provider
2008-12-29 07:03:13,471 : INFO : main : NameServiceManager.startNonStartedNS :    Name service for jeremie is started on port 2000
2008-12-29 07:03:13,510 : INFO : main : ServiceManager.startRegistry :    registry service started
2008-12-29 07:03:14,112 : INFO : main : ServiceManager.startJmx :    jmx service started
2008-12-29 07:03:14,966 : INFO : main : Current.<init> :    JOTM 2.0.11
2008-12-29 07:03:14,976 : INFO : main : Current.setDefaultRecovery :    Jotm Recovery= false
2008-12-29 07:03:15,017 : SEVERE : main : TransactionServiceImpl.doStart :    JOnAS: Cannot register JTAResource mBeanjava.rmi.RemoteException: java.net.UnknownHostException: colaborate.ndmquestar.com: colaborate.ndmquestar.com
2008-12-29 07:03:15,019 : INFO : main : ServiceManager.startServices :    jtm service started
2008-12-29 07:03:15,751 : INFO : main : DataBaseServiceImpl.createDataSource :    Mapping ConnectionManager jdbc:postgresql://localhost:5432/libresource on libresourceDS
2008-12-29 07:03:15,783 : INFO : main : ServiceManager.startServices :    dbm service started
2008-12-29 07:03:16,259 : INFO : main : ServiceManager.startServices :    security service started
2008-12-29 07:03:17,132 : INFO : main : Rar.processRar :    /usr/local/LibreSource/JONAS_4_7_6/rars/autoload/JOnAS_jdbcXA.rar available
2008-12-29 07:03:17,780 : INFO : main : Rar.processRar :    Starting deployment of /usr/local/LibreSource/JONAS_4_7_6/rars/autoload/joram_for_jonas_ra.rar
2008-12-29 07:03:17,825 : INFO : main : Debug.initialize :    Debug.initialize() - a3debug.cfg
2008-12-29 07:03:17,827 : INFO : main : JoramAdapter.<init> :    JORAM adapter instantiated.
2008-12-29 07:03:17,842 : INFO : main : MXWrapper.setMXServer :    setMXServer: com.scalagent.jmx.JMXServer@ffeef1
2008-12-29 07:03:17,879 : INFO : main : JoramAdapter.start :    JORAM adapter starting deployment…
2008-12-29 07:03:17,881 : INFO : main : JoramAdapter.start :      - Collocated JORAM server is starting…
2008-12-29 07:03:17,922 : WARNING : main : AgentServer.init :    AgentServer#0, init()
posted by moriger at Dec 29, 2008 10:41 PM