traccar перестал работать после перехода с 3.2 на 3.10 (openGTS)

ubuntu 14.04. Было установлено openGts и traccar 3.2. Все работало. Решил обновится на 3.10. Произвел удаление traccar 3.2. и установил traccar 3.10.
Конфиги следующие
default.xml

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

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

<properties>

    <!-- SERVER CONFIG -->

    <entry key='web.enable'>false</entry>
    <entry key='web.port'>8082</entry>
    <entry key='web.path'>./web</entry>

    <entry key='geocoder.enable'>true</entry>
    <entry key='geocoder.type'>google</entry>

    <entry key='logger.enable'>true</entry>
    <entry key='logger.level'>all</entry>
    <entry key='logger.file'>./logs/tracker-server.log</entry>


    <!-- DATABASE CONFIG -->

     <entry key='database.selectDevicesAll'>
        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>

    <!-- PROTOCOL CONFIG -->

    <entry key='gps103.port'>5001</entry>
    ...
    <entry key='pricol.port'>5134</entry>

</properties>

traccar.xml

<?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/gts?allowMultiQueries=true</entry>
    <entry key='database.user'>XXXXXX</entry>
    <entry key='database.password'>XXXXXXX</entry>

</properties>

Выдает такой лог

2017-02-26 15:33:06  INFO: Operating system name: Linux version: 3.13.0-107-generic architecture: i386
2017-02-26 15:33:06  INFO: Java runtime name: Java HotSpot(TM) Server VM vendor: Oracle Corporation version: 24.80-b11
2017-02-26 15:33:06  INFO: Memory limit heap: 787mb non-heap: 112mb
2017-02-26 15:33:06  INFO: Character encoding: UTF-8 charset: UTF-8
2017-02-26 15:33:06  INFO: Version: 3.10-SNAPSHOT
2017-02-26 15:33:06  INFO: Query not provided: database.selectGroupsAll
2017-02-26 15:33:06  INFO: Query not provided: database.selectLatestPositions
2017-02-26 15:33:06  INFO: Query not provided: database.selectServers
2017-02-26 15:33:06  INFO: Query not provided: database.selectUsersAll
2017-02-26 15:33:06  INFO: Query not provided: database.selectGroupsAll
2017-02-26 15:33:06  INFO: Query not provided: database.selectGroupPermissions
2017-02-26 15:33:06  INFO: Query not provided: database.selectDevicePermissions
2017-02-26 15:33:06  INFO: Query not provided: database.selectGroupsAll
2017-02-26 15:33:06  INFO: Query not provided: database.selectUserPermissions
2017-02-26 15:33:07  INFO: Query not provided: database.selectAttributeAliases
2017-02-26 15:33:07  INFO: Starting server...
2017-02-26 15:33:16  INFO: [CF0E371F] connected
2017-02-26 15:33:16 DEBUG: [CF0E371F: 5027 < 46.56.180.249] HEX: 000f333533393736303133323632333032
2017-02-26 15:33:16 DEBUG: [CF0E371F: 5027 > 46.56.180.249] HEX: 01
2017-02-26 15:33:16  INFO: Query not provided: database.updateDeviceStatus
2017-02-26 15:33:27 DEBUG: [CF0E371F: 5027 < 46.56.180.249] HEX: 000000000000002908010000015a775e61ec000f113130201ee04000910008090007000200014230f801c700000000000100005685
2017-02-26 15:33:27 DEBUG: [CF0E371F: 5027 > 46.56.180.249] HEX: 00000001
2017-02-26 15:33:27  INFO: Query not provided: database.updateDeviceStatus
2017-02-26 15:33:27  WARN: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' - SQLException (... < QueryBuilder:473 < DataManager:296 < DefaultDataHandler:27 < ...)
2017-02-26 15:33:27  INFO: Query not provided: database.updateLatestPosition
2017-02-26 15:33:27  INFO: [CF0E371F] id: 353976013262302, time: 2017-02-26 01:22:38, lat: 53.88944, lon: 25.27849, speed: 3.8, course: 8.0
2017-02-26 15:33:41  INFO: [CF0E371F] disconnected
2017-02-26 15:33:41  INFO: Query not provided: database.updateDeviceStatus
2017-02-26 15:34:40  INFO: Shutting down server...

получается traccar использует latin1_swedish_ci кодировку. Как её изменить? База opengts создана с кодировкой cp1251_general_ci

Подскажите как и что поправить ?

Попробуйте следующий URL для базы данных:

<entry key='database.url'>jdbc:mysql://[HOST]/[DATABASE]?allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>

Спасибо огромное . Все заработало коректно.