Hi Im new to Traccar. I installed Traccar Server Version 5.4 and change de config traccar.xml file to use MS SQL Server with the info below.
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
<entry key='database.url'>jdbc:sqlserver://localhost\SQLEXPRESS;user=sa;password=;databaseName=Traccar;</entry>
<entry key='database.user'>sa</entry>
<entry key='database.password'></entry>
When restarting de traccar service, so that it creates all tables in my already created Traccar database, I get the following error in the log.
2022-10-06 16:42:49 INFO: Operating system name: Windows 10 version: 10.0 architecture: amd64
2022-10-06 16:42:49 INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 17.0.4+8
2022-10-06 16:42:49 INFO: Memory limit heap: 1992mb non-heap: 0mb
2022-10-06 16:42:49 INFO: Character encoding: Cp1252 charset: windows-1252
2022-10-06 16:42:49 INFO: Version: 5.4
2022-10-06 16:42:49 INFO: Starting server...
2022-10-06 16:42:50 INFO: HikariPool-1 - Starting...
2022-10-06 16:42:52 ERROR: HikariPool-1 - Exception during pool initialization. - unable to find valid certification path to requested target - SunCertPathBuilderException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < Main:126 < ...)
2022-10-06 16:42:52 ERROR: Main method error - unable to find valid certification path to requested target - SunCertPathBuilderException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < Main:126 < ...)
2022-10-06 16:42:52 WARN: JNA: Callback org.traccar.WindowsService$ServiceMain@9573584 threw the following exception - unable to find valid certification path to requested target - SunCertPathBuilderException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < Main:126 < ...)
Hope any one can help with this issue. Thanks.
Thanks, I worked just by adding 'trustServerCertificate=true;' to the next entry key. Though the best option, for security considerations, would be to follow all the steps in the link above.
<entry key='database.url'>jdbc:sqlserver://localhost\SQLEXPRESS;user=sa;password=pepeSQL78;databaseName=Traccar; trustServerCertificate=true;</entry>
Thanks again.
Thanks for sharing the solution. I've updated the documentation with it just in case.
Hi Im new to Traccar. I installed Traccar Server Version 5.4 and change de config traccar.xml file to use MS SQL Server with the info below.
<!-- MSSQLServer --> <entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry> <entry key='database.url'>jdbc:sqlserver://localhost\SQLEXPRESS;user=sa;password=;databaseName=Traccar;</entry> <entry key='database.user'>sa</entry> <entry key='database.password'></entry>When restarting de traccar service, so that it creates all tables in my already created Traccar database, I get the following error in the log.
Hope any one can help with this issue. Thanks.