Sonarqube config with sql server

SonarQube Server / Community Build
1

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension) :8.4

  • what are you trying to achieve
    I have setup a sql server db and updated the jdbc connection in sonar.properties. But looks like the docker container is not picking the sql server jdbc connection.

  • what have you tried so far to achieve this
    Tried various things even the log doesn’t show any error related to sql server.

2020.08.13 06:45:38 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp
2020.08.13 06:45:38 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2020.08.13 06:45:38 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePrefix=es]] from [/opt/sonarqube/elasticsearch]: /opt/sonarqube/elasticsearch/bin/elasticsearch
2020.08.13 06:45:38 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2020.08.13 06:45:38 INFO app[o.e.p.PluginsService] no modules loaded
2020.08.13 06:45:38 INFO app[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.08.13 06:45:50 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2020.08.13 06:45:50 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘web’, ipcIndex=2, logFilenamePrefix=web]] from [/opt/sonarqube]: /opt/java/openjdk/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/
opt/sonarqube/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 -Xmx51
2m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.|[::1] -cp ./lib/common/:/opt/sonarqube/lib/jdbc/h2/h2-1.4.199.jar org.sonar.server.app.WebServer /opt/sonarqube/temp/sq-process5423541445175288303propertie
s
2020.08.13 06:46:06 INFO app[o.s.a.SchedulerImpl] Process[web] is up
2020.08.13 06:46:06 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘ce’, ipcIndex=3, logFilenamePrefix=ce]] from [/opt/sonarqube]: /opt/java/openjdk/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/op
t/sonarqube/temp -XX:-OmitStackTraceInFastThrow --add-opens=java.base/java.util=ALL-UNNAMED -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.|[::1] -cp ./lib/common/:/opt/sonarqube/lib/jdbc/h2/h2-1.4
.199.jar org.sonar.ce.app.CeServer /opt/sonarqube/temp/sq-process12762495906224721129properties
2020.08.13 06:46:12 INFO app[o.s.a.SchedulerImpl] Process[ce] is up
2020.08.13 06:46:12 INFO app[o.s.a.SchedulerImpl] SonarQube is up

2

Hi @kchava ,
welcome to the community :wave:

can you make sure that you have edited the sonar.properties file within the right location (as in a volume that is accessible within the container)?
Also you can configure the JDBC parameters via env vars as well:

version: "3"

services:
  sonarqube:
    image: sonarqube:8-community
    depends_on:
      - db
    environment:
      SONAR_JDBC_URL: jdbc:postgresql://db:5432/sonar
      SONAR_JDBC_USERNAME: sonar
      SONAR_JDBC_PASSWORD: sonar
  db:
    image: postgres:12
    environment:
      POSTGRES_USER: sonar
      POSTGRES_PASSWORD: sonar
    volumes:
      - postgresql:/var/lib/postgresql
      - postgresql_data:/var/lib/postgresql/data
volumes:
  postgresql:
  postgresql_data:

Hope that narrows down the problem for you