Upgraded to traccar 4.5 Ubuntu 18.04 LTS 64 bit server.

Adrian Hodgson5 years ago

It has gone OK, I do notice an extra warning when I run sudo systemctl status traccar:-

May 06 19:39:25 testserver traccar[29388]: SLF4J: Found binding in [jar:file:/opt/traccar/lib/slf4j-jdk14-1.7.26.jar!/org/slf4j/impl/StaticLoggerBinder.class]
May 06 19:39:25 testserver traccar[29388]: SLF4J: Found binding in [jar:file:/opt/traccar/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
May 06 19:39:25 testserver traccar[29388]: SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.                                                                         
May 06 19:39:25 testserver traccar[29388]: SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]                                                                                
May 06 19:39:26 testserver traccar[29388]: Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the S
May 06 19:39:32 testserver traccar[29388]: WARNING: An illegal reflective access operation has occurred                                                                                   
May 06 19:39:32 testserver traccar[29388]: WARNING: Illegal reflective access by com.google.inject.internal.cglib.core.$ReflectUtils$1 (file:/opt/traccar/lib/guice-4.2.2.jar) to method java.lang.ClassLo
May 06 19:39:32 testserver traccar[29388]: WARNING: Please consider reporting this to the maintainers of com.google.inject.internal.cglib.core.$ReflectUtils$1                  
May 06 19:39:32 testserver traccar[29388]: WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations                                                  
May 06 19:39:32 testserver traccar[29388]: WARNING: All illegal access operations will be denied in a future release

I am used to the illegal reflective operations sections.
Looking at a few other posts I tried changing to traccar.xml to use com.mysql.cj.jdbc.Driver as some others have tried, but this completely failed for me so I went back to com.mysql.jdbc.Driver.
Am I correct in thinking the new com.mysql.cj.jdbc.Driver is for MySQL version 8.x.x and not the Ubuntu 18.04 LTS version MySQL 5.7.26.

It works as it is, I am just wondering if with updates in traccar I need to consider an upgrade to MySQL version 8

Thanks for time.

Adrian

Anton Tananaev5 years ago

MySQL driver version is not the same as server version. Check this:

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-versions.html

Adrian Hodgson5 years ago

OK thank you I will have a read.

Adrian