Sonarqube with AWS RDS Postgresql

SonarQube Server / Community Build
1

Hi,

Below are the details

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension) -

sonarqube-6.7.6

  • what are you trying to achieve :

    I am trying to integrate sonarqube with aws rds postgresql in an EC2 instance.

  • what have you tried so far to achieve this

I am successfully connecting to the postgresql instance from the ec2 instance. I have installed sonarqube-6.7.6 in that EC2 Instance and trying to open the sonarqube UI (http://10.245.2.17:5432/postgres). But its failing with " This site can’t be reached" message. Please help.

sonar.properties:::

sonar.jdbc.username=postgres
sonar.jdbc.password=admin123
sonar.jdbc.url=jdbc:postgresql://sonarpostgres.ccix2qp0lqjg.eu-west-1.rds.amazonaws.com:5432/postgres
sonar.web.host=0.0.0.0
sonar.web.port=5432

2

Hello,

If SQ is started but you can’t access the UI with your browser, i would first check the Security Group of this EC2 instance and make sure that the inbound and outbound traffic are allowed from your IP.

3

I am getting connected if i give 9000 as port number. I have changed in sonar.properties file.
From:
sonar.web.port=5432
To:
sonar.web.port=9000

Successfully opened the URL http://10.245.2.17:9000/

Note: In Inbound i have allowed both Postgresql - 5432 and Mysql - 9000 ports

4

I’m not sure to understand what you are trying to achieve. Are you trying to expose the UI on the 5432 port ?

5

Yes. I tried changing the port to “sonar.web.port=5432” and accessed the URL “http://10.245.2.17:5432”. But its not working.

So i changed it to default port “sonar.web.port=9000” and the URL “http://10.245.2.17:9000” is working fine now.

6

5432 is the default postgresql port. If you try to use it as a http port on the same machine, you get a conflict port.

7

ok fine thanks.