Issue to running SQube Developer edition 8.4.2.36762 (Port 9000)

Nice_Show · September 25, 2020, 4:31pm

Hi Support,

I’m trying to install SonarQube Developer edition 8.4.2.36762 on Linux Azure VM (ubuntu 18.04) to my Dev Team and I’m facing issue to completed the process.

The service gets started but is not reachable on browser interface and i cannot track the port 9000

$ sudo netstat -tlnp

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.53:53 0.0.0.0:* LISTEN 927/systemd-resolve
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1324/sshd
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 1393/postgres
tcp 0 0 127.0.0.1:32000 0.0.0.0:* LISTEN 3054/java
tcp 0 0 0.0.0.0:25324 0.0.0.0:* LISTEN 2480/ruby
tcp6 0 0 :::22 :::* LISTEN 1324/sshd

sonar Logs.

Launching a JVM…

Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org

2020.09.25 16:18:21 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp

2020.09.25 16:18:21 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001

2020.09.25 16:18:21 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePrefix=es]] from [/opt/sonarqube/elasticsearch]: /opt/sonar$

2020.09.25 16:18:21 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running

OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.

2020.09.25 16:18:22 INFO app[o.e.p.PluginsService] no modules loaded

2020.09.25 16:18:22 INFO app[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]

ERROR: [2] bootstrap checks failed

[1]: max file descriptors [4096] for elasticsearch process is too low, increase to at least [65535]

[2]: max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]

2020.09.25 16:18:30 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 78

2020.09.25 16:18:30 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped

2020.09.25 16:18:30 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped

<-- Wrapper Stopped

–> Wrapper Started as Daemon

Launching a JVM…

Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org

2020.09.25 16:18:34 INFO app[o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp

2020.09.25 16:18:34 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001

2020.09.25 16:18:34 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePrefix=es]] from [/opt/sonarqube/elasticsearch]: /opt/sonar$

2020.09.25 16:18:34 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running

OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.

2020.09.25 16:18:35 INFO app[o.e.p.PluginsService] no modules loaded

2020.09.25 16:18:35 INFO app[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]

ERROR: [2] bootstrap checks failed

[1]: max file descriptors [4096] for elasticsearch process is too low, increase to at least [65535]

[2]: max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]

2020.09.25 16:18:43 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 78

2020.09.25 16:18:43 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped

2020.09.25 16:18:43 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped

2020.09.25 16:18:08 INFO app[o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001

2020.09.25 16:18:08 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘es’, ipcIndex=1, logFilenamePrefix=es]] from [/opt/sonarqube/elasticsearch]: /opt/sonar$

2020.09.25 16:18:08 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running

OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.

2020.09.25 16:18:09 INFO app[o.e.p.PluginsService] no modules loaded

2020.09.25 16:18:09 INFO app[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]

ERROR: [2] bootstrap checks failed

[1]: max file descriptors [4096] for elasticsearch process is too low, increase to at least [65535]

[2]: max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]

2020.09.25 16:18:17 WARN app[o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 78

2020.09.25 16:18:17 INFO app[o.s.a.SchedulerImpl] Process[es] is stopped

2020.09.25 16:18:17 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped

<-- Wrapper Stopped

–> Wrapper Started as Daemon

Tobias_Trabelsi · September 28, 2020, 8:07am

Hi @Nice_Show

welcome to the community

have you had a look at the requirements documentation? it is listed there how you should configure your system in order to comply with the requirements of elasicsearch that are hindering you from actually starting sonarqube on your system

Nice_Show · September 29, 2020, 2:04pm

i have to do what you have suggest me . but it not working.

when i stop the postgresql it’s works. it’s mean that we cannot run sonarqube and DB in the same vm

do you have any solution .

Tobias_Trabelsi · September 29, 2020, 2:19pm

This looks like another problem to me. can you share the content of the logs directory? maybe we can find additional information in the logs

Nice_Show · October 2, 2020, 5:51pm

Embedded database should be used for evaluation purposes only

Can you help with this issue i try to connect postgres as default db and it’s not working

Tobias_Trabelsi · October 3, 2020, 9:27am

sure if you can provide me the logs and your configuration

Nice_Show · October 5, 2020, 1:40pm

Hi,

My config :
sonar.jdbc.username=*********
sonar.jdbc.password=**********
sonar.jdbc.url=jdbc:sqlserver://sonarqube1.database.windows.net:1433;database=sonar;encrypt=true;

sonar.service config.

[Unit]
Description=SonarQube service
After=syslog.target network.target

[Service]
Type=forking

ExecStart=/opt/sonarqube/bin/linux-x86-64/sonar.sh start
ExecStop=/opt/sonarqube/bin/linux-x86-64/sonar.sh stop

User=sonar
Group=sonar
Restart=always

LimitNOFILE=65536
LimitNPROC=4096

[Install]
WantedBy=multi-user.target

Logs.
2020.10.02 18:12:43 INFO app[o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2020.10.02 18:12:43 INFO app[o.e.p.PluginsService] no modules loaded
2020.10.02 18:12:43 INFO app[o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
2020.10.02 18:12:56 INFO app[o.s.a.SchedulerImpl] Process[es] is up
2020.10.02 18:12:56 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘web’, ipcIndex=2, logFilenamePrefix=web]] from [/opt/sonarqube]: /usr/lib/jvm/java-11-openjdk-amd64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube/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 -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.|[::1] -cp ./lib/common/:/opt/sonarqube/lib/jdbc/h2/h2-1.4.199.jar org.sonar.server.app.WebServer /opt/sonarqube/temp/sq-process7113422039624054605properties
2020.10.02 18:13:23 INFO app[o.s.a.SchedulerImpl] Process[web] is up
2020.10.02 18:13:23 INFO app[o.s.a.ProcessLauncherImpl] Launch process[[key=‘ce’, ipcIndex=3, logFilenamePrefix=ce]] from [/opt/sonarqube]: /usr/lib/jvm/java-11-openjdk-amd64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube/temp -XX:-OmitStackTraceInFastThrow --add-opens=java.base/java.util=ALL-UNNAMED -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.|[::1] -cp ./lib/common/:/opt/sonarqube/lib/jdbc/h2/h2-1.4.199.jar org.sonar.ce.app.CeServer /opt/sonarqube/temp/sq-process757460961945265121properties
2020.10.02 18:13:31 INFO app[o.s.a.SchedulerImpl] Process[ce] is up
2020.10.02 18:13:31 INFO app[o.s.a.SchedulerImpl] SonarQube is up

Nice_Show · October 5, 2020, 1:43pm

I’m using SQL database created from Azure. The VM running Sonarqube is Ubuntu server 18.04.

Tobias_Trabelsi · October 5, 2020, 1:55pm

either it works now or it is not the complete log

Nice_Show · October 5, 2020, 3:45pm

all is running but i’m still getting the message The embedded database will not scale,

Tobias_Trabelsi · October 6, 2020, 5:22am

Okay now i understand.
where do you set the database settings and where is sonarqube installed?

Nice_Show · October 6, 2020, 3:07pm

I’m using my azure subscription for all setup
with Vpn network, all network connecting with Private IP, no issue with this

Sonarqube installed in Ubuntu VM
Data base installed in a new SQL data base using SQL server. *
Gen5*
up to 80 vCores, up to 408 GB memory

this is my connexion string from Azure

jdbc:sqlserver://sonarqube1.database.windows.net:1433;database=sonar;user=;password=*;encrypt=true;trustServerCertificate=false;hostNameInCertificate=.database.windows.net;loginTimeout=30;

Shoud i install the driver ! i have never perform this step. how i can do that

Tobias_Trabelsi · October 6, 2020, 6:36pm

have you had a look at our documentation regarding that?

i think you have to install the windows jdbc driver to your ubuntu vm in order to have this working and then configure your sonar.properties file accordingly.

it would also be helpful if you could share a error message and the log files that are written by your sonarqube installation when it is not working .

from your screenshot i can only see that there is no database configuration in your sonarqube instance, so it is using the embedded one