Sonarqube 9.9-enterprise connectivity with Azure Postgre Flexible server

Must-share information (formatted with Markdown):

  • which versions are you using -sonarqube:9.9-enterprise
  • how is SonarQube deployed: Using docker image in k8s yaml
  • what are you trying to achieve - To connect Azure postgreSQL flexible server using jdbc connection details
  • what have you tried so far to achieve this - I’m able to run sonarqube but its not showing any connection related information with Azure PostgreSQL. Its using h2 database.

yaml file-

apiVersion: apps/v1
kind: Deployment
metadata:
  labels:
    app: sonarqube
  name: sonarqube
  namespace: sonarqube
spec:
  replicas: 1
  selector:
    matchLabels:
      app: sonarqube
  template:
    metadata:
      labels:
        app: sonarqube
    spec:
      terminationGracePeriodSeconds: 15
      initContainers:
      - name: fix-the-volume-permission
        image: busybox
        command:
        - sh
        - -c
        - chown -R 1000:1000 /opt/sonarqube/extensions && chmod -R 777 /opt/sonarqube/extensions
        securityContext:
          privileged: true
        volumeMounts:
        - name: sonar-pv-volume-ext
          mountPath: /opt/sonarqube/extensions
      - name: fix-the-volume-permission1
        image: busybox
        command:
        - sh
        - -c
        - chown -R 1000:1000 /opt/sonarqube/data && chmod -R 777 /opt/sonarqube/data
        securityContext:
          privileged: true
        volumeMounts:
        - name: sonar-pv-volume
          mountPath: /opt/sonarqube/data
      - name: fix-the-volume-permission2
        image: busybox
        command:
        - sh
        - -c
        - chown -R 1000:1000 /opt/sonarqube/temp && chmod -R 777 /opt/sonarqube/temp
        securityContext:
          privileged: true
        volumeMounts:
        - name: sonar-pv-volume
          mountPath: /opt/sonarqube/temp
      containers:
        - name: sonarqube
          image: sonarqube:9.9-enterprise
          resources:
            requests:
              cpu: 4000m
              memory: 8192Mi
            limits:
              cpu: 4000m
              memory: 8192Mi
          volumeMounts:
          - mountPath: "/opt/sonarqube/data/"
            name: sonar-pv-volume
            subPath: data
          - mountPath: /opt/sonarqube/extensions/plugins/tmp
            name: sonar-pv-volume-ext
            subPath: tmp
          - mountPath: /opt/sonarqube/extensions/downloads
            name: sonar-pv-volume-ext
            subPath: downloads
          - mountPath: /opt/sonarqube/extensions/plugins
            name: sonar-pv-volume-ext
            subPath: plugins
          - mountPath: /opt/sonarqube/temp
            name: sonar-pv-volume
            subPath: temp
          - mountPath: /opt/sonarqube/logs
            name: sonar-pv-volume-ext
            subPath: logs
          - mountPath: /tmp
            name: tmp-dir
          env:
          - name: sonar.jdbc.username
            value: "psqladmin"
          - name: sonar.jdbc.url
            value: "jdbc:postgresql://xxxx.postgres.database.azure.com:5432/sonar_dev"
          - name: sonar.jdbc.password
            valueFrom:
              secretKeyRef:
                name: sonar-secret
                key: POSTGRES_PASSWORD
          - name: sonar.web.context
            value: /sonar-new
          - name: sonar.log.level
            value: TRACE
          ports:
          - containerPort: 9000
            protocol: TCP
      volumes:
        - name: sonar-pv-volume
          persistentVolumeClaim:
            claimName: sonar-pv-claim
        - name: sonar-pv-volume-ext
          persistentVolumeClaim:
            claimName: sonar-pv-claim-ext
        - name : tmp-dir
          emptyDir: {}

Pod Logs

Defaulted container "sonarqube" out of: sonarqube, fix-the-volume-permission (init), fix-the-volume-permission1 (init), fix-the-volume-permission2 (init)
2023.05.11 06:11:47 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp
2023.05.11 06:11:47 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.0.0.1:43471]
2023.05.11 06:11:47 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[ELASTICSEARCH] from [/opt/sonarqube/elasticsearch]: /opt/sonarqube/elasticsearch/bin/elasticsearch
2023.05.11 06:11:47 INFO  app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2023.05.11 06:11:48 INFO  es[][o.e.n.Node] version[7.17.8], pid[26], build[default/tar/120eabe1c8a0cb2ae87cffc109a5b65d213e9df1/2022-12-02T17:33:09.727072865Z], OS[Linux/5.15.0-1036-azure/amd64], JVM[Eclipse Adoptium/OpenJDK 64-Bit Server VM/17.0.7/17.0.7+7]
2023.05.11 06:11:48 INFO  es[][o.e.n.Node] JVM home [/opt/java/openjdk]
2023.05.11 06:11:48 INFO  es[][o.e.n.Node] JVM arguments [-XX:+UseG1GC, -Djava.io.tmpdir=/opt/sonarqube/temp, -XX:ErrorFile=/opt/sonarqube/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=/opt/sonarqube/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, -Xmx2G, -Xms2G, -XX:+HeapDumpOnOutOfMemoryError, -Des.path.home=/opt/sonarqube/elasticsearch, -Des.path.conf=/opt/sonarqube/temp/conf/es, -Des.distribution.flavor=default, -Des.distribution.type=tar, -Des.bundled_jdk=false]
2023.05.11 06:11:49 INFO  es[][o.e.p.PluginsService] loaded module [analysis-common]
2023.05.11 06:11:49 INFO  es[][o.e.p.PluginsService] loaded module [lang-painless]
2023.05.11 06:11:49 INFO  es[][o.e.p.PluginsService] loaded module [parent-join]
2023.05.11 06:11:49 INFO  es[][o.e.p.PluginsService] loaded module [reindex]
2023.05.11 06:11:49 INFO  es[][o.e.p.PluginsService] loaded module [transport-netty4]
2023.05.11 06:11:49 INFO  es[][o.e.p.PluginsService] no plugins loaded
2023.05.11 06:11:49 INFO  es[][o.e.e.NodeEnvironment] using [1] data paths, mounts [[/opt/sonarqube/data (/dev/sdb)]], net usable_space [269.3gb], net total_space [269.6gb], types [ext4]
2023.05.11 06:11:49 INFO  es[][o.e.e.NodeEnvironment] heap size [2gb], compressed ordinary object pointers [true]
2023.05.11 06:11:49 INFO  es[][o.e.n.Node] node name [sonarqube], node ID [ejot96UXR2OnCQwXrOhGRg], cluster name [sonarqube], roles [data_frozen, master, remote_cluster_client, data, data_content, data_hot, data_warm, data_cold, ingest]
2023.05.11 06:11:51 INFO  es[][o.e.t.NettyAllocator] creating NettyAllocator with the following configs: [name=elasticsearch_configured, chunk_size=256kb, suggested_max_allocation_size=256kb, factors={es.unsafe.use_netty_default_chunk_and_page_size=false, g1gc_enabled=true, g1gc_region_size=1mb}]
2023.05.11 06:11:51 INFO  es[][o.e.i.r.RecoverySettings] using rate limit [40mb] with [default=40mb, read=0b, write=0b, max=0b]
2023.05.11 06:11:51 INFO  es[][o.e.d.DiscoveryModule] using discovery type [zen] and seed hosts providers [settings]
2023.05.11 06:11:51 INFO  es[][o.e.g.DanglingIndicesState] gateway.auto_import_dangling_indices is disabled, dangling indices will not be automatically detected or imported and must be managed manually
2023.05.11 06:11:51 INFO  es[][o.e.n.Node] initialized
2023.05.11 06:11:51 INFO  es[][o.e.n.Node] starting ...
2023.05.11 06:11:52 INFO  es[][o.e.t.TransportService] publish_address {127.0.0.1:43471}, bound_addresses {127.0.0.1:43471}
2023.05.11 06:11:52 WARN  es[][o.e.b.BootstrapChecks] max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]
2023.05.11 06:11:52 INFO  es[][o.e.c.c.Coordinator] cluster UUID [MWxKeDpeQyStQeQooTcpFw]
2023.05.11 06:11:52 INFO  es[][o.e.c.s.MasterService] elected-as-master ([1] nodes joined)[{sonarqube}{ejot96UXR2OnCQwXrOhGRg}{nc5M6ru7Qkqcn-vdGWmcvA}{127.0.0.1}{127.0.0.1:43471}{cdfhimrsw} elect leader, _BECOME_MASTER_TASK_, _FINISH_ELECTION_], term: 260, version: 5225, delta: master node changed {previous [], current [{sonarqube}{ejot96UXR2OnCQwXrOhGRg}{nc5M6ru7Qkqcn-vdGWmcvA}{127.0.0.1}{127.0.0.1:43471}{cdfhimrsw}]}
2023.05.11 06:11:52 INFO  es[][o.e.c.s.ClusterApplierService] master node changed {previous [], current [{sonarqube}{ejot96UXR2OnCQwXrOhGRg}{nc5M6ru7Qkqcn-vdGWmcvA}{127.0.0.1}{127.0.0.1:43471}{cdfhimrsw}]}, term: 260, version: 5225, reason: Publication{term=260, version=5225}
2023.05.11 06:11:52 INFO  es[][o.e.h.AbstractHttpServerTransport] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2023.05.11 06:11:52 INFO  es[][o.e.n.Node] started
2023.05.11 06:11:52 INFO  es[][o.e.g.GatewayService] recovered [7] indices into cluster_state
2023.05.11 06:11:56 INFO  es[][o.e.c.r.a.AllocationService] Cluster health status changed from [RED] to [GREEN] (reason: [shards started [[components][2], [metadatas][0]]]).
2023.05.11 06:11:56 INFO  app[][o.s.a.SchedulerImpl] Process[es] is up
2023.05.11 06:11:56 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[WEB_SERVER] 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 --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 -Xmx1G -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-9.9.1.69595.jar:/opt/sonarqube/lib/jdbc/h2/h2-2.1.214.jar org.sonar.server.app.WebServer /opt/sonarqube/temp/sq-process9815881256162718847properties
WARNING: A terminally deprecated method in java.lang.System has been called
WARNING: System::setSecurityManager has been called by org.sonar.process.PluginSecurityManager (file:/opt/sonarqube/lib/sonar-application-9.9.1.69595.jar)
WARNING: Please consider reporting this to the maintainers of org.sonar.process.PluginSecurityManager
WARNING: System::setSecurityManager will be removed in a future release
2023.05.11 06:11:56 INFO  web[][o.s.p.ProcessEntryPoint] Starting Web Server
2023.05.11 06:11:57 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 9.9.1.69595 / ab53fa3b811b30e6c4391e9f77edce9019d84480
2023.05.11 06:11:57 INFO  web[][o.s.s.p.d.EmbeddedDatabase] Starting embedded database on port 9092 with url jdbc:h2:tcp://127.0.0.1:9092/sonar;NON_KEYWORDS=VALUE
2023.05.11 06:11:57 INFO  web[][o.s.s.p.d.EmbeddedDatabase] Embedded database started. Data stored in: /opt/sonarqube/data
2023.05.11 06:11:57 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:h2:tcp://127.0.0.1:9092/sonar;NON_KEYWORDS=VALUE
2023.05.11 06:11:57 INFO  web[][c.z.h.HikariDataSource] HikariPool-1 - Starting...
2023.05.11 06:11:58 INFO  web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection conn2: url=jdbc:h2:tcp://127.0.0.1:9092/sonar user=
2023.05.11 06:11:58 INFO  web[][c.z.h.HikariDataSource] HikariPool-1 - Start completed.
2023.05.11 06:11:58 WARN  web[][o.s.db.dialect.H2] H2 database should be used for evaluation purpose only.
2023.05.11 06:11:58 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
2023.05.11 06:11:58 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2023.05.11 06:11:58 INFO  web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport, monitoring, scim
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy ABAP Code Quality and Security / 3.11.0.4030 / efe73c1da897a69d2545e79710bec0909326dcdb
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Apex Code Quality and Security / 1.11.0.3905 / e1f28bc000e04ca01881e84218d01d464a17a36f
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy C# Code Quality and Security / 8.51.0.59060 / e14c642f118958f22fd08841dc42f9aae480366a
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy CFamily Code Quality and Security / 6.41.0.60884 / 6efcc8197e558ca2a78cada46494e8afe8c821ff
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy COBOL Code Quality / 5.2.0.5949 / e2e398ef68a9ee212c8b991cf05ee1fae28e5326
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Configuration detection fot Code Quality and Security / 1.2.0.267 / 4f37ba9ffb37a96d5883e52ad392ed32c5c6eaab
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Dataflow Bug Detection / 1.10.0.3046 / 0
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Dataflow Bug Detection Rules for Java / 1.10.0.3046 / 0
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Dataflow Bug Detection Rules for Python / 1.10.0.3046 / 0
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Flex Code Quality and Security / 2.8.0.3166 / 01f66bdddc678966c81a9064ed139156a6a89c97
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Go Code Quality and Security / 1.11.0.3905 / e1f28bc000e04ca01881e84218d01d464a17a36f
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy HTML Code Quality and Security / 3.7.1.3306 / d720acc6860c6d8b69ec4d17570a398a1e216da1
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy IaC Code Quality and Security / 1.11.0.2847 / 6892bd3a7320b3c110717acfdb18c4c7451069fd
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy JaCoCo / 1.3.0.1538 / 74a7798c7cea687c72ed9df40c93eb7ea2a58c49
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Java Code Quality and Security / 7.16.0.30901 / 4b1436558dfd5fc00c8d9aae8bb0364ba122c73e
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy JavaScript/TypeScript/CSS Code Quality and Security / 9.13.0.20537 / 68ff7657415044b86033814795ed95fc1f1558f1
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Kotlin Code Quality and Security / 2.12.0.1956 / a6df1ae252bd62d63f8673c28f87ad14258a7904
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy PHP Code Quality and Security / 3.27.1.9352 / 3ddc5a03e1a7e3729d41e7c1a30a37d5715958c7
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy PL/I Code Quality and Security / 1.12.0.3443 / e9d43136dec6eea6c0129c12d2a019d141fdcc39
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy PL/SQL Code Quality and Security / 3.8.0.4948 / ab46f4c11644e5c9b17f0a5a1612d4b7362e04f3
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Python Code Quality and Security / 3.24.0.10784 / 30aa413d983f6c37b4298eba00555c3050009b52
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy RPG Code Quality / 3.3.0.3147 / 9cb6a4566eb55cc6b874220ab95f0504a952b560
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Ruby Code Quality and Security / 1.11.0.3905 / e1f28bc000e04ca01881e84218d01d464a17a36f
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Scala Code Quality and Security / 1.11.0.3905 / e1f28bc000e04ca01881e84218d01d464a17a36f
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Swift Code Quality and Security / 4.8.0.5759 / 3d5b95aaf19a398736a7f5eec314c3c05f7193d2
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy T-SQL Code Quality and Security / 1.7.0.5449 / 110c82f888b1f40e1c2a0d3165fcffd413af36a5
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Text Code Quality and Security / 2.0.2.1090 / 7eb026363b98f5f98b43c603772b5177869c2c6a
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy VB.NET Code Quality and Security / 8.51.0.59060 / e14c642f118958f22fd08841dc42f9aae480366a
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy VB6 Code Quality and Security / 2.9.0.3341 / 2066b6ff3d7c789fefa0b86c6f70e9c9eb08f852
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Analysis / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for C# / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for JS / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for Java / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for PHP / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for Python / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1
2023.05.11 06:11:59 INFO  web[][o.s.s.p.ServerPluginManager] Deploy XML Code Quality and Security / 2.7.0.3820 / 656bccc1910d50c8984536bd2dfd917066b858e6
2023.05.11 06:12:00 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [http://localhost:9001]
2023.05.11 06:12:00 WARN  web[][o.s.a.s.w.WebService$Action] Description is not set on action api/monitoring/metrics
2023.05.11 06:12:00 WARN  web[][o.s.a.s.w.WebService$Action] Since is not set on action api/monitoring/metrics
2023.05.11 06:12:00 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/monitoring/metrics
2023.05.11 06:12:00 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/system/liveness
2023.05.11 06:12:00 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@6c6c2a73 [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, ...], exclusions=[/api/components/update_key, ...]}]
2023.05.11 06:12:00 INFO  web[][o.s.s.p.DetectPluginChange] Detect plugin changes
2023.05.11 06:12:00 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2023.05.11 06:12:00 INFO  web[][o.s.s.p.DetectPluginChange] No plugin change detected
2023.05.11 06:12:01 INFO  web[][o.s.s.s.LogServerId] Server ID: 147B411E-AYfw7iKoKGxZt2MPXLt3
2023.05.11 06:12:01 WARN  web[][o.s.s.a.LogOAuthWarning] For security reasons, OAuth authentication should use HTTPS. You should set the property 'Administration > Configuration > Server base URL' to a HTTPS URL.
2023.05.11 06:12:01 INFO  web[][o.s.s.p.UpdateCenterClient] Update center: https://update.sonarsource.org/update-center.properties (no proxy)
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action saml/validation_init
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/system/liveness
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/analysis_cache/get
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/check_pat
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/push/sonarlint_events
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/security_reports/download
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/views/definition
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/regulatory_reports/download
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/governance_reports/download
2023.05.11 06:12:02 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/support/info
2023.05.11 06:12:02 INFO  web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired session tokens has removed 0 elements
2023.05.11 06:12:02 INFO  web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired SAML message ids has removed 0 elements
2023.05.11 06:12:02 INFO  web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2023.05.11 06:12:02 INFO  web[][o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2023.05.11 06:12:03 INFO  web[][o.s.s.s.GeneratePluginIndex] Generate scanner plugin index
2023.05.11 06:12:03 INFO  web[][o.s.s.s.RegisterPermissionTemplates] Register permission templates
2023.05.11 06:12:03 INFO  web[][o.s.s.s.RenameDeprecatedPropertyKeys] Rename deprecated property keys
2023.05.11 06:12:03 INFO  web[][o.s.s.s.UpgradeSuggestionsCleaner] Dismissed messages cleanup
2023.05.11 06:12:03 INFO  web[][o.s.s.s.RegisterPlugins] Register plugins
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.SonarLintConnectionFilter@9af3906 [pattern=UrlPattern{inclusions=[/api/*], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@10c6e39e [pattern=UrlPattern{inclusions=[/api/issues/delete_comment.*, ...], exclusions=[/api/authentication/login.*, ...]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceReroutingFilter@31f1f07 [pattern=UrlPattern{inclusions=[/api/components/bulk_update_key, ...], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.DefaultAdminCredentialsVerifierFilter@37200765 [pattern=UrlPattern{inclusions=[/*], exclusions=[*.css, ...]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.InitFilter@47b77f8e [pattern=UrlPattern{inclusions=[/sessions/init/*], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.SamlValidationRedirectionFilter@604abef5 [pattern=UrlPattern{inclusions=[/oauth2/callback/saml], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.OAuth2CallbackFilter@1b5672dc [pattern=UrlPattern{inclusions=[/oauth2/callback/*], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ResetPasswordFilter@2cfa55fc [pattern=UrlPattern{inclusions=[/*], exclusions=[*.css, ...]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LoginAction@1a7b8323 [pattern=UrlPattern{inclusions=[/api/authentication/login], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LogoutAction@4fa800b5 [pattern=UrlPattern{inclusions=[/api/authentication/logout], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.ValidateAction@61a8efaf [pattern=UrlPattern{inclusions=[/api/authentication/validate], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.saml.ws.ValidationInitAction@22dcbcba [pattern=UrlPattern{inclusions=[/saml/validation_init], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.saml.ws.ValidationAction@27b6b1f4 [pattern=UrlPattern{inclusions=[/saml/validation], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.user.ws.ChangePasswordAction@504d14e2 [pattern=UrlPattern{inclusions=[/api/users/change_password], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.plugins.PluginsRiskConsentFilter@65c5a508 [pattern=UrlPattern{inclusions=[/*], exclusions=[*.css, ...]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter com.A.B.A@4d2debfe [pattern=UrlPattern{inclusions=[/api/scim/v2/Users, ...], exclusions=[]}]
2023.05.11 06:12:03 INFO  web[][o.s.s.q.ProjectsInWarningDaemon] Counting number of projects in warning is not started as there are no projects in this situation.
2023.05.11 06:12:03 INFO  web[][o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance
2023.05.11 06:12:03 INFO  web[][o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance (done) | time=5ms
2023.05.11 06:12:03 INFO  web[][o.s.s.p.p.PlatformLevelStartup] Running Enterprise Edition
2023.05.11 06:12:03 INFO  web[][o.s.s.p.Platform] Web Server is operational
2023.05.11 06:12:03 INFO  app[][o.s.a.SchedulerImpl] Process[web] is up
2023.05.11 06:12:03 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[COMPUTE_ENGINE] 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-exports=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/java.lang=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 -Xmx2G -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-9.9.1.69595.jar:/opt/sonarqube/lib/jdbc/h2/h2-2.1.214.jar org.sonar.ce.app.CeServer /opt/sonarqube/temp/sq-process2727150750386054746properties
WARNING: A terminally deprecated method in java.lang.System has been called
WARNING: System::setSecurityManager has been called by org.sonar.process.PluginSecurityManager (file:/opt/sonarqube/lib/sonar-application-9.9.1.69595.jar)
WARNING: Please consider reporting this to the maintainers of org.sonar.process.PluginSecurityManager
WARNING: System::setSecurityManager will be removed in a future release
2023.05.11 06:12:03 INFO  ce[][o.s.p.ProcessEntryPoint] Starting Compute Engine
2023.05.11 06:12:03 INFO  ce[][o.s.ce.app.CeServer] Compute Engine starting up...
2023.05.11 06:12:04 INFO  ce[][o.sonar.db.Database] Create JDBC data source for jdbc:h2:tcp://127.0.0.1:9092/sonar;NON_KEYWORDS=VALUE
2023.05.11 06:12:04 INFO  ce[][c.z.h.HikariDataSource] HikariPool-1 - Starting...
2023.05.11 06:12:04 INFO  ce[][c.z.h.p.HikariPool] HikariPool-1 - Added connection conn0: url=jdbc:h2:tcp://127.0.0.1:9092/sonar user=
2023.05.11 06:12:04 INFO  ce[][c.z.h.HikariDataSource] HikariPool-1 - Start completed.
2023.05.11 06:12:04 WARN  ce[][o.s.db.dialect.H2] H2 database should be used for evaluation purpose only.
2023.05.11 06:12:04 INFO  ce[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
2023.05.11 06:12:04 INFO  ce[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: enterprise-edition, ce-workers, developer-scanner, developer-server, governance, license, securityreport, monitoring, scim
2023.05.11 06:12:05 INFO  ce[][o.s.c.c.CePluginRepository] Load plugins
2023.05.11 06:12:06 INFO  ce[][o.s.c.c.ComputeEngineContainerImpl] Running Enterprise edition
2023.05.11 06:12:06 INFO  ce[][o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance
2023.05.11 06:12:06 INFO  ce[][o.s.s.e.CoreExtensionBootstraper] Bootstrapping Governance (done) | time=5ms
2023.05.11 06:12:06 INFO  ce[][o.s.ce.app.CeServer] Compute Engine is started
2023.05.11 06:12:06 INFO  app[][o.s.a.SchedulerImpl] Process[ce] is up
2023.05.11 06:12:06 INFO  app[][o.s.a.SchedulerImpl] SonarQube is operational
1 Like

Hi,

You’ve set sonar.jdbc.* and what I’m seeing in the docs is SONAR_JDBC_ (capitalization and dots versus underscores). The old var names had been deprecated for a while, and finally dropped at the end of the 9-series.

BTW, thanks for starting out with both the logs and the YAML file. :smile:

 
HTH,
Ann

Um. Can you be a little more explicit, such as a URL to the documentation and the issue. I just restarted my SQ Enterprise service and got this error and was underwhelmed by information in the error message.

Hi @SeanMcLinden,

Welcome to the community!

Here you go.

 
Ann