Web Socket Connection Error

beryindo 9 years ago

What wrong ?
socket error

Anton Tananaev 9 years ago

It means WebSocket connection failed. Use search. It has been discussed multiple times before.

beryindo 9 years ago

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

beryindo 9 years ago

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.0

wrapper.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

Anton Tananaev 9 years ago

What are the log files for?

beryindo 9 years ago

What are the log files for?

please help for solution anton. Thank you

beryindo 9 years ago

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 port
netstat -an | grep 'LISTEN'

tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN

Thank you Anton