3
1

Dear all,
If you want to use Collect in a multi-user environment, you can think about installing it in a server accessible remotely (or in the same local network) from different client computers.
Collect is just a web application that runs in a Application Server (e.g. Apache Tomcat).
You need to follow these steps:

  • install Apache Tomcat 9 application server (Tomcat 10 is not supported yet):
  • install Java Runtime Environment (JRE) 8+ (download Java)
  • install PostgreSQL 8+ (download PostgreSQL)
  • create an empty database called "collect"
  • download:
  • the latest version of the PostgreSQL JDBC driver
  • the latest version of the SQLite JDBC driver
  • put them into tomcat/libs folder
  • download the latest version of the Collect war file
  • put the war file into the tomcat/webapps folder and rename it into collect.war
  • download the sample collect.xml file
  • modify it with the correct database connection parameters
  • put it inside tomcat/conf/Catalina/localhost

Update a multi-user installation of Collect
If you have already installed Collect for a multi-user environment and you want to update it to the latest version, follow these steps:

  • shutdown Tomcat
  • take a full backup of your database (if you are using PostgreSQL, use PGAdmin and take a backup with Custom format)
  • move the file collect.war that is inside the tomcat/webapps folder into another location outside of the Tomcat folder
  • download the latest version of the Collect war file
  • put it inside tomcat/webapps folder and rename it into collect.war
  • startup Tomcat

Open Foris Team

asked 07 Jun '18, 13:15

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.8k119
accept rate: 19%

edited 20 Apr '22, 16:05


12next »

Hi,

I have the same problem like Zura collect war file can't start in tomcat "FAIL - Application at context path /collect could not be started". I followed all the steps above but it is the same massage. My server is in Windows Server 2016. Please can you give us some guidance on what to do?

Regaerd!

permanent link

answered 13 Sep '18, 14:35

ervinadurres's gravatar image

ervinadurres
214
accept rate: 0%

collect war file can't start in tomcat "FAIL - Application at context path [/collect-webapp-3.22.1] could not be started"

what is problem?

permanent link

answered 09 Jun '18, 10:20

zurabogveli's gravatar image

zurabogveli
111
accept rate: 0%

Dear Zura,
Can you give us some more details? In tomcat/logs folder there should be a Catalina.log file that should give you more information about the problem.
Thanks,
Open Foris Team

permanent link

answered 11 Jun '18, 09:14

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.8k119
accept rate: 19%

hello, thanks for answering, This is catalina.log

11-Jun-2018 11:26:33.577 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.31 11-Jun-2018 11:26:33.581 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Apr 27 2018 20:24:25 UTC 11-Jun-2018 11:26:33.582 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.31.0 11-Jun-2018 11:26:33.582 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 7 11-Jun-2018 11:26:33.582 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 6.1 11-Jun-2018 11:26:33.582 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64 11-Jun-2018 11:26:33.582 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Program Files\Java\jre-10.0.1 11-Jun-2018 11:26:33.582 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 10.0.1+10 11-Jun-2018 11:26:33.582 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: "Oracle Corporation" 11-Jun-2018 11:26:33.583 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Tomcat\Apache Software Foundation\Tomcat 8.5 11-Jun-2018 11:26:33.583 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Tomcat\Apache Software Foundation\Tomcat 8.5 11-Jun-2018 11:26:33.583 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Tomcat\Apache Software Foundation\Tomcat 8.5 11-Jun-2018 11:26:33.583 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Tomcat\Apache Software Foundation\Tomcat 8.5 11-Jun-2018 11:26:33.583 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Tomcat\Apache Software Foundation\Tomcat 8.5\temp 11-Jun-2018 11:26:33.584 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 11-Jun-2018 11:26:33.584 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Tomcat\Apache Software Foundation\Tomcat 8.5\conf\logging.properties 11-Jun-2018 11:26:33.584 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED 11-Jun-2018 11:26:33.584 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED 11-Jun-2018 11:26:33.584 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED 11-Jun-2018 11:26:33.584 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit 11-Jun-2018 11:26:33.584 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort 11-Jun-2018 11:26:33.585 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms128m 11-Jun-2018 11:26:33.585 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx256m 11-Jun-2018 11:26:33.585 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.16] using APR version [1.6.3]. 11-Jun-2018 11:26:33.585 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true]. 11-Jun-2018 11:26:33.585 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] 11-Jun-2018 11:26:34.490 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.0.2m 2 Nov 2017] 11-Jun-2018 11:26:34.533 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"] 11-Jun-2018 11:26:34.600 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 11-Jun-2018 11:26:34.606 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"] 11-Jun-2018 11:26:34.609 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 11-Jun-2018 11:26:34.609 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1539 ms 11-Jun-2018 11:26:34.672 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] 11-Jun-2018 11:26:34.672 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.31 11-Jun-2018 11:26:34.683 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying configuration descriptor [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\conf\Catalina\localhost\collect.xml] 11-Jun-2018 11:26:40.080 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 11-Jun-2018 11:26:43.820 INFO [localhost-startStop-1] org.zkoss.zk.ui.http.WebManager.<init>:115 Starting ZK 6.5.1.1 CE (build: 2012121311) 11-Jun-2018 11:26:43.843 INFO [localhost-startStop-1] org.zkoss.zk.ui.sys.ConfigParser.parseConfigXml:160 Loading system default 11-Jun-2018 11:26:43.940 INFO [localhost-startStop-1] org.zkoss.zk.ui.sys.ConfigParser.parse:267 Parsing file:/C:/Tomcat/Apache%20Software%20Foundation/Tomcat%208.5/webapps/collect/WEB-INF/zk.xml 11-Jun-2018 11:26:43.944 INFO [localhost-startStop-1] org.zkoss.zk.ui.sys.ConfigParser.parseSystemConfig:560 The event processing thread is disabled 11-Jun-2018 11:26:44.028 SEVERE [localhost-startStop-1] org.zkoss.zk.ui.util.Configuration.invokeWebAppInits:729 Failed to invoke class org.zkoss.spring.init.SecurityWebAppInit org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/openforis/collect/application-context-core.xml]: Invocation of init method failed; nested exception is liquibase.exception.DatabaseException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (path to 'C:\Windows\system32\config\systemprofile/OpenForis/Collect/data/collect.db': 'C:\Windows\system32\config\systemprofile\OpenForis' does not exist) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) 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:761) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:629) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: liquibase.exception.DatabaseException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (path to 'C:\Windows\system32\config\systemprofile/OpenForis/Collect/data/collect.db': 'C:\Windows\system32\config\systemprofile\OpenForis' does not exist) at liquibase.database.jvm.JdbcConnection.getDatabaseProductName(JdbcConnection.java:27) at liquibase.database.core.SQLiteDatabase.isCorrectDatabaseImplementation(SQLiteDatabase.java:59) at liquibase.database.DatabaseFactory.findCorrectDatabaseImplementation(DatabaseFactory.java:61) at org.openforis.collect.persistence.liquibase.DatabaseAwareSpringLiquibase.getDatabaseProductName(DatabaseAwareSpringLiquibase.java:36) at org.openforis.collect.persistence.liquibase.DatabaseAwareSpringLiquibase.createDatabase(DatabaseAwareSpringLiquibase.java:24) at liquibase.integration.spring.SpringLiquibase.createLiquibase(SpringLiquibase.java:266) at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:244) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) ... 25 more Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (path to 'C:\Windows\system32\config\systemprofile/OpenForis/Collect/data/collect.db': 'C:\Windows\system32\config\systemprofile\OpenForis' does not exist) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:225) at com.sun.proxy.$Proxy15.getMetaData(Unknown Source) at liquibase.database.jvm.JdbcConnection.getDatabaseProductName(JdbcConnection.java:25) ... 33 more Caused by: java.sql.SQLException: path to 'C:\Windows\system32\config\systemprofile/OpenForis/Collect/data/collect.db': 'C:\Windows\system32\config\systemprofile\OpenForis' does not exist at org.sqlite.Conn.open(Conn.java:103) at org.sqlite.Conn.<init>(Conn.java:57) at org.sqlite.JDBC.createConnection(JDBC.java:77) at org.sqlite.JDBC.connect(JDBC.java:64) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 39 more

11-Jun-2018 11:26:44.421 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file 11-Jun-2018 11:26:44.453 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/collect] startup failed due to previous errors 11-Jun-2018 11:26:44.523 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [collect] registered the JDBC driver [org.sqlite.JDBC] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 11-Jun-2018 11:26:44.535 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor Deployment of configuration descriptor [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\conf\Catalina\localhost\collect.xml] has finished in [9,850] ms 11-Jun-2018 11:26:44.537 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\sample.war] 11-Jun-2018 11:26:44.579 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\sample.war] has finished in [42] ms 11-Jun-2018 11:26:44.580 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\docs] 11-Jun-2018 11:26:44.598 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\docs] has finished in [18] ms 11-Jun-2018 11:26:44.599 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\host-manager] 11-Jun-2018 11:26:44.632 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\host-manager] has finished in [32] ms 11-Jun-2018 11:26:44.632 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\manager] 11-Jun-2018 11:26:44.673 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\manager] has finished in [40] ms 11-Jun-2018 11:26:44.673 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\ROOT] 11-Jun-2018 11:26:44.691 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\Apache Software Foundation\Tomcat 8.5\webapps\ROOT] has finished in [18] ms 11-Jun-2018 11:26:44.696 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"] 11-Jun-2018 11:26:44.706 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"] 11-Jun-2018 11:26:44.711 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 10102 ms 11-Jun-2018 11:26:52.660 INFO [http-nio-8080-exec-2] org.zkoss.zk.ui.http.WebManager.<init>:115 Starting ZK 6.5.1.1 CE (build: 2012121311) 11-Jun-2018 11:26:52.680 INFO [http-nio-8080-exec-2] org.zkoss.zk.ui.sys.ConfigParser.parseConfigXml:160 Loading system default 11-Jun-2018 11:26:52.759 INFO [http-nio-8080-exec-2] org.zkoss.zk.ui.sys.ConfigParser.parse:267 Parsing file:/C:/Tomcat/Apache%20Software%20Foundation/Tomcat%208.5/webapps/collect/WEB-INF/zk.xml 11-Jun-2018 11:26:52.761 INFO [http-nio-8080-exec-2] org.zkoss.zk.ui.sys.ConfigParser.parseSystemConfig:560 The event processing thread is disabled 11-Jun-2018 11:26:52.831 SEVERE [http-nio-8080-exec-2] org.zkoss.zk.ui.util.Configuration.invokeWebAppInits:729 Failed to invoke class org.zkoss.spring.init.SecurityWebAppInit org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/openforis/collect/application-context-core.xml]: Invocation of init method failed; nested exception is liquibase.exception.DatabaseException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (path to 'C:\Windows\system32\config\systemprofile/OpenForis/Collect/data/collect.db': 'C:\Windows\system32\config\systemprofile\OpenForis' does not exist) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) 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:761) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1349) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:679) at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:217) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:136) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:613) at org.apache.catalina.valves.RequestFilterValve.process(RequestFilterValve.java:348) at org.apache.catalina.valves.RemoteAddrValve.invoke(RemoteAddrValve.java:52) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1468) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source) Caused by: liquibase.exception.DatabaseException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (path to 'C:\Windows\system32\config\systemprofile/OpenForis/Collect/data/collect.db': 'C:\Windows\system32\config\systemprofile\OpenForis' does not exist) at liquibase.database.jvm.JdbcConnection.getDatabaseProductName(JdbcConnection.java:27) at liquibase.database.core.MaxDBDatabase.isCorrectDatabaseImplementation(MaxDBDatabase.java:107) at liquibase.database.DatabaseFactory.findCorrectDatabaseImplementation(DatabaseFactory.java:61) at org.openforis.collect.persistence.liquibase.DatabaseAwareSpringLiquibase.getDatabaseProductName(DatabaseAwareSpringLiquibase.java:36) at org.openforis.collect.persistence.liquibase.DatabaseAwareSpringLiquibase.createDatabase(DatabaseAwareSpringLiquibase.java:24) at liquibase.integration.spring.SpringLiquibase.createLiquibase(SpringLiquibase.java:266) at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:244) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) ... 50 more Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (path to 'C:\Windows\system32\config\systemprofile/OpenForis/Collect/data/collect.db': 'C:\Windows\system32\config\systemprofile\OpenForis' does not exist) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:225) at com.sun.proxy.$Proxy22.getMetaData(Unknown Source) at liquibase.database.jvm.JdbcConnection.getDatabaseProductName(JdbcConnection.java:25) ... 58 more Caused by: java.sql.SQLException: path to 'C:\Windows\system32\config\systemprofile/OpenForis/Collect/data/collect.db': 'C:\Windows\system32\config\systemprofile\OpenForis' does not exist at org.sqlite.Conn.open(Conn.java:103) at org.sqlite.Conn.<init>(Conn.java:57) at org.sqlite.JDBC.createConnection(JDBC.java:77) at org.sqlite.JDBC.connect(JDBC.java:64) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 64 more

11-Jun-2018 11:26:53.206 SEVERE [http-nio-8080-exec-2] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file 11-Jun-2018 11:26:53.207 SEVERE [http-nio-8080-exec-2] org.apache.catalina.core.StandardContext.startInternal Context [/collect] startup failed due to previous errors 11-Jun-2018 11:26:53.256 WARNING [http-nio-8080-exec-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [collect] registered the JDBC driver [org.sqlite.JDBC] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

permanent link

answered 11 Jun '18, 09:28

zurabogveli's gravatar image

zurabogveli
111
accept rate: 0%

Hi Zura,
Have you configured the collect.xml file properly? Also it must have the same name as the war file, have you renamed this one into collect.war?
Thanks,
Open Foris Team

permanent link

answered 12 Jun '18, 12:45

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.8k119
accept rate: 19%

hi,

yes xml file and war file name is same, "collect" and this is collect.xml file content

<context path="/collect" reloadable="false">
<!-- Parameters -->
<Parameter name="collect.simple_editor" value="false" /> <!-- Simplifies Survey Editor UI -->

<!-- SQLite database stored in USER_HOME/openforis/collect/data/collect.db file -->
<Resource 
   name="jdbc/collectDs" 
   auth="Container"
   type="javax.sql.DataSource"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory"
   driverClassName="org.sqlite.JDBC"
   url="jdbc:sqlite:${user.home}/OpenForis/Collect/data/collect.db">
 </Resource>

<!-- PostgreSQL database configuration
<Resource 
   name="jdbc/collectDs" 
   auth="Container"
   type="javax.sql.DataSource"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory"
   driverClassName="org.postgresql.Driver"
   url="jdbc:postgresql://localhost:5432/collect"
   username="collect"
   password="collect123"
   initialSize="5"
   maxActive="20"
   maxIdle="5">
 </Resource>
-->

</context>

permanent link

answered 12 Jun '18, 18:39

zurabogveli's gravatar image

zurabogveli
111
accept rate: 0%

Hi Zara,
In a multi user environment it would be better to use a PoatgreSQL database instead of the SQLite one, so you should comment the first block and uncomment the second one if you want to do this.
If you still want to try using the SQLite database, in the "url" resource property try to write an absolute path to a folder that will contain the collect.db file (the folder must be created before starting up Collect).
Let us know,
Open Foris Team

permanent link

answered 13 Jun '18, 07:00

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.8k119
accept rate: 19%

hello,

i use postgreSQL and database named "collect" has already created, in xml file which line this database location? in default xml file i did not edit anything, which line need edit to start cellct.war file?

permanent link

answered 13 Jun '18, 07:58

zurabogveli's gravatar image

zurabogveli
111
accept rate: 0%

Hi Zura,
If you want to use PostgreSQL database, just write this in your collect.xml file:

<context path="/collect" reloadable="false">
<!-- Parameters -->
<Parameter name="collect.simple_editor" value="false" /> <!-- Simplifies Survey Editor UI -->

<Resource 
   name="jdbc/collectDs" 
   auth="Container"
   type="javax.sql.DataSource"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory"
   driverClassName="org.postgresql.Driver"
   url="jdbc:postgresql://localhost:5432/collect"
   username="collect"
   password="collect123"
   initialSize="5"
   maxActive="20"
   maxIdle="5">
 </Resource>

</context>

Replace username and password properties values with the correct values.
(note that the last part of the url property is the name of the database, collect in our case).
Let us know, thanks.
Open Foris Team

permanent link

answered 14 Jun '18, 11:26

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.8k119
accept rate: 19%

hello, not work yet, we are working about this problem.

permanent link

answered 22 Jun '18, 08:47

zurabogveli's gravatar image

zurabogveli
111
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×494

question asked: 07 Jun '18, 13:15

question was seen: 10,174 times

last updated: 20 Apr '22, 16:05