Traccar not working with mysql

Binu6 years ago

Hi
I am new to linux and traccar. i installed traccar on digital ocean vps which have plesk control panel.
i have installed traccar successfully with default database, and it can track my devices and i can view the webview. then i try to migrate to mysql.
i have changed the traccar.xml for mysql.
mysql version: 10.1.38

while i start the traccar i got this error at tracker-server.log

2019-05-20 10:22:21  INFO: HikariPool-1 - Starting...
2019-05-20 10:22:21  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2019-05-20 10:22:21  INFO: HikariPool-1 - Start completed.
2019-05-20 10:22:22  INFO: Clearing database change log checksums
2019-05-20 10:22:22  INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2019-05-20 10:22:22  INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2019-05-20 10:22:22  INFO: SELECT `LOCKED` FROM traccar.DATABASECHANGELOGLOCK WHERE ID=1
2019-05-20 10:22:22  INFO: Successfully acquired change log lock
2019-05-20 10:22:22  INFO: SELECT MD5SUM FROM traccar.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2019-05-20 10:22:22  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = NULL
2019-05-20 10:22:22  INFO: Successfully released change log lock
2019-05-20 10:22:22  INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2019-05-20 10:22:22  INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2019-05-20 10:22:22  INFO: SELECT `LOCKED` FROM traccar.DATABASECHANGELOGLOCK WHERE ID=1
2019-05-20 10:22:22  INFO: Successfully acquired change log lock
2019-05-20 10:22:24  INFO: SELECT MD5SUM FROM traccar.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2019-05-20 10:22:24  INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOG
2019-05-20 10:22:24  INFO: Reading from traccar.DATABASECHANGELOG
2019-05-20 10:22:24  INFO: SELECT * FROM traccar.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2019-05-20 10:22:24  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:d59fa93049c031a8bcfbc02958c1942c' WHERE ID = 'changelog-4.0-clean' AND AUTHOR = 'author' AN$
2019-05-20 10:22:24  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:1adabae3238e02ccc97cc422359a58a0' WHERE ID = 'changelog-4.0-clean-common' AND AUTHOR = 'aut$
2019-05-20 10:22:24  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:ea6f202534dc7845fd1a49e1d8384d9c' WHERE ID = 'changelog-3.3' AND AUTHOR = 'author' AND FILE$
2019-05-20 10:22:24  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:194e3ae7ec6d201917136e04a26e237b' WHERE ID = 'changelog-3.5' AND AUTHOR = 'author' AND FILE$
2019-05-20 10:22:24  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:1ec7941b03749f24e365bc6126b07e1a' WHERE ID = 'changelog-3.6' AND AUTHOR = 'author' AND FILE$
2019-05-20 10:22:24  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:2e444e379f31d0b8e09273ec7ffe87a0' WHERE ID = 'changelog-3.7' AND AUTHOR = 'author' AND FILE$
2019-05-20 10:22:24  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:974c33d2fb399ef6477c3897450fb078' WHERE ID = 'changelog-3.7-notmssql' AND AUTHOR = 'author'$
2019-05-20 10:22:24  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:74d68027951f8d2ae6bb2e24df8365bc' WHERE ID = 'changelog-3.8' AND AUTHOR = 'author' AND FILE$
2019-05-20 10:22:24  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:34822842d65deb843a7d16f857d52ecc' WHERE ID = 'changelog-3.9' AND AUTHOR = 'author' AND FILE$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:e1ddbe83e1ecf856a912755fc118f82e' WHERE ID = 'changelog-3.10' AND AUTHOR = 'author' AND FIL$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:191c21d8f0f921845cf93bbc9d0639b9' WHERE ID = 'changelog-3.10-notmssql' AND AUTHOR = 'author$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:ad1f63566e8d08812fbf0b93a118ef6e' WHERE ID = 'changelog-3.10-mssql' AND AUTHOR = 'author' A$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:127b36b9d32a9d236df51d19b18c3766' WHERE ID = 'changelog-3.7-mssql' AND AUTHOR = 'author' AN$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:7800f890b9706a480bd5a79b591b6ca7' WHERE ID = 'changelog-3.11' AND AUTHOR = 'author' AND FIL$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:5ce520811d626ad325a014b9fcbb1a13' WHERE ID = 'changelog-3.12' AND AUTHOR = 'author' AND FIL$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:a3bf7fabcde29e106fe2f89829a76a84' WHERE ID = 'changelog-3.12-notmssql' AND AUTHOR = 'author$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:cfc881bd2dadb561aa9c1a467bc8cc1c' WHERE ID = 'changelog-3.12-pgsql' AND AUTHOR = 'author' A$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:1be7e6c0520f8be53ef1b099d96afba5' WHERE ID = 'changelog-3.14' AND AUTHOR = 'author' AND FIL$
2019-05-20 10:22:25  INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:b148f52efe9c6a3e74a56e33e257a3e2' WHERE ID = 'changelog-4.1-mssql' AND AUTHOR = 'author' AN$
2019-05-20 10:22:25  INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOG
2019-05-20 10:22:25  INFO: Reading from traccar.DATABASECHANGELOG
2019-05-20 10:22:25  INFO: SELECT * FROM traccar.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2019-05-20 10:22:25  INFO: Successfully released change log lock
2019-05-20 10:22:25  INFO: Logging initialized @4621ms to org.eclipse.jetty.util.log.Slf4jLog
2019-05-20 10:22:25  INFO: Your platform does not provide complete low-level API for accessing direct buffers reliably. Unless explicitly requested, heap buffer will a$
2019-05-20 10:22:26  INFO: Operating system name: Linux version: 4.15.0-50-generic architecture: amd64
2019-05-20 10:22:26  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 11.0.3-ojdkbuild+7
2019-05-20 10:22:26  INFO: Memory limit heap: 988mb non-heap: 0mb
2019-05-20 10:22:26  INFO: Character encoding: UTF-8 charset: UTF-8
2019-05-20 10:22:26  INFO: Version: 4.4
2019-05-20 10:22:26  INFO: Starting server...
2019-05-20 10:22:26  INFO: jetty-9.4.18.v20190429; built: 2019-04-29T20:42:08.989Z; git: e1bc35120a6617ee3df052294e433f3a25ce7097; jvm 11.0.3-ojdkbuild+7
2019-05-20 10:22:26  INFO: Started o.t.w.@7781263c{/,null,AVAILABLE}
2019-05-20 10:22:26  INFO: DefaultSessionIdManager workerName=node0
2019-05-20 10:22:26  INFO: No SessionScavenger set, using defaults
2019-05-20 10:22:26  INFO: node0 Scavenging every 660000ms
2019-05-20 10:22:27  INFO: Started o.e.j.s.ServletContextHandler@534d0e20{/,null,AVAILABLE}
2019-05-20 10:22:27  WARN: Web server start failed - Address already in use - BindException (... < WebServer:159 < Main:118 < *:104)

the error is clear that Address already in use, but i cant get the port number.
There is no wrapper.log file inside the logs folder (i am using the latest version traccar 4.5)
since i am using plesk control panel some port may get conflicting.
While checking the database through phpmysql Traccar have created 38 tables in the traccar database.

Anybody help me to run traccar with mysql database.
Thanks

Binu6 years ago

Ports used my plesk are given here
Plesk ports

Anton Tananaev6 years ago

You have to check what process uses the port.

Binu6 years ago

Thanks for your reply.
How to check it?

But traccar works perfectly with default database, i got the error only with mysql database.

Anton Tananaev6 years ago

You can try netstat, but that's not something Traccar specific, so if you have questions about linux, I would recommend asking on corresponding resources.