Microsoft SQL Server

RD2 months 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 Tananaev2 months ago

Have you checked the documentation?

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

RD2 months 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 Tananaev2 months ago

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

RD2 months ago

Hi Anton,

Is there a way to backup & restore H2 database?

Anton Tananaev2 months ago

You can just copy the whole file.

RD2 months ago

Thank you.
Where is the file file located?

Anton Tananaev2 months ago

You can find the answer in the config file.