Must-share information (formatted with Markdown):
- which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
Current Version:- 9.5 (build 56709) Developer Edition
Upgrading to 9.8.0.63668 - Developer Edition - how is SonarQube deployed: zip
- what are you trying to achieve
I am trying to upgrade Sonar Qube from 9.5 to 9.8 and then planning to upgrade to 9.9 - what have you tried so far to achieve this
- Copied the Zip folder on the server
- Unzip and updated sonar.properties file from previous version ( id not overwrite)
- Copied wrapper.config file from prev version
- In Wrapper config updated below
-
wrapper.java.classpath.1=…/…/lib/sonar-application-9.8.0.63668.jar
-
wrapper.java.classpath.3=…/…/lib/sonar-shutdowner-9.8.0.63668.jar
Then I downloaded the https://github.com/microsoft/mssql-jdbc/releases/download/v11.2.1/mssql-jdbc_auth.zip
-
Copied this “mssql-jdbc_auth-11.2.1.x64.dll” in a new folder created “C:\sonarqube\sonarqube-9.8.0.63668\jdbc\mssql”.
-
Also copied this in C:\sonarqube\sonarqube-9.8.0.63668\extensions\jdbc-driver\mssql
-
My Sonar Qube path is set “SONAR_HOME” with value “c:\sonarqube”
-
Sonar qube user has full access on this folder and also is sysadmin on DB.
Service just stopped after few minutes of restart.
Java JDK installed is JDK 11.
C:\Program Files\Java\jdk-11.0.10
We are using wrapper.config file as well which is also in conf folder. Java path is set up in wrapper.config file
wrapper.java.command=C:\Program Files\Java\jdk-11.0.10\bin\java.exe
Error in Web Log:-
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.
Error: “PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target”. ClientConnectionId:9e3ab9f6-0a40-4367-9962-6d8028dbe798
Error in Sonar.log:-
023.03.21 10:30:55 INFO app
o.s.a.AppFileSystem] Cleaning or creating temp directory C:\sonarqube\sonarqube-9.8.0.63668\temp
2023.03.21 10:30:55 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.0.0.1:59066]
2023.03.21 10:30:55 INFO app[o.s.a.ProcessLauncherImpl] Launch process[ELASTICSEARCH] from [C:\sonarqube\sonarqube-9.8.0.63668\elasticsearch]: C:\Program Files\Java\jdk-11.0.10\bin\java -XX:+UseG1GC -Djava.io.tmpdir=C:\sonarqube\sonarqube-9.8.0.63668\temp -XX:ErrorFile=…/logs/es_hs_err_pid%p.log -Des.networkaddress.cache.ttl=60 -Des.networkaddress.cache.negative.ttl=10 -XX:+AlwaysPreTouch -Xss1m -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djna.nosys=true -Djna.tmpdir=C:\sonarqube\sonarqube-9.8.0.63668\temp -XX:-OmitStackTraceInFastThrow -Dio.netty.noUnsafe=true -Dio.netty.noKeySetOptimization=true -Dio.netty.recycler.maxCapacityPerThread=0 -Dio.netty.allocator.numDirectArenas=0 -Dlog4j.shutdownHookEnabled=false -Dlog4j2.disable.jmx=true -Dlog4j2.formatMsgNoLookups=true -Djava.locale.providers=COMPAT -Dcom.redhat.fips=false -Des.enforce.bootstrap.checks=true -Xmx512m -Xms512m -XX:MaxDirectMemorySize=256m -XX:+HeapDumpOnOutOfMemoryError -Delasticsearch -Des.path.home=C:\sonarqube\sonarqube-9.8.0.63668\elasticsearch -Des.path.conf=C:\sonarqube\sonarqube-9.8.0.63668\temp\conf\es -cp lib/* org.elasticsearch.bootstrap.Elasticsearch
2023.03.21 10:30:55 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2023.03.21 10:31:02 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2023.03.21 10:31:02 INFO app[o.s.a.ProcessLauncherImpl] Launch process[WEB_SERVER] from [C:\sonarqube\sonarqube-9.8.0.63668]: C:\Program Files\Java\jdk-11.0.10\bin\java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=C:\sonarqube\sonarqube-9.8.0.63668\temp -XX:-OmitStackTraceInFastThrow --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED --add-exports=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/sun.nio.ch=ALL-UNNAMED --add-opens=java.management/sun.management=ALL-UNNAMED --add-opens=jdk.management/com.sun.management.internal=ALL-UNNAMED -Dcom.redhat.fips=false -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-9.8.0.63668.jar;C:\sonarqube\sonarqube-9.8.0.63668\lib\jdbc\mssql\mssql-jdbc-11.2.1.jre11.jar org.sonar.server.app.WebServer C:\sonarqube\sonarqube-9.8.0.63668\temp\sq-process15177727812824390543properties
2023.03.21 10:31:06 INFO app[o.s.a.SchedulerImpl] Process[Web Server] is stopped
2023.03.21 10:31:06 INFO app[o.s.a.SchedulerImpl] Process[ElasticSearch] is stopped
2023.03.21 10:31:06 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped
Other thing I tried is to upgrade step by step to 9.6 hen 9.7 and then 9.8 but still getting same error when upgrade to 9.6.
I wanted to upgrade finally to 9.9, (even tried installing JAVA JDK 17 for 9.9, but nothing works
Do not share screenshots of logs – share the text itself (bonus points for being well-formatted)!