Traccar service stops running if using Mysql on ubuntu server vps

Ndamulelo Muthaphuli6 years ago

Good day,

I installed traccar version 4.5 on ubuntu server. I started the service using sudo systemctl start traccar.service and the traccar started successfully and I could access on the browser using serverIP:8082.

Now the issue starts when I try to connect traccar to mysql database that is installed on the same ubuntu server. I modified traccar.xml following instructions from this link Connect traccar with MySQL. Traccar doesn't start as long as there is MySQL configurations on traccar.xml but when I remove MySQL configurations with the default H2 database configurations the service starts properly.

Below is how my log file looks like.

2019-06-05 18:38:03  INFO: user: 1, action: login
2019-06-05 20:41:15  INFO: Shutting down server...
2019-06-05 20:46:50  INFO: HikariPool-1 - Starting...
2019-06-05 20:46:51  INFO: HikariPool-1 - Start completed.
2019-06-05 20:46:51  INFO: Clearing database change log checksums
2019-06-05 20:46:51  INFO: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
2019-06-05 20:46:51  INFO: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
2019-06-05 20:46:51  INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2019-06-05 20:46:51  INFO: Successfully acquired change log lock
2019-06-05 20:46:51  INFO: SELECT MD5SUM FROM PUBLIC.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL
2019-06-05 20:46:51  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = NULL
2019-06-05 20:46:51  INFO: Successfully released change log lock
2019-06-05 20:46:51  INFO: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
2019-06-05 20:46:51  INFO: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
2019-06-05 20:46:51  INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2019-06-05 20:46:51  INFO: Successfully acquired change log lock
2019-06-05 20:46:54  INFO: SELECT MD5SUM FROM PUBLIC.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL
2019-06-05 20:46:54  INFO: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOG
2019-06-05 20:46:54  INFO: Reading from PUBLIC.DATABASECHANGELOG
2019-06-05 20:46:54  INFO: SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2019-06-05 20:46:54  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:d59fa93049c031a8bcfbc02958c1942c' WHERE ID = 'changelog-4.0-clean' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0-clean'
2019-06-05 20:46:54  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:1adabae3238e02ccc97cc422359a58a0' WHERE ID = 'changelog-4.0-clean-common' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0-clean'
2019-06-05 20:46:54  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:ea6f202534dc7845fd1a49e1d8384d9c' WHERE ID = 'changelog-3.3' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.3'
2019-06-05 20:46:54  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:194e3ae7ec6d201917136e04a26e237b' WHERE ID = 'changelog-3.5' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.5'
2019-06-05 20:46:54  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:1ec7941b03749f24e365bc6126b07e1a' WHERE ID = 'changelog-3.6' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.6'
2019-06-05 20:46:54  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:2e444e379f31d0b8e09273ec7ffe87a0' WHERE ID = 'changelog-3.7' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2019-06-05 20:46:54  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:974c33d2fb399ef6477c3897450fb078' WHERE ID = 'changelog-3.7-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:74d68027951f8d2ae6bb2e24df8365bc' WHERE ID = 'changelog-3.8' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.8'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:34822842d65deb843a7d16f857d52ecc' WHERE ID = 'changelog-3.9' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.9'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:e1ddbe83e1ecf856a912755fc118f82e' WHERE ID = 'changelog-3.10' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:191c21d8f0f921845cf93bbc9d0639b9' WHERE ID = 'changelog-3.10-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:ad1f63566e8d08812fbf0b93a118ef6e' WHERE ID = 'changelog-3.10-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:127b36b9d32a9d236df51d19b18c3766' WHERE ID = 'changelog-3.7-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:7800f890b9706a480bd5a79b591b6ca7' WHERE ID = 'changelog-3.11' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.11'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:5ce520811d626ad325a014b9fcbb1a13' WHERE ID = 'changelog-3.12' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:a3bf7fabcde29e106fe2f89829a76a84' WHERE ID = 'changelog-3.12-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:cfc881bd2dadb561aa9c1a467bc8cc1c' WHERE ID = 'changelog-3.12-pgsql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:1be7e6c0520f8be53ef1b099d96afba5' WHERE ID = 'changelog-3.14' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.14'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:ac8ccec176027e98bbf45dc6c15d9b05' WHERE ID = 'changelog-3.15' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.15'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:b59407d70bfe9bf57bc9968adfbbdf1c' WHERE ID = 'changelog-3.16' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.16'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:3f14c3b08068eb7628d0d3e2941eb2d3' WHERE ID = 'changelog-3.3-admin' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.17'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:8aa3e56afe6ba86cd004fa801507bc28' WHERE ID = 'changelog-3.17' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.17'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:3974bfe5a2e962c0cd663433c832c16a' WHERE ID = 'changelog-4.0-pre' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:65fb49c5be37693183708351c507dd50' WHERE ID = 'changelog-4.0-common' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:9831511507d8ae1d6759c8ccf506a27a' WHERE ID = 'changelog-4.0-pg' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:ac63c4153f5b2ee5c7a07056da269571' WHERE ID = 'changelog-4.0' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:90aedfa378aa717f8d8ae541f97b87b2' WHERE ID = 'changelog-4.0-renaming' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2019-06-05 20:46:55  INFO: UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:b148f52efe9c6a3e74a56e33e257a3e2' WHERE ID = 'changelog-4.1-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.1'
2019-06-05 20:46:55  INFO: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOG
2019-06-05 20:46:55  INFO: Reading from PUBLIC.DATABASECHANGELOG
2019-06-05 20:46:55  INFO: SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2019-06-05 20:46:55  INFO: Successfully released change log lock
2019-06-05 20:46:55  INFO: Logging initialized @5377ms to org.eclipse.jetty.util.log.Slf4jLog
2019-06-05 20:46:55  INFO: Your platform does not provide complete low-level API for accessing direct buffers reliably. Unless explicitly requested, heap buffer will always be preferred to avoid potential system instability.
2019-06-05 20:46:56  INFO: Operating system name: Linux version: 4.18.0-1018-azure architecture: amd64
2019-06-05 20:46:56  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 11.0.3-ojdkbuild+7
2019-06-05 20:46:56  INFO: Memory limit heap: 1990mb non-heap: 0mb
2019-06-05 20:46:56  INFO: Character encoding: UTF-8 charset: UTF-8
2019-06-05 20:46:56  INFO: Version: 4.4
2019-06-05 20:46:56  INFO: Starting server...
2019-06-05 20:46:56  INFO: jetty-9.4.18.v20190429; built: 2019-04-29T20:42:08.989Z; git: e1bc35120a6617ee3df052294e433f3a25ce7097; jvm 11.0.3-ojdkbuild+7
2019-06-05 20:46:56  INFO: Started o.t.w.@6af87130{/,null,AVAILABLE}
2019-06-05 20:46:56  INFO: DefaultSessionIdManager workerName=node0
2019-06-05 20:46:56  INFO: No SessionScavenger set, using defaults
2019-06-05 20:46:56  INFO: node0 Scavenging every 660000ms
2019-06-05 20:46:58  INFO: Started o.e.j.s.ServletContextHandler@3514ac7d{/,null,AVAILABLE}
2019-06-05 20:46:58  INFO: Started ServerConnector@7636823f{HTTP/1.1,[http/1.1]}{0.0.0.0:8082}
2019-06-05 20:46:58  INFO: Started @8158ms
2019-06-05 21:00:34  INFO: user: 1, action: login
2019-06-05 21:03:48  INFO: Shutting down server...

NOTE: Log file ends here.

When I run sudo systemctl status traccar.service below is the results

● traccar.service - traccar
   Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Thu 2019-06-06 07:43:42 UTC; 21min ago
  Process: 53791 ExecStart=/opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml (code=exited, status=1/FAILURE)
 Main PID: 53791 (code=exited, status=1/FAILURE)

Jun 06 07:43:42 leedev traccar[53791]:         at java.base/jdk.internal.util.xml.impl.ParserSAX.panic(ParserSAX.java:643)
Jun 06 07:43:42 leedev traccar[53791]:         at java.base/jdk.internal.util.xml.impl.Parser.step(Parser.java:355)
Jun 06 07:43:42 leedev traccar[53791]:         at java.base/jdk.internal.util.xml.impl.ParserSAX.parse(ParserSAX.java:508)
Jun 06 07:43:42 leedev traccar[53791]:         at java.base/jdk.internal.util.xml.impl.ParserSAX.parse(ParserSAX.java:411)
Jun 06 07:43:42 leedev traccar[53791]:         at java.base/jdk.internal.util.xml.impl.ParserSAX.parse(ParserSAX.java:374)
Jun 06 07:43:42 leedev traccar[53791]:         at java.base/jdk.internal.util.xml.impl.SAXParserImpl.parse(SAXParserImpl.java:97)
Jun 06 07:43:42 leedev traccar[53791]:         at java.base/jdk.internal.util.xml.PropertiesDefaultHandler.load(PropertiesDefaultHandler.java:83)
Jun 06 07:43:42 leedev traccar[53791]:         ... 5 more
Jun 06 07:43:42 leedev systemd[1]: traccar.service: Main process exited, code=exited, status=1/FAILURE
Jun 06 07:43:42 leedev systemd[1]: traccar.service: Failed with result 'exit-code'.

Thank you for your assistance in advance.

Anton Tananaev6 years ago

Invalid config file.

Ndamulelo Muthaphuli6 years ago

I figured out the problem. traccar.xml did not have a closing tag.

The reason why I put MySQL configurations on traccar.xml it's because of the instructions written on default.xml which states that DO NOT MODIFY THIS FILE. Use traccar.xml instead.. Thank you.