OpenGTS integration
Where's the error?
no received data in database
here is my config!
<?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'>false</entry>
<entry key='web.port'>8082</entry>
<entry key='web.path'>./web</entry>
<entry key='web.cacheControl'>max-age=3600,public</entry>
<entry key='geocoder.enable'>false</entry>
<entry key='geocoder.type'>google</entry>
<entry key='logger.enable'>true</entry>
<entry key='logger.level'>info</entry>
<entry key='logger.file'>./logs/tracker-server.log</entry>
<entry key='filter.enable'>true</entry>
<entry key='filter.future'>86400</entry>
<entry key='processing.computedAttributes.enable'>true</entry>
<entry key='processing.engineHours.enable'>true</entry>
<entry key='media.path'>./media</entry>
<entry key='notificator.types'>web,mail</entry>
<entry key='server.statistics'>https://www.traccar.org/analytics/</entry>
<entry key='commands.queueing'>true</entry>
<entry key='database.ignoreUnknown'>true</entry>
<entry key='database.driver'>com.mysql.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://localhost/gts?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>root</entry>
<entry key='database.password'>Magne@1986@2019</entry>
<entry key='database.selectDevices'>
SELECT CONCAT('1', imeiNumber) AS id, imeiNumber AS uniqueId FROM Device WHERE imeiNumber REGEXP '^[0-9]+$';
</entry>
<entry key='database.selectAllDevices'>
SELECT CONCAT('1', imeiNumber) AS id, imeiNumber AS uniqueId FROM Device WHERE imeiNumber REGEXP '^[0-9]+$';
</entry>
<entry key='database.insertPosition'>
START TRANSACTION;
UPDATE Device SET lastValidLatitude = :latitude, lastValidLongitude = :longitude, lastGPSTimestamp = UNIX_TIMESTAMP(:fixTime), lastUpdateTime = UNIX_TIMESTAMP(NOW()) WHERE imeiNumber = SUBSTRING(CAST(:deviceId AS CHAR(32)), 2);
SELECT @accountID := accountID, @deviceID := deviceID FROM Device WHERE imeiNumber = SUBSTRING(CAST(:deviceId AS CHAR(32)), 2);
INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, heading, altitude, rawData, creationTime, address)
VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:fixTime), 0, :latitude, :longitude, :speed * 1.852, :course, :altitude, '', UNIX_TIMESTAMP(NOW()), :address);
COMMIT;
</entry>
<entry key='gps103.port'>5001</entry>
<entry key='tk103.port'>5002</entry>
...
<entry key='its.port'>5179</entry>
<entry key='xrb28.port'>5180</entry>
</properties>please help me
i'm using sinotrack ST901, ont port 5013
What do you see in the logs other than what you already posted? Maybe you can share the whole file?
Just don't post it directly in the comment. Upload it somewhere and share the link.
this log file. please check.
To me it seems like the format is simply not supported. Probably because the version is too old.
Ok, please which traccar version did you advise me ?
I always recommend the latest version, but it doesn't support database OpenGTS integration. You would have to use forwarding instead.
please i try latest version, but not work.
please which version support database OpenGTS integration ?
or can you send the link to download ?
please help
Try latest 4.xx version.
pleas i have try opengts intégration , but get this error on traccar log.
help me please