Upgrade from 6.2 to 6.4

odhiambo4 months ago

Today I installed 6.4 on Linux. I have always run on FreeBSD.
So I installed on Debian 12, used my traccar.xml that I had on FreeBSD with v6.2. Imported the DB from 6.2.
TC is running on Linux. My two devices are online, but their status is NOT updating!
Is there a DB schema update between 6.2 to 6.4 that I need to import and how?
From 6.2:

  1. mysqldump traccar_db > traccar_db.sql
  2. Install traccar on Debian 12
  3. On the Linux server: MySQL traccar_db < traccar_db.sql

How do I update the DB schema so that all changes from 6.2 to 6.3 to 6.4 are incorporated?

And why is it that my devices, much as they are online, are not having their status updated on the web UI?

odhiambo4 months ago

Just to add. I changed my DNS config with Cloudflare so that they don't proxy for the FQDN. Now I can see my devices online, but the following error in the log file keeps repeating!

2024-08-13 01:46:14  INFO: Update summary generated
2024-08-13 01:46:14  INFO: Successfully released change log lock
2024-08-13 01:46:14  INFO: Command execution complete
2024-08-13 01:46:14  INFO: Health check enabled with period 480000
2024-08-13 01:46:16  INFO: jetty-11.0.21; built: 2024-05-14T03:19:28.958Z; git: 996cd61addad9cb033e0e3eba6fa3f0fa3dc270d; jvm 21.0.4+7-LTS
2024-08-13 01:46:16  INFO: Started o.t.w.@212be1dd{/,null,AVAILABLE}
2024-08-13 01:46:16  INFO: Session workerName=node0
2024-08-13 01:46:16  WARN: JAXBContext implementation could not be found. WADL feature is disabled.
2024-08-13 01:46:16  INFO: [Tc4e0c22d] connected
2024-08-13 01:46:16  INFO: [Tc4e0c22d: osmand < 194.124.76.32] POST /?id=932337×tamp=1722849798&lat=-1.2840909&lon=36.7374598&speed=0.0&bearing=0.0&altitude=1839.3330078125&accuracy=246.8249969482422&batt=85.0 HTTP/1.1\r\nContent-Type: application/x-www-form-urlencoded\r\nUser-Agent: Dalvik/2.1.0 (Linux; U; Android 14; Redmi Note 9 Pro Build/AP2A.240705.005)\r\nHost: tc.kictanet.or.ke:5055\r\nConnection: Keep-Alive\r\nAccept-Encoding: gzip\r\nContent-Length: 0\r\n\r\n
2024-08-13 01:46:16  INFO: Event id: 932337, time: 2024-08-13 01:46:16, type: deviceOnline, notifications: 0
2024-08-13 01:46:17  INFO: Started o.e.j.s.ServletContextHandler@20d15bf7{/,null,AVAILABLE}
2024-08-13 01:46:17  INFO: Started ServerConnector@676ce11e{HTTP/1.1, (http/1.1)}{localhost:8082}
2024-08-13 01:46:17  INFO: Started Server@2bd4737{STARTING}[11.0.21,sto=0] @8930ms
2024-08-13 01:46:17  WARN: Position forwarding failed: 0 pending - URI is not absolute - IllegalArgumentException (...)
2024-08-13 01:46:17  INFO: [Tc4e0c22d] id: 932337, time: 2024-08-05 11:23:18, lat: -1.28409, lon: 36.73746, course: 0.0, accuracy: 246.8
2024-08-13 01:46:17  INFO: [Tc4e0c22d: osmand > 194.124.76.32] HTTP/1.1 200 OK\r\ncontent-length: 0\r\n\r\n
2024-08-13 01:46:18  INFO: [Tc4e0c22d: osmand < 194.124.76.32] POST /?id=932337×tamp=1722850197&lat=-1.2831921&lon=36.7376418&speed=0.0&bearing=0.0&altitude=1968.7431640625&accuracy=136.33399963378906&batt=85.0 HTTP/1.1\r\nContent-Type: application/x-www-form-urlencoded\r\nUser-Agent: Dalvik/2.1.0 (Linux; U; Android 14; Redmi Note 9 Pro Build/AP2A.240705.005)\r\nHost: tc.kictanet.or.ke:5055\r\nConnection: Keep-Alive\r\nAccept-Encoding: gzip\r\nContent-Length: 0\r\n\r\n
2024-08-13 01:46:18  WARN: Position forwarding failed: 0 pending - URI is not absolute - IllegalArgumentException (...)
2024-08-13 01:46:18  INFO: [Tc4e0c22d] id: 932337, time: 2024-08-05 11:29:57, lat: -1.28319, lon: 36.73764, course: 0.0, accuracy: 136.3
2024-08-13 01:46:18  INFO: [Tc4e0c22d: osmand > 194.124.76.32] HTTP/1.1 200 OK\r\ncontent-length: 0\r\n\r\n
2024-08-13 01:46:19  INFO: [Tc4e0c22d: osmand < 194.124.76.32] POST /?id=932337×tamp=1722850596&lat=-1.2840526&lon=36.7372931&speed=0.0&bearing=0.0&altitude=1814.65576171875&accuracy=110.33100128173828&batt=85.0 HTTP/1.1\r\nContent-Type: application/x-www-form-urlencoded\r\nUser-Agent: Dalvik/2.1.0 (Linux; U; Android 14; Redmi Note 9 Pro Build/AP2A.240705.005)\r\nHost: tc.kictanet.or.ke:5055\r\nConnection: Keep-Alive\r\nAccept-Encoding: gzip\r\nContent-Length: 0\r\n\r\n
2024-08-13 01:46:19  WARN: Position forwarding failed: 0 pending - URI is not absolute - IllegalArgumentException (...)
2024-08-13 01:46:19  INFO: [Tc4e0c22d] id: 932337, time: 2024-08-05 11:36:36, lat: -1.28405, lon: 36.73729, course: 0.0, accuracy: 110.3
2024-08-13 01:46:19  INFO: [Tc4e0c22d: osmand > 194.124.76.32] HTTP/1.1 200 OK\r\ncontent-length: 0\r\n\r\n
2024-08-13 01:46:19  INFO: [Tc4e0c22d: osmand < 194.124.76.32] POST /?id=932337×tamp=1722850993&lat=-1.2835637&lon=36.7367876&speed=0.0&bearing=0.0&altitude=1906.004150390625&accuracy=84.3740005493164&batt=85.0 HTTP/1.1\r\nContent-Type: application/x-www-form-urlencoded\r\nUser-Agent: Dalvik/2.1.0 (Linux; U; Android 14; Redmi Note 9 Pro Build/AP2A.240705.005)\r\nHost: tc.kictanet.or.ke:5055\r\nConnection: Keep-Alive\r\nAccept-Encoding: gzip\r\nContent-Length: 0\r\n\r\n
2024-08-13 01:46:19  WARN: Position forwarding failed: 0 pending - URI is not absolute - IllegalArgumentException (...)
2024-08-13 01:46:19  INFO: [Tc4e0c22d] id: 932337, time: 2024-08-05 11:43:13, lat: -1.28356, lon: 36.73679, course: 0.0, accuracy: 84.4
2024-08-13 01:46:19  INFO: [Tc4e0c22d: osmand > 194.124.76.32] HTTP/1.1 200 OK\r\ncontent-length: 0\r\n\r\n
2024-08-13 01:46:20  INFO: [Tc4e0c22d: osmand < 194.124.76.32] POST /?id=932337×tamp=1722851394&lat=-1.283658&lon=36.7370915&speed=0.0&bearing=0.0&altitude=1883.93408203125&accuracy=263.0740051269531&batt=85.0 HTTP/1.1\r\nContent-Type: application/x-www-form-urlencoded\r\nUser-Agent: Dalvik/2.1.0 (Linux; U; Android 14; Redmi Note 9 Pro Build/AP2A.240705.005)\r\nHost: tc.kictanet.or.ke:5055\r\nConnection: Keep-Alive\r\nAccept-Encoding: gzip\r\nContent-Length: 0\r\n\r\n
2024-08-13 01:46:20  WARN: Position forwarding failed: 0 pending - URI is not absolute - IllegalArgumentException (...)
2024-08-13 01:46:20  INFO: [Tc4e0c22d] id: 932337, time: 2024-08-05 11:49:54, lat: -1.28366, lon: 36.73709, course: 0.0, accuracy: 263.1
2024-08-13 01:46:20  INFO: [Tc4e0c22d: osmand > 194.124.76.32] HTTP/1.1 200 OK\r\ncontent-length: 0\r\n\r\n
2024-08-13 01:46:21  INFO: [Tc4e0c22d: osmand < 194.124.76.32] POST /?id=932337×tamp=1722851596&lat=-1.2829235&lon=36.7366973&speed=0.0&bearing=0.0&altitude=2028.46484375&accuracy=231.58900451660156&batt=85.0 HTTP/1.1\r\nContent-Type: application/x-www-form-urlencoded\r\nUser-Agent: Dalvik/2.1.0 (Linux; U; Android 14; Redmi Note 9 Pro Build/AP2A.240705.005)\r\nHost: tc.kictanet.or.ke:5055\r\nConnection: Keep-Alive\r\nAccept-Encoding: gzip\r\nContent-Length: 0\r\n\r\n
2024-08-13 01:46:21  WARN: Position forwarding failed: 0 pending - URI is not absolute - IllegalArgumentException (...)
2024-08-13 01:46:21  INFO: [Tc4e0c22d] id: 932337, time: 2024-08-05 11:53:16, lat: -1.28292, lon: 36.73670, course: 0.0, accuracy: 231.6
2024-08-13 01:46:21  INFO: [Tc4e0c22d: osmand > 194.124.76.32] HTTP/1.1 200 OK\r\ncontent-length: 0\r\n\r\n

PS: I am using Ngix and the config is this:

server {
    listen 443 ssl http2;
    server_name tc.kictanet.or.ke;

    root /opt/traccar/web;

    index index.html index.php;

    ssl_certificate /etc/letsencrypt/live/tc.kictanet.or.ke/fullchain.pem;
    ssl_certificate_key /etc/letsencrypt/live/tc.kictanet.or.ke/privkey.pem;
    ssl_trusted_certificate /etc/letsencrypt/live/tc.kictanet.or.ke/chain.pem;
    include snippets/ssl.conf;
    include snippets/letsencrypt.conf;

    # Tell browsers the site should only be accessed via https.
    add_header Strict-Transport-Security "max-age=31536000; includeSubDomains" always;

    # log files
    access_log /var/log/nginx/tc.kictanet.or.ke-access.log;
    error_log /var/log/nginx/tc.kictanet.or.ke-error.log;

    location = /favicon.ico {
    log_not_found off;
    access_log off;
    }

    location ~ /\.ht {
    deny all;
    }

    location = /robots.txt {
    allow all;
    log_not_found off;
    access_log off;
    }

    location /api/socket {
       include proxy_params;
       proxy_http_version 1.1;
       proxy_cache_bypass $http_upgrade;
       proxy_buffering off;
       proxy_set_header Host $host;
       proxy_set_header Upgrade $http_upgrade;
       proxy_set_header Connection "Upgrade";
       proxy_pass http://127.0.0.1:8082/api/socket;

    }

    location / {
       proxy_set_header X-Forwarded-Host $host:$server_port;
       proxy_set_header X-Forwarded-Server $host;
       proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
       proxy_pass http://127.0.0.1:8082/;
    }
}