traccar Ubuntu mysql error help

Naveen6 years ago

Dear Anton, I am trying to install traccar 3.15 with mysql 5.7 in a ubuntu 16.04 VPS.
i am getting an error and unable to proceed further.
Please can you guide.
Thanks in advance.

The error noted in wrapperlog is as follows:

WARNING|wrapper|Service traccar|18-06-09 08:51:31|YAJSW: yajsw-stable-12.11
WARNING|wrapper|Service traccar|18-06-09 08:51:31|OS   : Linux/4.4.0-127-generic/amd64
WARNING|wrapper|Service traccar|18-06-09 08:51:31|JVM  : Oracle Corporation/1.8.0_171//usr/lib/jvm/java-8-openjdk-amd64/jre/64
INFO|wrapper|Service traccar|18-06-09 08:51:32|exec:java -classpath /opt/traccar/wrapperApp.jar:/opt/traccar/tracker-server.jar:/opt/traccar/lib/log4j-1.2.17.jar:/opt/traccar/lib/joda-tim$
INFO|wrapper|Service traccar|18-06-09 08:51:32|posix_spawn pid 3406
INFO|wrapper|Service traccar|18-06-09 08:51:32|started process 3406
INFO|wrapper|Service traccar|18-06-09 08:51:32|started process with pid 3406
INFO|3406/0|Service traccar|18-06-09 08:51:34|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|3406/0|Service traccar|18-06-09 08:51:36|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|3406/0|Service traccar|18-06-09 08:51:42|[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
INFO|3406/0|Service traccar|18-06-09 08:51:42|com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 t$
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2094)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2019)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at org.traccar.database.DataManager.initDatabase(DataManager.java:133)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at org.traccar.database.DataManager.<init>(DataManager.java:86)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at org.traccar.Context.init(Context.java:333)
INFO|3406/0|Service traccar|18-06-09 08:51:42|  at org.traccar.Main.main(Main.java:35)

Anton Tananaev6 years ago

The error is pretty self-explanatory:

Could not create connection to database server.