Traccar Service Dont Start : traccar.service: Failed with result 'exit-code'.

Bacar Sylla3 years ago

Hi There,
I'm working on a GPS Tracking Service for my boss and I'm testing Traccar.

After following the installation process from this site, i still can't start Traccar service. when looking for the service status, it's showing up with the following message:

Process: 699 ExecStart=/opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml (code=exited, status=1/FA ...
traccar.service: Failed with result 'exit-code'.

When trying to exec manually from

> /opt/traccar# /opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml

Showing me the following error:

Exception in thread "main" java.lang.RuntimeException: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
      at org.traccar.Main.run(Main.java:147)
        at org.traccar.Main.main(Main.java:106)
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
        at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596)
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582)
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
       at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
        at org.traccar.database.DataManager.initDatabase(DataManager.java:131)
        at org.traccar.database.DataManager.<init>(DataManager.java:90)
        at org.traccar.Context.init(Context.java:298)
        at org.traccar.Main.run(Main.java:120)

Following the documentation, i configured the traccar.xml like this :

  <?xml version='1.0' encoding='UTF-8'?>
 <!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>

 <properties>

  <entry key="config.default">./conf/default.xml</entry>

  <!--Configuration Interface Web sur greek.midoga.net -->
   <entry key='web.timeout'>300000</entry>
   <entry key='web.enable'>true</entry>
   <entry key='web.port'>8082</entry>
   <entry key='web.path'>./web</entry>
   <entry key='web.debug'>true</entry>
   <entry key='logger.level'>all</entry>

   <!--Configuration de la base de donnee -->
   <entry key='database.driver'>com.mysql.cj.jdbc.Driver</entry>
   <entry key='database.url'>jdbc:mysql://localhost:3306/midogadb?serverTimezone=UTC&amp;useSSL=false&amp;allowMultiQue>   <entry > 
      key='database.user'>root</entry>
   <entry key='database.password'>MyDBPassword</entry>

Mysql is configured with the following Database name : midogadb , User : Root , Pswd : ******, with necessary access.

Can anyone light me up ?

Anton Tananaev3 years ago

The error is pretty clear from the log:

Could not create connection to database server. Attempted reconnect 3 times. Giving up.

It means that the database doesn't accept connection using the parameters you provided. Have you tried connecting to it using a command line tool to check? What command did you use?

Bacar Sylla3 years ago

Hi Anton,

I could connect to MySQL with command line and access to the database and work with. After checking logs, Traccar is online for about 1mn and then stop.
I don't know what was the problem but i changed the Localhost to the local IP first and then reinstalled mysql.

Now the service is running but i'm blocked to the loadig page when trying to access to the panel. Will try to check it tonight. Thank you