Setup SonarQube Version 6.4 (build 25310) and have it running after having issue not opening 9000 from previous question: Setting up SonarQube on AWS using EC2
Now I am trying to setup PostGres via AWS RDS:
- Setup PostgreSQL 9.6.2
- Configure security for 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 the sonar instance
- VI sonar.properties file
sonar.jdbc.username=XXXXXX
--> Username used during RDS setupsonar.jdbc.password=XXXXXX
--> Password used during RDS setupsonar.jdbc.url=jdbc:sonardbpostgre.XXXXXXXXX.us-east-1.rds.amazonaws.com:5432
cd ../bin/linux-x86-64/
./sonar.sh restart
From what I can tell something in my config is not happy as it does try to start as I can see the pid
come up but then it immediately gets killed.
Any suggestions?
If I uncomment the changes in the changes in sonar.properties
it comes back up after restart.
Here is what I see after I try adding the config 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
Format of JDBC URL for PostgreSQL is
jdbc:postgresql://<host>/<database>
. In your case the property should look likesonar.jdbc.url=jdbc:postgresql://xxx.us-east-1.rds.amazonaws.com:5432/sonarqube
.