Problems with Traccar 4.6 version

gabriele5 years ago

I have a problem on version 4.6 after installing it on Ubuntu 18.04 following the instructions the service does not start attach the logs. Someone can help me find the solution to solve the problem.

● traccar.service - traccar
   Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Mon 2019-09-09 09:25:59 CEST; 4s ago
  Process: 10686 ExecStart=/opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml (code=exited, status=1/FAILURE)
 Main PID: 10686 (code=exited, status=1/FAILURE)

set 09 09:25:59 vps683449 traccar[10686]:         at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
set 09 09:25:59 vps683449 traccar[10686]:         at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
set 09 09:25:59 vps683449 traccar[10686]:         at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
set 09 09:25:59 vps683449 traccar[10686]:         at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2139)
set 09 09:25:59 vps683449 traccar[10686]:         at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2163)
set 09 09:25:59 vps683449 traccar[10686]:         at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1301)
set 09 09:25:59 vps683449 traccar[10686]:         at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:860)
set 09 09:25:59 vps683449 traccar[10686]:         ... 16 more
set 09 09:25:59 vps683449 systemd[1]: traccar.service: Main process exited, code=exited, status=1/FAILURE
set 09 09:25:59 vps683449 systemd[1]: traccar.service: Failed with result 'exit-code'.

2019-09-09 09:25:54  INFO: HikariPool-1 - Starting...
2019-09-09 09:25:54  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2019-09-09 09:25:59 ERROR: HikariPool-1 - Exception during pool initialization. - The server time zone value 'CEST' is unrecognized or represents more than one time zone$

Thanks
BR
Gabriel

Anton Tananaev5 years ago

Check this documentation:

https://www.traccar.org/mysql/

webo5 years ago

Make sure the MySQL connector is installed with sudo apt-get install libmysql-java (that was the most recent command I could find so I'm hoping they didn't change the name for it)

For the timezone, make sure you're defining it using the tz database name (look for either the exact city or the nearest city in this list: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones)

gabriele5 years ago

Thanks probel solved.
BR
Gabriel

Anton Tananaev5 years ago

@webo, you don't need to install connector.

webo5 years ago

Good to know Anton, thank you