{"action":"created","issue":{"url":"https://api.github.com/repos/tananaev/traccar/issues/2383","repository_url":"https://api.github.com/repos/tananaev/traccar","labels_url":"https://api.github.com/repos/tananaev/traccar/issues/2383/labels{/name}","comments_url":"https://api.github.com/repos/tananaev/traccar/issues/2383/comments","events_url":"https://api.github.com/repos/tananaev/traccar/issues/2383/events","html_url":"https://github.com/tananaev/traccar/issues/2383","id":179968038,"number":2383,"title":"Traccar 3.7 - OpenGTS 2.6.2 integration","user":{"login":"marianilie","id":20853749,"avatar_url":"https://avatars.githubusercontent.com/u/20853749?v=3","gravatar_id":"","url":"https://api.github.com/users/marianilie","html_url":"https://github.com/marianilie","followers_url":"https://api.github.com/users/marianilie/followers","following_url":"https://api.github.com/users/marianilie/following{/other_user}","gists_url":"https://api.github.com/users/marianilie/gists{/gist_id}","starred_url":"https://api.github.com/users/marianilie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marianilie/subscriptions","organizations_url":"https://api.github.com/users/marianilie/orgs","repos_url":"https://api.github.com/users/marianilie/repos","events_url":"https://api.github.com/users/marianilie/events{/privacy}","received_events_url":"https://api.github.com/users/marianilie/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-09-29T07:02:31Z","updated_at":"2016-09-29T08:52:15Z","closed_at":"2016-09-29T08:52:15Z","body":"Hello,\r\nI'm tring to integrate Traccar witg OpenGTS. I can see the device on the OpenGTS map but i have some errors in log file:\r\n```\r\n2016-09-29 09:30:56  INFO: Operating system name: Linux version: 4.4.0-38-generic architecture: amd64\r\n2016-09-29 09:30:56  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 25.91-b14\r\n2016-09-29 09:30:56  INFO: Memory limit heap: 955mb non-heap: 0mb\r\n2016-09-29 09:30:56  INFO: Character encoding: UTF-8 charset: UTF-8\r\n2016-09-29 09:30:56  INFO: Version: 3.7-SNAPSHOT\r\n2016-09-29 09:30:58  INFO: Query not provided: database.selectGroupsAll\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectLatestPositions\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectServers\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectUsersAll\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectGroupsAll\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectGroupPermissions\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectDevicePermissions\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectGroupsAll\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectGeofencesAll\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectGeofencePermissions\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectGroupGeofences\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectDeviceGeofences\r\n2016-09-29 09:30:59  INFO: Query not provided: database.selectNotifications\r\n2016-09-29 09:31:01  INFO: Starting server...\r\n2016-09-29 09:36:03  INFO: [C81EDA5E] connected\r\n2016-09-29 09:36:03 DEBUG: [C81EDA5E: 5013 < 192.168.0.3] HEX: 2a48512c323232323232323232322c56312c3037333330302c412c343433342e333234352c4e2c30323535312e303236332c452c3030302e302c3134372c3239303931362c464646464646464623\r\n2016-09-29 09:36:03  INFO: Query not provided: database.insertEvent\r\n2016-09-29 09:36:03  INFO: Query not provided: database.updateDeviceStatus\r\n2016-09-29 09:36:03  WARN: [C81EDA5E] error - NullPointerException (DeviceManager:342 < OverspeedEventHandler:51 < BaseEventHandler:28 < ...)\r\n2016-09-29 09:36:03  INFO: [C81EDA5E] disconnected\r\n2016-09-29 09:36:03  INFO: Query not provided: database.insertEvent\r\n2016-09-29 09:36:03  INFO: Query not provided: database.updateDeviceStatus\r\n2016-09-29 09:38:15  INFO: [185868D8] connected\r\n2016-09-29 09:38:15 DEBUG: [185868D8: 5013 < 192.168.0.3] HEX: 2a48512c323232323232323232322c56312c3037333830302c412c343434342e333234352c4e2c30323535312e303236332c452c3031312e302c3134372c3239303931362c464646464646464623\r\n2016-09-29 09:38:15  INFO: Query not provided: database.insertEvent\r\n2016-09-29 09:38:15  INFO: Query not provided: database.updateDeviceStatus\r\n2016-09-29 09:38:15  WARN: [185868D8] error - NullPointerException (DeviceManager:342 < OverspeedEventHandler:51 < BaseEventHandler:28 < ...)\r\n2016-09-29 09:38:15  INFO: [185868D8] disconnected\r\n2016-09-29 09:38:15  INFO: Query not provided: database.insertEvent\r\n2016-09-29 09:38:15  INFO: Query not provided: database.updateDeviceStatus\r\n2016-09-29 09:52:46  INFO: [887CA58E] connected\r\n2016-09-29 09:52:46 DEBUG: [887CA58E: 5013 < 192.168.0.3] HEX: 2a48512c323232323232323232322c56312c3037353230302c412c343434312e333234352c4e2c30323535312e303236332c452c3032312e302c3134372c3239303931362c464646464646464623\r\n2016-09-29 09:52:46  INFO: Query not provided: database.insertEvent\r\n2016-09-29 09:52:46  INFO: Query not provided: database.updateDeviceStatus\r\n2016-09-29 09:52:47  WARN: [887CA58E] error - NullPointerException (DeviceManager:342 < OverspeedEventHandler:51 < BaseEventHandler:28 < ...)\r\n2016-09-29 09:52:47  INFO: [887CA58E] disconnected\r\n2016-09-29 09:52:47  INFO: Query not provided: database.insertEvent\r\n2016-09-29 09:52:47  INFO: Query not provided: database.updateDeviceStatus\r\n```\r\n\r\n\r\nMy config file is:\r\n```\r\n<!-- SERVER CONFIG -->\r\n\r\n    <entry key='web.enable'>false</entry>\r\n    <entry key='web.port'>8082</entry>\r\n    <entry key='web.path'>/opt/traccar/web</entry>\r\n\r\n    <entry key='geocoder.enable'>true</entry>\r\n    <entry key='geocoder.type'>google</entry>\r\n\r\n    <entry key='logger.enable'>true</entry>\r\n    <entry key='logger.level'>all</entry>\r\n    <entry key='logger.file'>/opt/traccar/logs/tracker-server.log</entry>\r\n\r\n    <entry key='event.enable'>true</entry>\r\n    <entry key='event.overspeedHandler'>true</entry>\r\n    <entry key='event.overspeed.notRepeat'>true</entry>\r\n    <entry key='event.motionHandler'>true</entry>\r\n    <entry key='event.geofenceHandler'>true</entry>\r\n    <entry key='event.alertHandler'>true</entry>\r\n    <entry key='event.ignitionHandler'>true</entry>\r\n\r\n    <!-- DATABASE CONFIG -->\r\n\r\n    <entry key='database.driver'>com.mysql.jdbc.Driver</entry>\r\n    <entry key='database.url'>jdbc:mysql://localhost:3306/gts?allowMultiQueries=true</entry>\r\n    <entry key='database.user'>root</entry>\r\n    <entry key='database.password'>marian#78</entry>\r\n\r\n    <entry key='database.selectDevicesAll'>\r\n        SELECT CONCAT('1', imeiNumber) AS id, imeiNumber AS uniqueId FROM Device WHERE imeiNumber REGEXP '^[0-9]+$';\r\n    </entry>\r\n\r\n    <entry key='database.insertPosition'>\r\n        START TRANSACTION;\r\n            UPDATE Device SET lastValidLatitude = :latitude, lastValidLongitude = :longitude, lastGPSTimestamp = UNIX_TIMESTAMP(:fixTime), lastUpdateTime = UNIX_TIMESTAMP(NOW()) WHERE imeiNumber = SUBSTRING(CAST(:deviceId AS CHAR(32)), 2);\r\n            SELECT @accountID := accountID, @deviceID := deviceID FROM Device WHERE imeiNumber = SUBSTRING(CAST(:deviceId AS CHAR(32)), 2);\r\n            INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, heading, altitude, rawData, creationTime, address)\r\n            VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:fixTime), 0, :latitude, :longitude, :speed * 1.852, :course, :altitude, '', UNIX_TIMESTAMP(NOW()), :address);\r\n        COMMIT;\r\n    </entry>\r\n\r\n  \r\n\r\n    <!-- PROTOCOL CONFIG -->\r\n```\r\nWhat am I doing wrong?"},"comment":{"url":"https://api.github.com/repos/tananaev/traccar/issues/comments/250408355","html_url":"https://github.com/tananaev/traccar/issues/2383#issuecomment-250408355","issue_url":"https://api.github.com/repos/tananaev/traccar/issues/2383","id":250408355,"user":{"login":"marianilie","id":20853749,"avatar_url":"https://avatars.githubusercontent.com/u/20853749?v=3","gravatar_id":"","url":"https://api.github.com/users/marianilie","html_url":"https://github.com/marianilie","followers_url":"https://api.github.com/users/marianilie/followers","following_url":"https://api.github.com/users/marianilie/following{/other_user}","gists_url":"https://api.github.com/users/marianilie/gists{/gist_id}","starred_url":"https://api.github.com/users/marianilie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marianilie/subscriptions","organizations_url":"https://api.github.com/users/marianilie/orgs","repos_url":"https://api.github.com/users/marianilie/repos","events_url":"https://api.github.com/users/marianilie/events{/privacy}","received_events_url":"https://api.github.com/users/marianilie/received_events","type":"User","site_admin":false},"created_at":"2016-09-29T08:52:15Z","updated_at":"2016-09-29T08:52:15Z","body":"Thank you. it's ok now."}}
{"actor":{"display_login":"marianilie"}}