Traccar Client offline, MYSQL issues

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

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

Adam 7 years ago

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

Anton Tananaev 7 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.