Linux / Centos - no web interface - just spinning circle

new install, everything appeared to install correctly...
as per subject, I don't get past the spinning circle with the web interface.

Here are the logs

tracker-server.log

2018-05-15 13:29:59  INFO: Operating system name: Linux version: 3.10.0-693.21.1.el7.x86_64 architecture: amd64
2018-05-15 13:29:59  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 24.181-b00
2018-05-15 13:29:59  INFO: Memory limit heap: 7123mb non-heap: 214mb
2018-05-15 13:29:59  INFO: Character encoding: UTF-8 charset: UTF-8
2018-05-15 13:29:59  INFO: Version: 3.16-SNAPSHOT
2018-05-15 13:30:02  INFO: Starting server...

wrapper.log

WARNING|wrapper|Service traccar|18-05-15 13:29:58|YAJSW: yajsw-stable-12.12
WARNING|wrapper|Service traccar|18-05-15 13:29:58|OS   : Linux/3.10.0-693.21.1.el7.x86_64/amd64
WARNING|wrapper|Service traccar|18-05-15 13:29:58|JVM  : Oracle Corporation/1.7.0_181//usr/lib/jvm/java-1.7.0-openjdk-1.7.0.181-2.6.14.5.el7.x86_64/jre/64
INFO|wrapper|Service traccar|18-05-15 13:29:58|exec:/bin/java -classpath /opt/traccar/wrapperApp.jar:/opt/traccar/tracker-server.jar:/opt/traccar/lib/log4j-1.2.17.jar:/opt/traccar/lib/joda-time-2.9.9.jar:/opt/traccar/lib/commons-codec-1.11.jar:/opt/traccar/lib/h2-1.4.196.jar:/opt/traccar/lib/mysql-connector-java-5.1.45.jar:/opt/traccar/lib/postgresql-42.2.1.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.4.0.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.13.jar:/opt/traccar/lib/slf4j-api-1.7.21.jar:/opt/traccar/lib/netty-3.10.6.Final.jar:/opt/traccar/lib/async-http-client-1.9.40.jar:/opt/traccar/lib/slf4j-simple-1.7.25.jar:/opt/traccar/lib/javax.json-1.0.4.jar:/opt/traccar/lib/jetty-server-9.2.24.v20180105.jar:/opt/traccar/lib/javax.servlet-api-3.1.0.jar:/opt/traccar/lib/jetty-http-9.2.24.v20180105.jar:/opt/traccar/lib/jetty-io-9.2.24.v20180105.jar:/opt/traccar/lib/jetty-servlet-9.2.24.v20180105.jar:/opt/traccar/lib/jetty-security-9.2.24.v20180105.jar:/opt/traccar/lib/jetty-webapp-9.2.24.v20180105.jar:/opt/traccar/lib/jetty-xml-9.2.24.v20180105.jar:/opt/traccar/lib/jetty-jndi-9.2.24.v20180105.jar:/opt/traccar/lib/jetty-util-9.2.24.v20180105.jar:/opt/traccar/lib/jetty-proxy-9.2.24.v20180105.jar:/opt/traccar/lib/jetty-client-9.2.24.v20180105.jar:/opt/traccar/lib/websocket-server-9.2.24.v20180105.jar:/opt/traccar/lib/websocket-common-9.2.24.v20180105.jar:/opt/traccar/lib/websocket-api-9.2.24.v20180105.jar:/opt/traccar/lib/websocket-client-9.2.24.v20180105.jar:/opt/traccar/lib/websocket-servlet-9.2.24.v20180105.jar:/opt/traccar/lib/jersey-container-servlet-2.25.1.jar:/opt/traccar/lib/jersey-container-servlet-core-2.25.1.jar:/opt/traccar/lib/javax.inject-2.5.0-b32.jar:/opt/traccar/lib/jersey-common-2.25.1.jar:/opt/traccar/lib/javax.annotation-api-1.2.jar:/opt/traccar/lib/jersey-guava-2.25.1.jar:/opt/traccar/lib/hk2-api-2.5.0-b32.jar:/opt/traccar/lib/hk2-utils-2.5.0-b32.jar:/opt/traccar/lib/aopalliance-repackaged-2.5.0-b32.jar:/opt/traccar/lib/hk2-locator-2.5.0-b32.jar:/opt/traccar/lib/javassist-3.20.0-GA.jar:/opt/traccar/lib/osgi-resource-locator-1.0.1.jar:/opt/traccar/lib/jersey-server-2.25.1.jar:/opt/traccar/lib/jersey-client-2.25.1.jar:/opt/traccar/lib/jersey-media-jaxb-2.25.1.jar:/opt/traccar/lib/validation-api-1.1.0.Final.jar:/opt/traccar/lib/javax.ws.rs-api-2.0.1.jar:/opt/traccar/lib/jersey-media-json-jackson-2.25.1.jar:/opt/traccar/lib/jersey-entity-filtering-2.25.1.jar:/opt/traccar/lib/jackson-jaxrs-base-2.8.4.jar:/opt/traccar/lib/jackson-core-2.8.4.jar:/opt/traccar/lib/jackson-databind-2.8.4.jar:/opt/traccar/lib/jackson-jaxrs-json-provider-2.8.4.jar:/opt/traccar/lib/jackson-module-jaxb-annotations-2.8.4.jar:/opt/traccar/lib/jackson-annotations-2.8.4.jar:/opt/traccar/lib/liquibase-core-3.5.5.jar:/opt/traccar/lib/snakeyaml-1.17.jar:/opt/traccar/lib/mail-1.4.7.jar:/opt/traccar/lib/activation-1.1.jar:/opt/traccar/lib/jxls-2.4.4.jar:/opt/traccar/lib/commons-jexl-2.1.1.jar:/opt/traccar/lib/commons-beanutils-1.9.2.jar:/opt/traccar/lib/jcl-over-slf4j-1.7.12.jar:/opt/traccar/lib/logback-core-1.1.3.jar:/opt/traccar/lib/jxls-poi-1.0.14.jar:/opt/traccar/lib/poi-3.17.jar:/opt/traccar/lib/poi-ooxml-3.17.jar:/opt/traccar/lib/poi-ooxml-schemas-3.17.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.04.jar:/opt/traccar/lib/velocity-1.7.jar:/opt/traccar/lib/commons-collections-3.2.1.jar:/opt/traccar/lib/commons-lang-2.4.jar:/opt/traccar/lib/velocity-tools-2.0.jar:/opt/traccar/lib/commons-digester-1.8.jar:/opt/traccar/lib/commons-chain-1.1.jar:/opt/traccar/lib/commons-logging-1.1.jar:/opt/traccar/lib/servlet-api-2.3.jar:/opt/traccar/lib/commons-validator-1.3.1.jar:/opt/traccar/lib/dom4j-1.1.jar:/opt/traccar/lib/oro-2.0.8.jar:/opt/traccar/lib/sslext-1.2-0.jar:/opt/traccar/lib/struts-core-1.3.8.jar:/opt/traccar/lib/antlr-2.7.2.jar:/opt/traccar/lib/struts-taglib-1.3.8.jar:/opt/traccar/lib/struts-tiles-1.3.8.jar:/opt/traccar/lib/commons-collections4-4.1.jar:/opt/traccar/lib/ical4j-2.0.5.jar:/opt/traccar/lib/commons-lang3-3.6.jar:/opt/traccar/lib/threetenbp-1.3.6.jar:/opt/traccar/lib/ch-smpp-5.0.9.jar:/opt/traccar/lib/ch-commons-util-6.0.2.jar:/opt/traccar/lib/ch-commons-charset-3.0.2.jar -Dfile.encoding=UTF-8 -Xrs -Dwrapper.service=true -Dwrapper.console.visible=false -Dwrapper.port=15003 -Dwrapper.key=-2609938072932691576 -Dwrapper.teeName=-2609938072932691576$1526387398180 -Dwrapper.tmp.path=/opt/traccar/tmp -Djna_tmpdir=/opt/traccar/tmp -Dwrapper.config=/opt/traccar/conf/wrapper.conf -Dwrapper.visible=false -Dwrapper.pidfile=/run/wrapper.traccar.pid org.rzo.yajsw.app.WrapperJVMMain 
INFO|wrapper|Service traccar|18-05-15 13:29:58|posix_spawn pid 5328
INFO|wrapper|Service traccar|18-05-15 13:29:58|started process 5328
INFO|wrapper|Service traccar|18-05-15 13:29:58|started process with pid 5328
INFO|5328/0|Service traccar|18-05-15 13:29:59|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|5328/0|Service traccar|18-05-15 13:29:59|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|5328/0|Service traccar|18-05-15 13:29:59|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
INFO|5328/0|Service traccar|18-05-15 13:30:00|INFO 5/15/18 1:30 PM: liquibase: Clearing database change log checksums
INFO|5328/0|Service traccar|18-05-15 13:30:00|INFO 5/15/18 1:30 PM: liquibase: Successfully acquired change log lock
INFO|5328/0|Service traccar|18-05-15 13:30:00|INFO 5/15/18 1:30 PM: liquibase: Successfully released change log lock
INFO|5328/0|Service traccar|18-05-15 13:30:00|INFO 5/15/18 1:30 PM: liquibase: Successfully acquired change log lock
INFO|5328/0|Service traccar|18-05-15 13:30:01|INFO 5/15/18 1:30 PM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO|5328/0|Service traccar|18-05-15 13:30:01|INFO 5/15/18 1:30 PM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO|5328/0|Service traccar|18-05-15 13:30:01|INFO 5/15/18 1:30 PM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8-dropuniquetoken::author: Change set changelog-3.8::changelog-3.8-dropuniquetoken::author failed, but failOnError was false.  Error: Constraint "UK_USER_TOKEN" not found; SQL statement:
INFO|5328/0|Service traccar|18-05-15 13:30:01|ALTER TABLE PUBLIC.users DROP CONSTRAINT uk_user_token [90057-196] [Failed SQL: ALTER TABLE PUBLIC.users DROP CONSTRAINT uk_user_token]
INFO|5328/0|Service traccar|18-05-15 13:30:01|INFO 5/15/18 1:30 PM: liquibase: Successfully released change log lock
INFO|5328/0|Service traccar|18-05-15 13:30:01|[main] INFO org.eclipse.jetty.util.log - Logging initialized @2970ms
INFO|5328/0|Service traccar|18-05-15 13:30:02|[main] INFO org.eclipse.jetty.server.Server - jetty-9.2.24.v20180105
INFO|5328/0|Service traccar|18-05-15 13:30:02|[main] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@7f5d0856{/api,null,AVAILABLE}
INFO|5328/0|Service traccar|18-05-15 13:30:02|[main] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.t.w.@1b3df7e1{/,null,AVAILABLE}
INFO|5328/0|Service traccar|18-05-15 13:30:02|[main] INFO org.eclipse.jetty.server.ServerConnector - Started ServerConnector@2e249075{HTTP/1.1}{0.0.0.0:80}
INFO|5328/0|Service traccar|18-05-15 13:30:02|[main] INFO org.eclipse.jetty.server.Server - Started @4247ms

I'm assuming the problem is the SQL UK_USER_TOKEN bit - but I'm at a loss how to proceed further...
Please can anyone help ?

Anton Tananaev7 years ago

Your logs look fine. You need to check browser developer console to see what the problem is.

steve walsh7 years ago

Thanks for the reply - looks to be a problem with load.js ???

I've linked to a screenshot below

Anton Tananaev7 years ago

Looks like the problem is with ExtJS. Check network tab.

steve walsh7 years ago

Here's the network tab... Sorry to ask for more help but I'm still not sure what the solution is...

Anton Tananaev7 years ago

What happened to all the files from cdnjs? Why are they 0 bytes?

steve walsh7 years ago

ahh, I see what you mean...

Upon further investigation it appears that my pihole (pi-hole.net) had blocked them !

I've whitelisted the domain and it all looks good :-)

I wasn't aware of the need for external resources... now I've searched for cloudflare on your site, I see there are ways around this...

Thank you for helping to troubleshoot this. (and apologies that it was all my own fault)