root@sync-endpoint-sandbox:~# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES ca925daaa4fe odk/sync-endpoint:latest "/tmp/init.sh /usr/l…" 19 minutes ago Up 19 minutes syncldap_sync.1.t464ozurjqv933jkqrydz9h3u a1b9f7f40083 postgres:9.6 "docker-entrypoint.s…" 19 minutes ago Up 19 minutes syncldap_db.1.nwnu4mxukrc2s14wi1v1ace5n f719f146fca9 odk/phpldapadmin:latest "/container/tool/run" 19 minutes ago Up 19 minutes 80/tcp, 443/tcp syncldap_phpldapadmin.1.yfwrfwmenlxev7pcc63rughl0 26dc334d17c1 odk/openldap:latest "/container/tool/run" 19 minutes ago Up 19 minutes syncldap_ldap-service.1.xgyqfht39m02aca0o53gj38j0 root@sync-endpoint-sandbox:~# docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 51f1350d07af nginx:mainline "nginx -g 'daemon of…" Less than a second ago Created syncldap_nginx.1.1172aletldl2x36t30wt6ehsp a9d4dae11f33 nginx:mainline "nginx -g 'daemon of…" 8 seconds ago Exited (1) 1 second ago syncldap_nginx.1.0bvf3op65nh706sfb7xrsvsk9 69a268651dad nginx:mainline "nginx -g 'daemon of…" 16 seconds ago Exited (1) 9 seconds ago syncldap_nginx.1.qfcaeexlm8dt6w6l5dqva42cj b8898f5e460e nginx:mainline "nginx -g 'daemon of…" 23 seconds ago Exited (1) 17 seconds ago syncldap_nginx.1.nf3ixvaq6ve85bfnjyucvs6tc d36ba7f2c278 nginx:mainline "nginx -g 'daemon of…" 30 seconds ago Exited (1) 24 seconds ago syncldap_nginx.1.ot4mzpymdg18xn8jzr3r91o9t cafe7aff5094 nginx:mainline "nginx -g 'daemon of…" 38 seconds ago Exited (1) 31 seconds ago syncldap_nginx.1.pqo4djb9yppch2apx2mrjzygq ca925daaa4fe odk/sync-endpoint:latest "/tmp/init.sh /usr/l…" 19 minutes ago Up 19 minutes syncldap_sync.1.t464ozurjqv933jkqrydz9h3u 0e719ed9793b odk/db-bootstrap:latest "./bootstrap.sh" 19 minutes ago Exited (0) 19 minutes ago syncldap_db-bootstrap.1.nozj4rd116880cgz94ptipolk a1b9f7f40083 postgres:9.6 "docker-entrypoint.s…" 19 minutes ago Up 19 minutes syncldap_db.1.nwnu4mxukrc2s14wi1v1ace5n f719f146fca9 odk/phpldapadmin:latest "/container/tool/run" 19 minutes ago Up 19 minutes 80/tcp, 443/tcp syncldap_phpldapadmin.1.yfwrfwmenlxev7pcc63rughl0 26dc334d17c1 odk/openldap:latest "/container/tool/run" 19 minutes ago Up 19 minutes syncldap_ldap-service.1.xgyqfht39m02aca0o53gj38j0 8be61d0ca039 b2074e8a209b "/bin/sh -c 'cd /web…" 20 minutes ago Exited (1) 20 minutes ago zen_carson root@sync-endpoint-sandbox:~# docker stack ls NAME SERVICES ORCHESTRATOR syncldap 7 Swarm root@sync-endpoint-sandbox:~# docker service ls ID NAME MODE REPLICAS IMAGE PORTS 07ed3im8r0pq syncldap_db replicated 1/1 postgres:9.6 vqzi3xvsy20k syncldap_db-bootstrap replicated 0/1 odk/db-bootstrap:latest ug16kwv5x3v8 syncldap_ldap-service replicated 1/1 odk/openldap:latest gp6ko5wgbpr9 syncldap_nginx replicated 0/1 nginx:mainline *:80->80/tcp, *:443->443/tcp 3emc0g2eyb3w syncldap_phpldapadmin replicated 1/1 odk/phpldapadmin:latest *:40000->443/tcp kza7f106z00y syncldap_sync replicated 1/1 odk/sync-endpoint:latest k10wn5boy3pz syncldap_web-ui replicated 0/1 odk/sync-web-ui:latest root@sync-endpoint-sandbox:~# docker logs ca925daaa4fe 20-Jan-2020 02:20:07.388 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/8.5.50 20-Jan-2020 02:20:07.392 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Dec 7 2019 19:19:46 UTC 20-Jan-2020 02:20:07.393 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 8.5.50.0 20-Jan-2020 02:20:07.393 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux 20-Jan-2020 02:20:07.394 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 4.15.0-74-generic 20-Jan-2020 02:20:07.394 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64 20-Jan-2020 02:20:07.395 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/local/openjdk-8/jre 20-Jan-2020 02:20:07.395 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_232-b09 20-Jan-2020 02:20:07.396 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation 20-Jan-2020 02:20:07.396 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /usr/local/tomcat 20-Jan-2020 02:20:07.396 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /usr/local/tomcat 20-Jan-2020 02:20:07.397 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat/conf/logging.properties 20-Jan-2020 02:20:07.397 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 20-Jan-2020 02:20:07.398 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 20-Jan-2020 02:20:07.398 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 20-Jan-2020 02:20:07.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 20-Jan-2020 02:20:07.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs= 20-Jan-2020 02:20:07.400 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat 20-Jan-2020 02:20:07.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat 20-Jan-2020 02:20:07.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat/temp 20-Jan-2020 02:20:07.402 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.23] using APR version [1.5.2]. 20-Jan-2020 02:20:07.402 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true]. 20-Jan-2020 02:20:07.407 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] 20-Jan-2020 02:20:07.413 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.0l 10 Sep 2019] 20-Jan-2020 02:20:07.538 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"] 20-Jan-2020 02:20:07.557 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 20-Jan-2020 02:20:07.581 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["https-openssl-nio-8443"] 20-Jan-2020 02:20:07.665 SEVERE [main] org.apache.catalina.core.StandardService.initInternal Failed to initialize connector [Connector[HTTP/1.1-8443]] org.apache.catalina.LifecycleException: Protocol handler initialization failed at org.apache.catalina.connector.Connector.initInternal(Connector.java:995) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136) at org.apache.catalina.core.StandardService.initInternal(StandardService.java:552) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136) at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:848) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136) at org.apache.catalina.startup.Catalina.load(Catalina.java:639) at org.apache.catalina.startup.Catalina.load(Catalina.java:662) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:303) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473) Caused by: java.lang.IllegalArgumentException: /run/secrets/odksync-tomcat.keystore (No such file or directory) at org.apache.tomcat.util.net.AbstractJsseEndpoint.createSSLContext(AbstractJsseEndpoint.java:100) at org.apache.tomcat.util.net.AbstractJsseEndpoint.initialiseSsl(AbstractJsseEndpoint.java:72) at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:246) at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:1118) at org.apache.tomcat.util.net.AbstractJsseEndpoint.init(AbstractJsseEndpoint.java:223) at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:581) at org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:70) at org.apache.catalina.connector.Connector.initInternal(Connector.java:993) ... 13 more Caused by: java.io.FileNotFoundException: /run/secrets/odksync-tomcat.keystore (No such file or directory) at java.io.FileInputStream.open0(Native Method) at java.io.FileInputStream.open(FileInputStream.java:195) at java.io.FileInputStream.(FileInputStream.java:138) at java.io.FileInputStream.(FileInputStream.java:93) at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:90) at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:188) at org.apache.tomcat.util.file.ConfigFileLoader.getInputStream(ConfigFileLoader.java:89) at org.apache.tomcat.util.net.SSLUtilBase.getStore(SSLUtilBase.java:197) at org.apache.tomcat.util.net.SSLHostConfigCertificate.getCertificateKeystore(SSLHostConfigCertificate.java:206) at org.apache.tomcat.util.net.SSLUtilBase.getKeyManagers(SSLUtilBase.java:282) at org.apache.tomcat.util.net.openssl.OpenSSLUtil.getKeyManagers(OpenSSLUtil.java:98) at org.apache.tomcat.util.net.SSLUtilBase.createSSLContext(SSLUtilBase.java:246) at org.apache.tomcat.util.net.AbstractJsseEndpoint.createSSLContext(AbstractJsseEndpoint.java:98) ... 20 more 20-Jan-2020 02:20:07.671 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"] 20-Jan-2020 02:20:07.677 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 20-Jan-2020 02:20:07.680 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 958 ms 20-Jan-2020 02:20:07.721 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] 20-Jan-2020 02:20:07.722 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.50 20-Jan-2020 02:20:07.734 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/webapps/ROOT] 20-Jan-2020 02:20:09.434 INFO [localhost-startStop-1] org.springframework.web.context.ContextLoader.initWebApplicationContext Root WebApplicationContext: initialization started 20-Jan-2020 02:20:09.562 INFO [localhost-startStop-1] org.springframework.web.context.support.XmlWebApplicationContext.prepareRefresh Refreshing Root WebApplicationContext: startup date [Mon Jan 20 02:20:09 UTC 2020]; root of context hierarchy 20-Jan-2020 02:20:09.639 INFO [localhost-startStop-1] org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions Loading XML bean definitions from ServletContext resource [/odk-settings.xml] 20-Jan-2020 02:20:09.846 INFO [localhost-startStop-1] org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.doRegisterBeanDefinitions Skipped XML bean definition file due to specified profiles [mysql] not matching: ServletContext resource [/odk-settings.xml] 20-Jan-2020 02:20:09.852 INFO [localhost-startStop-1] org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions Loading XML bean definitions from ServletContext resource [/odk-postgres-settings.xml] 20-Jan-2020 02:20:10.002 INFO [localhost-startStop-1] org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.doRegisterBeanDefinitions Skipped XML bean definition file due to specified profiles [sqlserver] not matching: ServletContext resource [/odk-settings.xml] 20-Jan-2020 02:20:10.004 INFO [localhost-startStop-1] org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext-security.xml] 20-Jan-2020 02:20:10.173 INFO [localhost-startStop-1] org.springframework.security.core.SpringSecurityCoreVersion.performVersionChecks You are running with Spring Security Core 4.2.13.RELEASE 20-Jan-2020 02:20:10.184 INFO [localhost-startStop-1] org.springframework.security.config.SecurityNamespaceHandler. Spring Security 'config' module version is 4.2.13.RELEASE 20-Jan-2020 02:20:10.248 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_USER') or hasRole('ROLE_SITE_ACCESS_ADMIN')' for /Aggregate.html 20-Jan-2020 02:20:10.248 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /images/** 20-Jan-2020 02:20:10.249 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /javascript/** 20-Jan-2020 02:20:10.249 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /res/** 20-Jan-2020 02:20:10.250 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /stylesheets/** 20-Jan-2020 02:20:10.250 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /access-denied.html 20-Jan-2020 02:20:10.250 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /over-quota.html 20-Jan-2020 02:20:10.251 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /robots.txt 20-Jan-2020 02:20:10.251 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /service-error.html 20-Jan-2020 02:20:10.252 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /AggregateUI.css 20-Jan-2020 02:20:10.252 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /favicon.ico 20-Jan-2020 02:20:10.252 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /index.html 20-Jan-2020 02:20:10.252 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /logout.html 20-Jan-2020 02:20:10.253 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /odk_color.png 20-Jan-2020 02:20:10.253 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /multimode_login.html 20-Jan-2020 02:20:10.253 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /relogin.html 20-Jan-2020 02:20:10.254 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'isFullyAuthenticated() and (hasAuthority('AUTH_LOCAL') or hasAuthority('AUTH_ACTIVE_DIRECTORY') or hasAuthority('AUTH_LDAP'))' for /local_login.html 20-Jan-2020 02:20:10.254 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /formList 20-Jan-2020 02:20:10.255 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /formXml 20-Jan-2020 02:20:10.255 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_OWNER')' for /submission 20-Jan-2020 02:20:10.255 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /formUpload 20-Jan-2020 02:20:10.256 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /upload 20-Jan-2020 02:20:10.256 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /xformsDownload 20-Jan-2020 02:20:10.256 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /xformsList 20-Jan-2020 02:20:10.257 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /xformsManifest 20-Jan-2020 02:20:10.257 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_USER')' for /www/** 20-Jan-2020 02:20:10.258 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_VIEWER') or hasRole('ROLE_ATTACHMENT_VIEWER')' for /view/binaryData 20-Jan-2020 02:20:10.258 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_VIEWER')' for /view/** 20-Jan-2020 02:20:10.258 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /auth/** 20-Jan-2020 02:20:10.259 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SITE_ACCESS_ADMIN')' for /ssl/** 20-Jan-2020 02:20:10.259 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER') or hasRole('ROLE_SITE_ACCESS_ADMIN')' for /enk/** 20-Jan-2020 02:20:10.259 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /gae/** 20-Jan-2020 02:20:10.260 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'true' for /remote_api 20-Jan-2020 02:20:10.260 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/manifest/** 20-Jan-2020 02:20:10.260 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/files/** 20-Jan-2020 02:20:10.261 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/* 20-Jan-2020 02:20:10.261 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/properties/* 20-Jan-2020 02:20:10.261 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/* 20-Jan-2020 02:20:10.262 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/clientVersions 20-Jan-2020 02:20:10.262 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'isFullyAuthenticated() and hasRole('ROLE_USER')' for /odktables/*/privilegesInfo 20-Jan-2020 02:20:10.262 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'isFullyAuthenticated() and hasRole('ROLE_USER')' for /odktables/*/usersInfo 20-Jan-2020 02:20:10.263 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables 20-Jan-2020 02:20:10.263 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/installationInfo 20-Jan-2020 02:20:10.264 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/diff/** 20-Jan-2020 02:20:10.264 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/diff 20-Jan-2020 02:20:10.264 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/query/** 20-Jan-2020 02:20:10.264 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/manifest 20-Jan-2020 02:20:10.264 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/download 20-Jan-2020 02:20:10.265 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/upload 20-Jan-2020 02:20:10.265 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/file/** 20-Jan-2020 02:20:10.265 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/rows/** 20-Jan-2020 02:20:10.265 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/rows 20-Jan-2020 02:20:10.265 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/installationStatus 20-Jan-2020 02:20:10.266 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_ADMINISTER_TABLES')' for /odktables/*/** 20-Jan-2020 02:20:10.273 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_USER')' for /odktables/ 20-Jan-2020 02:20:10.274 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_USER')' for /odktables 20-Jan-2020 02:20:10.276 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /appLevelFileUpload/** 20-Jan-2020 02:20:10.277 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /tableFileUpload/** 20-Jan-2020 02:20:10.277 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /tableFileDownload/** 20-Jan-2020 02:20:10.277 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /tableKeyValueManifest/** 20-Jan-2020 02:20:10.278 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'hasRole('ROLE_ADMINISTER_TABLES')' for /uploadTableFromCSV/** 20-Jan-2020 02:20:10.280 INFO [localhost-startStop-1] org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser.parseInterceptUrlsForFilterInvocationRequestMap Creating access control expression attribute 'isAnonymous()' for /** 20-Jan-2020 02:20:10.561 INFO [localhost-startStop-1] org.springframework.beans.factory.config.PropertyPlaceholderConfigurer.loadProperties Properties resource not found: /run/secrets/org.opendatakit.aggregate.logging.properties (No such file or directory) 20-Jan-2020 02:20:10.745 INFO [localhost-startStop-1] org.opendatakit.common.security.Realm.afterPropertiesSet Version: v1.4.14 Production 20-Jan-2020 02:20:10.746 INFO [localhost-startStop-1] org.opendatakit.common.security.Realm.afterPropertiesSet Hostname: null 20-Jan-2020 02:20:10.746 INFO [localhost-startStop-1] org.opendatakit.common.security.Realm.afterPropertiesSet Port: 20-Jan-2020 02:20:10.746 INFO [localhost-startStop-1] org.opendatakit.common.security.Realm.afterPropertiesSet SecurePort: 20-Jan-2020 02:20:10.747 INFO [localhost-startStop-1] org.opendatakit.common.security.Realm.afterPropertiesSet SslIsRequired: no 20-Jan-2020 02:20:10.747 INFO [localhost-startStop-1] org.opendatakit.common.security.Realm.afterPropertiesSet SslIsAvailable: no 20-Jan-2020 02:20:10.747 INFO [localhost-startStop-1] org.opendatakit.common.security.Realm.afterPropertiesSet RealmString: opendatakit.org ODK Sync Endpoint 20-Jan-2020 02:20:10.748 INFO [localhost-startStop-1] org.opendatakit.common.security.Realm.afterPropertiesSet isGaeEnvironment: no 20-Jan-2020 02:20:10.748 INFO [localhost-startStop-1] org.opendatakit.common.security.Realm.afterPropertiesSet java.library.path: /usr/local/tomcat/native-jni-lib:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib 20-Jan-2020 02:20:10.804 INFO [localhost-startStop-1] org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler.initialize Initializing ExecutorService 'task_scheduler' Inside setServletContextafterPropertiesSet WATCHDOG TASK IN TOMCAT 20-Jan-2020 02:20:11.197 WARNING [localhost-startStop-1] org.springframework.web.context.support.XmlWebApplicationContext.refresh Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sitePreferencesBean' defined in ServletContext resource [/odk-settings.xml]: Invocation of init method failed; nested exception is org.opendatakit.common.persistence.exception.ODKEntityNotFoundException: org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "odk") 20-Jan-2020 02:20:11.198 INFO [localhost-startStop-1] org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler.shutdown Shutting down ExecutorService 'task_scheduler' 20-Jan-2020 02:20:11.203 SEVERE [localhost-startStop-1] org.springframework.web.context.ContextLoader.initWebApplicationContext Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sitePreferencesBean' defined in ServletContext resource [/odk-settings.xml]: Invocation of init method failed; nested exception is org.opendatakit.common.persistence.exception.ODKEntityNotFoundException: org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "odk") at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1630) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:756) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) 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:4699) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1125) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1859) 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) Caused by: org.opendatakit.common.persistence.exception.ODKEntityNotFoundException: org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "odk") at org.opendatakit.aggregate.server.ServerPreferencesProperties.setServerPreferencesProperty(ServerPreferencesProperties.java:413) at org.opendatakit.aggregate.server.ServerPreferencesProperties.setOdkTablesEnabled(ServerPreferencesProperties.java:197) at org.opendatakit.aggregate.server.SitePreferencesBean.afterPropertiesSet(SitePreferencesBean.java:162) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1688) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1626) ... 25 more Caused by: org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "odk") at org.opendatakit.common.persistence.engine.pgres.DatastoreImpl.assertRelation(DatastoreImpl.java:650) at org.opendatakit.aggregate.server.ServerPreferencesProperties.assertRelation(ServerPreferencesProperties.java:345) at org.opendatakit.aggregate.server.ServerPreferencesProperties.setServerPreferencesProperty(ServerPreferencesProperties.java:380) ... 29 more Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "odk") at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:289) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:377) at org.opendatakit.common.persistence.engine.pgres.DatastoreImpl.assertRelation(DatastoreImpl.java:506) ... 31 more Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "odk") at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:735) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:605) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:809) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:246) ... 33 more Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "odk" at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:520) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.(PgConnection.java:195) at org.postgresql.Driver.makeConnection(Driver.java:458) at org.postgresql.Driver.connect(Driver.java:260) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:116) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:731) ... 36 more 20-Jan-2020 02:20:11.210 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 20-Jan-2020 02:20:11.223 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [] startup failed due to previous errors 20-Jan-2020 02:20:11.252 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ROOT] 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. 20-Jan-2020 02:20:11.266 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/webapps/ROOT] has finished in [3,531] ms 20-Jan-2020 02:20:11.276 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"] 20-Jan-2020 02:20:11.303 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"] 20-Jan-2020 02:20:11.308 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 3627 ms root@sync-endpoint-sandbox:~#