Sonarqube serve installation issue

[fredchienftc (Fred Chien)]

Hi Sir/Madam,

Since the license is expired and we are installing new Sonarqube server on the another machine

The original Sonarqube is hosting on Redhat and the new one is on Ubunbtu 22.04.4 LTS
The Sonarqube developer version is :sonarqube-10.7.0.96327

We suffer some problem on installation.

If we create a user “sonar” and use it to start the server,

/opt/sonarqube-10.7.0.96327/bin/linux-x86-64$ ./sonar.sh start

/usr/bin/java

Starting SonarQube…

./sonar.sh: line 165: ./SonarQube.pid: Permission denied

Failed to start SonarQube.

./sonar.sh: line 164: …/…/logs/nohup.log: Permission denied

Then we add the user “sonar” to sudoer and try again

sonar@ftclnx157:/opt/sonarqube-10.7.0.96327/bin/linux-x86-64$ sudo ./sonar.sh start

[sudo] password for sonar:

/usr/bin/java

Starting SonarQube…

Started SonarQube.

sonar@ftclnx157:/opt/sonarqube-10.7.0.96327/bin/linux-x86-64$ sudo ./sonar.sh console

/usr/bin/java

Running SonarQube…

Removed stale pid file: ./SonarQube.pid

2024.11.05 19:31:27 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube-10.7.0.96327/temp

2024.11.05 19:31:27 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.0.0.1:45781]

2024.11.05 19:31:27 INFO app[o.s.a.ProcessLauncherImpl] Launch process[ELASTICSEARCH] from [/opt/sonarqube-10.7.0.96327/elasticsearch]: /usr/lib/jvm/java-17-openjdk-amd64/bin/java -Xms4m -Xmx64m -XX:+UseSerialGC -Dcli.name=server -Dcli.script=./bin/elasticsearch -Dcli.libs=lib/tools/server-cli -Des.path.home=/opt/sonarqube-10.7.0.96327/elasticsearch -Des.path.conf=/opt/sonarqube-10.7.0.96327/temp/conf/es -Des.distribution.type=tar -cp /opt/sonarqube-10.7.0.96327/elasticsearch/lib/:/opt/sonarqube-10.7.0.96327/elasticsearch/lib/cli-launcher/ org.elasticsearch.launcher.CliToolLauncher

2024.11.05 19:31:27 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running

2024.11.05 19:31:30 INFO es[o.e.n.NativeAccess] Using [jna] native provider and native methods for [Linux]

2024.11.05 19:31:30 ERROR es[o.e.b.Elasticsearch] fatal exception while booting Elasticsearch

java.lang.RuntimeException: can not run elasticsearch as root

at org.elasticsearch.bootstrap.Elasticsearch.initializeNatives(Elasticsearch.java:286) ~[elasticsearch-8.14.1.jar:?]

at org.elasticsearch.bootstrap.Elasticsearch.initPhase2(Elasticsearch.java:169) ~[elasticsearch-8.14.1.jar:?]

at org.elasticsearch.bootstrap.Elasticsearch.main(Elasticsearch.java:74) ~[elasticsearch-8.14.1.jar:?]

ERROR: Elasticsearch did not exit normally - check the logs at /opt/sonarqube-10.7.0.96327/logs/sonarqube.log

ERROR: Elasticsearch died while starting up, with exit code 1

2024.11.05 19:31:30 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [ElasticSearch]: 1

2024.11.05 19:31:30 INFO app[o.s.a.SchedulerImpl] Process[ElasticSearch] is stopped

2024.11.05 19:31:30 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped

It shows the ElasticSearch failed

Do you have any suggestion how to proceed it?
Thanks.
Fred
Please see the attached logs:
sonar-1105.tar.gz.zip (2.5 KB)

[Colin]

Hey there.

@fredchienftc

java.lang.RuntimeException: can not run elasticsearch as root

You can’t start SonarQube as root.

If you’re facing permissions issues as your other user, you probably need to run a chown -R on the SonarQube install directory to make sure the user starting SonarQube has full read/write access to the directory. For example:

chown -R sonarqube:sonarqube /home/sonarqube

[fredchienftc (Fred Chien)]

Hello Colin,
Thanks for your comment.
I have set the folder permission to the user “sonar”
sonar@ftclnx157:/opt/sonarqube-10.7.0.96327/bin/linux-x86-64$ ls -al
total 24
drwxr-xr-x 2 sonar sonar 4096 ?? 9 01:25 .
drwxr-xr-x 6 sonar sonar 4096 銋? 27 15:13 …
-rwxr-xr-x 1 sonar sonar 7197 ?? 5 19:35 sonar.sh
-rwxr-xr-x 1 sonar sonar 7192 ?? 5 19:34 sonar.sh.org
Then start sonarqube server
sonar@ftclnx157:/opt/sonarqube-10.7.0.96327/bin/linux-x86-64$ ./sonar.sh start
/usr/bin/java
Starting SonarQube…
Started SonarQube.
When checking the status of the server, it show some error:
Sorry that it’s very huge message and please dont mind to read it through
sonar@ftclnx157:/opt/sonarqube-10.7.0.96327/bin/linux-x86-64$ ./sonar.sh console

/usr/bin/java
Running SonarQube…
Removed stale pid file: ./SonarQube.pid
2024.11.09 01:30:56 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube-10.7.0.96327/temp
2024.11.09 01:30:56 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.0.0.1:38005]
2024.11.09 01:30:56 INFO app[o.s.a.ProcessLauncherImpl] Launch process[ELASTICSEARCH] from [/opt/sonarqube-10.7.0.96327/elasticsearch]: /usr/lib/jvm/java-17-openjdk-amd64/bin/java -Xms4m -Xmx64m -XX:+UseSerialGC -Dcli.name=server -Dcli.script=./bin/elasticsearch -Dcli.libs=lib/tools/server-cli -Des.path.home=/opt/sonarqube-10.7.0.96327/elasticsearch -Des.path.conf=/opt/sonarqube-10.7.0.96327/temp/conf/es -Des.distribution.type=tar -cp /opt/sonarqube-10.7.0.96327/elasticsearch/lib/:/opt/sonarqube-10.7.0.96327/elasticsearch/lib/cli-launcher/ org.elasticsearch.launcher.CliToolLauncher
2024.11.09 01:30:56 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2024-11-09 01:30:59,735 main ERROR RollingFileManager (/opt/sonarqube-10.7.0.96327/logs/es.log) java.io.FileNotFoundException: /opt/sonarqube-10.7.0.96327/logs/es.log (Permission denied) java.io.FileNotFoundException: /opt/sonarqube-10.7.0.96327/logs/es.log (Permission denied)
at java.base/java.io.FileOutputStream.open0(Native Method)
at java.base/java.io.FileOutputStream.open(FileOutputStream.java:293)
at java.base/java.io.FileOutputStream.(FileOutputStream.java:235)
at java.base/java.io.FileOutputStream.(FileOutputStream.java:155)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory.createManager(RollingFileManager.java:748)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory.createManager(RollingFileManager.java:718)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.AbstractManager.getManager(AbstractManager.java:144)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.OutputStreamManager.getManager(OutputStreamManager.java:100)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.rolling.RollingFileManager.getFileManager(RollingFileManager.java:217)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.RollingFileAppender$Builder.build(RollingFileAppender.java:135)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.RollingFileAppender$Builder.build(RollingFileAppender.java:62)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.plugins.util.PluginBuilder.build(PluginBuilder.java:124)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.createPluginObject(AbstractConfiguration.java:1138)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:1063)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:1055)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.doConfigure(AbstractConfiguration.java:664)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.initialize(AbstractConfiguration.java:258)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.start(AbstractConfiguration.java:304)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.LoggerContext.setConfiguration(LoggerContext.java:621)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.LoggerContext.start(LoggerContext.java:285)
at org.elasticsearch.server@8.14.1/org.elasticsearch.common.logging.LogConfigurator.configure(LogConfigurator.java:250)
at org.elasticsearch.server@8.14.1/org.elasticsearch.common.logging.LogConfigurator.configure(LogConfigurator.java:129)
at org.elasticsearch.server@8.14.1/org.elasticsearch.bootstrap.Elasticsearch.initPhase1(Elasticsearch.java:135)
at org.elasticsearch.server@8.14.1/org.elasticsearch.bootstrap.Elasticsearch.main(Elasticsearch.java:70)

2024-11-09 01:30:59,743 main ERROR Could not create plugin of type class org.apache.logging.log4j.core.appender.RollingFileAppender for element RollingFile: java.lang.IllegalStateException: ManagerFactory [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory@645aa696] unable to create manager for [/opt/sonarqube-10.7.0.96327/logs/es.log] with data [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$FactoryData@6caf0677[pattern=/opt/sonarqube-10.7.0.96327/logs/es.%d{yyyy-MM-dd}.log, append=true, bufferedIO=true, bufferSize=8192, policy=CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)]), strategy=DefaultRolloverStrategy(min=-2147483648, max=2147483647, useMax=false), advertiseURI=null, layout=%d{yyyy.MM.dd HH:mm:ss} %-5level es[%logger{1.}] %msg%n, filePermissions=null, fileOwner=null]] java.lang.IllegalStateException: ManagerFactory [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory@645aa696] unable to create manager for [/opt/sonarqube-10.7.0.96327/logs/es.log] with data [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$FactoryData@6caf0677[pattern=/opt/sonarqube-10.7.0.96327/logs/es.%d{yyyy-MM-dd}.log, append=true, bufferedIO=true, bufferSize=8192, policy=CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)]), strategy=DefaultRolloverStrategy(min=-2147483648, max=2147483647, useMax=false), advertiseURI=null, layout=%d{yyyy.MM.dd HH:mm:ss} %-5level es[%logger{1.}] %msg%n, filePermissions=null, fileOwner=null]]
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.AbstractManager.getManager(AbstractManager.java:146)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.OutputStreamManager.getManager(OutputStreamManager.java:100)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.rolling.RollingFileManager.getFileManager(RollingFileManager.java:217)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.RollingFileAppender$Builder.build(RollingFileAppender.java:135)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.appender.RollingFileAppender$Builder.build(RollingFileAppender.java:62)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.plugins.util.PluginBuilder.build(PluginBuilder.java:124)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.createPluginObject(AbstractConfiguration.java:1138)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:1063)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:1055)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.doConfigure(AbstractConfiguration.java:664)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.initialize(AbstractConfiguration.java:258)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.start(AbstractConfiguration.java:304)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.LoggerContext.setConfiguration(LoggerContext.java:621)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.LoggerContext.start(LoggerContext.java:285)
at org.elasticsearch.server@8.14.1/org.elasticsearch.common.logging.LogConfigurator.configure(LogConfigurator.java:250)
at org.elasticsearch.server@8.14.1/org.elasticsearch.common.logging.LogConfigurator.configure(LogConfigurator.java:129)
at org.elasticsearch.server@8.14.1/org.elasticsearch.bootstrap.Elasticsearch.initPhase1(Elasticsearch.java:135)
at org.elasticsearch.server@8.14.1/org.elasticsearch.bootstrap.Elasticsearch.main(Elasticsearch.java:70)

2024-11-09 01:30:59,744 main ERROR Unable to invoke factory method in class org.apache.logging.log4j.core.appender.RollingFileAppender for element RollingFile: java.lang.IllegalStateException: No factory method found for class org.apache.logging.log4j.core.appender.RollingFileAppender java.lang.IllegalStateException: No factory method found for class org.apache.logging.log4j.core.appender.RollingFileAppender
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.plugins.util.PluginBuilder.findFactoryMethod(PluginBuilder.java:260)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.plugins.util.PluginBuilder.build(PluginBuilder.java:136)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.createPluginObject(AbstractConfiguration.java:1138)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:1063)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:1055)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.doConfigure(AbstractConfiguration.java:664)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.initialize(AbstractConfiguration.java:258)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.config.AbstractConfiguration.start(AbstractConfiguration.java:304)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.LoggerContext.setConfiguration(LoggerContext.java:621)
at org.apache.logging.log4j.core@8.14.1/org.apache.logging.log4j.core.LoggerContext.start(LoggerContext.java:285)
at org.elasticsearch.server@8.14.1/org.elasticsearch.common.logging.LogConfigurator.configure(LogConfigurator.java:250)
at org.elasticsearch.server@8.14.1/org.elasticsearch.common.logging.LogConfigurator.configure(LogConfigurator.java:129)
at org.elasticsearch.server@8.14.1/org.elasticsearch.bootstrap.Elasticsearch.initPhase1(Elasticsearch.java:135)
at org.elasticsearch.server@8.14.1/org.elasticsearch.bootstrap.Elasticsearch.main(Elasticsearch.java:70)

2024-11-09 01:30:59,745 main ERROR Null object returned for RollingFile in Appenders.
2024-11-09 01:30:59,745 main ERROR Unable to locate appender “file_es” for logger config “root”
2024.11.09 01:30:59 INFO es[o.e.n.NativeAccess] Using [jna] native provider and native methods for [Linux]
2024.11.09 01:31:00 INFO es[o.e.n.Node] version[8.14.1], pid[1041430], build[tar/93a57a1a76f556d8aee6a90d1a95b06187501310/2024-06-10T23:35:17.114581191Z], OS[Linux/6.5.0-44-generic/amd64], JVM[Ubuntu/OpenJDK 64-Bit Server VM/17.0.12/17.0.12+7-Ubuntu-1ubuntu222.04]
2024.11.09 01:31:00 INFO es[o.e.n.Node] JVM home [/usr/lib/jvm/java-17-openjdk-amd64], using bundled JDK [false]
2024.11.09 01:31:00 INFO es[o.e.n.Node] JVM arguments [-Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -Djava.security.manager=allow, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -XX:-OmitStackTraceInFastThrow, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Dlog4j2.formatMsgNoLookups=true, -Djava.locale.providers=SPI,COMPAT, --add-opens=java.base/java.io=org.elasticsearch.preallocate, --add-opens=org.apache.lucene.core/org.apache.lucene.store=org.elasticsearch.vec, -XX:ReplayDataFile=logs/replay_pid%p.log, -Djava.library.path=/opt/sonarqube-10.7.0.96327/elasticsearch/lib/platform/linux-x64:/usr/java/packages/lib:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib, -Djna.library.path=/opt/sonarqube-10.7.0.96327/elasticsearch/lib/platform/linux-x64:/usr/java/packages/lib:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib, -Des.distribution.type=tar, -XX:+UseG1GC, -Djava.io.tmpdir=/opt/sonarqube-10.7.0.96327/temp, -XX:ErrorFile=/opt/sonarqube-10.7.0.96327/logs/es_hs_err_pid%p.log, -Xlog:disable, -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-10.7.0.96327/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, -Des.enforce.bootstrap.checks=true, -Xmx512m, -Xms512m, -XX:MaxDirectMemorySize=256m, -XX:+HeapDumpOnOutOfMemoryError, -XX:G1HeapRegionSize=4m, -XX:InitiatingHeapOccupancyPercent=30, -XX:G1ReservePercent=15, --module-path=/opt/sonarqube-10.7.0.96327/elasticsearch/lib, --add-modules=jdk.net, --add-modules=ALL-MODULE-PATH, -Djdk.module.main=org.elasticsearch.server]
2024.11.09 01:31:00 INFO es[o.e.n.Node] Default Locale [en_US]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [rest-root]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [x-pack-core]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [x-pack-redact]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [reindex]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [x-pack-security]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [x-pack-apm-data]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [lang-painless]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [parent-join]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [old-lucene-versions]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [counted-keyword]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [x-pack-inference]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [analysis-common]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [health-shards-availability]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [transport-netty4]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [aggregations]
2024.11.09 01:31:01 INFO es[o.e.p.PluginsService] loaded module [apm]
2024.11.09 01:31:02 INFO es[o.e.e.NodeEnvironment] using [1] data paths, mounts [[/ (/dev/mapper/vgubuntu-root)]], net usable_space [63.4gb], net total_space [546.4gb], types [ext4]
2024.11.09 01:31:02 INFO es[o.e.e.NodeEnvironment] heap size [512mb], compressed ordinary object pointers [true]
2024.11.09 01:31:02 INFO es[o.e.n.Node] node name [sonarqube], node ID [539T0o6MSdq6utSWj3w1qQ], cluster name [sonarqube], roles [transform, data_content, data_warm, master, remote_cluster_client, data, data_cold, ingest, data_frozen, ml, data_hot]
2024.11.09 01:31:05 INFO es[o.e.f.FeatureService] Registered local node features [desired_node.version_deprecated, features_supported, health.extended_repository_indicator, knn_retriever_supported, license-trial-independent-version, retrievers_supported, standard_retriever_supported, usage.data_tiers.precalculate_stats]
2024.11.09 01:31:06 INFO es[o.e.x.s.Security] Security is disabled
2024.11.09 01:31:06 INFO es[o.e.x.a.APMPlugin] APM ingest plugin is disabled
2024.11.09 01:31:06 INFO es[o.e.t.a.APM] Sending apm metrics is disabled
2024.11.09 01:31:06 INFO es[o.e.t.a.APM] Sending apm tracing is disabled
2024.11.09 01:31:06 INFO es[o.e.t.n.NettyAllocator] creating NettyAllocator with the following configs: [name=unpooled, suggested_max_allocation_size=1mb, factors={es.unsafe.use_unpooled_allocator=null, g1gc_enabled=true, g1gc_region_size=4mb, heap_size=512mb}]
2024.11.09 01:31:06 INFO es[o.e.i.r.RecoverySettings] using rate limit [40mb] with [default=40mb, read=0b, write=0b, max=0b]
2024.11.09 01:31:06 INFO es[o.e.d.DiscoveryModule] using discovery type [single-node] and seed hosts providers [settings]
2024.11.09 01:31:07 INFO es[o.e.n.Node] initialized
2024.11.09 01:31:07 INFO es[o.e.n.Node] starting …
2024.11.09 01:31:07 INFO es[o.e.t.TransportService] publish_address {127.0.0.1:38005}, bound_addresses {127.0.0.1:38005}
2024.11.09 01:31:07 INFO es[o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2024.11.09 01:31:07 INFO es[o.e.c.c.ClusterBootstrapService] this node is locked into cluster UUID [51TRsF0zRQ6BWbvo87Ratg] and will not attempt further cluster bootstrapping
2024.11.09 01:31:07 INFO es[o.e.c.s.MasterService] elected-as-master ([1] nodes joined in term 3)[FINISH_ELECTION, {sonarqube}{539T0o6MSdq6utSWj3w1qQ}{rR8q2-i5RdWSqioxQR2UGQ}{sonarqube}{127.0.0.1}{127.0.0.1:38005}{cdfhilmrstw}{8.14.1}{7000099-8505000} completing election], term: 3, version: 12, delta: master node changed {previous , current [{sonarqube}{539T0o6MSdq6utSWj3w1qQ}{rR8q2-i5RdWSqioxQR2UGQ}{sonarqube}{127.0.0.1}{127.0.0.1:38005}{cdfhilmrstw}{8.14.1}{7000099-8505000}]}
2024.11.09 01:31:07 INFO es[o.e.c.s.ClusterApplierService] master node changed {previous , current [{sonarqube}{539T0o6MSdq6utSWj3w1qQ}{rR8q2-i5RdWSqioxQR2UGQ}{sonarqube}{127.0.0.1}{127.0.0.1:38005}{cdfhilmrstw}{8.14.1}{7000099-8505000}]}, term: 3, version: 12, reason: Publication{term=3, version=12}
2024.11.09 01:31:07 INFO es[o.e.c.f.AbstractFileWatchingService] starting file watcher …
2024.11.09 01:31:07 INFO es[o.e.c.f.AbstractFileWatchingService] file settings service up and running [tid=41]
2024.11.09 01:31:07 INFO es[o.e.r.s.FileSettingsService] setting file [/opt/sonarqube-10.7.0.96327/temp/conf/es/operator/settings.json] not found, initializing [file_settings] as empty
2024.11.09 01:31:07 INFO es[o.e.c.c.NodeJoinExecutor] node-join: [{sonarqube}{539T0o6MSdq6utSWj3w1qQ}{rR8q2-i5RdWSqioxQR2UGQ}{sonarqube}{127.0.0.1}{127.0.0.1:38005}{cdfhilmrstw}{8.14.1}{7000099-8505000}] with reason [completing election]
2024.11.09 01:31:07 INFO es[o.e.h.AbstractHttpServerTransport] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2024.11.09 01:31:07 INFO es[o.e.n.Node] started {sonarqube}{539T0o6MSdq6utSWj3w1qQ}{rR8q2-i5RdWSqioxQR2UGQ}{sonarqube}{127.0.0.1}{127.0.0.1:38005}{cdfhilmrstw}{8.14.1}{7000099-8505000}{xpack.installed=true, rack_id=sonarqube}
2024.11.09 01:31:07 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2024.11.09 01:31:07 INFO es[o.e.l.ClusterStateLicenseService] license [d525ed94-cd5b-44bd-ad4d-cb80b34c1037] mode [basic] - valid
2024.11.09 01:31:07 INFO es[o.e.g.GatewayService] recovered [0] indices into cluster_state
2024.11.09 01:31:07 INFO app[o.s.a.ProcessLauncherImpl] Launch process[WEB_SERVER] from [/opt/sonarqube-10.7.0.96327]: /usr/lib/jvm/java-17-openjdk-amd64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube-10.7.0.96327/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 -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -server -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-10.7.0.96327.jar:/opt/sonarqube-10.7.0.96327/lib/jdbc/postgresql/postgresql-42.7.3.jar org.sonar.server.app.WebServer /opt/sonarqube-10.7.0.96327/temp/sq-process14721842743508015968properties
2024.11.09 01:31:08 INFO es[o.e.h.n.s.HealthNodeTaskExecutor] Node [{sonarqube}{539T0o6MSdq6utSWj3w1qQ}] is selected as the current health node.
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-10.7.0.96327/lib/sonar-application-10.7.0.96327.jar)
WARNING: Please consider reporting this to the maintainers of org.sonar.process.PluginSecurityManager
WARNING: System::setSecurityManager will be removed in a future release
2024.11.09 01:31:08 INFO web[o.s.p.ProcessEntryPoint] Starting Web Server
2024.11.09 01:31:08 INFO web[o.s.s.a.TomcatHttpConnectorFactory] Starting Tomcat on port 9000
2024.11.09 01:31:09 INFO web[o.s.s.p.LogServerVersion] SonarQube Server / 10.7.0.96327 / 923a7aad28f71dce1686768b3ad7c4b1bb962f8d
2024.11.09 01:31:09 INFO web[o.s.d.DefaultDatabase] Create JDBC data source for jdbc:postgresql://localhost:5432/sonarqube
2024.11.09 01:31:09 INFO web[c.z.h.HikariDataSource] HikariPool-1 - Starting…
2024.11.09 01:31:10 WARN web[o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.db.DefaultDatabase’: Initialization of bean failed; nested exception is java.lang.IllegalStateException: Fail to connect to database
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.db.DefaultDatabase’: Initialization of bean failed; nested exception is java.lang.IllegalStateException: Fail to connect to database
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:628)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:591)
at org.sonar.core.platform.SpringComponentContainer.startComponents(SpringComponentContainer.java:225)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:80)
at org.sonar.server.platform.platformlevel.PlatformLevel1.start(PlatformLevel1.java:164)
at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:214)
at org.sonar.server.platform.PlatformImpl.startLevel1Container(PlatformImpl.java:179)
at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:79)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4007)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4448)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:721)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:211)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:415)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:878)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:72)
at org.sonar.server.app.WebServer.start(WebServer.java:55)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:97)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:81)
at org.sonar.server.app.WebServer.main(WebServer.java:104)
Caused by: java.lang.IllegalStateException: Fail to connect to database
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:130)
at org.sonar.core.platform.StartableBeanPostProcessor.postProcessBeforeInitialization(StartableBeanPostProcessor.java:33)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
… 44 common frames omitted
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:584)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:571)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:98)
at com.zaxxer.hikari.HikariDataSource.(HikariDataSource.java:80)
at org.sonar.db.DefaultDatabase.createHikariDataSource(DefaultDatabase.java:159)
at org.sonar.db.DefaultDatabase.initDataSource(DefaultDatabase.java:148)
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:126)
… 48 common frames omitted
Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:346)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:273)
at org.postgresql.Driver.makeConnection(Driver.java:446)
at org.postgresql.Driver.connect(Driver.java:298)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:120)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:360)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:461)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:550)
… 53 common frames omitted
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:547)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:602)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:633)
at org.postgresql.core.PGStream.createSocket(PGStream.java:243)
at org.postgresql.core.PGStream.(PGStream.java:98)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:136)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
… 62 common frames omitted
2024.11.09 01:31:10 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process
2024.11.09 01:31:10 INFO app[o.s.a.SchedulerImpl] Process[Web Server] is stopped
2024.11.09 01:31:10 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [ElasticSearch]: 143
2024.11.09 01:31:10 INFO app[o.s.a.SchedulerImpl] Process[ElasticSearch] is stopped
2024.11.09 01:31:10 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped

Fred

[Colin]

@fredchienftc

Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

It looks like your settings for sonar.jbc.url, sonar.jdbc.username, and sonar.jdbc.password need attention. Right now, SonarQube can’t establish a connection to your database. Are you sure you have Postgres running on port 5432?

[fredchienftc (Fred Chien)]

@Colin

Postgres

Hello Colin,
The status of postgresql is active and port is 1433
$ sudo systemctl status postgresql
??postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Mon 2024-11-11 17:14:47 CST; 6s ago
Process: 2668065 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 2668065 (code=exited, status=0/SUCCESS)
CPU: 1ms

?? 11 17:14:47 ftclnx157 systemd[1]: Starting PostgreSQL RDBMS…
?? 11 17:14:47 ftclnx157 systemd[1]: Finished PostgreSQL RDBMS

Now the sonarqube blocked in the port 1433 and error message as below
I have also checked the TCP port usage and port 1433 is available
+HeapDumpOnOutOfMemoryError -server -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-10.7.0.96327.jar:/opt/sonarqube-10.7.0.96327/lib/jdbc/mssql/mssql-jdbc-12.6.3.jre11.jar org.sonar.server.app.WebServer /opt/sonarqube-10.7.0.96327/temp/sq-process6804125680905728678properties
2024.11.11 17:15:36 INFO es[o.e.h.n.s.HealthNodeTaskExecutor] Node [{sonarqube}{539T0o6MSdq6utSWj3w1qQ}] is selected as the current health node.
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-10.7.0.96327/lib/sonar-application-10.7.0.96327.jar)
WARNING: Please consider reporting this to the maintainers of org.sonar.process.PluginSecurityManager
WARNING: System::setSecurityManager will be removed in a future release
2024.11.11 17:15:36 INFO web[o.s.p.ProcessEntryPoint] Starting Web Server
2024.11.11 17:15:36 INFO web[o.s.s.a.TomcatHttpConnectorFactory] Starting Tomcat on port 9000
2024.11.11 17:15:37 INFO web[o.s.s.p.LogServerVersion] SonarQube Server / 10.7.0.96327 / 923a7aad28f71dce1686768b3ad7c4b1bb962f8d
2024.11.11 17:15:37 INFO web[o.s.d.DefaultDatabase] Create JDBC data source for jdbc:sqlserver://localhost;databaseName=sonar
2024.11.11 17:15:37 INFO web[c.z.h.HikariDataSource] HikariPool-1 - Starting…
2024.11.11 17:15:46 WARN web[o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.db.DefaultDatabase’: Initialization of bean failed; nested exception is java.lang.IllegalStateException: Fail to connect to database
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.db.DefaultDatabase’: Initialization of bean failed; nested exception is java.lang.IllegalStateException: Fail to connect to database
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:628)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:591)
at org.sonar.core.platform.SpringComponentContainer.startComponents(SpringComponentContainer.java:225)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:80)
at org.sonar.server.platform.platformlevel.PlatformLevel1.start(PlatformLevel1.java:164)
at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:214)
at org.sonar.server.platform.PlatformImpl.startLevel1Container(PlatformImpl.java:179)
at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:79)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4007)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4448)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:721)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:211)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:415)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:878)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:72)
at org.sonar.server.app.WebServer.start(WebServer.java:55)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:97)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:81)
at org.sonar.server.app.WebServer.main(WebServer.java:104)
Caused by: java.lang.IllegalStateException: Fail to connect to database
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:130)
at org.sonar.core.platform.StartableBeanPostProcessor.postProcessBeforeInitialization(StartableBeanPostProcessor.java:33)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
… 44 common frames omitted
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: The TCP/IP connection to the host localhost, port 1433 has failed. Error: “Connection refused. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:584)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:571)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:98)
at com.zaxxer.hikari.HikariDataSource.(HikariDataSource.java:80)
at org.sonar.db.DefaultDatabase.createHikariDataSource(DefaultDatabase.java:159)
at org.sonar.db.DefaultDatabase.initDataSource(DefaultDatabase.java:148)
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:126)
… 48 common frames omitted
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: “Connection refused. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:233)
at com.microsoft.sqlserver.jdbc.SQLServerException.convertConnectExceptionToSQLServerException(SQLServerException.java:284)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2593)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:721)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3787)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3372)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:3197)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1971)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1263)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:120)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:360)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:461)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:550)
… 53 common frames omitted
2024.11.11 17:15:46 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process
2024.11.11 17:15:46 INFO app[o.s.a.SchedulerImpl] Process[Web Server] is stopped
2024.11.11 17:15:46 INFO app[o.s.a.SchedulerImpl] Process[ElasticSearch] is stopped
2024.11.11 17:15:46 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [ElasticSearch]: 143
2024.11.11 17:15:46 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped

sudo netstat -tuln | grep 1433

Fred.

[Colin]

You seem to have switched your JDBC URL from jdbc:postgresql:// to jdbc:sqlserver://.

If you’re using Postgres, you need to use jdbc:postgresql://.

It’s odd that you have Postgres running on Port 1433, but if you are, your JDBC URL needs to look like this:

jdbc:postgresql://localhost:1433/sonarqube

Of course, sonarqube should be replaced with the actual name of the database you’ve provisioned.

[fredchienftc (Fred Chien)]

Hello Colin,
It’s me again.
I have modifed the setting of sonar.properties and postgresql.conf
Now the failed seems to on the JDBC authentication
I have make sure the password in postgresql for the user “sonar” is “sonar”
Do you have any idea?
I think it’s almost done.

2024.11.11 17:40:07 INFO web[o.s.d.DefaultDatabase] Create JDBC data source for jdbc:postgresql://127.0.0.1:8877/sonar
2024.11.11 17:40:07 INFO web[c.z.h.HikariDataSource] HikariPool-1 - Starting…
2024.11.11 17:40:08 WARN web[o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.db.DefaultDatabase’: Initialization of bean failed; nested exception is java.lang.IllegalStateException: Fail to connect to database
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.db.DefaultDatabase’: Initialization of bean failed; nested exception is java.lang.IllegalStateException: Fail to connect to database
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:628)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:591)
at org.sonar.core.platform.SpringComponentContainer.startComponents(SpringComponentContainer.java:225)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:80)
at org.sonar.server.platform.platformlevel.PlatformLevel1.start(PlatformLevel1.java:164)
at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:214)
at org.sonar.server.platform.PlatformImpl.startLevel1Container(PlatformImpl.java:179)
at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:79)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4007)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4448)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:721)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:211)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:415)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:878)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:72)
at org.sonar.server.app.WebServer.start(WebServer.java:55)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:97)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:81)
at org.sonar.server.app.WebServer.main(WebServer.java:104)
Caused by: java.lang.IllegalStateException: Fail to connect to database
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:130)
at org.sonar.core.platform.StartableBeanPostProcessor.postProcessBeforeInitialization(StartableBeanPostProcessor.java:33)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
… 44 common frames omitted
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: FATAL: password authentication failed for user “sonar”
at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:584)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:571)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:98)
at com.zaxxer.hikari.HikariDataSource.(HikariDataSource.java:80)
at org.sonar.db.DefaultDatabase.createHikariDataSource(DefaultDatabase.java:159)
at org.sonar.db.DefaultDatabase.initDataSource(DefaultDatabase.java:148)
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:126)
… 48 common frames omitted
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user “sonar”
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:698)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:207)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:273)
at org.postgresql.Driver.makeConnection(Driver.java:446)
at org.postgresql.Driver.connect(Driver.java:298)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:120)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:360)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:461)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:550)
… 53 common frames omitted
2024.11.11 17:40:08 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process
2024.11.11 17:40:09 INFO app[o.s.a.SchedulerImpl] Process[Web Server] is stopped
2024.11.11 17:40:09 INFO app[o.s.a.SchedulerImpl] Process[ElasticSearch] is stopped
2024.11.11 17:40:09 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [ElasticSearch]: 143
2024.11.11 17:40:09 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped

Best Regards,
Fred

[fredchienftc (Fred Chien)]

sonar.zip (15.9 KB)
The zip contains sonar.properties and postgresql.conf

[fredchienftc (Fred Chien)]

@fredchienftc

Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: FATAL: password authentication failed for user “sonar”

Hi Colin,
I have found the solution and need to create a database and add the user for postgresql server
And now the Sonarqube is starting successfully
Thanks for your hints

Fred