Sonarqube developer edition cannot able to start

I installed the developer edition and I started the sonar without any DB configuration. Then after installing the SQL server 2019 and entered the connection string in the sonar.properties, right from there I cannot able to start the sonarqube. Also, I dont find the wrapper for my SQ version 10.1.0.7

2023.07.13 14:58:15 INFO  es[][o.e.n.Node] starting ...
2023.07.13 14:58:15 INFO  es[][o.e.t.TransportService] publish_address {127.0.0.1:55370}, bound_addresses {127.0.0.1:55370}
2023.07.13 14:58:16 INFO  es[][o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2023.07.13 14:58:16 WARN  es[][o.e.c.c.ClusterBootstrapService] this node is locked into cluster UUID [pjNJPhSTQauERTHlRuk55Q] but [cluster.initial_master_nodes] is set to [sonarqube]; remove this setting to avoid possible data loss caused by subsequent cluster bootstrap attempts; for further information see https://www.elastic.co/guide/en/elasticsearch/reference/8.7/important-settings.html#initial_master_nodes
2023.07.13 14:58:16 INFO  es[][o.e.c.s.MasterService] elected-as-master ([1] nodes joined)[_FINISH_ELECTION_, {sonarqube}{waXHy9d2QhajECDdFCPuPw}{G1hvfs0CSUy2zh2n4LPaPA}{sonarqube}{127.0.0.1}{127.0.0.1:55370}{cdfhilmrstw}{8.7.0} completing election], term: 18, version: 504, delta: master node changed {previous [], current [{sonarqube}{waXHy9d2QhajECDdFCPuPw}{G1hvfs0CSUy2zh2n4LPaPA}{sonarqube}{127.0.0.1}{127.0.0.1:55370}{cdfhilmrstw}{8.7.0}]}
2023.07.13 14:58:16 INFO  es[][o.e.c.s.ClusterApplierService] master node changed {previous [], current [{sonarqube}{waXHy9d2QhajECDdFCPuPw}{G1hvfs0CSUy2zh2n4LPaPA}{sonarqube}{127.0.0.1}{127.0.0.1:55370}{cdfhilmrstw}{8.7.0}]}, term: 18, version: 504, reason: Publication{term=18, version=504}
2023.07.13 14:58:16 INFO  es[][o.e.r.s.FileSettingsService] starting file settings watcher ...
2023.07.13 14:58:16 INFO  es[][o.e.c.c.NodeJoinExecutor] node-join: [{sonarqube}{waXHy9d2QhajECDdFCPuPw}{G1hvfs0CSUy2zh2n4LPaPA}{sonarqube}{127.0.0.1}{127.0.0.1:55370}{cdfhilmrstw}{8.7.0}] with reason [completing election]
2023.07.13 14:58:17 INFO  es[][o.e.r.s.FileSettingsService] file settings service up and running [tid=31]
2023.07.13 14:58:17 INFO  es[][o.e.h.AbstractHttpServerTransport] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2023.07.13 14:58:17 INFO  es[][o.e.n.Node] started {sonarqube}{waXHy9d2QhajECDdFCPuPw}{G1hvfs0CSUy2zh2n4LPaPA}{sonarqube}{127.0.0.1}{127.0.0.1:55370}{cdfhilmrstw}{8.7.0}{xpack.installed=true, rack_id=sonarqube}
2023.07.13 14:58:17 INFO  es[][o.e.l.LicenseService] license [1e54a92b-771c-4678-8944-53d7d36bf06f] mode [basic] - valid
2023.07.13 14:58:17 INFO  es[][o.e.g.GatewayService] recovered [6] indices into cluster_state
2023.07.13 14:58:17 INFO  es[][o.e.h.n.s.HealthNodeTaskExecutor] Node [{sonarqube}{waXHy9d2QhajECDdFCPuPw}] is selected as the current health node.
2023.07.13 14:58:21 INFO  es[][o.e.c.r.a.AllocationService] current.health="GREEN" message="Cluster health status changed from [RED] to [GREEN] (reason: [shards started [[metadatas][0]]])." previous.health="RED" reason="shards started [[metadatas][0]]"
2023.07.13 14:58:26 INFO  es[][o.e.n.Node] stopping ...
2023.07.13 14:58:26 INFO  es[][o.e.r.s.FileSettingsService] shutting down watcher thread
2023.07.13 14:58:26 INFO  es[][o.e.r.s.FileSettingsService] watcher service stopped
2023.07.13 14:58:26 INFO  es[][o.e.n.Node] stopped
2023.07.13 14:58:26 INFO  es[][o.e.n.Node] closing ...
2023.07.13 14:58:26 INFO  es[][o.e.n.Node] closed

Caused by: 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:9b00922a-382c-4467-8bd3-e7d708b41702
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3937)
	at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1950)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3456)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3077)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2919)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1787)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1229)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
	... 53 common frames omitted
Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
	at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:378)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:321)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:316)
	at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:654)
	at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(CertificateMessage.java:473)
	at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:369)
	at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:396)
	at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:480)
	at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:458)
	at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:201)
	at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:172)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1506)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1421)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:455)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:426)
	at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1839)
	... 63 common frames omitted
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
	at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:439)
	at java.base/sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:306)
	at java.base/sun.security.validator.Validator.validate(Validator.java:264)
	at java.base/sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:242)
	at java.base/sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:113)
	at com.microsoft.sqlserver.jdbc.HostNameOverrideX509TrustManager.checkServerTrusted(SQLServerTrustManager.java:86)
	at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1441)
	at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:638)
	... 75 common frames omitted
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
	at java.base/sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:146)
	at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:127)
	at java.base/java.security.cert.CertPathBuilder.build(CertPathBuilder.java:297)
	at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:434)
	... 82 common frames omitted
2023.07.13 14:58:26 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9005
2023.07.13 14:58:26 INFO  web[][o.s.p.ProcessEntryPoint] Hard stopping process

Hi,

Welcome to the community!

We try to keep it to one topic per thread. Otherwise it can get messy, fast.

Regarding your stacktrace, that looks like a certificate issue. Does your DB require encryption? If so, you may want to read the SQL Server portion of the docs.

 
HTH,
Ann

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.