Bitbucket throws an no sqljdbc_auth in java.library.path in the logs

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Problem

When starting Bitbucket Service, the following is shown on the atlassian-bitbucket.log:

2019-05-31 14:40:25,595 WARN  [spring-startup]  c.m.s.j.internals.AuthenticationJNI Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path
2019-05-31 14:40:39,543 ERROR [spring-startup]  com.zaxxer.hikari.pool.HikariPool bitbucket - Exception during pool initialization.
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:2d4c895d-73f9-4193-8f9e-6b1af5193098
...
Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.pathDiagnosis


Environment

  • Running Bitbucket with SQL Server on a Windows OS.

Cause

  • Bitbucket is configured to use windows auth, but the driver hasn't been renamed.
  • The JDBC string has integratedSecurity=true on its parameter,  causing an issue.

Resolution

  • If the intention is to use Windows authentication, it may be necessary to rename the appropriate driver. This document has the detailed steps to follow.
  • Open $BITBUCKET_HOME/shared/bitbucket.properties file and remove the integratedSecurity=true parameter from the jdbc.url string and restart Bitbucket Server.



Last modified on Jun 11, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.