Event save error, Update device status error and Failed to update device after upgrading from 3.7 to 4.1.

federico6 years ago

I am facing this issue after upgrading from 3.7 to 4.1.

2018-10-23 14:20:34  WARN: Event save error - Table 'traccardb.events' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:453 < NotificationManager:65 < ...)
2018-10-23 14:20:34  WARN: Update device status error - Table 'traccardb.user_device' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:333 < DeviceManager:249 < ...)
2018-10-23 14:20:35  WARN: Failed to update device - Table 'traccardb.user_device' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:348 < DeviceManager:277 < ...)

Anyone facing the same problem or maybe someone who can help?
The log is as follows:

Many thanks in advance...

2018-10-23 14:20:02  INFO: HikariPool-1 - Starting...
2018-10-23 14:20:03  INFO: HikariPool-1 - Start completed.
2018-10-23 14:20:05  INFO: Clearing database change log checksums
2018-10-23 14:20:05  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOGLOCK
2018-10-23 14:20:05  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOGLOCK
2018-10-23 14:20:05  INFO: SELECT `LOCKED` FROM traccardb.DATABASECHANGELOGLOCK WHERE ID=1
2018-10-23 14:20:05  INFO: Successfully acquired change log lock
2018-10-23 14:20:05  INFO: SELECT MD5SUM FROM traccardb.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2018-10-23 14:20:05  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = NULL
2018-10-23 14:20:05  INFO: Successfully released change log lock
2018-10-23 14:20:05  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOGLOCK
2018-10-23 14:20:05  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOGLOCK
2018-10-23 14:20:05  INFO: SELECT `LOCKED` FROM traccardb.DATABASECHANGELOGLOCK WHERE ID=1
2018-10-23 14:20:05  INFO: Successfully acquired change log lock
2018-10-23 14:20:09  INFO: SELECT MD5SUM FROM traccardb.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2018-10-23 14:20:09  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOG
2018-10-23 14:20:09  INFO: Reading from traccardb.DATABASECHANGELOG
2018-10-23 14:20:09  INFO: SELECT * FROM traccardb.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:ea6f202534dc7845fd1a49e1d8384d9c' WHERE ID = 'changelog-3.3' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.3'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:194e3ae7ec6d201917136e04a26e237b' WHERE ID = 'changelog-3.5' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.5'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:1ec7941b03749f24e365bc6126b07e1a' WHERE ID = 'changelog-3.6' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.6'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:2e444e379f31d0b8e09273ec7ffe87a0' WHERE ID = 'changelog-3.7' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:974c33d2fb399ef6477c3897450fb078' WHERE ID = 'changelog-3.7-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:74d68027951f8d2ae6bb2e24df8365bc' WHERE ID = 'changelog-3.8' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.8'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:34822842d65deb843a7d16f857d52ecc' WHERE ID = 'changelog-3.9' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.9'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:e1ddbe83e1ecf856a912755fc118f82e' WHERE ID = 'changelog-3.10' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:191c21d8f0f921845cf93bbc9d0639b9' WHERE ID = 'changelog-3.10-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:ad1f63566e8d08812fbf0b93a118ef6e' WHERE ID = 'changelog-3.10-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:127b36b9d32a9d236df51d19b18c3766' WHERE ID = 'changelog-3.7-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:7800f890b9706a480bd5a79b591b6ca7' WHERE ID = 'changelog-3.11' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.11'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:5ce520811d626ad325a014b9fcbb1a13' WHERE ID = 'changelog-3.12' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:a3bf7fabcde29e106fe2f89829a76a84' WHERE ID = 'changelog-3.12-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:cfc881bd2dadb561aa9c1a467bc8cc1c' WHERE ID = 'changelog-3.12-pgsql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:1be7e6c0520f8be53ef1b099d96afba5' WHERE ID = 'changelog-3.14' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.14'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:ac8ccec176027e98bbf45dc6c15d9b05' WHERE ID = 'changelog-3.15' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.15'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:b59407d70bfe9bf57bc9968adfbbdf1c' WHERE ID = 'changelog-3.16' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.16'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:3f14c3b08068eb7628d0d3e2941eb2d3' WHERE ID = 'changelog-3.3-admin' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.17'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:8aa3e56afe6ba86cd004fa801507bc28' WHERE ID = 'changelog-3.17' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.17'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:d59fa93049c031a8bcfbc02958c1942c' WHERE ID = 'changelog-4.0-clean' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0-clean'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:1adabae3238e02ccc97cc422359a58a0' WHERE ID = 'changelog-4.0-clean-common' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0-clean'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:3974bfe5a2e962c0cd663433c832c16a' WHERE ID = 'changelog-4.0-pre' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:65fb49c5be37693183708351c507dd50' WHERE ID = 'changelog-4.0-common' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:9831511507d8ae1d6759c8ccf506a27a' WHERE ID = 'changelog-4.0-pg' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:ac63c4153f5b2ee5c7a07056da269571' WHERE ID = 'changelog-4.0' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:90aedfa378aa717f8d8ae541f97b87b2' WHERE ID = 'changelog-4.0-renaming' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-23 14:20:10  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:b148f52efe9c6a3e74a56e33e257a3e2' WHERE ID = 'changelog-4.1-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.1'
2018-10-23 14:20:10  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOG
2018-10-23 14:20:10  INFO: Reading from traccardb.DATABASECHANGELOG
2018-10-23 14:20:10  INFO: SELECT * FROM traccardb.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2018-10-23 14:20:11  INFO: Successfully released change log lock
2018-10-23 14:20:11  INFO: Logging initialized @10324ms to org.eclipse.jetty.util.log.Slf4jLog
2018-10-23 14:20:13  INFO: Operating system name: Linux version: 4.4.0-138-generic architecture: amd64
2018-10-23 14:20:13  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 10.0.2-ojdkbuild+13
2018-10-23 14:20:13  INFO: Memory limit heap: 241mb non-heap: 0mb
2018-10-23 14:20:13  INFO: Character encoding: UTF-8 charset: UTF-8
2018-10-23 14:20:13  INFO: Version: 4.1-SNAPSHOT
2018-10-23 14:20:13  INFO: Starting server...
2018-10-23 14:20:14  INFO: jetty-9.4.12.v20180830; built: 2018-08-30T13:59:14.071Z; git: 27208684755d94a92186989f695db2d7b21ebc51; jvm 10.0.2-ojdkbuild+13
2018-10-23 14:20:14  INFO: Started o.t.w.@50cbcca7{/,null,AVAILABLE}
2018-10-23 14:20:14  INFO: DefaultSessionIdManager workerName=node0
2018-10-23 14:20:14  INFO: No SessionScavenger set, using defaults
2018-10-23 14:20:14  INFO: node0 Scavenging every 660000ms
2018-10-23 14:20:17  INFO: Started o.e.j.s.ServletContextHandler@25216999{/,null,AVAILABLE}
2018-10-23 14:20:17  INFO: Started ServerConnector@35439996{HTTP/1.1,[http/1.1]}{0.0.0.0:8082}
2018-10-23 14:20:17  INFO: Started @15849ms
2018-10-23 14:20:34  INFO: [1332a84c] connected
2018-10-23 14:20:34  INFO: [1332a84c: 5055 < 24.232.101.65] HEX: 474554202f3f69643d65333534363961633566323464306362266c61743d2d33342e35363736393538266c6f6e3d2d35382e343332353931382674696d653d323031382d31302d32335431373a32303a33332e3636335a2673706565643d302e302662656172696e673d302e3026616c7469747564653d302e3026707265636973696f6e3d32312e30343539393935323639373735342670726f766565646f723d6e6574776f726b26626174743d35382e302673657269616c3d4c47483836303362343030616437266163746976696461643d5354494c4c26736f757263653d4750534c6f6767657220485454502f312e310d0a436f6e74656e742d547970653a206170706c69636174696f6e2f782d7777772d666f726d2d75726c656e636f6465640d0a486f73743a20747261636b65722e716c69712e636f6d2e61723a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a557365722d4167656e743a206f6b687474702f332e372e300d0a0d0a
2018-10-23 14:20:34  INFO: [1332a84c: 5055 > 24.232.101.65] HEX: 485454502f312e3120323030204f4b0d0a636f6e74656e742d6c656e6774683a20300d0a0d0a
2018-10-23 14:20:34  WARN: Event save error - Table 'traccardb.events' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:453 < NotificationManager:65 < ...)
2018-10-23 14:20:34  WARN: Update device status error - Table 'traccardb.user_device' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:333 < DeviceManager:249 < ...)
2018-10-23 14:20:35  WARN: Failed to update device - Table 'traccardb.user_device' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:348 < DeviceManager:277 < ...)
2018-10-23 14:20:35  INFO: [1332a84c] id: e35469ac5f24d0cb, time: 2018-10-23 14:20:34, lat: -34.56770, lon: -58.43259, course: 0.0
2018-10-23 14:20:52  INFO: [998da478] connected
2018-10-23 14:21:08  INFO: [34573058] connected
2018-10-23 14:21:38  INFO: [875475d4] connected
Anton Tananaev6 years ago

I suspect you have a problem with config file. Remember that you can't just take old configuration and expect it to work with new version of Traccar.

federico6 years ago

Hi Anton,
Thanks for your answr. I thought it could work. Here is my traccar.xml file. Do you see somethink that could be wrong?
(default.xml is untouched)

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>

<properties>

    <!--

    This is the main configuration file. All your configuration parameters should be placed in this file.

    Default configuration parameters are located in the "default.xml" file. You should not modify it to avoid issues
    with upgrading to a new version. Parameters in the main config file override values in the default file. Do not
    remove "config.default" parameter from this file unless you know what you are doing.

    For list of available parameters see following page: https://www.traccar.org/configuration-file/

    -->

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

     <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
    <entry key='database.url'>jdbc:mysql://localhost:3306/traccardb?allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=ANSI_QUOTES</entry>
    <entry key='database.user'>xxxxx</entry>
    <entry key='database.password'>xxxxxxx</entry>
    <entry key='database.positionsHistoryDays'>180</entry>

    <entry key='forward.enable'>true</entry>
    <!-- <entry key='forward.url'>http://201.235.138.21:5055/?id={uniqueId};lat={latitude};lon={longitude};source=Fede</entry> -->
    <entry key='forward.url'>http://192.168.1.22:8123/api/gpslogger?latitude={latitude};longitude={longitude};device={uniqueId};accuracy=24.899999618530273;battery=58.0;speed={speed};direction={con={course};altitude={altitude};provider=GPS;activity=STILL;api_password=pAnAmA192</entry>

<!-- MAIL NOTIF CONFIG -->
 <entry key='mail.smtp.host'>smtp.gmail.com</entry>
 <!--for STARTTLS -->
    <!-- <entry key='mail.smtp.port'>587</entry> -->
    <!-- <entry key='mail.smtp.starttls.enable'>true</entry> -->
 <!-- for SSL -->
    <entry key='mail.smtp.port'>465</entry>
    <entry key='mail.smtp.ssl.enable'>true</entry>
    <entry key='mail.smtp.from'>xxxxx@xxxx.com.ar</entry>
    <entry key='mail.smtp.auth'>true</entry>
    <entry key='mail.smtp.username'>xxxx@xxx.com.ar</entry>
    <entry key='mail.smtp.password'>xxxxx</entry>
 <!-- SMPP CONFIG -->
 <entry key='sms.smpp.enable'>true</entry>
    <entry key='mail.smtp.from'>xxxx@xxxx.com.ar</entry>
    <entry key='mail.smtp.auth'>true</entry>
    <entry key='mail.smtp.username'>xxxx@xxxx.com.ar</entry>
    <entry key='mail.smtp.password'>xxxxxx</entry>
 <!-- SMPP CONFIG -->
 <entry key='sms.smpp.enable'>true</entry>
 <!-- <entry key='sms.smpp.version'>3.4</entry> -->
 <entry key='sms.smpp.host'>192.168.1.13</entry>
 <entry key='sms.smpp.port'>2775</entry>
 <entry key='sms.smpp.username'>xxxx</entry>
 <entry key='sms.smpp.password'>xxxxx</entry>
 <!-- <entry key='sms.smpp.sourceAddress'>5491144030004</entry> -->
 <entry key='sms.smpp.notificationsCharset'>GSM</entry>
 <entry key='sms.smpp.notificationsDataCoding'>0</entry>

</properties>

I see in error messages that the table that is referenced really does not exist because the prefix is missing.
This is an example of error message:

Failed to update device - Table 'traccardb.user_device' doesn't exist

And table in database exist as traccardb.**tc_**user_device with the "tc_" prefix
But I don´t know how to fix it. Maybe the DATABASECHANGELOG is usefull for you as reference.

Thank you very much for your help.

# ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, EXECTYPE, MD5SUM, DESCRIPTION, COMMENTS, TAG, LIQUIBASE, CONTEXTS, LABELS, DEPLOYMENT_ID
changelog-3.3, author, changelog-3.3, 2016-08-09 14:07:24, 1, EXECUTED, 8:ea6f202534dc7845fd1a49e1d8384d9c, createTable tableName=users; addUniqueConstraint constraintName=uk_user_email, tableName=users; createTable tableName=devices; addUniqueConstraint constraintName=uk_device_uniqueid, tableName=devices; createTable tableName=user_device; addForeignK..., , , 3.5.1, , , 0762443562
changelog-3.5, author, changelog-3.5, 2016-08-09 14:07:24, 2, EXECUTED, 8:194e3ae7ec6d201917136e04a26e237b, createTable tableName=groups; createTable tableName=user_group; addForeignKeyConstraint baseTableName=user_group, constraintName=fk_user_group_userid, referencedTableName=users; addForeignKeyConstraint baseTableName=user_group, constraintName=fk_u..., , , 3.5.1, , , 0762443562
changelog-3.6, author, changelog-3.6, 2016-08-09 14:07:25, 3, EXECUTED, 8:1ec7941b03749f24e365bc6126b07e1a, createTable tableName=events; addForeignKeyConstraint baseTableName=events, constraintName=fk_event_deviceid, referencedTableName=devices; addColumn tableName=devices; createTable tableName=geofences; createTable tableName=user_geofence; addForeig..., , , 3.5.1, , , 0762443562
changelog-3.7, author, changelog-3.7, 2016-11-19 18:39:05, 4, EXECUTED, 8:2e444e379f31d0b8e09273ec7ffe87a0, update tableName=devices; addForeignKeyConstraint baseTableName=devices, constraintName=fk_device_group_groupid, referencedTableName=groups; update tableName=groups; addColumn tableName=devices; dropColumn columnName=motion, tableName=devices; dro..., , , 3.5.3, , , 9591544770
changelog-3.7-notmssql, author, changelog-3.7, 2016-11-19 18:39:05, 5, EXECUTED, 8:974c33d2fb399ef6477c3897450fb078, addForeignKeyConstraint baseTableName=groups, constraintName=fk_group_group_groupid, referencedTableName=groups, , , 3.5.3, , , 9591544770
changelog-3.8, author, changelog-3.8, 2016-11-19 18:39:25, 6, EXECUTED, 8:74d68027951f8d2ae6bb2e24df8365bc, createTable tableName=attribute_aliases; addForeignKeyConstraint baseTableName=attribute_aliases, constraintName=fk_attribute_aliases_deviceid, referencedTableName=devices; addUniqueConstraint constraintName=uk_deviceid_attribute, tableName=attrib..., , , 3.5.3, , , 9591544770
changelog-3.8-dropuniquetoken, author, changelog-3.8, 2017-02-15 21:54:43, 7, EXECUTED, , dropUniqueConstraint constraintName=uk_user_token, tableName=users, , , 3.5.3, , , 7206483730
changelog-3.9, author, changelog-3.9, 2017-02-15 21:54:44, 8, EXECUTED, 8:34822842d65deb843a7d16f857d52ecc, addColumn tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications, , , 3.5.3, , , 7206483730
changelog-3.10, author, changelog-3.10, 2017-02-15 21:54:58, 9, EXECUTED, 8:e1ddbe83e1ecf856a912755fc118f82e, createTable tableName=calendars; createTable tableName=user_calendar; addForeignKeyConstraint baseTableName=user_calendar, constraintName=fk_user_calendar_userid, referencedTableName=users; addForeignKeyConstraint baseTableName=user_calendar, cons..., , , 3.5.3, , , 7206483730
changelog-3.10-notmssql, author, changelog-3.10, 2017-02-15 21:54:58, 10, EXECUTED, 8:191c21d8f0f921845cf93bbc9d0639b9, addForeignKeyConstraint baseTableName=user_user, constraintName=fk_user_user_manageduserid, referencedTableName=users, , , 3.5.3, , , 7206483730
changelog-3.10-mssql, author, changelog-3.10, 2017-02-15 21:54:58, 11, MARK_RAN, 8:ad1f63566e8d08812fbf0b93a118ef6e, sql, , , 3.5.3, , , 7206483730
changelog-3.7-mssql, author, changelog-3.10, 2017-02-15 21:54:58, 12, MARK_RAN, 8:127b36b9d32a9d236df51d19b18c3766, sql, , , 3.5.3, , , 7206483730
changelog-3.11, author, changelog-3.11, 2017-04-14 08:27:32, 13, EXECUTED, 8:7800f890b9706a480bd5a79b591b6ca7, addColumn tableName=users; addColumn tableName=notifications; addColumn tableName=server; addColumn tableName=server; addColumn tableName=users, , , 3.5.3, , , 2169251380
changelog-3.12, author, changelog-3.12, 2017-07-09 00:49:05, 14, EXECUTED, 8:5ce520811d626ad325a014b9fcbb1a13, addColumn tableName=statistics; createTable tableName=attributes; createTable tableName=user_attribute; addForeignKeyConstraint baseTableName=user_attribute, constraintName=fk_user_attribute_userid, referencedTableName=users; addForeignKeyConstrai..., , , 3.5.3, , , 9572143623
changelog-3.12-notmssql, author, changelog-3.12, 2017-07-09 00:49:05, 15, EXECUTED, 8:a3bf7fabcde29e106fe2f89829a76a84, dropForeignKeyConstraint baseTableName=groups, constraintName=fk_group_group_groupid; addForeignKeyConstraint baseTableName=groups, constraintName=fk_groups_groupid, referencedTableName=groups, , , 3.5.3, , , 9572143623
changelog-3.12-pgsql, author, changelog-3.12, 2017-07-09 00:49:05, 16, MARK_RAN, 8:cfc881bd2dadb561aa9c1a467bc8cc1c, dropColumn columnName=data, tableName=calendars; addColumn tableName=calendars, , , 3.5.3, , , 9572143623
changelog-3.14, author, changelog-3.14, 2017-09-02 20:44:19, 17, EXECUTED, 8:1be7e6c0520f8be53ef1b099d96afba5, createTable tableName=drivers; addUniqueConstraint constraintName=uk_driver_uniqueid, tableName=drivers; createTable tableName=user_driver; addForeignKeyConstraint baseTableName=user_driver, constraintName=fk_user_driver_userid, referencedTableNam..., , , 3.5.3, , , 4395858259
changelog-3.15, author, changelog-3.15, 2017-12-10 16:30:33, 18, EXECUTED, 8:ac8ccec176027e98bbf45dc6c15d9b05, dropForeignKeyConstraint baseTableName=attribute_aliases, constraintName=fk_attribute_aliases_deviceid; dropUniqueConstraint constraintName=uk_deviceid_attribute, tableName=attribute_aliases; dropTable tableName=attribute_aliases; dropColumn colum..., , , 3.5.3, , , 2934231717
changelog-3.16, author, changelog-3.16, 2018-03-11 08:57:44, 19, EXECUTED, 8:b59407d70bfe9bf57bc9968adfbbdf1c, addColumn tableName=devices; addColumn tableName=users; addColumn tableName=servers; addColumn tableName=notifications; addForeignKeyConstraint baseTableName=notifications, constraintName=fk_notification_calendar_calendarid, referencedTableName=ca..., , , 3.5.4, , , 0769463927
changelog-3.3-admin, author, changelog-3.17, 2018-05-27 15:12:44, 20, EXECUTED, 8:3f14c3b08068eb7628d0d3e2941eb2d3, renameColumn newColumnName=administrator, oldColumnName=admin, tableName=users, , , 3.6.1, , , 7444763864
changelog-3.17, author, changelog-3.17, 2018-05-27 15:12:48, 21, EXECUTED, 8:8aa3e56afe6ba86cd004fa801507bc28, addColumn tableName=events; createTable tableName=maintenances; createTable tableName=user_maintenance; addForeignKeyConstraint baseTableName=user_maintenance, constraintName=fk_user_maintenance_userid, referencedTableName=users; addForeignKeyCons..., , , 3.6.1, , , 7444763864
changelog-4.0-clean, author, changelog-4.0-clean, 2018-10-23 13:22:25, 22, MARK_RAN, 8:d59fa93049c031a8bcfbc02958c1942c, createTable tableName=tc_attributes; createTable tableName=tc_calendars; createTable tableName=tc_commands; createTable tableName=tc_device_attribute; createTable tableName=tc_device_command; createTable tableName=tc_device_driver; createTable tab..., , , 3.6.2, , , 0311745620
changelog-4.0-clean-common, author, changelog-4.0-clean, 2018-10-23 13:22:26, 23, MARK_RAN, 8:1adabae3238e02ccc97cc422359a58a0, addForeignKeyConstraint baseTableName=tc_groups, constraintName=fk_groups_groupid, referencedTableName=tc_groups; addForeignKeyConstraint baseTableName=tc_user_user, constraintName=fk_user_user_manageduserid, referencedTableName=tc_users, , , 3.6.2, , , 0311745620
changelog-4.0-clean-mssql, author, changelog-4.0-clean, 2018-10-23 13:22:26, 24, MARK_RAN, , sql; sql; sql; sql, , , 3.6.2, , , 0311745620
changelog-4.0-pre, author, changelog-4.0, 2018-10-23 13:22:26, 25, EXECUTED, 8:3974bfe5a2e962c0cd663433c832c16a, addColumn tableName=notifications, , , 3.6.2, , , 0311745620
changelog-4.0-common, author, changelog-4.0, 2018-10-23 13:22:26, 26, EXECUTED, 8:65fb49c5be37693183708351c507dd50, update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications, , , 3.6.2, , , 0311745620
changelog-4.0-pg, author, changelog-4.0, 2018-10-23 13:22:26, 27, MARK_RAN, 8:9831511507d8ae1d6759c8ccf506a27a, update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications, , , 3.6.2, , , 0311745620
changelog-4.0, author, changelog-4.0, 2018-10-23 13:22:26, 28, EXECUTED, 8:ac63c4153f5b2ee5c7a07056da269571, dropDefaultValue columnName=web, tableName=notifications; dropColumn columnName=web, tableName=notifications; dropDefaultValue columnName=mail, tableName=notifications; dropColumn columnName=mail, tableName=notifications; dropDefaultValue columnNa..., , , 3.6.2, , , 0311745620
changelog-4.0-renaming, author, changelog-4.0, 2018-10-23 13:22:28, 29, EXECUTED, 8:90aedfa378aa717f8d8ae541f97b87b2, renameTable newTableName=tc_attributes, oldTableName=attributes; renameTable newTableName=tc_calendars, oldTableName=calendars; renameTable newTableName=tc_commands, oldTableName=commands; renameTable newTableName=tc_device_attribute, oldTableName..., , , 3.6.2, , , 0311745620
changelog-4.1-mssql, author, changelog-4.1, 2018-10-23 13:52:42, 30, MARK_RAN, 8:b148f52efe9c6a3e74a56e33e257a3e2, sql; sql; sql; sql, , , 3.6.2, , , 0313562141
Anton Tananaev6 years ago

What's in default.xml file?

federico6 years ago

This is default.xml file:

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>

<properties>

    <!--

    DO NOT MODIFY THIS FILE. Use traccar.xml instead.

    -->

    <entry key='web.enable'>true</entry>
    <entry key='web.port'>8082</entry>
...
    <entry key='database.ignoreUnknown'>true</entry>
    <entry key='database.generateQueries'>true</entry>
    <entry key='database.changelog'>./schema/changelog-master.xml</entry>

    <entry key='database.loginUser'>
        SELECT * FROM tc_users
        WHERE email = :email OR login = :email
    </entry>

    <entry key='database.selectPositions'>
        SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime BETWEEN :from AND :to ORDER BY fixTime
    </entry>

    <entry key='database.selectLatestPositions'>
        SELECT tc_positions.* FROM tc_positions INNER JOIN tc_devices ON tc_positions.id = tc_devices.positionid;
    </entry>

    <entry key='database.updateLatestPosition'>
        UPDATE tc_devices SET positionId = :id WHERE id = :deviceId
    </entry>

    <entry key='database.selectEvents'>
        SELECT * FROM tc_events WHERE deviceId = :deviceId AND serverTime BETWEEN :from AND :to ORDER BY serverTime
    </entry>

    <entry key='database.deletePositions'>
        DELETE FROM tc_positions WHERE serverTime &lt; :serverTime AND id NOT IN (SELECT positionId FROM tc_devices WHERE positionId IS NOT NULL)
    </entry>

    <entry key='database.deleteEvents'>
        DELETE FROM tc_events WHERE serverTime &lt; :serverTime
    </entry>

    <entry key='database.selectStatistics'>
        SELECT * FROM tc_statistics WHERE captureTime BETWEEN :from AND :to ORDER BY captureTime
    </entry>

    <entry key='gps103.port'>5001</entry>
...
    <entry key='its.port'>5179</entry>

</properties>
Anton Tananaev6 years ago

Config looks fine. The issue must be somewhere else.

federico6 years ago

Any clue where to look?

Anton Tananaev6 years ago

I suspect that you are just not using official release.

federico6 years ago

I am using all official. I have no skills to make any changes or touch the code.

Anton Tananaev6 years ago

I would need access to your server to take a look.

federico6 years ago

ssh: [REMOVED]
user: [REMOVED]
Pwd: [REMOVED]

Anton Tananaev6 years ago

Have you updated your stored procedures in MySQL? Probably you should've mentioned that you have them. It would have saved both of us some time.

federico6 years ago

I did it Now.
I updated the SPs and everything seems to be working fine now.
Thank you very much!

federico6 years ago

Sorry, but not everything, I don´t know why SMPP is not connecting (to Kannel)

Here is the config that works ok on v3.17:

 <!-- SMPP CONFIG -->
 <entry key='sms.smpp.enable'>true</entry>
 <!-- <entry key='sms.smpp.version'>3.4</entry> -->
 <entry key='sms.smpp.version'>3.4</entry>
 <entry key='sms.smpp.host'>192.168.1.13</entry>
 <entry key='sms.smpp.port'>2775</entry>
 <entry key='sms.smpp.username'>xxxxxx</entry>
 <entry key='sms.smpp.password'>xxxxxx</entry>
 <!-- <entry key='sms.smpp.sourceAddress'>5491144030004</entry> -->
 <entry key='sms.smpp.sourceAddress'>5491144030004</entry>
 <entry key='sms.smpp.notificationsCharset'>GSM</entry>
 <entry key='sms.smpp.notificationsDataCoding'>0</entry>

And I don´t see enything in the log

federico@Tracker:~$ sudo systemctl stop traccar.service
federico@Tracker:~$ sudo systemctl start traccar.service
federico@Tracker:~$ sudo tail -f  /opt/traccar/logs/tracker-server.log
2018-10-24 12:52:50  INFO: [8c567847] id: 926880, time: 2018-10-24 12:52:54, lat: -36.76562, lon: -59.86909, course: 0.0, accuracy: 20.6
2018-10-24 12:52:51  INFO: [937a2378: 5013 < 186.12.4.123] HEX: 2a48512c313630303036333236382c56312c3135353234382c412c333634362e353431302c532c30353935312e383137302c572c3030372e352c3034342e39342c3234313031382c464646464646464623
2018-10-24 12:52:51  INFO: [937a2378: 5013 > 186.12.4.123] HEX: 2a48512c313630303036333236382c56342c56312c323031383130323431353532353123
2018-10-24 12:52:51  INFO: [937a2378] id: 1600063268, time: 2018-10-24 12:52:48, lat: -36.77568, lon: -59.86362, speed: 7.5, course: 44.9
2018-10-24 12:53:19  INFO: [937a2378: 5013 < 186.12.4.123] HEX: 2a48512c313630303036333236382c56312c3135353331382c412c333634362e343939342c532c30353935312e373636342c572c3030302e302c3034352e38312c3234313031382c464646464646464623
2018-10-24 12:53:19  INFO: [937a2378: 5013 > 186.12.4.123] HEX: 2a48512c313630303036333236382c56342c56312c323031383130323431353533313923
2018-10-24 12:53:19  INFO: [937a2378] id: 1600063268, time: 2018-10-24 12:53:18, lat: -36.77499, lon: -59.86277, course: 45.8
2018-10-24 12:53:27  INFO: [bd2eadaa] connected
2018-10-24 12:53:37  INFO: HikariPool-1 - Starting...
2018-10-24 12:53:38  INFO: HikariPool-1 - Start completed.
2018-10-24 12:53:39  INFO: Clearing database change log checksums
2018-10-24 12:53:39  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOGLOCK
2018-10-24 12:53:39  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOGLOCK
2018-10-24 12:53:39  INFO: SELECT `LOCKED` FROM traccardb.DATABASECHANGELOGLOCK WHERE ID=1
2018-10-24 12:53:39  INFO: Successfully acquired change log lock
2018-10-24 12:53:39  INFO: SELECT MD5SUM FROM traccardb.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2018-10-24 12:53:39  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = NULL
2018-10-24 12:53:39  INFO: Successfully released change log lock
2018-10-24 12:53:39  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOGLOCK
2018-10-24 12:53:39  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOGLOCK
2018-10-24 12:53:39  INFO: SELECT `LOCKED` FROM traccardb.DATABASECHANGELOGLOCK WHERE ID=1
2018-10-24 12:53:39  INFO: Successfully acquired change log lock
2018-10-24 12:53:43  INFO: SELECT MD5SUM FROM traccardb.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2018-10-24 12:53:43  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOG
2018-10-24 12:53:43  INFO: Reading from traccardb.DATABASECHANGELOG
2018-10-24 12:53:43  INFO: SELECT * FROM traccardb.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:ea6f202534dc7845fd1a49e1d8384d9c' WHERE ID = 'changelog-3.3' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.3'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:194e3ae7ec6d201917136e04a26e237b' WHERE ID = 'changelog-3.5' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.5'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:1ec7941b03749f24e365bc6126b07e1a' WHERE ID = 'changelog-3.6' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.6'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:2e444e379f31d0b8e09273ec7ffe87a0' WHERE ID = 'changelog-3.7' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:974c33d2fb399ef6477c3897450fb078' WHERE ID = 'changelog-3.7-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:74d68027951f8d2ae6bb2e24df8365bc' WHERE ID = 'changelog-3.8' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.8'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:34822842d65deb843a7d16f857d52ecc' WHERE ID = 'changelog-3.9' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.9'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:e1ddbe83e1ecf856a912755fc118f82e' WHERE ID = 'changelog-3.10' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:191c21d8f0f921845cf93bbc9d0639b9' WHERE ID = 'changelog-3.10-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:ad1f63566e8d08812fbf0b93a118ef6e' WHERE ID = 'changelog-3.10-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:127b36b9d32a9d236df51d19b18c3766' WHERE ID = 'changelog-3.7-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:7800f890b9706a480bd5a79b591b6ca7' WHERE ID = 'changelog-3.11' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.11'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:5ce520811d626ad325a014b9fcbb1a13' WHERE ID = 'changelog-3.12' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:a3bf7fabcde29e106fe2f89829a76a84' WHERE ID = 'changelog-3.12-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:cfc881bd2dadb561aa9c1a467bc8cc1c' WHERE ID = 'changelog-3.12-pgsql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:1be7e6c0520f8be53ef1b099d96afba5' WHERE ID = 'changelog-3.14' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.14'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:ac8ccec176027e98bbf45dc6c15d9b05' WHERE ID = 'changelog-3.15' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.15'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:b59407d70bfe9bf57bc9968adfbbdf1c' WHERE ID = 'changelog-3.16' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.16'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:3f14c3b08068eb7628d0d3e2941eb2d3' WHERE ID = 'changelog-3.3-admin' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.17'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:8aa3e56afe6ba86cd004fa801507bc28' WHERE ID = 'changelog-3.17' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.17'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:d59fa93049c031a8bcfbc02958c1942c' WHERE ID = 'changelog-4.0-clean' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0-clean'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:1adabae3238e02ccc97cc422359a58a0' WHERE ID = 'changelog-4.0-clean-common' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0-clean'
2018-10-24 12:53:44  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:3974bfe5a2e962c0cd663433c832c16a' WHERE ID = 'changelog-4.0-pre' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-24 12:53:45  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:65fb49c5be37693183708351c507dd50' WHERE ID = 'changelog-4.0-common' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-24 12:53:45  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:9831511507d8ae1d6759c8ccf506a27a' WHERE ID = 'changelog-4.0-pg' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-24 12:53:45  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:ac63c4153f5b2ee5c7a07056da269571' WHERE ID = 'changelog-4.0' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-24 12:53:45  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:90aedfa378aa717f8d8ae541f97b87b2' WHERE ID = 'changelog-4.0-renaming' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-24 12:53:45  INFO: UPDATE traccardb.DATABASECHANGELOG SET MD5SUM = '8:b148f52efe9c6a3e74a56e33e257a3e2' WHERE ID = 'changelog-4.1-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.1'
2018-10-24 12:53:45  INFO: SELECT COUNT(*) FROM traccardb.DATABASECHANGELOG
2018-10-24 12:53:45  INFO: Reading from traccardb.DATABASECHANGELOG
2018-10-24 12:53:45  INFO: SELECT * FROM traccardb.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2018-10-24 12:53:45  INFO: Successfully released change log lock
2018-10-24 12:53:45  INFO: Logging initialized @9548ms to org.eclipse.jetty.util.log.Slf4jLog
2018-10-24 12:53:47  INFO: Operating system name: Linux version: 4.4.0-138-generic architecture: amd64
2018-10-24 12:53:47  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 10.0.2-ojdkbuild+13
2018-10-24 12:53:47  INFO: Memory limit heap: 241mb non-heap: 0mb
2018-10-24 12:53:47  INFO: Character encoding: UTF-8 charset: UTF-8
2018-10-24 12:53:47  INFO: Version: 4.1-SNAPSHOT
2018-10-24 12:53:47  INFO: Starting server...
2018-10-24 12:53:48  INFO: jetty-9.4.12.v20180830; built: 2018-08-30T13:59:14.071Z; git: 27208684755d94a92186989f695db2d7b21ebc51; jvm 10.0.2-ojdkbuild+13
2018-10-24 12:53:48  INFO: Started o.t.w.@50cbcca7{/,null,AVAILABLE}
2018-10-24 12:53:48  INFO: DefaultSessionIdManager workerName=node0
2018-10-24 12:53:48  INFO: No SessionScavenger set, using defaults
2018-10-24 12:53:48  INFO: node0 Scavenging every 600000ms
2018-10-24 12:53:50  INFO: [94365337] connected
2018-10-24 12:53:50  INFO: Started o.e.j.s.ServletContextHandler@25216999{/,null,AVAILABLE}
2018-10-24 12:53:50  INFO: Started ServerConnector@6b98d958{HTTP/1.1,[http/1.1]}{0.0.0.0:8082}
2018-10-24 12:53:50  INFO: Started @14783ms
2018-10-24 12:54:07  INFO: [2826aab7] connected
2018-10-24 12:54:07  INFO: [2826aab7: 5055 < 181.228.69.8] HEX: 474554202f3f69643d366334343232336663333864343061332674696d657374616d703d31353430333936343437266c61743d2d33342e3432323433266c6f6e3d2d35382e3537343230303030303030303030352673706565643d302e302662656172696e673d3137382e333939393933383936343834333826616c7469747564653d31372e3926626174743d35342e3020485454502f312e310d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420362e302e313b20534d2d473533324d204275696c642f4d4d42323954290d0a486f73743a20747261636b65722e716c69712e636f6d2e61723a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a0d0a
2018-10-24 12:54:07  INFO: [2826aab7: 5055 > 181.228.69.8] HEX: 485454502f312e3120323030204f4b0d0a636f6e74656e742d6c656e6774683a20300d0a0d0a
2018-10-24 12:54:07  INFO: [2826aab7] id: 6c44223fc38d40a3, time: 2018-10-24 12:54:07, lat: -34.42243, lon: -58.57420, course: 178.4
2018-10-24 12:54:13  INFO: [84de0a75] connected
2018-10-24 12:54:35  INFO: [993bdad0] connected
2018-10-24 12:54:48  INFO: [aab3a9c2] connected
2018-10-24 12:54:50  INFO: [aab3a9c2: 5013 < 181.117.224.78] HEX: 2a48512c313630303036333236382c56312c3135353334372c412c333634362e343537342c532c30353935312e373136352c572c3031362e382c3034332e37392c3234313031382c464646464646464623
2018-10-24 12:54:50  INFO: [aab3a9c2: 5013 > 181.117.224.78] HEX: 2a48512c313630303036333236382c56342c56312c323031383130323431353534353023
2018-10-24 12:54:50  INFO: [aab3a9c2] id: 1600063268, time: 2018-10-24 12:53:47, lat: -36.77429, lon: -59.86194, speed: 16.8, course: 43.8
2018-10-24 12:54:51  INFO: [aab3a9c2: 5013 < 181.117.224.78] HEX: 2a48512c313630303036333236382c56312c3135353431372c412c333634362e333635372c532c30353935312e363037302c572c3031322e362c3034332e33302c3234313031382c464646464646464623
2018-10-24 12:54:51  INFO: [aab3a9c2: 5013 > 181.117.224.78] HEX: 2a48512c313630303036333236382c56342c56312c323031383130323431353534353123
2018-10-24 12:54:51  INFO: [aab3a9c2] id: 1600063268, time: 2018-10-24 12:54:17, lat: -36.77276, lon: -59.86012, speed: 12.6, course: 43.3
2018-10-24 12:54:52  INFO: [aab3a9c2: 5013 < 181.117.224.78] HEX: 2a48512c313630303036333236382c56312c3135353434372c412c333634362e323834392c532c30353935312e353038312c572c3031302e382c3034342e31392c3234313031382c464646464646464623
2018-10-24 12:54:52  INFO: [aab3a9c2: 5013 > 181.117.224.78] HEX: 2a48512c313630303036333236382c56342c56312c323031383130323431353534353223
2018-10-24 12:54:52  INFO: [aab3a9c2] id: 1600063268, time: 2018-10-24 12:54:47, lat: -36.77142, lon: -59.85847, speed: 10.8, course: 44.2
2018-10-24 12:54:58  INFO: [c4821142] connected
2018-10-24 12:55:04  INFO: [87c014e9] connected
2018-10-24 12:55:04  INFO: [87c014e9: 5055 < 192.168.1.1] HEX: 504f5354202f3f69643d6565663438333966633939623364662674696d657374616d703d31353430333936353032266c61743d2d33362e37363536313932266c6f6e3d2d35392e383639313133362673706565643d302e302662656172696e673d302e3026616c7469747564653d302e302661636375726163793d31392e36383739393937323533343137393726626174743d32362e3020485454502f312e310d0a436f6e74656e742d547970653a206170706c69636174696f6e2f782d7777772d666f726d2d75726c656e636f6465640d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420362e302e313b20534d2d473533324d204275696c642f4d4d42323954290d0a486f73743a20747261636b65722e716c69712e636f6d2e61723a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2018-10-24 12:55:04  INFO: [87c014e9: 5055 > 192.168.1.1] HEX: 485454502f312e3120323030204f4b0d0a636f6e74656e742d6c656e6774683a20300d0a0d0a
2018-10-24 12:55:04  INFO: [87c014e9] id: eef4839fc99b3df, time: 2018-10-24 12:55:02, lat: -36.76562, lon: -59.86911, course: 0.0, accuracy: 19.7
2018-10-24 12:55:19  INFO: [aab3a9c2: 5013 < 181.117.224.78] HEX: 2a48512c313630303036333236382c56312c3135353531382c412c333634362e313832332c532c30353935312e333834372c572c3031352e342c3034352e30302c3234313031382c464646464646464623
2018-10-24 12:55:19  INFO: [aab3a9c2: 5013 > 181.117.224.78] HEX: 2a48512c313630303036333236382c56342c56312c323031383130323431353535313923
2018-10-24 12:55:19  INFO: [aab3a9c2] id: 1600063268, time: 2018-10-24 12:55:18, lat: -36.76971, lon: -59.85641, speed: 15.4, course: 45.0
2018-10-24 12:55:20  INFO: [38989ce5] connected
2018-10-24 12:55:44  INFO: [4a561c7f] connected
^C
federico6 years ago

Solved adding sms to notificator.types and also adding <entry key='sms.enable'>true</entry>

should I remove <entry key='sms.smpp.enable'>true</entry> ?

Thanks and regards.