Traccar 4.2 to 4.10 update issue

Rodrigo Oliveira 5 years ago

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.

Anton Tananaev 5 years ago

Well, there must be an issue with your database connection details in the config.

Rodrigo Oliveira 5 years ago

Can you help me try to fix this please?

Anton Tananaev 5 years ago

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.

Rodrigo Oliveira 5 years ago

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?

Anton Tananaev 5 years ago

Yes, it has updated driver.

Rodrigo Oliveira 5 years ago

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.

Anton Tananaev 5 years ago

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?