Device Table / Other service connectivity to db issue

Dear Anton,

I am facing an issue which I am unable to troubleshoot.

I have a cronjob/task set on my linux traccar server version 3.1, where the cronjob calculates distance for all devices and updates the device table with the value in a particular column i have named odometer.

This cronjob is set to run everyday at 5:01 AM. Works fine.

However since I started it I have noticed few of my devices stop sending data after 5:01 am after the cronjob is run. No other value has been changed in device table, however I am confused as to why this is happening.

Please advice.

If you don't see HEX messages in the log, it means server doesn't receive any data.

Note that Traccar is able to calculate distance as well. You don't need a cronjob for it. Just add following line to the config file:

<entry key='distance.enable'>true</entry>

Thanks for both the info Anton, I am now monitoring the hex messages. However that's quite a task :)

Also regarding the distance.enable Thanks a ton for that enabling it now. However where does the distance then get stored in mysql db?

Also one more thing will the distance be calculated only for new data coming in or existing record as well?

Distance is store in "other" fields with all other extra information.

It calculates distance between last position and the current one and adds it to the previous distance value.

Checked other table, for multiple devices.. after enabling this feature, however no distance value.

{"sat":9,"acc":true,"mcc":405,"mnc":15,"lac":15091,"cell":1073741824,"index":9242,"ip":"123.239.32.121"}

I've just checked and it wasn't implemented in version 3.1. I added it later.

Alright, I think there should be a way to also calculate previous position logs total distance before adding new over the last row/entry?

If you enable this flag from the beginning, it will calculate total distance.