Traccer installed but device data not saved in MySQL

sakosche9 years ago

Hello

I've installed traccar on debian wheezy and it seems to work fine.

By using Ulbotech T381 device, configured to port 5072, data are stored in log but not in MySQL-DB.

Here some log entries:

2016-04-15 08:46:28 DEBUG: [F4A927D0: 5072 < 109.45.3.5] HEX: 2a545330312c3836383332333032333130373037382c3137333034363134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a333b332c4d47523a3232342c4144433a303b302e30303b313b34302e30313b323b332e36342c4556543a31232a545330312c3836383332333032333130373037382c3137333034393134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a323b332c4d47523a3232342c4144433a303b31312e37363b313b34302e30313b323b332e37332c4556543a46303b31232a545330312c3836383332333032333130373037382c3137333035343134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a323b332c4d47523a3232342c4144433a303b31312e36323b313b33392e38323b323b332e37352c4556543a31232a545330312c3836383332333032333130373037382c3137333035383134303431362c4750533a333b4e35322e3530373431323b4531332e3339313738303b313b3139313b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36333b313b33392e38323b323b332e37362c4556543a31232a545330312c3836383332333032333130373037382c3137333130333134303431362c4750533a333b4e35322e3530373431373b4531332e3339313830333b303b3230333b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36353b313b33392e38323b323b332e37372c4556543a31232a545330312c3836383332333032333130373037382c3137333130383134303431362c4750533a333b4e35322e3530373434363b4531332e3339313833303b303b3230333b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36383b313b33392e38323b323b332e37382c4556543a31232a545330312c3836383332333032333130373037382c3137333131333134303431362c4750533a333b4e35322e3530373435363b4531332e3339313835343b303b303b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e37303b313b33392e38323b323b332e37382c4556543a31232a545330312c3836383332333032333130373037382c3137333131383134303431362c4750533a333b4e35322e3530373435373b4531332e3339313836353b303b303b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36333b313b33392e38323b323b332e37392c4556543a3123
2016-04-15 08:46:38 DEBUG: [F4A927D0: 5072 < 109.45.3.5] HEX: 2a545330312c3836383332333032333130373037382c3137333034363134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a333b332c4d47523a3232342c4144433a303b302e30303b313b34302e30313b323b332e36342c4556543a31232a545330312c3836383332333032333130373037382c3137333034393134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a323b332c4d47523a3232342c4144433a303b31312e37363b313b34302e30313b323b332e37332c4556543a46303b31232a545330312c3836383332333032333130373037382c3137333035343134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a323b332c4d47523a3232342c4144433a303b31312e36323b313b33392e38323b323b332e37352c4556543a31232a545330312c3836383332333032333130373037382c3137333035383134303431362c4750533a333b4e35322e3530373431323b4531332e3339313738303b313b3139313b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36333b313b33392e38323b323b332e37362c4556543a31232a545330312c3836383332333032333130373037382c3137333130333134303431362c4750533a333b4e35322e3530373431373b4531332e3339313830333b303b3230333b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36353b313b33392e38323b323b332e37372c4556543a31232a545330312c3836383332333032333130373037382c3137333130383134303431362c4750533a333b4e35322e3530373434363b4531332e3339313833303b303b3230333b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36383b313b33392e38323b323b332e37382c4556543a31232a545330312c3836383332333032333130373037382c3137333131333134303431362c4750533a333b4e35322e3530373435363b4531332e3339313835343b303b303b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e37303b313b33392e38323b323b332e37382c4556543a31232a545330312c3836383332333032333130373037382c3137333131383134303431362c4750533a333b4e35322e3530373435373b4531332e3339313836353b303b303b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36333b313b33392e38323b323b332e37392c4556543a3123
2016-04-15 08:46:48 DEBUG: [F4A927D0: 5072 < 109.45.3.5] HEX: 2a545330312c3836383332333032333130373037382c3137333034363134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a333b332c4d47523a3232342c4144433a303b302e30303b313b34302e30313b323b332e36342c4556543a31232a545330312c3836383332333032333130373037382c3137333034393134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a323b332c4d47523a3232342c4144433a303b31312e37363b313b34302e30313b323b332e37332c4556543a46303b31232a545330312c3836383332333032333130373037382c3137333035343134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a323b332c4d47523a3232342c4144433a303b31312e36323b313b33392e38323b323b332e37352c4556543a31232a545330312c3836383332333032333130373037382c3137333035383134303431362c4750533a333b4e35322e3530373431323b4531332e3339313738303b313b3139313b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36333b313b33392e38323b323b332e37362c4556543a31232a545330312c3836383332333032333130373037382c3137333130333134303431362c4750533a333b4e35322e3530373431373b4531332e3339313830333b303b3230333b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36353b313b33392e38323b323b332e37372c4556543a31232a545330312c3836383332333032333130373037382c3137333130383134303431362c4750533a333b4e35322e3530373434363b4531332e3339313833303b303b3230333b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36383b313b33392e38323b323b332e37382c4556543a31232a545330312c3836383332333032333130373037382c3137333131333134303431362c4750533a333b4e35322e3530373435363b4531332e3339313835343b303b303b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e37303b313b33392e38323b323b332e37382c4556543a31232a545330312c3836383332333032333130373037382c3137333131383134303431362c4750533a333b4e35322e3530373435373b4531332e3339313836353b303b303b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36333b313b33392e38323b323b332e37392c4556543a3123
2016-04-15 08:46:58 DEBUG: [F4A927D0: 5072 < 109.45.3.5] HEX: 2a545330312c3836383332333032333130373037382c3137333034363134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a333b332c4d47523a3232342c4144433a303b302e30303b313b34302e30313b323b332e36342c4556543a31232a545330312c3836383332333032333130373037382c3137333034393134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a323b332c4d47523a3232342c4144433a303b31312e37363b313b34302e30313b323b332e37332c4556543a46303b31232a545330312c3836383332333032333130373037382c3137333035343134303431362c4c42533a3236323b323b464646453b3242313430313b37332c5354543a323b332c4d47523a3232342c4144433a303b31312e36323b313b33392e38323b323b332e37352c4556543a31232a545330312c3836383332333032333130373037382c3137333035383134303431362c4750533a333b4e35322e3530373431323b4531332e3339313738303b313b3139313b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36333b313b33392e38323b323b332e37362c4556543a31232a545330312c3836383332333032333130373037382c3137333130333134303431362c4750533a333b4e35322e3530373431373b4531332e3339313830333b303b3230333b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36353b313b33392e38323b323b332e37372c4556543a31232a545330312c3836383332333032333130373037382c3137333130383134303431362c4750533a333b4e35322e3530373434363b4531332e3339313833303b303b3230333b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36383b313b33392e38323b323b332e37382c4556543a31232a545330312c3836383332333032333130373037382c3137333131333134303431362c4750533a333b4e35322e3530373435363b4531332e3339313835343b303b303b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e37303b313b33392e38323b323b332e37382c4556543a31232a545330312c3836383332333032333130373037382c3137333131383134303431362c4750533a333b4e35322e3530373435373b4531332e3339313836353b303b303b312e30312c5354543a323b332c4d47523a3232342c4144433a303b31312e36333b313b33392e38323b323b332e37392c4556543a3123

Who can tell me what's wrong?

Thanks in advance

Anton Tananaev9 years ago

Traccar supports only binary format for Ulbotech devices. Your device sends in text format.

sakosche9 years ago

Hi Anton

Thanks for your hint.

I've changed to binary and log writes error:

2016-04-15 10:39:58  WARN: [66FE49F7] error - Readable bytes exceeded - Need 282, maximum is 58 - IndexOutOfBoundsException (... < UlbotechProtocolDecoder:216 < ExtendedObjectDecoder:39 < ...)

Do you know to this failure also how to fix it?

Thanks in advance

Anton Tananaev9 years ago

Please provide more information from the log.

sakosche9 years ago

Hi Anton

Here is the whole log to this event:

2016-04-15 10:39:58  INFO: [66FE49F7] connected
2016-04-15 10:39:58 DEBUG: [66FE49F7: 5072 < 109.45.1.108] HEX: f8010108683230231070781ea36556020bffffffffffffffffffff780304000100010404000002c205060174178322071005e0000000013fcdf8f8010108683230231070781ea3655c020bffffffffffffffffffff780304000300030404000002c205060174177e22041005e0000000032786f8
2016-04-15 10:39:58  WARN: [66FE49F7] error - Readable bytes exceeded - Need 282, maximum is 58 - IndexOutOfBoundsException (... < UlbotechProtocolDecoder:216 < ExtendedObjectDecoder:39 < ...)
2016-04-15 10:39:58  INFO: [66FE49F7] disconnected
Anton Tananaev9 years ago

I've seen similar problem before. Your device sends malformed message. Ask vendor if they have a firmware update for the device to fix it.

sakosche9 years ago

Thank you for analyzing the error, I'll contact the vendor.

sakosche9 years ago

Hi Anton

After changing config back to text the transmission works - a bit. Traccar receives data and saves in MySQL. I disabled "ACK" also.

Now the trouble became a bit smaller, here some log lines:

2016-04-15 17:58:14 DEBUG: [AAB7FDBA: 5072 < 109.45.3.236] HEX: 2a545330312c3836383332333032333130373037382c3135353734333135303431362c4c42533a3236323b323b464646453b3242313430313b36392c5354543a333b332c4d47523a313535332c4144433a303b302e30303b313b31382e32383b323b332e33322c4556543a45303b3323
2016-04-15 17:58:15 DEBUG: [AAB7FDBA: 5072 < 109.45.3.236] HEX: f8010108683230231070789ea3673c010e0321333000cc58170000000000810304000000030404000002c20506032a178b220e1001013b17f8f8010108683230231070789ea36741010e0321332900cc58110000000000810304000000030404000002c20506032b178b220e100101774cf8f8010108683230231070789ea36746010e0321332300cc580c0000000000810304000000030404000002c20506032b178b220e100101a3def8f8010108683230231070789ea3674b010e0321332000cc580a0000000000810304000000030404000002c20506032a178b220e1001010791f8f8010108683230231070789ea36750010e0321331d00cc58080000000000810304000000030404000002c2050603291790220e100101b1acf8f8010108683230231070789ea36755010e0321331f00cc580b0000000000810304000000030404000002c205060326178b220e100101e655f8f8010108683230231070789ea3675a010e0321332400cc58130000000000810304000000030404000002c20506032b178b220e10010125a9f8f8010108683230231070789ea3675f010e0321332500cc58140000000000810304000000030404000002c20506032b1790220e1001013ba0f8f8010108683230231070789ea36764010e0321332700cc58150000000000810304000000030404000002c20506032b178b220e100101f96af8f8010108683230231070789ea36769010e0321332a00cc58170000000000810304000000030404000002c20506032a1790220e100101796ef8f8010108683230231070781ea3676e020bffffffffffffffffffff780304000000030404000002c20506032a1790220e100101ac72f8f8010108683230231070789ea36773010e0321333000cc58210000000000810304000000030404000002c2050603271790220e100101a2e7f8f8010108683230231070789ea36778010e0321333500cc58250000000000810304000000030404000002c20506032b1790220e1001017dd5f8f8010108683230231070789ea3677d010e0321333a00cc58260000000000810304000000030404000002c20506032a1790220e1001010044f8f8010108683230231070789ea36782010e0321333d00cc58270000000000810304000000030404000002c20506032b1798220d100101feadf8f8010108683230231070789ea36787010e0321333d00cc58260000000000810304000000030404000002c20506032b1794220d1001019806f8f8010108683230231070789ea3678c010e0321333c00cc58220000000000810304000000030404000002c20506032b1794220d1001010655f8f8010108683230231070789ea36791010e0321333c00cc58210000000000810304000000030404000002c2050603291794220d100101f70fccf8
2016-04-15 17:58:15  WARN: [AAB7FDBA] error - Readable bytes exceeded - Need 282, maximum is 54 - IndexOutOfBoundsException (... < UlbotechProtocolDecoder:216 < ExtendedObjectDecoder:39 < ...)
2016-04-15 17:58:15  INFO: [AAB7FDBA] disconnected
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:49:11, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:01, lat: 52.50743, lon: 13.39189, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:49:06, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:49:16, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:56, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:41, lat: 52.50743, lon: 13.39190, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:47:56, lat: 52.50744, lon: 13.39190, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:36, lat: 52.50743, lon: 13.39189, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:06, lat: 52.50743, lon: 13.39188, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:11, lat: 52.50742, lon: 13.39188, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:16, lat: 52.50742, lon: 13.39188, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:26, lat: 52.50743, lon: 13.39189, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:31, lat: 52.50743, lon: 13.39189, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:51, lat: 52.50744, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:48:21, lat: 52.50742, lon: 13.39188, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:49:21, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:15  INFO: [AAB7FDBA] id: 1, time: 2016-04-15 10:49:01, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:47  INFO: [BAB23BFC] connected
2016-04-15 17:58:48 DEBUG: [BAB23BFC: 5072 < 109.45.3.236] HEX: f8010108683230231070789ea3673c010e0321333000cc58170000000000810304000000030404000002c20506032a178b220e1001013b17f8f8010108683230231070789ea36741010e0321332900cc58110000000000810304000000030404000002c20506032b178b220e100101774cf8f8010108683230231070789ea36746010e0321332300cc580c0000000000810304000000030404000002c20506032b178b220e100101a3def8f8010108683230231070789ea3674b010e0321332000cc580a0000000000810304000000030404000002c20506032a178b220e1001010791f8f8010108683230231070789ea36750010e0321331d00cc58080000000000810304000000030404000002c2050603291790220e100101b1acf8f8010108683230231070789ea36755010e0321331f00cc580b0000000000810304000000030404000002c205060326178b220e100101e655f8f8010108683230231070789ea3675a010e0321332400cc58130000000000810304000000030404000002c20506032b178b220e10010125a9f8f8010108683230231070789ea3675f010e0321332500cc58140000000000810304000000030404000002c20506032b1790220e1001013ba0f8f8010108683230231070789ea36764010e0321332700cc58150000000000810304000000030404000002c20506032b178b220e100101f96af8f8010108683230231070789ea36769010e0321332a00cc58170000000000810304000000030404000002c20506032a1790220e100101796ef8f8010108683230231070781ea3676e020bffffffffffffffffffff780304000000030404000002c20506032a1790220e100101ac72f8f8010108683230231070789ea36773010e0321333000cc58210000000000810304000000030404000002c2050603271790220e100101a2e7f8f8010108683230231070789ea36778010e0321333500cc58250000000000810304000000030404000002c20506032b1790220e1001017dd5f8f8010108683230231070789ea3677d010e0321333a00cc58260000000000810304000000030404000002c20506032a1790220e1001010044f8f8010108683230231070789ea36782010e0321333d00cc58270000000000810304000000030404000002c20506032b1798220d100101feadf8f8010108683230231070789ea36787010e0321333d00cc58260000000000810304000000030404000002c20506032b1794220d1001019806f8f8010108683230231070789ea3678c010e0321333c00cc58220000000000810304000000030404000002c20506032b1794220d1001010655f8f8010108683230231070789ea36791010e0321333c00cc58210000000000810304000000030404000002c2050603291794220d100101f70fccf8
2016-04-15 17:58:48  WARN: [BAB23BFC] error - Readable bytes exceeded - Need 282, maximum is 54 - IndexOutOfBoundsException (... < UlbotechProtocolDecoder:216 < ExtendedObjectDecoder:39 < ...)
2016-04-15 17:58:48  INFO: [BAB23BFC] disconnected
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:56, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:51, lat: 52.50744, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:49:01, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:49:06, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:47:56, lat: 52.50744, lon: 13.39190, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:49:16, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:49:21, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:21, lat: 52.50742, lon: 13.39188, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:01, lat: 52.50743, lon: 13.39189, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:06, lat: 52.50743, lon: 13.39188, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:31, lat: 52.50743, lon: 13.39189, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:11, lat: 52.50742, lon: 13.39188, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:16, lat: 52.50742, lon: 13.39188, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:41, lat: 52.50743, lon: 13.39190, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:26, lat: 52.50743, lon: 13.39189, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:48:36, lat: 52.50743, lon: 13.39189, speed: 0.0, course: 0.0
2016-04-15 17:58:48  INFO: [BAB23BFC] id: 1, time: 2016-04-15 10:49:11, lat: 52.50745, lon: 13.39191, speed: 0.0, course: 0.0

The device broadcasts older GPS fixes only, and again ...

Do you have any idea to fix it?

Anton Tananaev9 years ago

Problem is the same as before. Some messages are malformed.