Problems with Aggregate 1.4.8 and 1.4.9

Support
1

I'm trying to install locally an Aggregate server, with versions 1.4.5 and
1.4.7 I have no problem, but now when I try to install versions 1.4.8 and
1.4.9 the application doesn't start and get this errors in the catalina.out
file:

May 25, 2016 10:58:08 AM org.springframework.web.context.ContextLoader
initWebApplicationContext
SEVERE: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'hierarchicalRoleRelationships' defined in ServletContext
resource [/WEB-INF/applicationContext-security.xml]: Invocation of init
method failed; nest$

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)*

  •    at

org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)*

  •    at

org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)*

  •    at

org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)*

  •    at

org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)*

  •    at

org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)*

  •    at

org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)*

  •    at

org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)*

  •    at

org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)*

  •    at

org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)*

  •    at

org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)*

  •    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)*

  •    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)*

  •    at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)*

  •    at

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)*

  •    at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)*

  •    at

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)*

  •    at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)*

  •    at

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)*

  •    at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)*

  •    at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)*

  •    at

org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)*

  •    at java.lang.Thread.run(Thread.java:745)*

Caused by:
org.opendatakit.common.persistence.exception.ODKDatastoreException:
org.springframework.transaction.CannotCreateTransactionException: Could not
open JDBC Connection for transaction; nested exception is
org.postgresql.util.PSQ$

  •    at

org.opendatakit.common.persistence.engine.pgres.DatastoreImpl.assertRelation(DatastoreImpl.java:549)*

  •    at

org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:115)*

  •    at

org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:186)*

  •    at

org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:464)*

  •    at

org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:281)*

  •    at

org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:132)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)**
... 35 more*

And

May 25, 2016 10:58:08 AM org.apache.catalina.core.StandardContext
listenerStart
SEVERE: Exception sending context initialized event to listener instance
of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'hierarchicalRoleRelationships' defined in ServletContext
resource [/WEB-INF/applicationContext-security.xml]: Invocation of init
method failed; nest$

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)*

  •    at

org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)*

  •    at

org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)*

  •    at

org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)*

  •    at

org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)*

  •    at

org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)*

  •    at

org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)*

  •    at

org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)*

  •    at

org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)*

  •    at

org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)*

  •    at

org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)*

  •    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)*

  •    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)*

  •    at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)*

  •    at

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)*

  •    at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)*

  •    at

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)*

  •    at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)*

  •    at

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)*

  •    at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)*

  •    at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)*

  •    at

org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)**
at java.lang.Thread.run(Thread.java:745)*

I've installed on a Ubuntu 12.04, with tomcat 6.

Why is this happening?

Hope anyone can help.

David

2

Looks like your JDBC configuration is not correct or you did not run the
create_db_and_user.sql script:

Caused by:
org.opendatakit.common.persistence.exception.ODKDatastoreException:
org.springframework.transaction.CannotCreateTransactionException: Could not
open JDBC Connection for transaction; nested exception is
org.postgresql.util.PSQ$

··· On Wed, May 25, 2016 at 10:48 AM, David Piedra wrote:

I'm trying to install locally an Aggregate server, with versions 1.4.5 and
1.4.7 I have no problem, but now when I try to install versions 1.4.8 and
1.4.9 the application doesn't start and get this errors in the catalina.out
file:

May 25, 2016 10:58:08 AM org.springframework.web.context.ContextLoader
initWebApplicationContext
SEVERE: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'hierarchicalRoleRelationships' defined in ServletContext
resource [/WEB-INF/applicationContext-security.xml]: Invocation of init
method failed; nest$

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)*

  •    at

org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)*

  •    at

org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)*

  •    at

org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)*

  •    at

org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)*

  •    at

org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)*

  •    at

org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)*

  •    at

org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)*

  •    at

org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)*

  •    at

org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)*

  •    at

org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)*

  •    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)*

  •    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)*

  •    at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)*

  •    at

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)*

  •    at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)*

  •    at

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)*

  •    at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)*

  •    at

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)*

  •    at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)*

  •    at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)*

  •    at

org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)*

  •    at java.lang.Thread.run(Thread.java:745)*

Caused by:
org.opendatakit.common.persistence.exception.ODKDatastoreException:
org.springframework.transaction.CannotCreateTransactionException: Could not
open JDBC Connection for transaction; nested exception is
org.postgresql.util.PSQ$

  •    at

org.opendatakit.common.persistence.engine.pgres.DatastoreImpl.assertRelation(DatastoreImpl.java:549)*

  •    at

org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:115)*

  •    at

org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:186)*

  •    at

org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:464)*

  •    at

org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:281)*

  •    at

org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:132)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)**
... 35 more*

And

May 25, 2016 10:58:08 AM org.apache.catalina.core.StandardContext
listenerStart
SEVERE: Exception sending context initialized event to listener instance
of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'hierarchicalRoleRelationships' defined in ServletContext
resource [/WEB-INF/applicationContext-security.xml]: Invocation of init
method failed; nest$

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)*

  •    at

org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)*

  •    at

org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)*

  •    at

org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)*

  •    at

org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)*

  •    at

org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)*

  •    at

org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)*

  •    at

org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)*

  •    at

org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)*

  •    at

org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)*

  •    at

org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)*

  •    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)*

  •    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)*

  •    at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)*

  •    at

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)*

  •    at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)*

  •    at

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)*

  •    at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)*

  •    at

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)*

  •    at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)*

  •    at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)*

  •    at

org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)**
at java.lang.Thread.run(Thread.java:745)*

I've installed on a Ubuntu 12.04, with tomcat 6.

Why is this happening?

Hope anyone can help.

David

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

3

I did run de create_db_and_user.sql script. About the JDBC configuration,
in the versions 1.4.5 and 1.4.7 I didn't do anything for the JDBC, just
deploy the war file run the sql file and works.

Is there an extra step for this configuration?

Also, later in the catalina.out fale appears this:

May 25, 2016 10:58:08 AM org.apache.catalina.loader.WebappClassLoader
clearReferencesJdbc**SEVERE: The web application [/ODKAggregate ]
registered the JDBC driver [org.postgresql.Driver] but failed to unregister
it when the web application was stopped. To prevent a memory leak, the JDBC
Driver has been forcibly unregistered.

Thanks,

David

··· El miércoles, 25 de mayo de 2016, 11:58:01 (UTC-6), Mitch Sundt escribió: > > Looks like your JDBC configuration is not correct or you did not run the > create_db_and_user.sql script: > > *Caused by: > org.opendatakit.common.persistence.exception.ODKDatastoreException: > org.springframework.transaction.CannotCreateTransactionException: Could not > open JDBC Connection for transaction; nested exception is > org.postgresql.util.PSQ$* > > > > On Wed, May 25, 2016 at 10:48 AM, David Piedra <david....@gmail.com > wrote: > >> I'm trying to install locally an Aggregate server, with versions 1.4.5 >> and 1.4.7 I have no problem, but now when I try to install versions 1.4.8 >> and 1.4.9 the application doesn't start and get this errors in the >> catalina.out file: >> >> >>> *May 25, 2016 10:58:08 AM org.springframework.web.context.ContextLoader >>> initWebApplicationContext* >>> *SEVERE: Context initialization failed* >>> *org.springframework.beans.factory.BeanCreationException: Error creating >>> bean with name 'hierarchicalRoleRelationships' defined in ServletContext >>> resource [/WEB-INF/applicationContext-security.xml]: Invocation of init >>> method failed; nest$* >>> * at >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)* >>> * at >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)* >>> * at >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)* >>> * at >>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)* >>> * at >>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)* >>> * at >>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)* >>> * at >>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)* >>> * at >>> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)* >>> * at >>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)* >>> * at >>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)* >>> * at >>> org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)* >>> * at >>> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)* >>> * at >>> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)* >>> * at >>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)* >>> * at >>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)* >>> * at >>> org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)* >>> * at >>> org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)* >>> * at >>> org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)* >>> * at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)* >>> * at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)* >>> * at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)* >>> * at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)* >>> * at >>> org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)* >>> * at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)* >>> * at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)* >>> * at >>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)* >>> * at >>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)* >>> * at >>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)* >>> * at >>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)* >>> * at >>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)* >>> * at >>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)* >>> * at >>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)* >>> * at >>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)* >>> * at >>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)* >>> * at >>> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)* >>> * at java.lang.Thread.run(Thread.java:745)* >>> *Caused by: >>> org.opendatakit.common.persistence.exception.ODKDatastoreException: >>> org.springframework.transaction.CannotCreateTransactionException: Could not >>> open JDBC Connection for transaction; nested exception is >>> org.postgresql.util.PSQ$* >>> * at >>> org.opendatakit.common.persistence.engine.pgres.DatastoreImpl.assertRelation(DatastoreImpl.java:549)* >>> * at >>> org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:115)* >>> * at >>> org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:186)* >>> * at >>> org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:464)* >>> * at >>> org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:281)* >>> * at >>> org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:132)* >>> * at >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)* >>> * at >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)** >>> ... 35 more* >> >> >> And >> >> >>> *May 25, 2016 10:58:08 AM org.apache.catalina.core.StandardContext >>> listenerStart* >>> *SEVERE: Exception sending context initialized event to listener >>> instance of class org.springframework.web.context.ContextLoaderListener* >>> *org.springframework.beans.factory.BeanCreationException: Error creating >>> bean with name 'hierarchicalRoleRelationships' defined in ServletContext >>> resource [/WEB-INF/applicationContext-security.xml]: Invocation of init >>> method failed; nest$* >>> * at >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)* >>> * at >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)* >>> * at >>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)* >>> * at >>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)* >>> * at >>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)* >>> * at >>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)* >>> * at >>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)* >>> * at >>> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)* >>> * at >>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)* >>> * at >>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)* >>> * at >>> org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)* >>> * at >>> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)* >>> * at >>> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)* >>> * at >>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)* >>> * at >>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)* >>> * at >>> org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)* >>> * at >>> org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)* >>> * at >>> org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)* >>> * at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)* >>> * at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)* >>> * at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)* >>> * at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)* >>> * at >>> org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)* >>> * at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)* >>> * at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)* >>> * at >>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)* >>> * at >>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)* >>> * at >>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)* >>> * at >>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)* >>> * at >>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)* >>> * at >>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)* >>> * at >>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)* >>> * at >>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)* >>> * at >>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)* >>> * at >>> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)** >>> at java.lang.Thread.run(Thread.java:745)* >> >> >> I've installed on a Ubuntu 12.04, with tomcat 6. >> >> Why is this happening? >> >> Hope anyone can help. >> >> David >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "ODK Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to opendatakit...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >
4

Open your postgres admin console and attempt to connect to your Postgres
server using the settings that you used when you ran the installer.

All indications are that the username and/or password and/or location of
the Postgres server are not properly configured.

Or, if you have the old working installs, find the older (from the 1.4.5 or
1.4.7 install):

ODKAggregate.war

Copy this and rename it to ODKAggregate.zip.

Right-click and Extract all...

Then navigate to, and select:

ODKAggregate/WEB-INF/lib/ODKAggregate-settings.jar

copy that file to a folder elsewhere. Rename that to end in .zip, and
right-click, Extract all...

Then open the jdbc.properties file with a text editor (e.g., Notepad++)

This will contain the username, password, hostname and port (if not the
default port), etc. used to access the postgreSQL server.

Confirm that these are the same values as you have been entering during the
running of the 1.4.9 installer.

··· On Wed, May 25, 2016 at 11:08 AM, David Piedra wrote:

I did run de create_db_and_user.sql script. About the JDBC configuration,
in the versions 1.4.5 and 1.4.7 I didn't do anything for the JDBC, just
deploy the war file run the sql file and works.

Is there an extra step for this configuration?

Also, later in the catalina.out fale appears this:

May 25, 2016 10:58:08 AM org.apache.catalina.loader.WebappClassLoader
clearReferencesJdbc**SEVERE: The web application [/ODKAggregate ]
registered the JDBC driver [org.postgresql.Driver] but failed to unregister
it when the web application was stopped. To prevent a memory leak, the JDBC
Driver has been forcibly unregistered.

Thanks,

David

El miércoles, 25 de mayo de 2016, 11:58:01 (UTC-6), Mitch Sundt escribió:

Looks like your JDBC configuration is not correct or you did not run the
create_db_and_user.sql script:

Caused by:
org.opendatakit.common.persistence.exception.ODKDatastoreException:
org.springframework.transaction.CannotCreateTransactionException: Could not
open JDBC Connection for transaction; nested exception is
org.postgresql.util.PSQ$

On Wed, May 25, 2016 at 10:48 AM, David Piedra david....@gmail.com wrote:

I'm trying to install locally an Aggregate server, with versions 1.4.5
and 1.4.7 I have no problem, but now when I try to install versions 1.4.8
and 1.4.9 the application doesn't start and get this errors in the
catalina.out file:

May 25, 2016 10:58:08 AM org.springframework.web.context.ContextLoader
initWebApplicationContext
SEVERE: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'hierarchicalRoleRelationships' defined in
ServletContext resource [/WEB-INF/applicationContext-security.xml]:
Invocation of init method failed; nest$

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)*

  •    at

org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)*

  •    at

org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)*

  •    at

org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)*

  •    at

org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)*

  •    at

org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)*

  •    at

org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)*

  •    at

org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)*

  •    at

org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)*

  •    at

org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)*

  •    at

org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)*

  •    at

javax.servlet.http.HttpServlet.service(HttpServlet.java:617)*

  •    at

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)*

  •    at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)*

  •    at

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)*

  •    at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)*

  •    at

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)*

  •    at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)*

  •    at

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)*

  •    at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)*

  •    at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)*

  •    at org.apache.tomcat.util.net

http://org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)*

  •    at java.lang.Thread.run(Thread.java:745)*

Caused by:
org.opendatakit.common.persistence.exception.ODKDatastoreException:
org.springframework.transaction.CannotCreateTransactionException: Could not
open JDBC Connection for transaction; nested exception is
org.postgresql.util.PSQ$

  •    at

org.opendatakit.common.persistence.engine.pgres.DatastoreImpl.assertRelation(DatastoreImpl.java:549)*

  •    at

org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:115)*

  •    at

org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:186)*

  •    at

org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:464)*

  •    at

org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:281)*

  •    at

org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:132)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)**
... 35 more*

And

May 25, 2016 10:58:08 AM org.apache.catalina.core.StandardContext
listenerStart
SEVERE: Exception sending context initialized event to listener
instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'hierarchicalRoleRelationships' defined in
ServletContext resource [/WEB-INF/applicationContext-security.xml]:
Invocation of init method failed; nest$

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)*

  •    at

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)*

  •    at

org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)*

  •    at

org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)*

  •    at

org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)*

  •    at

org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)*

  •    at

org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)*

  •    at

org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)*

  •    at

org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)*

  •    at

org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)*

  •    at

org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)*

  •    at

org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)*

  •    at

org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)*

  •    at

org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)*

  •    at

javax.servlet.http.HttpServlet.service(HttpServlet.java:617)*

  •    at

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)*

  •    at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)*

  •    at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)*

  •    at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)*

  •    at

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)*

  •    at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)*

  •    at

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)*

  •    at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)*

  •    at

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)*

  •    at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)*

  •    at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)*

  •    at org.apache.tomcat.util.net

http://org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)**
at java.lang.Thread.run(Thread.java:745)*

I've installed on a Ubuntu 12.04, with tomcat 6.

Why is this happening?

Hope anyone can help.

David

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

5

Thank you so much, now I have 1.4.9 working! Sorry for all the
inconvinience.

David

··· El miércoles, 25 de mayo de 2016, 14:33:08 (UTC-6), Mitch Sundt escribió: > > Open your postgres admin console and attempt to connect to your Postgres > server using the settings that you used when you ran the installer. > > All indications are that the username and/or password and/or location of > the Postgres server are not properly configured. > > Or, if you have the old working installs, find the older (from the 1.4.5 > or 1.4.7 install): > > ODKAggregate.war > > Copy this and rename it to ODKAggregate.zip. > > Right-click and Extract all... > > Then navigate to, and select: > > ODKAggregate/WEB-INF/lib/ODKAggregate-settings.jar > > copy that file to a folder elsewhere. Rename that to end in .zip, and > right-click, Extract all... > > Then open the jdbc.properties file with a text editor (e.g., Notepad++) > > This will contain the username, password, hostname and port (if not the > default port), etc. used to access the postgreSQL server. > > Confirm that these are the same values as you have been entering during > the running of the 1.4.9 installer. > > > On Wed, May 25, 2016 at 11:08 AM, David Piedra <david....@gmail.com > wrote: > >> I did run de create_db_and_user.sql script. About the JDBC configuration, >> in the versions 1.4.5 and 1.4.7 I didn't do anything for the JDBC, just >> deploy the war file run the sql file and works. >> >> Is there an extra step for this configuration? >> >> Also, later in the catalina.out fale appears this: >> >> >>> *May 25, 2016 10:58:08 AM org.apache.catalina.loader.WebappClassLoader >>> clearReferencesJdbc**SEVERE: The web application [/ODKAggregate ] >>> registered the JDBC driver [org.postgresql.Driver] but failed to unregister >>> it when the web application was stopped. To prevent a memory leak, the JDBC >>> Driver has been forcibly unregistered.* >> >> >> Thanks, >> >> David >> >> El miércoles, 25 de mayo de 2016, 11:58:01 (UTC-6), Mitch Sundt escribió: >>> >>> Looks like your JDBC configuration is not correct or you did not run the >>> create_db_and_user.sql script: >>> >>> *Caused by: >>> org.opendatakit.common.persistence.exception.ODKDatastoreException: >>> org.springframework.transaction.CannotCreateTransactionException: Could not >>> open JDBC Connection for transaction; nested exception is >>> org.postgresql.util.PSQ$* >>> >>> >>> >>> On Wed, May 25, 2016 at 10:48 AM, David Piedra wrote: >>> >>>> I'm trying to install locally an Aggregate server, with versions 1.4.5 >>>> and 1.4.7 I have no problem, but now when I try to install versions 1.4.8 >>>> and 1.4.9 the application doesn't start and get this errors in the >>>> catalina.out file: >>>> >>>> >>>>> *May 25, 2016 10:58:08 AM >>>>> org.springframework.web.context.ContextLoader initWebApplicationContext* >>>>> *SEVERE: Context initialization failed* >>>>> *org.springframework.beans.factory.BeanCreationException: Error >>>>> creating bean with name 'hierarchicalRoleRelationships' defined in >>>>> ServletContext resource [/WEB-INF/applicationContext-security.xml]: >>>>> Invocation of init method failed; nest$* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)* >>>>> * at >>>>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)* >>>>> * at >>>>> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)* >>>>> * at >>>>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)* >>>>> * at >>>>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)* >>>>> * at >>>>> org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)* >>>>> * at >>>>> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)* >>>>> * at >>>>> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)* >>>>> * at >>>>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)* >>>>> * at >>>>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)* >>>>> * at >>>>> org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)* >>>>> * at >>>>> org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)* >>>>> * at >>>>> org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)* >>>>> * at >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:617)* >>>>> * at >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)* >>>>> * at >>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)* >>>>> * at >>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)* >>>>> * at >>>>> org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)* >>>>> * at >>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)* >>>>> * at >>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)* >>>>> * at >>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)* >>>>> * at >>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)* >>>>> * at >>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)* >>>>> * at >>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)* >>>>> * at >>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)* >>>>> * at >>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)* >>>>> * at >>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)* >>>>> * at >>>>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)* >>>>> * at >>>>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)* >>>>> * at org.apache.tomcat.util.net >>>>> .JIoEndpoint$Worker.run(JIoEndpoint.java:489)* >>>>> * at java.lang.Thread.run(Thread.java:745)* >>>>> *Caused by: >>>>> org.opendatakit.common.persistence.exception.ODKDatastoreException: >>>>> org.springframework.transaction.CannotCreateTransactionException: Could not >>>>> open JDBC Connection for transaction; nested exception is >>>>> org.postgresql.util.PSQ$* >>>>> * at >>>>> org.opendatakit.common.persistence.engine.pgres.DatastoreImpl.assertRelation(DatastoreImpl.java:549)* >>>>> * at >>>>> org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:115)* >>>>> * at >>>>> org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:186)* >>>>> * at >>>>> org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:464)* >>>>> * at >>>>> org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:281)* >>>>> * at >>>>> org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:132)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)** >>>>> ... 35 more* >>>> >>>> >>>> And >>>> >>>> >>>>> *May 25, 2016 10:58:08 AM org.apache.catalina.core.StandardContext >>>>> listenerStart* >>>>> *SEVERE: Exception sending context initialized event to listener >>>>> instance of class org.springframework.web.context.ContextLoaderListener* >>>>> *org.springframework.beans.factory.BeanCreationException: Error >>>>> creating bean with name 'hierarchicalRoleRelationships' defined in >>>>> ServletContext resource [/WEB-INF/applicationContext-security.xml]: >>>>> Invocation of init method failed; nest$* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)* >>>>> * at >>>>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)* >>>>> * at >>>>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)* >>>>> * at >>>>> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)* >>>>> * at >>>>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)* >>>>> * at >>>>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)* >>>>> * at >>>>> org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)* >>>>> * at >>>>> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)* >>>>> * at >>>>> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)* >>>>> * at >>>>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)* >>>>> * at >>>>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)* >>>>> * at >>>>> org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)* >>>>> * at >>>>> org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)* >>>>> * at >>>>> org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)* >>>>> * at >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:617)* >>>>> * at >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)* >>>>> * at >>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)* >>>>> * at >>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)* >>>>> * at >>>>> org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:193)* >>>>> * at >>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)* >>>>> * at >>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)* >>>>> * at >>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)* >>>>> * at >>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)* >>>>> * at >>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)* >>>>> * at >>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)* >>>>> * at >>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)* >>>>> * at >>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)* >>>>> * at >>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)* >>>>> * at >>>>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)* >>>>> * at >>>>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)* >>>>> * at org.apache.tomcat.util.net >>>>> .JIoEndpoint$Worker.run(JIoEndpoint.java:489)** >>>>> at java.lang.Thread.run(Thread.java:745)* >>>> >>>> >>>> I've installed on a Ubuntu 12.04, with tomcat 6. >>>> >>>> Why is this happening? >>>> >>>> Hope anyone can help. >>>> >>>> David >>>> >>>> -- >>>> -- >>>> Post: opend...@googlegroups.com >>>> Unsubscribe: opendatakit...@googlegroups.com >>>> Options: http://groups.google.com/group/opendatakit?hl=en >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "ODK Community" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to opendatakit...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Mitch Sundt >>> Software Engineer >>> University of Washington >>> mitche...@gmail.com >>> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "ODK Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to opendatakit...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >