From 8156d99918eb55fdd104d5fe939e0660fdd49912 Mon Sep 17 00:00:00 2001 From: Dimitris Kavvathas Date: Tue, 18 Oct 2022 10:56:07 +0200 Subject: [PATCH] Dependency upgrade (minor): com.microsoft.sqlserver:mssql-jdbc from 11.2.0.jre11 to 11.2.1.jre11 --- build.gradle | 2 +- server/sonar-docs/src/pages/setup/install-server.md | 2 +- server/sonar-docs/src/pages/setup/sonar-properties.md | 2 +- sonar-application/src/main/assembly/conf/sonar.properties | 6 +++--- 4 files changed, 6 insertions(+), 6 deletions(-) diff --git a/build.gradle b/build.gradle index a211da46c3c..09f59e698ef 100644 --- a/build.gradle +++ b/build.gradle @@ -252,7 +252,7 @@ subprojects { } dependency 'com.hazelcast:hazelcast-kubernetes:2.2.3' // Documentation must be updated if mssql-jdbc is updated: https://github.com/SonarSource/sonarqube/commit/03e4773ebf6cba854cdcf57a600095f65f4f53e7 - dependency('com.microsoft.sqlserver:mssql-jdbc:11.2.0.jre11') { + dependency('com.microsoft.sqlserver:mssql-jdbc:11.2.1.jre11') { exclude 'com.fasterxml.jackson.core:jackson-databind' } dependency 'com.oracle.database.jdbc:ojdbc8:21.6.0.0.1' diff --git a/server/sonar-docs/src/pages/setup/install-server.md b/server/sonar-docs/src/pages/setup/install-server.md index 5a70208e21e..92381119c7a 100644 --- a/server/sonar-docs/src/pages/setup/install-server.md +++ b/server/sonar-docs/src/pages/setup/install-server.md @@ -63,7 +63,7 @@ Create an empty schema and a `sonarqube` user. Grant this `sonarqube` user permi | |To use integrated security: | -|1. Download the [Microsoft SQL JDBC Auth 11.2.0 package](https://github.com/microsoft/mssql-jdbc/releases/download/v11.2.0/mssql-jdbc_auth.zip) and copy `mssql-jdbc_auth-11.2.0.x64.dll` to any folder in your path. +|1. Download the [Microsoft SQL JDBC Auth 11.2.1 package](https://github.com/microsoft/mssql-jdbc/releases/download/v11.2.1/mssql-jdbc_auth.zip) and copy `mssql-jdbc_auth-11.2.1.x64.dll` to any folder in your path. | |2. _If you're running SonarQube as a Windows service_, make sure the Windows account under which the service is running has permission to connect your SQL server. The account should have `db_owner` database role membership. | diff --git a/server/sonar-docs/src/pages/setup/sonar-properties.md b/server/sonar-docs/src/pages/setup/sonar-properties.md index f39a8a48963..e98e179aa1a 100644 --- a/server/sonar-docs/src/pages/setup/sonar-properties.md +++ b/server/sonar-docs/src/pages/setup/sonar-properties.md @@ -37,7 +37,7 @@ By default the schema named "public" is used. It can be overridden with the para **`SONAR_JDBC_URL=jdbc:sqlserver://localhost;databaseName=sonar;integratedSecurity=true`** A database named sonar must exist and its collation must be case-sensitive (CS) and accent-sensitive (AS). Use this connection string if you want to use integrated security with Microsoft Sql Server. Do not set the `SONAR_JDBC_USERNAME` or `SONAR_JDBC_PASSWORD` property if you are using Integrated Security. -For Integrated Security to work, you have to download the Microsoft SQL JDBC Auth 11.2.0 package [here](https://github.com/microsoft/mssql-jdbc/releases/download/v11.2.0/mssql-jdbc_auth.zip) and copy `mssql-jdbc_auth-11.2.0.x64.dll` to your path. +For Integrated Security to work, you have to download the Microsoft SQL JDBC Auth 11.2.1 package [here](https://github.com/microsoft/mssql-jdbc/releases/download/v11.2.1/mssql-jdbc_auth.zip) and copy `mssql-jdbc_auth-11.2.1.x64.dll` to your path. **`SONAR_JDBC_URL=jdbc:sqlserver://localhost;databaseName=sonar`** Use this connection string if you want to use SQL Auth while connecting to MS Sql Server. Set the `SONAR_JDBC_USERNAME` and `SONAR_JDBC_PASSWORD` appropriately. diff --git a/sonar-application/src/main/assembly/conf/sonar.properties b/sonar-application/src/main/assembly/conf/sonar.properties index 24560229682..779485312e1 100644 --- a/sonar-application/src/main/assembly/conf/sonar.properties +++ b/sonar-application/src/main/assembly/conf/sonar.properties @@ -40,9 +40,9 @@ # A database named sonar must exist and its collation must be case-sensitive (CS) and accent-sensitive (AS) # Use the following connection string if you want to use integrated security with Microsoft Sql Server # Do not set sonar.jdbc.username or sonar.jdbc.password property if you are using Integrated Security -# For Integrated Security to work, you have to download the Microsoft SQL JDBC Auth 11.2.0 package from -# https://github.com/microsoft/mssql-jdbc/releases/download/v11.2.0/mssql-jdbc_auth.zip -# and 'mssql-jdbc_auth-11.2.0.x64.dll' to your path. +# For Integrated Security to work, you have to download the Microsoft SQL JDBC Auth 11.2.1 package from +# https://github.com/microsoft/mssql-jdbc/releases/download/v11.2.1/mssql-jdbc_auth.zip +# and 'mssql-jdbc_auth-11.2.1.x64.dll' to your path. #sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=sonar;integratedSecurity=true # Use the following connection string if you want to use SQL Auth while connecting to MS Sql Server. -- 2.39.5