SonarQube Enterprise Edition initial installation: Sonar crashes at startup

Don · June 16, 2020, 12:10pm

I have installed SonarQube Enterprise on a Windows 10 machine, MS SQL 17 Express, Java JDK 11.0.7. I set the logging to debug. Right beofre it crashes, this is logged:

2020.06.16 06:45:03 INFO app[][o.s.a.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [C:\Program Files\SonarQube\sonarqube-8.3.1.34397]: C:\Program Files\Java\jdk-11.0.7\bin\java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=C:\Program Files\SonarQube\sonarqube-8.3.1.34397\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 -Xmx1G -Xms512m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/common/*;C:\Program Files\SonarQube\sonarqube-8.3.1.34397\lib\jdbc\mssql\mssql-jdbc-7.4.1.jre11.jar org.sonar.server.app.WebServer C:\Program Files\SonarQube\sonarqube-8.3.1.34397\temp\sq-process356133886384046779properties

I probably have a configuration wrong and someone that is intimate with the installation probably knows what is wrong off immediately. Any help is appreciated. Thanks!

Tobias_Trabelsi · June 17, 2020, 7:03am

Hi @Don ,

welcome to the community

the log you posted is more a general startup information. could you post more information, like maybe the stack trace?

Don · June 17, 2020, 11:53am

Sure Tobias, I’ll post that. Thanks for responding and the greeting. Do you go by Tobias or Toby?

Tobias_Trabelsi · June 17, 2020, 12:40pm

looking forward to the logs.
I usually get called with either of those names

Don · June 17, 2020, 12:50pm

Thanks Toby. Yep, failed to connect to the DB was in the stack trace (see below). here is the connection string:
sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=sonar

Trace error:
2020.06.16 06:45:23 ERROR web[o.s.s.p.PlatformImpl] Web server startup failed
java.lang.IllegalStateException: Fail to connect to database
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:86)
at org.sonar.core.platform.StartableCloseableSafeLifecyleStrategy.start(StartableCloseableSafeLifecyleStrategy.java:40)
at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84)
at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169)
at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132)
at org.picocontainer.behaviors.Stored.start(Stored.java:110)
at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1016)
at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1009)
at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:767)
at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:136)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90)
at org.sonar.server.platform.platformlevel.PlatformLevel1.start(PlatformLevel1.java:164)
at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:213)
at org.sonar.server.platform.PlatformImpl.startLevel1Container(PlatformImpl.java:172)
at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:86)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4701)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1402)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by ‘sonar.jdbc.’).
at org.sonar.db.DefaultDatabase.checkConnection(DefaultDatabase.java:118)
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:83)
… 24 common frames omitted
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host localhost, port 1433 has failed. Error: “Connection refused: connect. 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 org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:669)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:544)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753)
at org.sonar.db.profiling.NullConnectionInterceptor.getConnection(NullConnectionInterceptor.java:31)
at org.sonar.db.profiling.ProfiledDataSource.getConnection(ProfiledDataSource.java:317)
at org.sonar.db.DefaultDatabase.checkConnection(DefaultDatabase.java:115)
… 25 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: connect. 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:234)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:285)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2431)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:656)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2472)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2142)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1993)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1164)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:760)
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:55)
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355)
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:115)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:665)
… 30 common frames omitted

Tobias_Trabelsi · June 17, 2020, 1:25pm

ah okay I see. can you confirm that your MsSQL Server is running on localhost, port 1433 and no firewall is blocking this connection?
The jdbc string looks good for me. maybe include the sqlexpress type as well:

jdbc:sqlserver://localhost;instance=SQLEXPRESS;databaseName=sonar

Don · June 17, 2020, 3:03pm

Interesting…
So SQL was not listening on 1433, fixed that. It now is able to connect to SQL. It is still hard stopping and not saying why, here are the traces in the logs:
sonar.log-
2020.06.17 09:48:11 DEBUG app[i.n.b.AbstractByteBuf] -Dio.netty.buffer.checkAccessible: true
2020.06.17 09:48:11 DEBUG app[i.n.b.AbstractByteBuf] -Dio.netty.buffer.checkBounds: true
2020.06.17 09:48:11 DEBUG app[i.n.u.ResourceLeakDetectorFactory] Loaded default ResourceLeakDetector: io.netty.util.ResourceLeakDetector@283fb80c
2020.06.17 09:48:11 DEBUG app[i.n.util.Recycler] -Dio.netty.recycler.maxCapacityPerThread: 4096
2020.06.17 09:48:11 DEBUG app[i.n.util.Recycler] -Dio.netty.recycler.maxSharedCapacityFactor: 2
2020.06.17 09:48:11 DEBUG app[i.n.util.Recycler] -Dio.netty.recycler.linkCapacity: 16
2020.06.17 09:48:11 DEBUG app[i.n.util.Recycler] -Dio.netty.recycler.ratio: 8
2020.06.17 09:48:11 DEBUG app[o.e.t.ConnectionManager] connected to node [{sonarqube}{x42vRMBSSruUqaPpIHpO6g}{zYweF94qQPCnxMdOS_AzpA}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}]
2020.06.17 09:48:12 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2020.06.17 09:48:12 DEBUG app[o.s.a.p.ManagedProcessLifecycle] EventWatcher[es] tryToMoveTo es from STARTED to STARTING => false
2020.06.17 09:48:12 DEBUG app[o.s.a.p.ManagedProcessLifecycle] EventWatcher[es] tryToMoveTo web from INIT to STARTING => true
2020.06.17 09:48:12 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘web’, ipcIndex=2, logFilenamePrefix=web]] from [C:\Program Files\SonarQube\sonarqube-8.3.1.34397]: C:\Program Files\Java\jdk-11.0.7\bin\java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=C:\Program Files\SonarQube\sonarqube-8.3.1.34397\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 -Xmx1G -Xms512m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.|[::1] -cp ./lib/common/;C:\Program Files\SonarQube\sonarqube-8.3.1.34397\lib\jdbc\mssql\mssql-jdbc-7.4.1.jre11.jar org.sonar.server.app.WebServer C:\Program Files\SonarQube\sonarqube-8.3.1.34397\temp\sq-process14364296075093122800properties
2020.06.17 09:48:12 DEBUG app[o.s.a.p.ManagedProcessLifecycle] EventWatcher[es] tryToMoveTo web from STARTING to STARTED => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [web]: 0
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] StopWatcher[web] tryToMoveTo web from STARTED to HARD_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] StopWatcher[web] tryToMoveTo web from HARD_STOPPING to FINALIZE_STOPPING => true
2020.06.17 09:48:29 INFO app[o.s.a.SchedulerImpl] Process[web] is stopped
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] StopWatcher[web] tryToMoveTo web from FINALIZE_STOPPING to STOPPED => true
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] HardStopper-0 tryToMoveTo from STARTING to HARD_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo ce from INIT to HARD_STOPPING => false
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo web from STOPPED to HARD_STOPPING => false
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo es from STARTED to HARD_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo es from HARD_STOPPING to FINALIZE_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] StopWatcher[es] tryToMoveTo es from FINALIZE_STOPPING to HARD_STOPPING => false
2020.06.17 09:48:29 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] HardStopper-0 tryToMoveTo from HARD_STOPPING to FINALIZE_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] HardStopper-0 tryToMoveTo from FINALIZE_STOPPING to STOPPED => true
2020.06.17 09:48:29 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo es from FINALIZE_STOPPING to STOPPED => true
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] HardStopper-0 tryToMoveTo from STOPPED to FINALIZE_STOPPING => false
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] Shutdown Hook tryToMoveTo from STOPPED to STOPPING => false

web.log-
2020.06.17 09:48:19 INFO web[o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://localhost;instance=SQLEXPRESS;databaseName=sonar
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:401ac46421b31321030ebbe4121ac51d, Subject:CN=VeriSign Universal Root Certification Authority, OU=“© 2008 VeriSign, Inc. - For authorized use only”, OU=VeriSign Trust Network, O=“VeriSign, Inc.”, C=US, Issuer:CN=VeriSign Universal Root Certification Authority, OU=“© 2008 VeriSign, Inc. - For authorized use only”, OU=VeriSign Trust Network, O=“VeriSign, Inc.”, C=US, Key type:RSA, Length:2048, Cert Id:-1976681486, Valid from:4/1/08, 7:00 PM, Valid until:12/1/37, 5:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:7c1b35354ae7db74e7415f1169ca6ba8, Subject:CN=Symantec Class 3 SHA256 Code Signing CA - G2, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Issuer:CN=VeriSign Universal Root Certification Authority, OU=“© 2008 VeriSign, Inc. - For authorized use only”, OU=VeriSign Trust Network, O=“VeriSign, Inc.”, C=US, Key type:RSA, Length:2048, Cert Id:920743424, Valid from:7/21/14, 7:00 PM, Valid until:7/21/24, 6:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:4fee99d3322a02ac3ffde2f52be24a4c, Subject:CN=Microsoft Corporation, OU=Java Signing (SHA2), O=Microsoft Corporation, L=REDMOND, ST=Washington, C=US, Issuer:CN=Symantec Class 3 SHA256 Code Signing CA - G2, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Key type:RSA, Length:4096, Cert Id:-260461596, Valid from:11/9/18, 6:00 PM, Valid until:10/27/21, 6:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:7b05b1d449685144f7c989d29c199d12, Subject:CN=Symantec SHA256 TimeStamping CA, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Issuer:CN=VeriSign Universal Root Certification Authority, OU=“© 2008 VeriSign, Inc. - For authorized use only”, OU=VeriSign Trust Network, O=“VeriSign, Inc.”, C=US, Key type:RSA, Length:2048, Cert Id:679469769, Valid from:1/11/16, 6:00 PM, Valid until:1/11/31, 5:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:7bd4e5afbacc073fa101230422414d12, Subject:CN=Symantec SHA256 TimeStamping Signer - G3, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Issuer:CN=Symantec SHA256 TimeStamping CA, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Key type:RSA, Length:2048, Cert Id:-1917605033, Valid from:12/22/17, 6:00 PM, Valid until:3/22/29, 6:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:-da1ddaf415df4b8, Subject:CN=D-C68MBM2.southernco.com, Issuer:CN=D-C68MBM2.southernco.com, Key type:RSA, Length:2048, Cert Id:1843686597, Valid from:1/14/19, 10:58 AM, Valid until:1/14/29, 10:58 AM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] TLSHandshake: localhost:1433, TLSv1.2, TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, 1843686597
2020.06.17 09:48:19 DEBUG web[jdk.event.security] TLSHandshake: localhost:1433, TLSv1.2, TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, 1843686597
2020.06.17 09:48:20 INFO web[o.s.s.p.ServerFileSystemImpl] SonarQube home: C:\Program Files\SonarQube\sonarqube-8.3.1.34397
2020.06.17 09:48:20 INFO web[o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2020.06.17 09:48:21 INFO web[o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: enterprise-edition
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: ce-workers
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: developer-scanner
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: developer-server
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: governance
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: license
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: securityreport
2020.06.17 09:48:21 DEBUG web[jdk.event.security] TLSHandshake: localhost:1433, TLSv1.2, TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, 1843686597
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin C# Code Quality and Security / 8.6.1.17183 / e9f4299031df68d8c4be6ba670fd4c0395eebf76
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin CFamily Code Quality and Security / 6.9.0.17076 / 05f2b0d1d57eb98a9efed7be184627ae5c962cac
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Git / 1.11.1.2008 / 204dc9b2cc33ec6b780303f926234eed26aea67d
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin JaCoCo / 1.1.0.898 / f65b288e6c2888393bd7fb72ad7ac1425f88eebf
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Java Code Quality and Security / 6.3.0.21585 / ecf8f9f571691771e6789b8e59ff5e6b4ef36ad8
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarABAP / 3.8.0.2034 / 2904652c6ef4863eaace62c40fec0512724430e4
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarApex / 1.7.0.883 / 023988648404d79a66207cf63587a0902cac093b
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarCOBOL / 4.4.0.3403 / 87052f378052eedd582643a831d334123cf39965
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarCSS / 1.2.0.1325 / 8dc9fe17b6230c20715d3b4cb34e0b6d02151afd
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarFlex / 2.5.1.1831 / a0c44437f6abb0feec76edd073f91fec64db2a6c
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarGo / 1.6.0.719 / edcc6a9e42fcdd30bb6f84a779c6cd7009ec72fd
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarHTML / 3.2.0.2082 / 997a51b39c4d0a5399c73a8fb729030a69eb392b
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarJS / 6.2.0.12043 / 8b9c1eb83d6ecfd2eda2cc3798e593900b6735fd
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarKotlin / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarPHP / 3.3.0.5166 / 88e11dffb965aeef9d5bdd6d8413f394d35fecba
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarPLI / 1.10.0.1880 / 1f78eb283a8d0c3e7f911f3259094c5696adad64
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarPLSQL / 3.4.1.2576 / a27e6384088454d7160dd39ea5ba54a9929c15f4
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarPython / 2.8.0.6204 / 5600d1ed780882d2362bedb3604dbad7ea63eb27
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarRPG / 2.3.0.1187 / e0c75c815c1ae3955d823f1abcc8c1718b2d69f7
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarRuby / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarScala / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarSwift / 4.2.2.77 / ad3e52bad0857bc89efe0503a420fac67d809398
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarTS / 2.1.0.4359 / 268ba9581b700c4fb2bc194d4069d283da915213
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarTSQL / 1.4.0.3334 / 7b4dc9eeb6301765e09583a3d570b5941223e0b4
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarVB6 / 2.6.0.1875 / cfa6ee80615b98744158f3981fb29497101a03f5
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarXML / 2.0.1.2020 / c5b84004face582d56f110e24c29bf9c6a679e69
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Svn / 1.9.0.1295 / 942e075773975354e32691a60bfd968065703e04
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin VB.NET Code Quality and Security / 8.6.1.17183 / e9f4299031df68d8c4be6ba670fd4c0395eebf76
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Analysis / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for C# / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for Java / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for PHP / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for Python / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:27 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA1withDSA, Serial:10, Subject:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Sun Microsystems Inc, L=Palo Alto, ST=CA, C=US, Issuer:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Sun Microsystems Inc, L=Palo Alto, ST=CA, C=US, Key type:DSA, Length:1024, Cert Id:1776909028, Valid from:4/25/01, 2:00 AM, Valid until:4/25/20, 2:00 AM
2020.06.17 09:48:27 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA1withDSA, Serial:47f, Subject:CN=Legion of the Bouncy Castle Inc., OU=Java Software Code Signing, O=Sun Microsystems Inc, Issuer:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Sun Microsystems Inc, L=Palo Alto, ST=CA, C=US, Key type:DSA, Length:1024, Cert Id:-2023852845, Valid from:3/10/17, 7:15 PM, Valid until:4/25/20, 2:00 AM
2020.06.17 09:48:27 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:3c9eb1fc89f733d3, Subject:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Oracle Corporation, Issuer:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Oracle Corporation, Key type:RSA, Length:2048, Cert Id:-1250580323, Valid from:7/6/16, 6:48 PM, Valid until:12/30/30, 6:00 PM
2020.06.17 09:48:27 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:4efb7bc62e2b049e, Subject:CN=Legion of the Bouncy Castle Inc., OU=Java Software Code Signing, O=Oracle Corporation, Issuer:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Oracle Corporation, Key type:DSA, Length:2048, Cert Id:-654023182, Valid from:3/10/17, 7:07 PM, Valid until:3/10/22, 7:07 PM
2020.06.17 09:48:28 DEBUG web[o.s.c.i.DefaultI18n] Loaded 3419 properties from l10n bundles
2020.06.17 09:48:28 INFO web[o.s.s.p.d.m.c.MssqlCharsetHandler] Verify that database collation is case-sensitive and accent-sensitive
2020.06.17 09:48:28 ERROR web[o.s.s.p.PlatformImpl] Web server startup failed: Database collation must be case-sensitive and accent-sensitive. It is SQL_Latin1_General_CP1_CI_AS but should be SQL_Latin1_General_CP1_CS_AS.
2020.06.17 09:48:29 WARN web[o.a.c.u.SessionIdGeneratorBase] Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [328] milliseconds.
2020.06.17 09:48:29 DEBUG web[o.s.s.a.TomcatAccessLog] Tomcat is started
2020.06.17 09:48:29 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.06.17 09:48:29 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process

Don · June 17, 2020, 3:10pm

I changed the string and then did a telnet on 1433, it was not listening. I fixed that and now it is able to connect to sql. It is still hard stopping and not saying why in the trace. See below:

web.log-
2020.06.17 09:48:19 INFO web[o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://localhost;instance=SQLEXPRESS;databaseName=sonar
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:401ac46421b31321030ebbe4121ac51d, Subject:CN=VeriSign Universal Root Certification Authority, OU=“© 2008 VeriSign, Inc. - For authorized use only”, OU=VeriSign Trust Network, O=“VeriSign, Inc.”, C=US, Issuer:CN=VeriSign Universal Root Certification Authority, OU=“© 2008 VeriSign, Inc. - For authorized use only”, OU=VeriSign Trust Network, O=“VeriSign, Inc.”, C=US, Key type:RSA, Length:2048, Cert Id:-1976681486, Valid from:4/1/08, 7:00 PM, Valid until:12/1/37, 5:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:7c1b35354ae7db74e7415f1169ca6ba8, Subject:CN=Symantec Class 3 SHA256 Code Signing CA - G2, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Issuer:CN=VeriSign Universal Root Certification Authority, OU=“© 2008 VeriSign, Inc. - For authorized use only”, OU=VeriSign Trust Network, O=“VeriSign, Inc.”, C=US, Key type:RSA, Length:2048, Cert Id:920743424, Valid from:7/21/14, 7:00 PM, Valid until:7/21/24, 6:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:4fee99d3322a02ac3ffde2f52be24a4c, Subject:CN=Microsoft Corporation, OU=Java Signing (SHA2), O=Microsoft Corporation, L=REDMOND, ST=Washington, C=US, Issuer:CN=Symantec Class 3 SHA256 Code Signing CA - G2, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Key type:RSA, Length:4096, Cert Id:-260461596, Valid from:11/9/18, 6:00 PM, Valid until:10/27/21, 6:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:7b05b1d449685144f7c989d29c199d12, Subject:CN=Symantec SHA256 TimeStamping CA, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Issuer:CN=VeriSign Universal Root Certification Authority, OU=“© 2008 VeriSign, Inc. - For authorized use only”, OU=VeriSign Trust Network, O=“VeriSign, Inc.”, C=US, Key type:RSA, Length:2048, Cert Id:679469769, Valid from:1/11/16, 6:00 PM, Valid until:1/11/31, 5:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:7bd4e5afbacc073fa101230422414d12, Subject:CN=Symantec SHA256 TimeStamping Signer - G3, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Issuer:CN=Symantec SHA256 TimeStamping CA, OU=Symantec Trust Network, O=Symantec Corporation, C=US, Key type:RSA, Length:2048, Cert Id:-1917605033, Valid from:12/22/17, 6:00 PM, Valid until:3/22/29, 6:59 PM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:-da1ddaf415df4b8, Subject:CN=D-C68MBM2.southernco.com, Issuer:CN=D-C68MBM2.southernco.com, Key type:RSA, Length:2048, Cert Id:1843686597, Valid from:1/14/19, 10:58 AM, Valid until:1/14/29, 10:58 AM
2020.06.17 09:48:19 DEBUG web[jdk.event.security] TLSHandshake: localhost:1433, TLSv1.2, TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, 1843686597
2020.06.17 09:48:19 DEBUG web[jdk.event.security] TLSHandshake: localhost:1433, TLSv1.2, TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, 1843686597
2020.06.17 09:48:20 INFO web[o.s.s.p.ServerFileSystemImpl] SonarQube home: C:\Program Files\SonarQube\sonarqube-8.3.1.34397
2020.06.17 09:48:20 INFO web[o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2020.06.17 09:48:21 INFO web[o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: enterprise-edition
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: ce-workers
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: developer-scanner
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: developer-server
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: governance
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: license
2020.06.17 09:48:21 DEBUG web[o.s.c.e.CoreExtensionsInstaller] Installed core extension: securityreport
2020.06.17 09:48:21 DEBUG web[jdk.event.security] TLSHandshake: localhost:1433, TLSv1.2, TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, 1843686597
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin C# Code Quality and Security / 8.6.1.17183 / e9f4299031df68d8c4be6ba670fd4c0395eebf76
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin CFamily Code Quality and Security / 6.9.0.17076 / 05f2b0d1d57eb98a9efed7be184627ae5c962cac
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Git / 1.11.1.2008 / 204dc9b2cc33ec6b780303f926234eed26aea67d
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin JaCoCo / 1.1.0.898 / f65b288e6c2888393bd7fb72ad7ac1425f88eebf
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Java Code Quality and Security / 6.3.0.21585 / ecf8f9f571691771e6789b8e59ff5e6b4ef36ad8
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarABAP / 3.8.0.2034 / 2904652c6ef4863eaace62c40fec0512724430e4
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarApex / 1.7.0.883 / 023988648404d79a66207cf63587a0902cac093b
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarCOBOL / 4.4.0.3403 / 87052f378052eedd582643a831d334123cf39965
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarCSS / 1.2.0.1325 / 8dc9fe17b6230c20715d3b4cb34e0b6d02151afd
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarFlex / 2.5.1.1831 / a0c44437f6abb0feec76edd073f91fec64db2a6c
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarGo / 1.6.0.719 / edcc6a9e42fcdd30bb6f84a779c6cd7009ec72fd
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarHTML / 3.2.0.2082 / 997a51b39c4d0a5399c73a8fb729030a69eb392b
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarJS / 6.2.0.12043 / 8b9c1eb83d6ecfd2eda2cc3798e593900b6735fd
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarKotlin / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarPHP / 3.3.0.5166 / 88e11dffb965aeef9d5bdd6d8413f394d35fecba
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarPLI / 1.10.0.1880 / 1f78eb283a8d0c3e7f911f3259094c5696adad64
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarPLSQL / 3.4.1.2576 / a27e6384088454d7160dd39ea5ba54a9929c15f4
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarPython / 2.8.0.6204 / 5600d1ed780882d2362bedb3604dbad7ea63eb27
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarRPG / 2.3.0.1187 / e0c75c815c1ae3955d823f1abcc8c1718b2d69f7
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarRuby / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarScala / 1.5.0.315 / 4ff3a145a58f3f84f1b39846a205a129d742e993
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarSwift / 4.2.2.77 / ad3e52bad0857bc89efe0503a420fac67d809398
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarTS / 2.1.0.4359 / 268ba9581b700c4fb2bc194d4069d283da915213
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarTSQL / 1.4.0.3334 / 7b4dc9eeb6301765e09583a3d570b5941223e0b4
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarVB6 / 2.6.0.1875 / cfa6ee80615b98744158f3981fb29497101a03f5
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin SonarXML / 2.0.1.2020 / c5b84004face582d56f110e24c29bf9c6a679e69
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Svn / 1.9.0.1295 / 942e075773975354e32691a60bfd968065703e04
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin VB.NET Code Quality and Security / 8.6.1.17183 / e9f4299031df68d8c4be6ba670fd4c0395eebf76
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Analysis / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for C# / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for Java / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for PHP / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:22 INFO web[o.s.s.p.ServerPluginRepository] Deploy plugin Vulnerability Rules for Python / 8.3.0.1825 / 69e80e00e81ec01c571ecc4e589fc6a229285052
2020.06.17 09:48:27 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA1withDSA, Serial:10, Subject:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Sun Microsystems Inc, L=Palo Alto, ST=CA, C=US, Issuer:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Sun Microsystems Inc, L=Palo Alto, ST=CA, C=US, Key type:DSA, Length:1024, Cert Id:1776909028, Valid from:4/25/01, 2:00 AM, Valid until:4/25/20, 2:00 AM
2020.06.17 09:48:27 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA1withDSA, Serial:47f, Subject:CN=Legion of the Bouncy Castle Inc., OU=Java Software Code Signing, O=Sun Microsystems Inc, Issuer:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Sun Microsystems Inc, L=Palo Alto, ST=CA, C=US, Key type:DSA, Length:1024, Cert Id:-2023852845, Valid from:3/10/17, 7:15 PM, Valid until:4/25/20, 2:00 AM
2020.06.17 09:48:27 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:3c9eb1fc89f733d3, Subject:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Oracle Corporation, Issuer:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Oracle Corporation, Key type:RSA, Length:2048, Cert Id:-1250580323, Valid from:7/6/16, 6:48 PM, Valid until:12/30/30, 6:00 PM
2020.06.17 09:48:27 DEBUG web[jdk.event.security] X509Certificate: Alg:SHA256withRSA, Serial:4efb7bc62e2b049e, Subject:CN=Legion of the Bouncy Castle Inc., OU=Java Software Code Signing, O=Oracle Corporation, Issuer:CN=JCE Code Signing CA, OU=Java Software Code Signing, O=Oracle Corporation, Key type:DSA, Length:2048, Cert Id:-654023182, Valid from:3/10/17, 7:07 PM, Valid until:3/10/22, 7:07 PM
2020.06.17 09:48:28 DEBUG web[o.s.c.i.DefaultI18n] Loaded 3419 properties from l10n bundles
2020.06.17 09:48:28 INFO web[o.s.s.p.d.m.c.MssqlCharsetHandler] Verify that database collation is case-sensitive and accent-sensitive
2020.06.17 09:48:28 ERROR web[o.s.s.p.PlatformImpl] Web server startup failed: Database collation must be case-sensitive and accent-sensitive. It is SQL_Latin1_General_CP1_CI_AS but should be SQL_Latin1_General_CP1_CS_AS.
2020.06.17 09:48:29 WARN web[o.a.c.u.SessionIdGeneratorBase] Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [328] milliseconds.
2020.06.17 09:48:29 DEBUG web[o.s.s.a.TomcatAccessLog] Tomcat is started
2020.06.17 09:48:29 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.06.17 09:48:29 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process

sonar.log-
2020.06.17 09:48:11 DEBUG app[o.e.t.ConnectionManager] connected to node [{sonarqube}{x42vRMBSSruUqaPpIHpO6g}{zYweF94qQPCnxMdOS_AzpA}{127.0.0.1}{127.0.0.1:9001}{rack_id=sonarqube}]
2020.06.17 09:48:12 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2020.06.17 09:48:12 DEBUG app[o.s.a.p.ManagedProcessLifecycle] EventWatcher[es] tryToMoveTo es from STARTED to STARTING => false
2020.06.17 09:48:12 DEBUG app[o.s.a.p.ManagedProcessLifecycle] EventWatcher[es] tryToMoveTo web from INIT to STARTING => true
2020.06.17 09:48:12 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘web’, ipcIndex=2, logFilenamePrefix=web]] from [C:\Program Files\SonarQube\sonarqube-8.3.1.34397]: C:\Program Files\Java\jdk-11.0.7\bin\java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=C:\Program Files\SonarQube\sonarqube-8.3.1.34397\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 -Xmx1G -Xms512m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.|[::1] -cp ./lib/common/;C:\Program Files\SonarQube\sonarqube-8.3.1.34397\lib\jdbc\mssql\mssql-jdbc-7.4.1.jre11.jar org.sonar.server.app.WebServer C:\Program Files\SonarQube\sonarqube-8.3.1.34397\temp\sq-process14364296075093122800properties
2020.06.17 09:48:12 DEBUG app[o.s.a.p.ManagedProcessLifecycle] EventWatcher[es] tryToMoveTo web from STARTING to STARTED => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [web]: 0
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] StopWatcher[web] tryToMoveTo web from STARTED to HARD_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] StopWatcher[web] tryToMoveTo web from HARD_STOPPING to FINALIZE_STOPPING => true
2020.06.17 09:48:29 INFO app[o.s.a.SchedulerImpl] Process[web] is stopped
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] StopWatcher[web] tryToMoveTo web from FINALIZE_STOPPING to STOPPED => true
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] HardStopper-0 tryToMoveTo from STARTING to HARD_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo ce from INIT to HARD_STOPPING => false
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo web from STOPPED to HARD_STOPPING => false
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo es from STARTED to HARD_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo es from HARD_STOPPING to FINALIZE_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] StopWatcher[es] tryToMoveTo es from FINALIZE_STOPPING to HARD_STOPPING => false
2020.06.17 09:48:29 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] HardStopper-0 tryToMoveTo from HARD_STOPPING to FINALIZE_STOPPING => true
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] HardStopper-0 tryToMoveTo from FINALIZE_STOPPING to STOPPED => true
2020.06.17 09:48:29 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped
2020.06.17 09:48:29 DEBUG app[o.s.a.p.ManagedProcessLifecycle] HardStopper-0 tryToMoveTo es from FINALIZE_STOPPING to STOPPED => true
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] HardStopper-0 tryToMoveTo from STOPPED to FINALIZE_STOPPING => false
2020.06.17 09:48:29 DEBUG app[o.s.a.NodeLifecycle] Shutdown Hook tryToMoveTo from STOPPED to STOPPING => false

Don · June 17, 2020, 3:15pm

Toby, I responded twice essentially with the same information. It was hidden until a staff member is able to review. I hope that you are able to

pierreguillot · June 17, 2020, 4:07pm

Hey, jumping in the thread, I see that your error is :

Web server startup failed: Database collation must be case-sensitive and accent-sensitive. It is SQL_Latin1_General_CP1_CI_AS but should be SQL_Latin1_General_CP1_CS_AS.

You can find some guidance in the SonarQube requirements, on MsSQL:

Collation must be case-sensitive (CS) and accent-sensitive (AS) (example: Latin1_General_CS_AS)

I guess you want to follow this kind of instructions to change the database collation on your existing database.

Don · June 17, 2020, 4:12pm

Thanks Pierre, I will give that a shot (great catch).

Don · June 17, 2020, 5:50pm

jvm 1 | 2020.06.17 11:43:18 INFO app[o.s.a.SchedulerImpl] SonarQube is up

Nice job guys. I wouldn’t have been able to figure this out by myself. Thank you both so much.

pierreguillot · June 18, 2020, 12:57pm

Glad you figured it out