SonarQube does not return after enabling PostGres and setting sonar.properties

Install SonarQube Version 6.4 (Build 25310) and run it after you didn't open 9000 from the previous question: Setting up SonarQube on AWS using EC2

Now I'm trying to set up PostGres via AWS RDS:

  • PostgreSQL 9.6.2 setup
  • Configuring security for a Sonar EC2 instance to allow inbound rules:
  • PostGreSQl / TCP / 5432 / 0.0.0.0 / 0, :: / 0
  • PostGreSQl / TCP / 5432 / Anywhere / 0.0.0.0 / 0, :: / 0
  • PostGreSQl / TCP / 5432 / Custom / Sonar Security group → group for sonar instance
  • VI sonar.properties file
  • sonar.jdbc.username=XXXXXX

    → Username used when setting up RDS
  • sonar.jdbc.password=XXXXXX

    → Password used when setting up RDS
  • sonar.jdbc.url=jdbc:sonardbpostgre.XXXXXXXXX.us-east-1.rds.amazonaws.com:5432

  • cd ../bin/linux-x86-64/

  • ./sonar.sh restart

From what I can say something in my config, it is not very nice as it tries to start as I see how it pid

appears, but then it gets killed immediately.

Any suggestions?

If I uncomment the changes in changes sonar.properties

, it comes back after reboot.

This is what I see after I try to add the configuration for the DB:

root@ip-172- linux-x86-64]# ls
lib  SonarQube.pid  sonar.sh  wrapper
[root@ip-172- linux-x86-64]# ./sonar.sh restart
Stopping SonarQube...
Stopped SonarQube.
Starting SonarQube...
Started SonarQube.
[root@ip-172- linux-x86-64]# ls
lib  sonar.sh  wrapper
[root@ip-172- linux-x86-64]# ls
lib  sonar.sh  wrapper
[root@ip-172- linux-x86-64]# ./sonar.sh restart
Stopping SonarQube...
SonarQube was not running.
Starting SonarQube...
Started SonarQube.
[root@ip-172- linux-x86-64]# ls
lib  SonarQube.pid  sonar.sh  wrapper
[root@ip-172- linux-x86-64]# ls
lib  sonar.sh  wrapper

      

0


source to share


1 answer


The JDBC URL format for PostgreSQL is jdbc:postgresql://<host>/<database>

. In your case, the property should look like sonar.jdbc.url=jdbc:postgresql://xxx.us-east-1.rds.amazonaws.com:5432/sonarqube

.



+2


source







All Articles