Exception during pool initialization.

Nelson 3 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 Tananaev 3 years ago

What's your database configuration?

Nelson 3 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 Tananaev 3 years ago

Have you tried the config from our official documentation?

Nelson 3 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 Tananaev 3 years ago

Now it looks like you have some schema conflict.

Nelson 3 years ago

What can I do in this case, sorry ?

Anton Tananaev 3 years ago

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