During installation, there is a problem with postgresql connection.
I tried a lot of things, here the logs.
If someone can help, many thanks.
2020.12.14 16:39:33 ERROR web[o.s.s.p.PlatformImpl] Web server startup failed
java.lang.IllegalStateException: Fail to connect to database
Hi,
Welcome to the community!
I’m confident at least one of your server logs provides more details than that.
Ann
of course 
user : sonarqubeuser
database : sonarqube
schema : myschema
jdbcpath: sonar.jdbc.url=jdbc:postgresql://localhost/sonarqube?currentSchema=myschema
logs :
2020.12.14 16:44:15 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.12.14 16:44:15 INFO web[][o.s.p.ProcessEntryPoint] Hard stopping process
2020.12.14 20:06:58 INFO web[][o.s.p.ProcessEntryPoint] Starting web
2020.12.14 20:07:00 INFO web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2020.12.14 20:07:03 INFO web[][o.e.p.PluginsService] no modules loaded
2020.12.14 20:07:03 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2020.12.14 20:07:03 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2020.12.14 20:07:03 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.12.14 20:07:04 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2020.12.14 20:07:04 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 8.5.1.38104 / 568d59cd4cc6521467703887ba4bc2861cf6f3f1
2020.12.14 20:07:04 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://localhost/sonarqube?currentSchema=myschema
2020.12.14 20:07:05 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:166)
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:4689)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5155)
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 (FATAL: Ident authentication failed for user "sonarqubeuser")
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: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "sonarqubeuser"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:613)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:161)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:225)
at org.postgresql.Driver.makeConnection(Driver.java:465)
at org.postgresql.Driver.connect(Driver.java:264)
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
Suppressed: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "sonarqubeuser"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:613)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:161)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
... 38 common frames omitted
2020.12.14 20:07:05 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] appears to have started a thread named [elasticsearch[_client_][[timer]]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.9/java.lang.Thread.sleep(Native Method)\n app//org.elasticsearch.threadpool.ThreadPool$CachedTimeThread.run(ThreadPool.java:574)
2020.12.14 20:07:05 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] appears to have started a thread named [elasticsearch[_client_][scheduler][T#1]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.9/jdk.internal.misc.Unsafe.park(Native Method)\n java.base@11.0.9/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234)\n java.base@11.0.9/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123)\n java.base@11.0.9/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182)\n java.base@11.0.9/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899)\n java.base@11.0.9/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)\n java.base@11.0.9/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)\n java.base@11.0.9/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n java.base@11.0.9/java.lang.Thread.run(Thread.java:834)
2020.12.14 20:07:05 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] appears to have started a thread named [elasticsearch[_client_][transport_worker][T#1]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.9/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.9/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.9/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.9/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.9/java.lang.Thread.run(Thread.java:834)
2020.12.14 20:07:05 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] appears to have started a thread named [elasticsearch[_client_][generic][T#1]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.9/jdk.internal.misc.Unsafe.park(Native Method)\n java.base@11.0.9/java.util.concurrent.locks.LockSupport.park(LockSupport.java:194)\n java.base@11.0.9/java.util.concurrent.LinkedTransferQueue.awaitMatch(LinkedTransferQueue.java:743)\n java.base@11.0.9/java.util.concurrent.LinkedTransferQueue.xfer(LinkedTransferQueue.java:684)\n java.base@11.0.9/java.util.concurrent.LinkedTransferQueue.take(LinkedTransferQueue.java:1366)\n java.base@11.0.9/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)\n java.base@11.0.9/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)\n java.base@11.0.9/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n java.base@11.0.9/java.lang.Thread.run(Thread.java:834)
2020.12.14 20:07:05 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] appears to have started a thread named [elasticsearch[_client_][transport_worker][T#2]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.9/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.9/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.9/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.9/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.9/java.lang.Thread.run(Thread.java:834)
2020.12.14 20:07:05 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] appears to have started a thread named [elasticsearch[_client_][transport_worker][T#3]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.9/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.9/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.9/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.9/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.9/java.lang.Thread.run(Thread.java:834)
2020.12.14 20:07:05 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [sonarqube] appears to have started a thread named [elasticsearch[_client_][transport_worker][T#4]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:\n java.base@11.0.9/sun.nio.ch.EPoll.wait(Native Method)\n java.base@11.0.9/sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:120)\n java.base@11.0.9/sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:124)\n java.base@11.0.9/sun.nio.ch.SelectorImpl.select(SelectorImpl.java:136)\n app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)\n app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)\n app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)\n app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)\n java.base@11.0.9/java.lang.Thread.run(Thread.java:834)
2020.12.14 20:07:05 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.12.14 20:07:05 INFO web[][o.s.p.ProcessEntryPoint] Hard stopping process
Hi,
Here’s what I see:
Caused by: ... Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.').
Caused by: ... Cannot create PoolableConnectionFactory (FATAL: Ident authentication failed for user "sonarqubeuser")
Caused by: ... FATAL: Ident authentication failed for user "sonarqubeuser"
It looks like the connection credentials aren’t correct.
HTH,
Ann
Thanks Ann,
i think something is missing with postgres settings.
i think with the pg_hba.conf file. if there is a template for this ?
Many thanks,
Finally, it’s working now by editing the pg_hba.conf.
Thanks Ann,