Problem using traccar with MySQL

Hi from Venezuela,

I have installed the package traccar-linux-64-3.7.zip on one Ubuntu 16.04 server, it runs very well using the default database, but when i want to use mysql the server does not start, the only thing i have made is to change que lines in the traccar.xml file using the instruccions on this link https://www.traccar.org/mysql/

The MySQL database is running fine and the database is created, i'm using the root user and password in the config file just to make sure that there are no permissions issues.

I´ve been googling about the error but i haven't found the information to solve the issue, im not an expert in coding.

Any help will be apreciated.

The messages in the log files are:

STATUS | wrapper  | 2016/11/11 09:49:45 | --> Wrapper Started as Daemon
STATUS | wrapper  | 2016/11/11 09:49:45 | Java Service Wrapper Community Edition 64-bit 3.5.28
STATUS | wrapper  | 2016/11/11 09:49:45 |   Copyright (C) 1999-2016 Tanuki Software, Ltd. All Rights Reserved.
STATUS | wrapper  | 2016/11/11 09:49:45 |     http://wrapper.tanukisoftware.com
STATUS | wrapper  | 2016/11/11 09:49:45 |
STATUS | wrapper  | 2016/11/11 09:49:46 | Launching a JVM...
INFO   | jvm 1    | 2016/11/11 09:49:46 | WrapperManager: Initializing...
INFO   | jvm 1    | 2016/11/11 09:49:46 | [WrapperSimpleAppMain] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Started.
INFO   | jvm 1    | 2016/11/11 09:49:47 | [WrapperSimpleAppMain] INFO com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Driver does not support get/set network timeout for connections. (com.mysql.jdbc.Connection.getNetworkTimeout()I)
INFO   | jvm 1    | 2016/11/11 09:49:47 | [WrapperSimpleAppMain] ERROR com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Failed to execute isValid() for connection, configure connection test query. (com.mysql.jdbc.Connection.isValid(I)Z)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp:
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error: Encountered an error running main:
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: com.mysql.jdbc.Connection.isValid(I)Z
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:514)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:107)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:71)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at org.traccar.database.DataManager.initDatabase(DataManager.java:111)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at org.traccar.database.DataManager.<init>(DataManager.java:66)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at org.traccar.Context.init(Context.java:150)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at org.traccar.Main.main(Main.java:35)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at java.lang.reflect.Method.invoke(Method.java:498)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at java.lang.Thread.run(Thread.java:745)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error: Caused by: java.lang.AbstractMethodError: com.mysql.jdbc.Connection.isValid(I)Z
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at com.zaxxer.hikari.pool.PoolBase.checkDriverSupport(PoolBase.java:400)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:375)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:346)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:508)
INFO   | jvm 1    | 2016/11/11 09:49:47 | WrapperSimpleApp Error:       ... 12 more
STATUS | wrapper  | 2016/11/11 09:49:49 | <-- Wrapper Stopped

It seems like you have some problem with database driver. Are you sure you have a completely clean installation of version 3.7?

Hi, now i'm testing again the system, it was my fault, i was using al old java library, now is working very well.

Thanks for your help.