Exception during pool initialization.

Nelson2 years ago

Hi, Im getting this error message in the log when I try to initial the traccar

2023-03-03 14:41:52  INFO: Starting server...
2023-03-03 14:41:52  INFO: HikariPool-1 - Starting...
2023-03-03 14:41:53 ERROR: HikariPool-1 - Exception during pool initialization. - unable to find valid certification path to requested target - SunCertPathBuilderException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < Main:126 < ...)
2023-03-03 14:41:53 ERROR: Main method error - unable to find valid certification path to requested target - SunCertPathBuilderException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < Main:126 < ...)
2023-03-03 14:41:53  WARN: JNA: Callback org.traccar.WindowsService$ServiceMain@82ea68c threw the following exception - unable to find valid certification path to requested target - SunCertPathBuilderException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < Main:126 < ...)
Anton Tananaev2 years ago

What's your database configuration?

Nelson2 years ago
    <entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
    <entry key='database.url'>jdbc:sqlserver://NS652895\NELSON\DB:1433;databaseName=traccar;</entry>
    <entry key='database.user'>user</entry>
    <entry key='database.password'>password</entry> 
Anton Tananaev2 years ago

Have you tried the config from our official documentation?

Nelson2 years ago

Thanks I've made the changes and it has connected to the SQL, but now I'm getting this error message in the log

2023-03-03 15:14:10  INFO: Operating system name: Windows Server 2019 version: 10.0 architecture: amd64
2023-03-03 15:14:10  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 17.0.6+10
2023-03-03 15:14:10  INFO: Memory limit heap: 30688mb non-heap: 0mb
2023-03-03 15:14:10  INFO: Character encoding: Cp1252 charset: windows-1252
2023-03-03 15:14:10  INFO: Version: 5.6
2023-03-03 15:14:10  INFO: Starting server...
2023-03-03 15:14:11  INFO: HikariPool-1 - Starting...
2023-03-03 15:14:11  INFO: HikariPool-1 - Added connection ConnectionID:1 ClientConnectionId: 8aebba81-1930-4d81-87f5-90589c341a33
2023-03-03 15:14:11  INFO: HikariPool-1 - Start completed.
2023-03-03 15:14:11  INFO: Set default schema name to dbo
2023-03-03 15:14:11  INFO: Clearing database change log checksums
2023-03-03 15:14:16 ERROR: Main method error - There is already an object named 'DATABASECHANGELOGLOCK' in the database. - SQLServerException (... < DatabaseModule:95 < <gener:-1 < *:-1 < ... < Main:126 < ...)
2023-03-03 15:14:16  WARN: JNA: Callback org.traccar.WindowsService$ServiceMain@82ea68c threw the following exception - There is already an object named 'DATABASECHANGELOGLOCK' in the database. - SQLServerException (... < DatabaseModule:95 < <gener:-1 < *:-1 < ... < Main:126 < ...)
Anton Tananaev2 years ago

Now it looks like you have some schema conflict.

Nelson2 years ago

What can I do in this case, sorry ?

Anton Tananaev2 years ago

I'm not sure. I think you're not telling us some context.