Linux / Centos - no web interface - just spinning circle

steve walsh 8 years ago

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 Tananaev 8 years ago

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

steve walsh 8 years ago

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

I've linked to a screenshot below

Anton Tananaev 8 years ago

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

steve walsh 8 years ago

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

Anton Tananaev 8 years ago

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

steve walsh 8 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)