Microsoft SQL Server

RDa month 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 Tananaeva month ago

Have you checked the documentation?

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

RDa month 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 Tananaeva month ago

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

RDa month ago

Hi Anton,

Is there a way to backup & restore H2 database?

Anton Tananaeva month ago

You can just copy the whole file.

RDa month ago

Thank you.
Where is the file file located?

Anton Tananaeva month ago

You can find the answer in the config file.