root@stuff:/opt/traccar/conf# cat ./traccar.cfg
<?xml version='1.0' encoding='UTF-8'?>

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

<properties>

    <!-- Global configuration -->
<!--    <entry key='database.driver'>org.h2.Driver</entry>
    <entry key='database.url'>jdbc:h2:/opt/traccar/data/database</entry>
    <entry key='database.user'>sa</entry>
    <entry key='database.password'></entry>
-->

    <entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
    <entry key='database.url'>jdbc:mysql://127.0.0.1:3306/traccar?allowMultiQueries=true&amp;autoReconnect=true</entry>
    <entry key='database.user'>traccar</entry> 
    <entry key='database.password'>xxxxx</entry>


    <!-->
        id - Long
        imei - String
    <-->
    <entry key='database.selectDevice'>
        SELECT id, uniqueId as imei
        FROM devices;
    </entry>

    <!-->
        device_id - Long
        time - Date
        valid - Boolean
        latitude - Double
        longitude - Double
        speed - Double
        course - Double
        power - Double (NULL for some protocols)
        extended_info - String (XML)
    <-->
    <entry key='database.insertPosition'>
        INSERT INTO positions (device_id, time, valid, latitude, longitude, altitude, speed, course, power, address, other)
        VALUES (:device_id, :time, :valid, :latitude, :longitude, :altitude, :speed, :course, :power, :address, :extended_info);
    </entry>

    <!-->
        device_id - Long
        id - Long
    <-->
    <entry key='database.updateLatestPosition'>
        UPDATE devices SET latestPosition_id = :id WHERE id = :device_id;
    </entry>

    <!-- Web interface -->
    <entry key='http.enable'>true</entry>
    <!--<entry key='http.address'></entry>-->
    <entry key='http.port'>8082</entry>
    <entry key='http.application'>/opt/traccar/traccar-web.war</entry>

    <!-- Geocoder options -->
    <entry key='geocoder.enable'>false</entry>
    <entry key='geocoder.type'>nominatim</entry>
    <entry key='geocoder.url'>http://nominatim.openstreetmap.org/reverse</entry>

    <!-- Filtering options -->
    <!--<entry key='filter.enable'>true</entry>
    <entry key='filter.limit'>3600</entry>
    <entry key='filter.invalid'>true</entry>
    <entry key='filter.zero'>true</entry>
    <entry key='filter.duplicate'>true</entry>
    <entry key='filter.distance'>50</entry>-->

    <!-- Logging options -->
    <entry key='logger.enable'>true</entry>
    <entry key='logger.level'>all</entry>
    <entry key='logger.file'>/opt/traccar/logs/tracker-server.log</entry>

    <!-- Protocol detector -->
    <entry key='detector.enable'>true</entry>
    <entry key='detector.port'>15000</entry>

    <!-- GT06 server configuration -->
    <entry key='gt06.enable'>true</entry>
    <entry key='gt06.port'>15023</entry>


</properties>
root@stuff:/opt/traccar/conf#