Microsoft SQL Server

RD a year ago

This is my traccar.xml but I when I try to open my traccar page I got this message "Failed to Fetch".

This is the traccar log;

2025-02-28 12:58:50  INFO: Operating system name: Windows Server 2012 R2 version: 6.3 architecture: amd64
2025-02-28 12:58:50  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 21.0.4+7-LTS
2025-02-28 12:58:50  INFO: Memory limit heap: 1008mb non-heap: 0mb
2025-02-28 12:58:50  INFO: Character encoding: UTF-8
2025-02-28 12:58:50  INFO: Version: 6.6
2025-02-28 12:58:50  INFO: Starting server...
2025-02-28 12:58:51 ERROR: Main method error - Unable to make void jdk.internal.loader.ClassLoaders$AppClassLoader.appendToClassPathForInstrumentation(java.lang.String) accessible: module java.base does not "opens jdk.internal.loader" to unnamed module @3e2e18f2 - InaccessibleObjectException (... < DatabaseModule:57 < <gener:-1 < *:-1 < ... < MainModule:138 < <gener:-1 < ...)

[serverName] is the server name
[userName] is the database user name
[password] is the user password
[database] is the database name

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>
<properties>

    <!-- Documentation: https://www.traccar.org/configuration-file/ -->


    <entry key='database.driverFile'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
    <entry key='database.url'>jdbc:sqlserver://PSERVER2;user=sa;password=1231;databaseName=traccar;trustServerCertificate=true;</entry>
   <entry key='database.user'>traccar</entry>
   <entry key='database.password'>1231</entry>


</properties>
Anton Tananaev a year ago

Have you checked the documentation?

https://www.traccar.org/ms-sql/

RD a year ago

Yes I did but I tried multiple users and password but doesn’t work.
The server works with the h2 database where l’m able to track on port 5013, H02 protocol.

Anton Tananaev a year ago

If you read that, then why are you using different configuration parameters?

RD a year ago

Hi Anton,

Is there a way to backup & restore H2 database?

Anton Tananaev a year ago

You can just copy the whole file.

RD a year ago

Thank you.
Where is the file file located?

Anton Tananaev a year ago

You can find the answer in the config file.