I upgraded traccar 4.2 to 4.10 but when starting the service, it causes a problem with the MySQL connection.
2020-10-01 13:01:25 INFO: HikariPool-1 - Starting...
2020-10-01 13:01:28 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-10-01 13:01:35 ERROR: HikariPool-1 - Exception during pool initialization. - Could not create connection to database server. Attempted reconnect 3 times. Giving up. - SQLNonTransientConnectionException (... < DataManager:139 < *:89 < Context:292 < Main:137 < ...)
2020-10-01 13:01:35 ERROR: Main method error - Could not create connection to database server. Attempted reconnect 3 times. Giving up. - SQLNonTransientConnectionException (... < DataManager:139 < *:89 < Context:292 < Main:137 < ...)
2020-10-01 13:01:35 WARN: JNA: Callback org.traccar.WindowsService$ServiceMain@730d2164 threw the following exception - Could not create connection to database server. Attempted reconnect 3 times. Giving up. - SQLNonTransientConnectionException (... < DataManager:139 < *:89 < Context:292 < Main:137 < ...)
I reinstall traccar version 4.2 and it works normally.
But traccar version 4.10, but version 4.10 of traccar I can't always give this error.
Well, there must be an issue with your database connection details in the config.
Can you help me try to fix this please?
Based on the information provided it's not possible to tell anything more than you already know. The issue is related to the database connection.
Anton, just take one more question, I'm using MySQL 5.1 and the MySQL connector of version 4.2 of traccar is 5.1.47 so far everything works 100% on MySQL 5.1, now my question comes, version 4.10 of traccar must come with a most updated version of this MySQL connector, can that be?
Yes, it has updated driver.
Anton, I installed Traccar 4.10 and mysql 5.1.69 the same configuration I tried on my server and it also gave a connection error. Deleted Mysql and installed version 8.0.18 of it, and it now works. Question: Does Mysql 5.1. ** not work on these new versions of Traccar? I'm insisting on this version of Mysql because in the company we have 4 servers between tracing, ERP and others and they all use this same version.
Probably not supported. MySQL 5.1 is a very old version and I don't think it's maintained anymore. What is the reason for upgrading it, at least to more recent 5.x version?
I upgraded traccar 4.2 to 4.10 but when starting the service, it causes a problem with the MySQL connection.
I reinstall traccar version 4.2 and it works normally.
But traccar version 4.10, but version 4.10 of traccar I can't always give this error.