App "odk" couldn't submitted the surveys to Aggregate server

1. What is the problem? Be very detailed.
We were not able to submit the surveys from mobile App "odk" to Aggregate server . We got a message saying “trust anchor for certification path not found.” Any idea what’s wrong?

2. What app or server are you using and on what device and operating system? Include version numbers.
App: odk on Android.
Server: ODK Aggregate Server (version 2.05) on Linux (CentOs 7)

3. What you have you tried to fix the problem?
Tried different accounts, but all failed.

4. What steps can we take to reproduce the problem?

5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.
Here are some log from tomcat catalina log:

52.42.15.67 - - [24/Jan/2021:13:23:19 -0800] "GET null HTTP/1.1" 400 2087
64.39.108.58 - - [24/Jan/2021:13:23:19 -0800] "GET null HTTP/1.1" 400 2351
64.39.108.58 - - [24/Jan/2021:13:23:27 -0800] "GET null HTTP/1.1" 400 2347
64.39.108.58 - - [24/Jan/2021:13:23:30 -0800] "GET null HTTP/1.1" 400 2363
64.39.108.58 - - [24/Jan/2021:13:23:38 -0800] "GET null HTTP/1.1" 400 2345
64.39.108.58 - - [24/Jan/2021:13:23:40 -0800] "GET null HTTP/1.1" 400 2361
64.39.108.58 - - [24/Jan/2021:13:23:48 -0800] "GET null HTTP/1.1" 400 2353
64.39.108.58 - - [24/Jan/2021:13:23:50 -0800] "GET null HTTP/1.1" 400 2365
64.39.108.58 - - [24/Jan/2021:13:23:59 -0800] "GET null HTTP/1.1" 400 2351
64.39.108.58 - - [24/Jan/2021:13:24:09 -0800] "GET null HTTP/1.1" 400 2351
64.39.108.58 - - [24/Jan/2021:13:24:20 -0800] "GET null HTTP/1.1" 400 2349
64.39.108.58 - - [24/Jan/2021:13:24:30 -0800] "GET /QUALYS13813 HTTP/1.0" 404 762
64.39.108.58 - - [24/Jan/2021:13:24:31 -0800] "GET /userportal/webpages/myaccount/login.jsp HTTP/1.0" 404 781
64.39.108.58 - - [24/Jan/2021:13:24:31 -0800] "GET /login HTTP/1.0" 404 756
64.39.108.58 - - [24/Jan/2021:13:24:32 -0800] "GET /login HTTP/1.0" 404 756
64.39.108.58 - - [24/Jan/2021:13:24:33 -0800] "GET /system/login HTTP/1.0" 404 767
64.39.108.58 - - [24/Jan/2021:13:24:33 -0800] "GET /redfish/v1 HTTP/1.0" 404 765
64.39.108.58 - - [24/Jan/2021:13:24:34 -0800] "GET /webtools/control/xmlrpc HTTP/1.0" 404 782
64.39.108.58 - - [24/Jan/2021:13:24:34 -0800] "GET /gms/rest/debugFiles/ HTTP/1.0" 404 783
64.39.108.58 - - [24/Jan/2021:13:24:35 -0800] "GET /conf HTTP/1.0" 404 755
64.39.108.58 - - [24/Jan/2021:13:24:35 -0800] "GET /jmx?qry=Hadoop:* HTTP/1.0" 404 754
64.39.108.58 - - [24/Jan/2021:13:24:36 -0800] "GET /node HTTP/1.0" 404 755
64.39.108.58 - - [24/Jan/2021:13:24:37 -0800] "GET /cluster HTTP/1.0" 404 758
64.39.108.58 - - [24/Jan/2021:13:24:37 -0800] "GET /epa/epa.html HTTP/1.0" 404 767
64.39.108.58 - - [24/Jan/2021:13:24:38 -0800] "POST /run HTTP/1.0" 404 754
64.39.108.58 - - [24/Jan/2021:13:24:48 -0800] "GET /dp/login.xml HTTP/1.0" 404 767
64.39.108.58 - - [24/Jan/2021:13:24:49 -0800] "GET /login HTTP/1.0" 404 756
64.39.108.58 - - [24/Jan/2021:13:24:49 -0800] "POST /console/images/%252e%252e%252fconsole.portal HTTP/1.0" 404 803
64.39.108.58 - - [24/Jan/2021:13:24:50 -0800] "GET null HTTP/1.1" 400 2425
64.39.108.58 - - [24/Jan/2021:13:25:01 -0800] "GET null HTTP/1.1" 400 2427
64.39.108.58 - - [24/Jan/2021:13:25:11 -0800] "POST /console/css/%252e%252e%252fconsole.portal HTTP/1.0" 404 800
64.39.108.58 - - [24/Jan/2021:13:25:12 -0800] "GET null HTTP/1.1" 400 2419
64.39.108.58 - - [24/Jan/2021:13:25:22 -0800] "GET null HTTP/1.1" 400 2421
64.39.108.58 - - [24/Jan/2021:13:25:33 -0800] "POST /console/bea-helpsets/%252e%252e%252fconsole.portal HTTP/1.0" 404 809
64.39.108.58 - - [24/Jan/2021:13:25:33 -0800] "GET null HTTP/1.1" 400 2437
64.39.108.58 - - [24/Jan/2021:13:25:44 -0800] "GET null HTTP/1.1" 400 2439
64.39.108.58 - - [24/Jan/2021:13:25:54 -0800] "POST /console/framework/skins/wlsconsole/images/%252e%252e%252fconsole.portal HTTP/1.0" 404 842
64.39.108.58 - - [24/Jan/2021:13:25:55 -0800] "GET null HTTP/1.1" 400 2503
64.39.108.58 - - [24/Jan/2021:13:26:05 -0800] "GET null HTTP/1.1" 400 2505
64.39.108.58 - - [24/Jan/2021:13:26:15 -0800] "POST /console/framework/skins/wlsconsole/css/%252e%252e%252fconsole.portal HTTP/1.0" 404 839
64.39.108.58 - - [24/Jan/2021:13:26:16 -0800] "GET null HTTP/1.1" 400 2497
64.39.108.58 - - [24/Jan/2021:13:26:26 -0800] "GET null HTTP/1.1" 400 2499
64.39.108.58 - - [24/Jan/2021:13:26:36 -0800] "POST /framework/skeletons/wlsconsole/js/%252e%252e%252fconsole.portal HTTP/1.0" 404 830
64.39.108.58 - - [24/Jan/2021:13:26:37 -0800] "GET null HTTP/1.1" 400 2503
64.39.108.58 - - [24/Jan/2021:13:26:47 -0800] "GET null HTTP/1.1" 400 2505
209.141.60.195 - - [24/Jan/2021:13:27:51 -0800] "-" 400 -
5.154.9.150 - - [24/Jan/2021:13:36:23 -0800] "GET / HTTP/1.1" 302 -
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET / HTTP/1.1" 200 1273
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /AggregateUI.css HTTP/1.1" 200 4292
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /stylesheets/button.css HTTP/1.1" 200 3475
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /stylesheets/table.css HTTP/1.1" 200 787
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /stylesheets/navigation.css HTTP/1.1" 200 2142
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /odk_color.png HTTP/1.1" 200 8424
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /Aggregate.html HTTP/1.1" 200 1861
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /javascript/resize.js HTTP/1.1" 200 6489
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /javascript/main.js HTTP/1.1" 200 355
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /aggregateui/aggregateui.nocache.js HTTP/1.1" 200 7555
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /javascript/jquery-1.11.1.min.js HTTP/1.1" 200 95786
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /AggregateUI.css HTTP/1.1" 200 4292
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /stylesheets/button.css HTTP/1.1" 200 3475
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /stylesheets/table.css HTTP/1.1" 200 787
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /stylesheets/navigation.css HTTP/1.1" 200 2142
54.70.53.60 - - [24/Jan/2021:13:45:08 -0800] "GET /aggregateui/AEDF6C1A4BD201AC07895962ED7EC737.cache.js HTTP/1.1" 200 481605
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "GET /aggregateui/clear.cache.gif HTTP/1.1" 200 43
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "POST /aggregateui/securityservice HTTP/1.1" 200 119
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "GET /images/help_icon_off.png HTTP/1.1" 200 672
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "GET /images/help_icon_on.png HTTP/1.1" 200 961
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "GET /images/help_book_icon.png HTTP/1.1" 200 1593
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "GET /images/help_dialog_on.jpg HTTP/1.1" 200 1396
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "GET /images/odk_color.png HTTP/1.1" 200 5011
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "GET /images/help_dialog_off.jpg HTTP/1.1" 200 1863
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "POST /aggregateui/securityservice HTTP/1.1" 200 226
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "POST /aggregateui/securityservice HTTP/1.1" 200 166
54.70.53.60 - - [24/Jan/2021:13:45:09 -0800] "GET /aggregateui/clear.cache.gif HTTP/1.1" 200 43
54.70.53.60 - - [24/Jan/2021:13:47:16 -0800] "POST /aggregateui/preferenceservice HTTP/1.1" 200 45
54.70.53.60 - - [24/Jan/2021:13:49:24 -0800] "POST /aggregateui/preferenceservice HTTP/1.1" 200 45
54.70.53.60 - - [24/Jan/2021:13:51:31 -0800] "POST /aggregateui/preferenceservice HTTP/1.1" 200 45
54.70.53.60 - - [24/Jan/2021:13:53:38 -0800] "POST /aggregateui/preferenceservice HTTP/1.1" 200 45
54.70.53.60 - - [24/Jan/2021:13:55:45 -0800] "POST /aggregateui/preferenceservice HTTP/1.1" 200 45
54.70.53.60 - - [24/Jan/2021:13:57:53 -0800] "POST /aggregateui/preferenceservice HTTP/1.1" 200 45
189.91.226.131 - - [24/Jan/2021:14:47:36 -0800] "GET / HTTP/1.1" 302 -
194.208.107.161 - - [24/Jan/2021:15:01:50 -0800] "GET / HTTP/1.1" 302 -

Please note that Aggregate is no longer being updated. We recommend use you Central instead.

The error message suggests that you either don't have SSL setup properly or you are using a self-signed cert. Put your server URL at https://www.sslshopper.com/ssl-checker.html and see what it reports.

Hi Yanokwa, thanks for the help !
I checked the SSL, it's all valid, also our SSL is not self-signed cert.

What version of Android are you using? If it's old, it's possible that the operating system doesn't your server's root certificate.

Our Android version is 4.4.2. Thanks !

Android 4.4.2 is 7+ years old and likely doesn't support your root cert. What happens if you use a modern device?

Thanks Yanokwa! That's very helpful. Could you share me the document showing that information? Our current server is Aggregate server.

Your best bet for a resolution is to talk to the person/organization who provided you the SSL cert, tell them what Android device you are using, and ask what they suggest. Perhaps they can provide a cert that works with the older device.

Now I got this error message when I submitted the survey from ODK Collect from Android tablet:
"Test Survey_2021-03-23-Error: Generic Exception: java.lang.Exception" .

Any idea typically what kind of issues might cause the error ?

I appreciate your prompt reply,

Does this problem happen on other Android devices? Especially those running on the latest version of Collect (currently v1.30.1)?

Also, read your Aggregate logs. Do they offer any hints?

Hi Yaw,

I noticed this on our odk website (via tomcat on Linux):
The website showed up, but at the lower left corner of the browser, it mentioned:
"v2.0.5 - Version check failed"

Any idea why ?

Thanks

On Tomcat server, I met the errors below when I tried to submit the filled form from tablet :

104.129.199.8 - - [30/Mar/2021:16:57:37 -0700] "HEAD /submission?deviceID=mac%3A00%3AE3%3AB2%3AE3%3A3B%3ACC HTTP/1.1" 204 -
104.129.199.8 - - [30/Mar/2021:16:57:37 -0700] "POST /submission?deviceID=mac%3A00%3AE3%3AB2%3AE3%3A3B%3ACC HTTP/1.1" 302 -
104.129.199.8 - - [30/Mar/2021:16:57:37 -0700] "GET /submission?deviceID=mac%3A00%3AE3%3AB2%3AE3%3A3B%3ACC HTTP/1.1" 204 -

I appreciate for any expert opinion .

I'm not sure why the version check failed. It's checks for updates through Github, so maybe that is being blocked.

Regardless. Aggregate is no longer being updated, so we are limited in the support we can provide. At this stage, you might want to switch Central and make sure you are using the latest version of Collect (currently v1.30.1).

Hi Yam,

Thanks for the reply !
Is ODK Central able to be installed on "on-premises" server like our own Linux server? Or it must be installed on cloud ?

I appreciate your reply,

If your on-premise server is connected to the internet and you have a global IP for the machine, it should be possible to follow the instructions in the documentation. If you're working on a purely internal network, you may run into some challenges getting the SSL set up. See this thread for a related discussion:

1 Like