fail to run traccar server on ubuntu16.04

Hello, I have installed the traccar linux 64.4.8 version into my ubuntu16.04 server. I put my configuration files in /opt/traccar/conf/
while i try to start the traccar service .. it starts but nothing shown in the browser. the status command shows as follows:

  sudo systemctl status traccar.service
● traccar.service - traccar
   Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Mon 2020-06-22 05:54:59 UTC; 5min ago
  Process: 29327 ExecStart=/opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml (code=exited, status=1/FAI
 Main PID: 29327 (code=exited, status=1/FAILURE)

Jun 22 05:54:59 gotracker traccar[29327]:         at org.h2.Driver.connect(Driver.java:69)
Jun 22 05:54:59 gotracker traccar[29327]:         at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSou
Jun 22 05:54:59 gotracker traccar[29327]:         at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
Jun 22 05:54:59 gotracker traccar[29327]:         at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
Jun 22 05:54:59 gotracker traccar[29327]:         at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:4
Jun 22 05:54:59 gotracker traccar[29327]:         at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554
Jun 22 05:54:59 gotracker traccar[29327]:         ... 7 more
Jun 22 05:54:59 gotracker systemd[1]: traccar.service: Main process exited, code=exited, status=1/FAILURE
Jun 22 05:54:59 gotracker systemd[1]: traccar.service: Unit entered failed state.
Jun 22 05:54:59 gotracker systemd[1]: traccar.service: Failed with result 'exit-code'.

Anton Tananaev5 years ago

Check logs for full exception trace.

mehossain5 years ago

hello, thanks for your prompt reply. here is my full log trace:

...
2020-06-22 05:33:14 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-06-22 05:33:20 ERROR: HikariPool-1 - Exception during pool initialization. - Access denied for user 'root'@'localhost' (using password: YES) - CJException (... < DataManager:139 < *:89 < Context:292 < Main:110 < ...)
2020-06-22 05:33:20 ERROR: Main method error - Access denied for user 'root'@'localhost' (using password: YES) - CJException (... < DataManager:139 < *:89 < Context:292 < Main:110 < ...)
2020-06-22 05:54:56 INFO: HikariPool-1 - Starting...
2020-06-22 05:54:59 ERROR: HikariPool-1 - Exception during pool initialization. - Table "POSITIONS" not found; SQL statement:
ALTER TABLE PUBLIC.POSITIONS ADD CONSTRAINT PUBLIC.PK_POSITIONS PRIMARY KEY(ID) INDEX PUBLIC.PRIMARY_KEY_8 [42102-200] - JdbcSQLSyntaxErrorException (... < DataManager:139 < *:89 < Context:292 < Main:110 < ...)
2020-06-22 05:54:59 ERROR: Main method error - Table "POSITIONS" not found; SQL statement:
ALTER TABLE PUBLIC.POSITIONS ADD CONSTRAINT PUBLIC.PK_POSITIONS PRIMARY KEY(ID) INDEX PUBLIC.PRIMARY_KEY_8 [42102-200] - JdbcSQLSyntaxErrorException (... < DataManager:139 < *:89 < Context:292 < Main:110 < ...)

Anton Tananaev5 years ago

Access denied for user 'root'@'localhost'

The error seems to be pretty obvious.

mehossain5 years ago

Hi.. Tananaev.. thanks for your help.... i installed a fresh Traccar Linux 64 4.8 . the status is running but can not access via browser http://<ip address>:8082 .
sudo systemctl status traccar shows error as below:

● traccar.service - traccar
   Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
   Active: active (running) since Wed 2020-06-24 13:34:17 UTC; 2min 40s ago
 Main PID: 1096 (java)
    Tasks: 28
   Memory: 240.4M
      CPU: 13.923s
   CGroup: /system.slice/traccar.service
           └─1096 /opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml

Jun 24 13:34:17 gotracker systemd[1]: Started traccar.
Jun 24 13:34:20 gotracker traccar[1096]: Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'.
Jun 24 13:34:32 gotracker traccar[1096]: WARNING: An illegal reflective access operation has occurred
Jun 24 13:34:32 gotracker traccar[1096]: WARNING: Illegal reflective access by com.google.inject.internal.cglib.core.$ReflectUtils$1 (file:/opt/traccar/
Jun 24 13:34:32 gotracker traccar[1096]: WARNING: Please consider reporting this to the maintainers of com.google.inject.internal.cglib.core.$ReflectUti
Jun 24 13:34:32 gotracker traccar[1096]: WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
Jun 24 13:34:32 gotracker traccar[1096]: WARNING: All illegal access operations will be denied in a future release

Anton Tananaev5 years ago

Again, you should probably check logs. And also check what ports Traccar is listening on.

mehossain5 years ago

in default.xml file the web.port is 8082
shall i have to create any file under sites-available folder like traccar.conf ?
for your information, some of my other application is running under port 80. i want to run traccar on 8082 port
now if i browser <ip address>:8082 it just show the apache2 homepage

Anton Tananaev5 years ago

Wait, it looks like you haven't enabled the port on firewall. How do you expect to connect to it? Am I missing something?

mehossain5 years ago

I have already allowed the port 8082

sudo ufw status
Status: active

To                         Action      From
--                         ------      ----
OpenSSH                    ALLOW       Anywhere
20/tcp                     ALLOW       Anywhere
21/tcp                     ALLOW       Anywhere
990/tcp                    ALLOW       Anywhere
40000:50000/tcp            ALLOW       Anywhere
80                         ALLOW       Anywhere
3306                       ALLOW       <ip address>
3306/tcp                   ALLOW       Anywhere
8082                       ALLOW       Anywhere
OpenSSH (v6)               ALLOW       Anywhere (v6)
20/tcp (v6)                ALLOW       Anywhere (v6)
21/tcp (v6)                ALLOW       Anywhere (v6)
990/tcp (v6)               ALLOW       Anywhere (v6)
40000:50000/tcp (v6)       ALLOW       Anywhere (v6)
80 (v6)                    ALLOW       Anywhere (v6)
3306/tcp (v6)              ALLOW       Anywhere (v6)
8082 (v6)                  ALLOW       Anywhere (v6)

mehossain5 years ago

Hello, tananaev...
after some research i have found that there is no "bin" folder in my /opt/traccar folder ...
is it the main reason why my site is not running?
If yes.. how can i get that bin folder inside my traccar folder...

thanks in advance

Anton Tananaev5 years ago

You shouldn't have a bin folder if you are using latest release.

mehossain5 years ago

Hello, tananaev...
my traccar site still shows the homepage of apache2.
my log file shows as follows:

2020-06-25 06:13:38 INFO: Starting server...
2020-06-25 06:13:38 INFO: jetty-9.4.26.v20200117; built: 2020-01-17T12:35:33.676Z; git: 7b38981d25d14afb4a12ff1f2596756144edf695; jvm 11.0.5+10-LTS
2020-06-25 06:13:39 INFO: Started o.t.w.@4af70b83{/,null,AVAILABLE}
2020-06-25 06:13:39 INFO: DefaultSessionIdManager workerName=node0
2020-06-25 06:13:39 INFO: No SessionScavenger set, using defaults
2020-06-25 06:13:39 INFO: node0 Scavenging every 660000ms
2020-06-25 06:13:40 INFO: Started o.e.j.s.ServletContextHandler@7744195{/,null,AVAILABLE}
2020-06-25 06:13:40 WARN: Web server start failed - Address already in use - BindException (... < WebServer:159 < Main:118 < *:104)

thanks in advance

mehossain5 years ago

Hello Tananaev,
i check my port from https://www.traccar.org/port-check/ and it shows the port is open
but while i type: http://45.77.181.161:2082 then it just not running anything.

I am just stuck to run the traccar web interface. my traccar service is running ok but the web interface is not showing. below is my traccar status:

sudo systemctl status traccar
● traccar.service - traccar
   Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2020-06-25 10:37:44 UTC; 11s ago
 Main PID: 3551 (java)
    Tasks: 28
   Memory: 164.8M
      CPU: 10.629s
   CGroup: /system.slice/traccar.service
           └─3551 /opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml

Jun 25 10:37:44 gotracker systemd[1]: Stopped traccar.
Jun 25 10:37:44 gotracker systemd[1]: Started traccar.
Jun 25 10:37:53 gotracker traccar[3551]: WARNING: An illegal reflective access operation has occurred
Jun 25 10:37:53 gotracker traccar[3551]: 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.l
Jun 25 10:37:53 gotracker traccar[3551]: WARNING: Please consider reporting this to the maintainers of com.google.inject.internal.cglib.core.$ReflectUtils$1
Jun 25 10:37:53 gotracker traccar[3551]: WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
Jun 25 10:37:53 gotracker traccar[3551]: WARNING: All illegal access operations will be denied in a future release

Anton Tananaev5 years ago

OK, please stop posting the same service status output. It doesn't give any useful information.

Now if you carefully read your log file, you will see what the problem is.