Deploy Sonar to Azure App Service using an Azure SQLServer fails

Trying to deploy Sonarqube to Azure App Service (latest docker image) using an Azure SQLServer keeps failing with error below.

I have tried using these Overrides in Application settings:
SONAR_ES_BOOTSTRAP_CHECKS_DISABLE=true
SONAR_SEARCH_JAVAADDITIONALOPTS=-Dnode.store.allow_mmap=false

error log snippet:

2022-03-14T19:00:17.929383610Z 2022.03.14 19:00:17 DEBUG app[][o.a.h.c.p.RequestAuthCache] Re-using cached 'basic' auth scheme for http://127.0.0.1:9001

2022-03-14T19:00:17.939323020Z 2022.03.14 19:00:17 DEBUG app[][o.a.h.c.p.RequestAuthCache] No credentials for preemptive authentication

2022-03-14T19:00:17.940523358Z 2022.03.14 19:00:17 DEBUG app[][o.a.h.i.n.c.InternalHttpAsyncClient] [exchange: 1] Request connection for {}->http://127.0.0.1:9001

2022-03-14T19:00:17.944679488Z 2022.03.14 19:00:17 DEBUG app[][o.a.h.i.n.c.PoolingNHttpClientConnectionManager] Connection request: [route: {}->http://127.0.0.1:9001][total kept alive: 0; route allocated: 0 of 10; total allocated: 0 of 30]

2022-03-14T19:00:17.995129163Z 2022.03.14 19:00:17 DEBUG app[][o.a.h.i.n.c.PoolingNHttpClientConnectionManager] Connection request failed

2022-03-14T19:00:17.995158664Z java.net.ConnectException: Connection refused

2022-03-14T19:00:17.995164164Z 	at java.base/sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)

2022-03-14T19:00:17.995168564Z 	at java.base/sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source)

2022-03-14T19:00:17.995201866Z 	at org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processEvent(DefaultConnectingIOReactor.java:174)

2022-03-14T19:00:17.995206366Z 	at org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processEvents(DefaultConnectingIOReactor.java:148)

2022-03-14T19:00:17.995210266Z 	at org.apache.http.impl.nio.reactor.AbstractMultiworkerIOReactor.execute(AbstractMultiworkerIOReactor.java:351)

2022-03-14T19:00:17.995214066Z 	at org.apache.http.impl.nio.conn.PoolingNHttpClientConnectionManager.execute(PoolingNHttpClientConnectionManager.java:221)

2022-03-14T19:00:17.995218066Z 	at org.apache.http.impl.nio.client.CloseableHttpAsyncClientBase$1.run(CloseableHttpAsyncClientBase.java:64)

2022-03-14T19:00:17.995221866Z 	at java.base/java.lang.Thread.run(Unknown Source)

Hi,

It looks like Elasticsearch isn’t starting up. You need to check that server log to see why.

 
Ann

So I read this doesn’t work with Azure App Service, is this true? 101-webapp-linux-sonarqube-azuresql template vm.max_map_count error · Issue #7481 · Azure/azure-quickstart-templates · GitHub

Hi,

There are workarounds listed in the issue you pointed to…?

 
Ann

I am able to get it working. I will post updates on how as soon as I get them tested.

1 Like