Sonarqube is failing to create Tables in Postgres

SonarQube
1

Hi Team,

We have brought up sonarqube using the community-edition (8.4.1). We have configured a postgres DB of version 11.9.
The below is configured in the sonar.properties:
sonar.jdbc.username=xxxxxxxx
sonar.jdbc.password=xxxxxxxx
sonar.jdbc.url=jdbc:postgresql://:/

When we are running a sonar scan we are getting the timings perfectly as attached in the screenshot. But tables are not being created wherein we will see vulnerabilities of various projects present in sonarqube dashboard.

Could you please let us the know the expected results in DB and help us in reflecting the same.

Thanks,
Poonam

MicrosoftTeams-image (1)
MicrosoftTeams-image (1)1131×470 31.1 KB
MicrosoftTeams-image
MicrosoftTeams-image1657×779 89.7 KB

2

Hi,

Analysis shouldn’t be creating tables. When you first spin SonarQube up, it should set up its schema in the database. Without that, I’m surprised SonarQube is actually running. You probably need to go back to your server logs to untangle that.

 
HTH,
Ann