Traccar cannot connect with mysql
Logs please.
And also provide your config, at least the database part.
traccar.xml configuration:
<entry key='database.driver'>com.mysql.cj.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://localhost:3306/traccar?zeroDateTimeBehavior=round&serverTimezone=
UTC&allowPublicKeyRetrieval=true&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode
=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>xxxx</entry>
<entry key='database.password'>xxxx</entry>Log errors:
2025-01-16 14:35:42 INFO: Version: 6.6
2025-01-16 14:35:42 INFO: Starting server...
2025-01-16 14:35:42 INFO: HikariPool-1 - Starting...
2025-01-16 14:35:43 ERROR: Main method error - Driver com.mysql.cj.jdbc.Driver claims to not accept jdbcUrl, jdbc:mysql
://localhost:3306/traccar?zeroDateTimeBehavior=round&serverTimezone=
UTC&allowPublicKeyRetrieval=true&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode
=yes&characterEncoding=UTF-8&sessionVariables=sql_mode='' - RuntimeException (... < DatabaseModule:80 < <gener:-1 < *:
-1 < ... < MainModule:138 < <gener:-1 < ...)Why do you have a bunch of line breaks there?
Just to visualize all the text in one screen. Besides, it is easier to copy/paste in this way
What do you think? Should I try with an earlier version of traccar or mysql?
Line breaks probably made it invalid, so you should fix that.
Yessss, that fixes the problem. Thank you Anton!!!!
Hello!!!!
I installed traccar 6.6 on a new vps with ubuntu 22.04 and mysql 8.0.40
I copied and existing traccar.xml config file from a working traccar 6.4 server (with mysql)
Traccar 6.6 fails at start up and the log file shows the error " Driver com.mysql.cj.jdbc.Driver claims to not accept jdbcUrl"
What can be wrong?