installed 3.15, unable to start service

penguin6 years ago

I'm running on Ubuntu 18.05
this is the wrapper log:

WARNING|wrapper|Service traccar|17-12-14 08:52:19|YAJSW: yajsw-stable-12.11
WARNING|wrapper|Service traccar|17-12-14 08:52:19|OS   : Linux/4.13.0-17-generic/amd64
WARNING|wrapper|Service traccar|17-12-14 08:52:19|JVM  : Oracle Corporation/1.8.0_151//usr/lib/jvm/java-8-oracle/jre/64
INFO|wrapper|Service traccar|17-12-14 08:52:19|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/h2-1.4.196.jar:/opt/traccar/lib/mysql-connector-java-5.1.45.jar:/opt/traccar/lib/postgresql-42.1.4.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.2.2.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.22.v20170606.jar:/opt/traccar/lib/javax.servlet-api-3.1.0.jar:/opt/traccar/lib/jetty-http-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-io-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-servlet-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-security-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-webapp-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-xml-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-jndi-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-util-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-proxy-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-client-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-server-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-common-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-api-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-client-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-servlet-9.2.22.v20170606.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.4.2.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.13.jar:/opt/traccar/lib/poi-3.16.jar:/opt/traccar/lib/poi-ooxml-3.16.jar:/opt/traccar/lib/poi-ooxml-schemas-3.16.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.4.jar:/opt/traccar/lib/commons-codec-1.9.jar:/opt/traccar/lib/commons-lang3-3.3.2.jar:/opt/traccar/lib/threetenbp-1.3.3.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=-8115840801832330127 -Dwrapper.teeName=-8115840801832330127$1513237938892 -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-12-14 08:52:19|posix_spawn pid 5938
INFO|wrapper|Service traccar|17-12-14 08:52:19|started process 5938
INFO|wrapper|Service traccar|17-12-14 08:52:19|started process with pid 5938
INFO|5938/0|Service traccar|17-12-14 08:52:26|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|5938/0|Service traccar|17-12-14 08:52:27|java.lang.reflect.InvocationTargetException
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at java.lang.reflect.Method.invoke(Method.java:498)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|5938/0|Service traccar|17-12-14 08:52:27|Caused by: java.util.InvalidPropertiesFormatException: org.xml.sax.SAXParseException; lineNumber: 28; columnNumber: 14; The content of element type "properties" must match "(comment?,entry*)".
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at sun.util.xml.PlatformXmlPropertiesProvider.load(PlatformXmlPropertiesProvider.java:80)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at java.util.Properties$XmlSupport.load(Properties.java:1201)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at java.util.Properties.loadFromXML(Properties.java:881)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at org.traccar.Config.load(Config.java:32)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at org.traccar.Context.init(Context.java:318)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at org.traccar.Main.main(Main.java:35)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  ... 6 more
INFO|5938/0|Service traccar|17-12-14 08:52:27|Caused by: org.xml.sax.SAXParseException; lineNumber: 28; columnNumber: 14; The content of element type "properties" must match "(comment?,entry*)".
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:203)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:134)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:396)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:284)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleEndElement(XMLDTDValidator.java:1994)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.endElement(XMLDTDValidator.java:879)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1782)
INFO|5938/0|Service traccar|17-12-14 08:52:27|  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2967)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:841)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:770)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:243)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:339)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  at sun.util.xml.PlatformXmlPropertiesProvider.getLoadingDoc(PlatformXmlPropertiesProvider.java:106)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  at sun.util.xml.PlatformXmlPropertiesProvider.load(PlatformXmlPropertiesProvider.java:78)
INFO|5938/0|Service traccar|17-12-14 08:52:28|  ... 11 more
INFO|wrapper|Service traccar|17-12-14 08:52:28|waitpid 5938 59136
INFO|wrapper|Service traccar|17-12-14 08:52:28|exit code posix process: 59136 application: 231

Any clue?

Regards,
Tony

penguin6 years ago

It seems it's only when I use the MySql connection like this in the traccer.xml

 <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
 <entry key='database.url'>jdbc:mysql://127.0.0.1:3306/***?useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
 <entry key='database.user'>***</entry>
 <entry key='database.password'>***</entry>

penguin6 years ago

It seems a connection to the MySQL db can't be made, as when I put a wrong password, it exits with the same error.

Anton Tananaev6 years ago

The error means that your XML config is invalid. It fact error points exact line and column number of the problem.

penguin6 years ago

I don't have 28 lines in traccar.xml.

The default.xml, wrapper.xml and wrapper.xml.default I did not touch.

If I change traccar.xml to use the default db (which now is empty) traccar starts.

Anton Tananaev6 years ago

OK, please upload both XML config files somewhere and provide links.

penguin6 years ago

thx for the help.
Config files are downloadable from here: http://one-life-live-it.be/conf.zip

Anton Tananaev6 years ago

Your traccar.xml_MYSQL has 32 lines. Why did you lie that it doesn't have 28 lines?

Also, what are those ### doing in the file? That's definitely a problem. I would recommend you to follow official documentation word by word.

penguin6 years ago

That's my bad. I was only focusing on the db config lines.
the ### was used to remark the lines, used # as habit.

I removed them, I get further now.

Thanks!

But... now I got the INFO|4626/0|Service traccar|17-12-14 10:57:23|INFO 12/14/17 10:57 AM: liquibase: Waiting for changelog lock....
error, so I hope I can fix that without loosing the db

penguin6 years ago

Back online. Deleted the databasechangeloglock entry and lock was gone.