Traccar Client offline, MYSQL issues

Adam6 years ago

Hi,

It would be useful to get some assistance please, I've attempted to migrate to MYSQL but suddenly cannot connect to my traccar client from the browser & the database has no tables created as expected.

Wrapper log below:

WARNING|wrapper|Service traccar|19-06-13 17:13:33|OS   : Linux/4.15.0-51-generic/amd64
WARNING|wrapper|Service traccar|19-06-13 17:13:33|JVM  : Oracle Corporation/11.0.3//usr/lib/jvm/java-11-openjdk-amd64/64
INFO|wrapper|Service traccar|19-06-13 17:13:33|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.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=-8999265510022121592 -Dwrapper.teeName=-8999265510022121592$1560446013342 -Dwrapper.tmp.path=/opt/traccar/tmp -Djna_tmpdir=/opt/traccar/tmp -Dwrapper.config=/opt/traccar/conf/wrapper.conf -Dwrapper.pidfile=/run/wrapper.traccar.pid -Dwrapper.visible=false org.rzo.yajsw.app.WrapperJVMMain
INFO|wrapper|Service traccar|19-06-13 17:13:33|posix_spawn pid 1305
INFO|wrapper|Service traccar|19-06-13 17:13:33|started process 1305
INFO|wrapper|Service traccar|19-06-13 17:13:33|started process with pid 1305
INFO|1305/0|Service traccar|19-06-13 17:13:37|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|1305/0|Service traccar|19-06-13 17:13:38|java.lang.reflect.InvocationTargetException
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/java.lang.reflect.Method.invoke(Method.java:566)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|1305/0|Service traccar|19-06-13 17:13:38|Caused by: java.lang.RuntimeException: Configuration file is not a valid XML document
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at org.traccar.Config.load(Config.java:49)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at org.traccar.Context.init(Context.java:318)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at org.traccar.Main.main(Main.java:35)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  ... 6 more
INFO|1305/0|Service traccar|19-06-13 17:13:38|Caused by: java.util.InvalidPropertiesFormatException: jdk.internal.org.xml.sax.SAXParseException; Attribute "key" is required and must be specified for element type "entry"
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.util.xml.PropertiesDefaultHandler.load(PropertiesDefaultHandler.java:85)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/java.util.Properties.loadFromXML(Properties.java:962)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at org.traccar.Config.load(Config.java:34)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  ... 8 more
INFO|1305/0|Service traccar|19-06-13 17:13:38|Caused by: jdk.internal.org.xml.sax.SAXParseException; Attribute "key" is required and must be specified for element type "entry"
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.util.xml.PropertiesDefaultHandler.startElement(PropertiesDefaultHandler.java:175)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.util.xml.impl.ParserSAX.parse(ParserSAX.java:470)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.util.xml.impl.ParserSAX.parse(ParserSAX.java:411)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.util.xml.impl.ParserSAX.parse(ParserSAX.java:374)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.util.xml.impl.SAXParserImpl.parse(SAXParserImpl.java:97)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  at java.base/jdk.internal.util.xml.PropertiesDefaultHandler.load(PropertiesDefaultHandler.java:83)
INFO|1305/0|Service traccar|19-06-13 17:13:38|  ... 10 more
INFO|wrapper|Service traccar|19-06-13 17:13:38|waitpid 1305 59136
INFO|wrapper|Service traccar|19-06-13 17:13:38|exit code posix process: 59136 application(status/signal): 231/0

my db setup is below:

    <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
    <entry key='database.url'>jdbc:mysql://SG-dght-794-master.servers.mongodirector.com:3306/DATABASE?serverTimezone=UTC&amp;useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
    <entry key='database.user'>USER</entry>
    <entry key='database.password'>PASS</entry>

Anton Tananaev6 years ago

I would recommend to carefully read error messages from the log.

Adam6 years ago

Thanks but I'm really struggling to decode the logs - can you point me in the right direction?

Anton Tananaev6 years ago

Your config file is not a valid XML document. You need to find and fix the issue. If you can't spot it yourself, I'm sure there are plenty of tools that can validate it for you.