FAIL - Application at context path [/ODKAggregate]

Hi all,

I installed ODK Aggregate using the provided link https://github.com/getodk/aggregate/releases/tag/v2.0.5

I have tomcat v8.5 and mysql version v8 java version 8

I receive FAIL - Application at context path [/ODKAggregate] could not be started when I click on start in tomcat server. I am a beginner tried various ways such as copied the .war file of odkaggregate in tomcat folder of webapps and.jar file on mysql connector in lib of tomcat folder.

But I am getting this error FAIL - Application at context path [/ODKAggregate]

Please help! Urgent!

Please paste tomcat logs. Also confirm if you installed mysql-connector, and which version.

I have mysql-connector installed and it's version is mysql-connector-j-8.0.32

This is my tomcat/logs -> catalina.logs

15-Apr-2023 12:51:50.450 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/8.5.87
15-Apr-2023 12:51:50.454 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Feb 27 2023 19:32:33 UTC
15-Apr-2023 12:51:50.454 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 8.5.87.0
15-Apr-2023 12:51:50.454 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows 10
15-Apr-2023 12:51:50.455 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
15-Apr-2023 12:51:50.456 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
15-Apr-2023 12:51:50.456 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             C:\Program Files\Java\jdk-20
15-Apr-2023 12:51:50.456 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           20+36-2344
15-Apr-2023 12:51:50.456 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
15-Apr-2023 12:51:50.457 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80
15-Apr-2023 12:51:50.458 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80
15-Apr-2023 12:51:50.464 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80
15-Apr-2023 12:51:50.464 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80
15-Apr-2023 12:51:50.464 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\temp
15-Apr-2023 12:51:50.464 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
15-Apr-2023 12:51:50.464 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\conf\logging.properties
15-Apr-2023 12:51:50.464 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED
15-Apr-2023 12:51:50.464 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED
15-Apr-2023 12:51:50.465 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
15-Apr-2023 12:51:50.465 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit
15-Apr-2023 12:51:50.465 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort
15-Apr-2023 12:51:50.465 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms128m
15-Apr-2023 12:51:50.465 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx256m
15-Apr-2023 12:51:50.465 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\Java\jdk-20\bin;C:\Program Files\Common Files\Oracle\Java\javapath;C:\Program Files\Eclipse Adoptium\jdk-11.0.18.10-hotspot\bin;C:\Python310\Scripts\;C:\Python310\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Azure Data Studio\bin;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\php\v8.0;C:\ProgramData\ComposerSetup\bin;C:\Program Files\Git\cmd;C:\Program Files\nodejs\;C:\ProgramData\chocolatey\bin;C:\Windows\ServiceProfiles\LocalService\AppData\Local\Microsoft\WindowsApps;.]
15-Apr-2023 12:51:50.532 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
15-Apr-2023 12:51:50.597 SEVERE [main] org.apache.catalina.core.StandardService.initInternal Failed to initialize connector [Connector[HTTP/1.1-8080]]
	org.apache.catalina.LifecycleException: Protocol handler initialization failed
		at org.apache.catalina.connector.Connector.initInternal(Connector.java:1075)
		at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
		at org.apache.catalina.core.StandardService.initInternal(StandardService.java:559)
		at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
		at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:857)
		at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
		at org.apache.catalina.startup.Catalina.load(Catalina.java:646)
		at org.apache.catalina.startup.Catalina.load(Catalina.java:669)
		at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
		at java.base/java.lang.reflect.Method.invoke(Method.java:578)
		at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:307)
		at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:477)
	Caused by: java.net.BindException: Address already in use: bind
		at java.base/sun.nio.ch.Net.bind0(Native Method)
		at java.base/sun.nio.ch.Net.bind(Net.java:556)
		at java.base/sun.nio.ch.ServerSocketChannelImpl.netBind(ServerSocketChannelImpl.java:344)
		at java.base/sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:301)
		at java.base/sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:89)
		at org.apache.tomcat.util.net.NioEndpoint.initServerSocket(NioEndpoint.java:226)
		at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:202)
		at org.apache.tomcat.util.net.AbstractEndpoint.bindWithCleanup(AbstractEndpoint.java:1296)
		at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:1309)
		at org.apache.tomcat.util.net.AbstractJsseEndpoint.init(AbstractJsseEndpoint.java:231)
		at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:693)
		at org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:76)
		at org.apache.catalina.connector.Connector.initInternal(Connector.java:1073)
		... 11 more
15-Apr-2023 12:51:50.597 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1394 ms
15-Apr-2023 12:51:50.675 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
15-Apr-2023 12:51:50.675 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/8.5.87]
15-Apr-2023 12:51:50.699 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\docs]
15-Apr-2023 12:51:51.258 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\docs] has finished in [558] ms
15-Apr-2023 12:51:51.258 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\examples]
15-Apr-2023 12:51:52.504 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\examples] has finished in [1,246] ms
15-Apr-2023 12:51:52.504 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\host-manager]
15-Apr-2023 12:51:52.556 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\host-manager] has finished in [52] ms
15-Apr-2023 12:51:52.557 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\manager]
15-Apr-2023 12:51:52.611 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\manager] has finished in [54] ms
15-Apr-2023 12:51:52.611 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\ROOT]
15-Apr-2023 12:51:52.641 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\ROOT] has finished in [30] ms
15-Apr-2023 12:51:52.643 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 2043 ms
15-Apr-2023 13:51:06.868 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\ODKAggregate.war]
15-Apr-2023 13:51:34.389 SEVERE [localhost-startStop-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
15-Apr-2023 13:51:34.390 SEVERE [localhost-startStop-2] org.apache.catalina.core.StandardContext.startInternal Context [/ODKAggregate] startup failed due to previous errors
15-Apr-2023 13:51:34.412 WARNING [localhost-startStop-2] 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.
15-Apr-2023 13:51:34.489 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Program Files\Apache Software Foundation\Tomcat 8.5_Tomcat80\webapps\ODKAggregate.war] has finished in [27,621] ms

Hi @Iman, welcome to the ODK forum! We're glad you're here. When you get a chance, please introduce yourself on this forum thread. I'd also encourage you to add a picture as your avatar because it helps build community!

Is there a reason you are installing Aggregate and not Central? Please note that Aggregate is no longer being supported. Central is now the ODK server. We strongly recommend using Central becauseAggregate has not been patched for security, reliability, and other issues since May 2021 when it reached end-of-life. The post below has more details.

Seemingly this is the issue.

Are your ports 80, 8080, 443 confirmed open, and firewall is disabled?

Thank you for your response.
Yes, my firewall is disabled and all my ports are opened. I used netstat -a -n -o | find " " command to check for my ports.
Any help would be highly appreciated.
Awaiting your response.

Awaiting your response.

I am still unable to configure it out.

Hi,

Sorry, I cannot judge any more issues from the logs.

If its a new installation, I would strongly recommend to use ODK Central. Aggregate has been old and you may not find help for it.

The last time I setup ODK Aggregate, I used following versions of various tools:

  • ODK Aggregate v2.0.5
  • Java version 1.8.0
  • Tomcat version 8
  • MySQL connector mysql-connector-java-8.0.17

Try this combination if it works for you.

1 Like

Guys solved!

I was getting one or more listener failed to start error in my logs. ( Because of latest sql connector file i was using )

  • Tomcat 9
  • Aggregate 2.0.5
  • MySQL 5.7.33
  • Connector file : mysql-connector-java-5.1.46-bin and mysql-connector-java-8.0.23 ( I have both of these files in my lib folder of tomcat )
  • JRE: jre-8u211-windows-x64_offline ( during the tomcat installation I gave this jre path )

and it worked!