Web Socket Connection Error
It means WebSocket connection failed. Use search. It has been discussed multiple times before.
It means WebSocket connection failed. Use search. It has been discussed multiple times before.
not found solution for Web socket connection error. but gps work
tracker-server.log
2017-03-19 08:20:15 DEBUG: [7A34E5AC: 5023 < 114.120.232.162] HEX: 78781f12110313141407c900bbd5ee0b8b458009d0c901fe0a370800c886004b7c6b0d0a
2017-03-19 08:20:15 DEBUG: [7A34E5AC: 5023 > 114.120.232.162] HEX: 78780512004b5e730d0a
2017-03-19 08:20:15 INFO: [7A34E5AC] id: 358899055385671, time: 2017-03-19 16:20:07, lat: -6.83889, lon: 107.59815, speed: 4.9, course: 201.0wrapper.log.20170319
WARNING|wrapper|Service traccar|17-03-19 07:26:11|YAJSW: yajsw-stable-12.08
WARNING|wrapper|Service traccar|17-03-19 07:26:11|OS : Linux/2.6.32-042stab117.14/amd64
WARNING|wrapper|Service traccar|17-03-19 07:26:11|JVM : Oracle Corporation/1.8.0_121//usr/lib/jvm/java-8-oracle/jre/64
INFO|wrapper|Service traccar|17-03-19 07:26:11|exec:"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.7.jar:/opt/traccar/lib/h2-1.4.193.jar:/opt/traccar/lib/mysql-connector-java-5.1.40.jar:/opt/traccar/lib/postgresql-9.4.1212.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.1.0.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.11.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.22.jar:/opt/traccar/lib/javax.json-1.0.4.jar:/opt/traccar/lib/jetty-server-9.2.21.v20170120.jar:/opt/traccar/lib/javax.servlet-api-3.1.0.jar:/opt/traccar/lib/jetty-http-9.2.21.v20170120.jar:/opt/traccar/lib/jetty-io-9.2.21.v20170120.jar:/opt/traccar/lib/jetty-servlet-9.2.21.v20170120.jar:/opt/traccar/lib/jetty-security-9.2.21.v20170120.jar:/opt/traccar/lib/jetty-webapp-9.2.21.v20170120.jar:/opt/traccar/lib/jetty-xml-9.2.21.v20170120.jar:/opt/traccar/lib/jetty-jndi-9.2.21.v20170120.jar:/opt/traccar/lib/jetty-util-9.2.21.v20170120.jar:/opt/traccar/lib/websocket-server-9.2.21.v20170120.jar:/opt/traccar/lib/websocket-common-9.2.21.v20170120.jar:/opt/traccar/lib/websocket-api-9.2.21.v20170120.jar:/opt/traccar/lib/websocket-client-9.2.21.v20170120.jar:/opt/traccar/lib/websocket-servlet-9.2.21.v20170120.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.3.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.3.0.jar:/opt/traccar/lib/commons-jexl-2.1.1.jar:/opt/traccar/lib/commons-logging-1.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.11.jar:/opt/traccar/lib/poi-3.14.jar:/opt/traccar/lib/poi-ooxml-3.14.jar:/opt/traccar/lib/poi-ooxml-schemas-3.14.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.03.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/ical4j-2.0.0.jar:/opt/traccar/lib/commons-collections4-4.0.jar:/opt/traccar/lib/groovy-all-2.3.2.jar:/opt/traccar/lib/bndlib-2.3.0.jar:/opt/traccar/lib/org.osgi.core-4.3.1.jar:/opt/traccar/lib/commons-lang3-3.3.2.jar:/opt/traccar/lib/commons-codec-1.9.jar" "-Dfile.encoding=UTF-8" "-Xrs" "-Dwrapper.service=true" "-Dwrapper.console.visible=false" "-Dwrapper.port=15003" "-Dwrapper.key=58580893839155854" "-Dwrapper.teeName=58580893839155854$1489922771021" "-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|17-03-19 07:26:11|posix_spawn pid 22463
INFO|wrapper|Service traccar|17-03-19 07:26:11|started process 22463
INFO|wrapper|Service traccar|17-03-19 07:26:11|started process with pid 22463
INFO|22463/0|Service traccar|17-03-19 07:26:15|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|22463/0|Service traccar|17-03-19 07:26:16|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|22463/0|Service traccar|17-03-19 07:26:17|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
INFO|22463/0|Service traccar|17-03-19 07:26:18|INFO 3/19/17 7:26 AM: liquibase: Clearing database change log checksums
INFO|22463/0|Service traccar|17-03-19 07:26:19|INFO 3/19/17 7:26 AM: liquibase: Successfully acquired change log lock
INFO|22463/0|Service traccar|17-03-19 07:26:20|INFO 3/19/17 7:26 AM: liquibase: Successfully released change log lock
INFO|22463/0|Service traccar|17-03-19 07:26:20|INFO 3/19/17 7:26 AM: liquibase: Successfully acquired change log lock
INFO|22463/0|Service traccar|17-03-19 07:26:22|INFO 3/19/17 7:26 AM: liquibase: Reading from traccar.DATABASECHANGELOG
INFO|22463/0|Service traccar|17-03-19 07:26:23|INFO 3/19/17 7:26 AM: liquibase: Reading from traccar.DATABASECHANGELOG
INFO|22463/0|Service traccar|17-03-19 07:26:23|INFO 3/19/17 7:26 AM: 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: Can't DROP 'uk_user_token'; check that column/key exists [Failed SQL: ALTER TABLE traccar.users DROP KEY uk_user_token]
INFO|22463/0|Service traccar|17-03-19 07:26:23|INFO 3/19/17 7:26 AM: liquibase: Successfully released change log lock
INFO|22463/0|Service traccar|17-03-19 07:26:24|[main] INFO org.eclipse.jetty.util.log - Logging initialized @12202ms
INFO|22463/0|Service traccar|17-03-19 07:26:26|[main] INFO org.eclipse.jetty.server.Server - jetty-9.2.21.v20170120
INFO|22463/0|Service traccar|17-03-19 07:26:27|[main] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@3ba0ae41{/api,null,AVAILABLE}
INFO|22463/0|Service traccar|17-03-19 07:26:27|[main] INFO org.eclipse.jetty.server.ServerConnector - Started ServerConnector@2b4b96a4{HTTP/1.1}{0.0.0.0:80}
INFO|22463/0|Service traccar|17-03-19 07:26:27|[main] INFO org.eclipse.jetty.server.Server - Started @15265ms
What are the log files for?
What are the log files for?
please help for solution anton. Thank you
yes I have solution. problem on traccar.xml
this wrong for my config
<entry key='database.url'>jdbc:mysql://localhost:3306/traccar?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
this true for my config
<entry key='database.url'>jdbc:mysql://127.0.0.1:3306/traccar?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
because I check portnetstat -an | grep 'LISTEN'
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
Thank you Anton
What wrong ?
