What is the problem? Please be detailed.
Hi Guys. The aggregate install is not working for me. Spent hours trying to troubleshoot... Help appreciated 
I have installed Tomcat8 (working)
MySql (working)
ODK aggregrate (not working)
I get the HTTP Status 404 - /ODKAggregate/ when I try to go to
file:///var/lib/tomcat8/webapps/ODKAggregate/Aggregate.html
This page shows correctly before a redirect.
file:///var/lib/tomcat8/webapps/ODKAggregate/index.html
What ODK tool and version are you using? And on what device and operating system version?
ODK Aggregate linux-x64-installer.run
Ubuntu 16.04.4
What steps can we take to reproduce the problem?
Tried all the steps on the web site:
https://docs.opendatakit.org/aggregate-tomcat/
What you have you tried to fix the problem?
Tried all the steps on the web site:
https://docs.opendatakit.org/aggregate-tomcat/
Anything else we should know or have? If you have a test form or screenshots or logs, attach here.
localhost log
127.0.0.1 - - [10/Apr/2018:17:18:35 +1000] "GET /ODKAggregate/ HTTP/1.1" 404 1038
127.0.0.1 - - [10/Apr/2018:17:44:35 +1000] "GET /ODKAggregate/ HTTP/1.1" 404 1038
127.0.0.1 - - [10/Apr/2018:17:44:35 +1000] "GET /favicon.ico HTTP/1.1" 404 1034
127.0.0.1 - - [10/Apr/2018:17:44:44 +1000] "GET /ODKAggregate/ HTTP/1.1" 404 1038
127.0.0.1 - - [10/Apr/2018:17:57:41 +1000] "GET /ODKAggregate/ HTTP/1.1" 404 1038
127.0.0.1 - - [10/Apr/2018:17:57:41 +1000] "GET /favicon.ico HTTP/1.1" 404 1034
127.0.0.1 - - [10/Apr/2018:17:58:10 +1000] "GET /ODKAggregate/ HTTP/1.1" 404 1038
127.0.0.1 - - [10/Apr/2018:17:58:27 +1000] "GET /ODKAggregate/ HTTP/1.1" 404 1038
127.0.0.1 - - [10/Apr/2018:17:58:36 +1000] "GET / HTTP/1.1" 304 -
127.0.0.1 - - [10/Apr/2018:18:09:24 +1000] "GET /ODKAggregate/ HTTP/1.1" 404 1038
Catalina log
0-Apr-2018 17:44:14.018 INFO [Thread-3] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-8080"]
10-Apr-2018 17:44:14.029 INFO [Thread-3] org.apache.catalina.core.StandardService.stopInternal Stopping service Catalina
10-Apr-2018 17:44:14.056 INFO [Thread-3] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["http-nio-8080"]
10-Apr-2018 17:44:14.061 INFO [Thread-3] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["http-nio-8080"]
10-Apr-2018 17:44:14.237 WARNING [main] org.apache.catalina.startup.ClassLoaderFactory.validateFile Problem with directory [/usr/share/tomcat8/common/classes], exists: [false], isDirectory: [false], canRead: [false]
10-Apr-2018 17:44:14.246 WARNING [main] org.apache.catalina.startup.ClassLoaderFactory.validateFile Problem with directory [/usr/share/tomcat8/common], exists: [false], isDirectory: [false], canRead: [false]
10-Apr-2018 17:44:14.249 WARNING [main] org.apache.catalina.startup.ClassLoaderFactory.validateFile Problem with directory [/usr/share/tomcat8/server/classes], exists: [false], isDirectory: [false], canRead: [false]
10-Apr-2018 17:44:14.250 WARNING [main] org.apache.catalina.startup.ClassLoaderFactory.validateFile Problem with directory [/usr/share/tomcat8/server], exists: [false], isDirectory: [false], canRead: [false]
10-Apr-2018 17:44:14.252 WARNING [main] org.apache.catalina.startup.ClassLoaderFactory.validateFile Problem with directory [/usr/share/tomcat8/shared/classes], exists: [false], isDirectory: [false], canRead: [false]
10-Apr-2018 17:44:14.254 WARNING [main] org.apache.catalina.startup.ClassLoaderFactory.validateFile Problem with directory [/usr/share/tomcat8/shared], exists: [false], isDirectory: [false], canRead: [false]
10-Apr-2018 17:44:14.886 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.0.32 (Ubuntu)
10-Apr-2018 17:44:14.887 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Sep 27 2017 21:23:18 UTC
10-Apr-2018 17:44:14.888 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.0.32.0
10-Apr-2018 17:44:14.890 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
10-Apr-2018 17:44:14.892 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 4.13.0-38-generic
10-Apr-2018 17:44:14.893 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
10-Apr-2018 17:44:14.901 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/lib/jvm/java-8-openjdk-amd64/jre
10-Apr-2018 17:44:14.902 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_162-8u162-b12-0ubuntu0.16.04.2-b12
10-Apr-2018 17:44:14.902 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
10-Apr-2018 17:44:14.903 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /var/lib/tomcat8
10-Apr-2018 17:44:14.903 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /usr/share/tomcat8
10-Apr-2018 17:44:14.905 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/var/lib/tomcat8/conf/logging.properties
10-Apr-2018 17:44:14.906 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
10-Apr-2018 17:44:14.907 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true
10-Apr-2018 17:44:14.909 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx128m
10-Apr-2018 17:44:14.913 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseConcMarkSweepGC
10-Apr-2018 17:44:14.913 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.endorsed.dirs=/usr/share/tomcat8/endorsed
10-Apr-2018 17:44:14.913 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/var/lib/tomcat8
10-Apr-2018 17:44:14.914 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/share/tomcat8
10-Apr-2018 17:44:14.914 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/tmp/tomcat8-tomcat8-tmp
10-Apr-2018 17:44:15.078 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
10-Apr-2018 17:44:15.121 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
10-Apr-2018 17:44:15.132 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 845 ms
10-Apr-2018 17:44:15.172 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
10-Apr-2018 17:44:15.187 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.0.32 (Ubuntu)
10-Apr-2018 17:44:15.247 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive /var/lib/tomcat8/webapps/ODKAggregate.war
10-Apr-2018 17:44:17.867 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
10-Apr-2018 17:44:17.880 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/ODKAggregate] startup failed due to previous errors
10-Apr-2018 17:44:17.896 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc 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.
10-Apr-2018 17:44:17.899 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive /var/lib/tomcat8/webapps/ODKAggregate.war has finished in 2,651 ms
10-Apr-2018 17:44:17.906 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /var/lib/tomcat8/webapps/ROOT
10-Apr-2018 17:44:18.527 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /var/lib/tomcat8/webapps/ROOT has finished in 621 ms
10-Apr-2018 17:44:18.533 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
10-Apr-2018 17:44:18.550 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 3417 ms
10-Apr-2018 17:52:18.588 INFO [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig.undeploy Undeploying context [/ODKAggregate]
10-Apr-2018 17:52:18.608 SEVERE [localhost-startStop-2] org.apache.tomcat.util.digester.Digester.fatalError Parse Fatal Error at line 6 column 2: The markup in the document following the root element must be well-formed.
org.xml.sax.SAXParseException; systemId: file:///var/lib/tomcat8/webapps/ODKAggregate/META-INF/context.xml; lineNumber: 6; columnNumber: 2; The markup in the document following the root element must be well-formed.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:203)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:400)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1472)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$TrailingMiscDriver.next(XMLDocumentScannerImpl.java:1395)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:842)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:771)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:643)
at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1445)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:814)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1812)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
10-Apr-2018 17:52:18.609 SEVERE [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployWAR Error deploying configuration descriptor /var/lib/tomcat8/webapps/ODKAggregate.war
org.xml.sax.SAXParseException; systemId: file:///var/lib/tomcat8/webapps/ODKAggregate/META-INF/context.xml; lineNumber: 6; columnNumber: 2; The markup in the document following the root element must be well-formed.
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1239)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:643)
at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1445)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:814)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1812)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
10-Apr-2018 17:52:18.613 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive /var/lib/tomcat8/webapps/ODKAggregate.war
10-Apr-2018 17:52:18.626 SEVERE [localhost-startStop-2] org.apache.tomcat.util.digester.Digester.fatalError Parse Fatal Error at line 6 column 2: The markup in the document following the root element must be well-formed.
org.xml.sax.SAXParseException; systemId: file:/var/lib/tomcat8/webapps/ODKAggregate/META-INF/context.xml; lineNumber: 6; columnNumber: 2; The markup in the document following the root element must be well-formed.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:203)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:400)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1472)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$TrailingMiscDriver.next(XMLDocumentScannerImpl.java:1395)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:842)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:771)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:643)
at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1461)
at org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:541)
at org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:500)
at org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:740)
at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:316)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:95)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:394)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:110)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:136)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:939)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1812)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
10-Apr-2018 17:52:18.627 SEVERE [localhost-startStop-2] org.apache.catalina.startup.ContextConfig.processContextConfig Parse error in context.xml for /ODKAggregate
org.xml.sax.SAXParseException; systemId: file:/var/lib/tomcat8/webapps/ODKAggregate/META-INF/context.xml; lineNumber: 6; columnNumber: 2; The markup in the document following the root element must be well-formed.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:203)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:400)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1472)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$TrailingMiscDriver.next(XMLDocumentScannerImpl.java:1395)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:842)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:771)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
@rward3182 from your logs, it looks like you edited file:///var/lib/tomcat8/webapps/ODKAggregate/META-INF/context.xml and somehow the file was corrupted? Did you edit that file? If so, why? And can you post the contents (assuming there is nothing sensitive)?
Yaw
I solved this. I installed Tomcat 8 independently of the instructions and then put Aggregate on.
It's been a while since I last set up Tomcat and that was on Windows and MSSQL in 2003!
Thanks
Roger
1 Like