После обновления до Traccar 5.8 перестал работать

Umarovich2 years ago

После обновления до Traccar 5.8 перестал работать веб-сервер, проблема началась после подключения к старой базе данных MariaDB через XML-конфигурацию.

● traccar.service - traccar
     Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
    Drop-In: /etc/systemd/system/traccar.service.d
             └─run-as-user.conf
     Active: activating (auto-restart) (Result: exit-code) since Sat 2023-08-19 08:52:50 UTC; 4s ago
    Process: 5093 ExecStart=/opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml (code=exited, status=1/FAILURE)

Traccar.xml

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

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

<properties>

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

    <entry key='database.driver'>com.mariadb.jdbc.Drive</entry>
    <entry key='database.url'>jdbc:mariadb://localhost:3306/traccar?serverTimezone=UTC&amp;useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
    <entry key='database.user'>traccar</entry>
    <entry key='database.password'>!!2617272Umid!!</entry>

</properties>
Anton Tananaev2 years ago

Вы логи смотрели?

Umarovich2 years ago
2023-08-19 15:32:50  INFO: Starting server...
2023-08-19 15:32:50  INFO: HikariPool-1 - Starting...
2023-08-19 15:32:51  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2023-08-19 15:32:56 ERROR: HikariPool-1 - Exception during pool initialization. - Unknown system variable 'transaction_isolation' - CJException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < MainModule:123 < ...)
2023-08-19 15:32:56 ERROR: Main method error - Unknown system variable 'transaction_isolation' - CJException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < MainModule:123 < ...)
Anton Tananaev2 years ago

Вы искали на форуме? Это уже обсуждалось много раз.

Umarovich2 years ago

Да, я искал и читал, но решения не нашел.

Umarovich2 years ago
2023-08-20 03:36:55  INFO: Operating system name: Linux version: 5.4.0-156-generic architecture: amd64
2023-08-20 03:36:55  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 17.0.6+10
2023-08-20 03:36:55  INFO: Memory limit heap: 980mb non-heap: 0mb
2023-08-20 03:36:55  INFO: Character encoding: UTF-8 charset: UTF-8
2023-08-20 03:36:55  INFO: Version: 5.8
2023-08-20 03:36:55  INFO: Starting server...
2023-08-20 03:36:55  INFO: HikariPool-1 - Starting...
2023-08-20 03:37:00 ERROR: HikariPool-1 - Exception during pool initialization. - Unknown system variable 'transaction_isolation' - CJException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < MainModule:123 < ...)
2023-08-20 03:37:00 ERROR: Main method error - Unknown system variable 'transaction_isolation' - CJException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < MainModule:123 < ...)
Umarovich2 years ago

Спосибо Антон.