SonarQube default credentials for internal H2 db?

Question

I'm running SonarQube 5.6.1 and am trying to save a view that I created. To do that, I want to take a peek at H2 DB that Sonar (according to it's own readme) uses for internal embedded DB.

I've ran the H2 jar file and in console was able to log in to dummy DB. If SonarQUbe is running, I can't connect.

So, what are default credentials for that DB? Tried my user credentials and admin/admin, none work. Admin/admin is default for SonarQube administrator user.

Note that the SonarQube DB should be treated as a black box. — G. Ann - SonarSource Team, Aug 29 '16 at 13:28
I fully get it. Just trying things out, not planning to build anything long-lasting. — LAFK 4Monica_banAI_modStrike, Aug 30 '16 at 09:43
I also cannot get admin/admin to work as described on https://docs.sonarqube.org/display/SONAR/Get+Started+in+Two+Minutes — pzulw, Sep 28 '17 at 19:37
sonar/sonar login does not work either. Note: I'm using 6.5. — pzulw, Sep 28 '17 at 19:49

score 6 · Answer 1 · edited Jul 01 '22 at 22:36

6

For the config below (openjdk-11, sonarqube-8), follow the steps:

Change directory to /opt/sq/lib/jdbc/h2

cd /opt/sq/lib/jdbc/h2
Run the command line below to open h2 shell

java -cp h2-1.3.176.jar org.h2.tools.Shell

you will be prompted to fill the following:

URL jdbc:h2:tcp://localhost:9092/sonar
Driver org.h2.Driver
User blank or 'sonar'
Password blank or 'sonar'

edited Jul 01 '22 at 22:36

Donald Byrd

7,668
4
33
50

answered Jan 17 '20 at 17:31

Mostav

2,203
15
27

Nicolas B. · Accepted Answer · 2018-04-11T13:09:24.293

2

The default values are sonar/sonar .

Edit: this was answered at the time of SonarQube 5.6.x. Recent versions (e.g. v6.7 LTS) might have changed to empty username/password (for embedded database).

edited Apr 11 '18 at 13:09

answered Aug 29 '16 at 13:15

Nicolas B.

7,245
17
29

Doesn't work for me, I use sonarqube 6.7.3. Says Wrong user name or password [28000-176] 28000/28000 – Karthick Meenakshi Sundaram Apr 10 '18 at 16:18
1

What worked for me was an empty username and an empty password! :-) – Karthick Meenakshi Sundaram Apr 10 '18 at 16:35
Thanks, answer fine-tuned accordingly – Nicolas B. Apr 11 '18 at 13:09

score 2 · Answer 3 · answered Sep 21 '20 at 22:21

Here are instructions for SonarQube v8.4.2:

After logging in to SonarQube with administration credentials (admin/admin, if you downloaded the vanilla installation), then you can navigate from the top menu labeled "Administration", click on "System", click on "System" drop-down box, and look for the Database section. You will find "user" and "URL". Confirm this is what you expect.

In my default installation, I used the following to log into the H2 console (after ensuring my SonarQube instance is up, I had to restart it since it had been running too long also, I think it must have stalled):

Driver Class: org.h2.Driver
JDBC URL: jdbc:h2:tcp://localhost:9092/sonar

There is no username and password needed. If you want to set one, then you can modify the sonar.jdbc.username and sonar.jdbc.password properties in the your-sonarqube-installation-directory/conf/sonar.properties file. Here's a snippet of it:

# User credentials.
# Permissions to create tables, indices and triggers must be granted to JDBC user.
# The schema must be created first.
#sonar.jdbc.username=
#sonar.jdbc.password=

#----- Embedded Database (default)
# H2 embedded database server listening port, defaults to 9092
#sonar.embeddedDatabase.port=9092

score 0 · Answer 4 · answered Mar 23 '18 at 03:30

I'm using sonar 6.5 and username password was default values. username is sa without any password. I was able to backup database using following command (from sonar home directory):

java -cp lib/jdbc/h2/h2-1.3.176.jar org.h2.tools.Script -url jdbc:h2:tcp://localhost:9092/sonar

which is the same as:

java -cp lib/jdbc/h2/h2-1.3.176.jar org.h2.tools.Script -url jdbc:h2:tcp://localhost:9092/sonar -user sa

Also if server is down, you still can access database using:

-url jdbc:h2:<SONAR_HOME>/data/sonar -user sa

java_dude · Answer 5 · 2019-07-14T13:03:24.663

0

Default is admin/admin version 7.1. Installed using brew.

edited Jul 14 '19 at 13:03

answered Jul 14 '19 at 12:43

java_dude

4,038
9
36
61

This is referring to SonarQube server login, not the H2 database login of SonarQube. There is no username or password needed by default for internal H2 database login. – jojo Feb 14 '22 at 16:18

SonarQube default credentials for internal H2 db?

5 Answers5

Linked