Sonarqube_Postgress_Installation

In this guide, you will learn how to install SonarQube static code analysis on Ubuntu 22.04 server. 
You will also learn how to install PostgreSQL which will be used as the database for SonarQube and the Nginx web server that will be used as the reverse proxy.


- sudo apt update 
- sudo apt install default-jdk 
- java -version
- wget -qO - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
- sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
- sudo apt-get update
- sudo apt-get install postgresql-13
- psql --version

- sudo systemctl is-enabled postgresql
- sudo systemctl status postgresql

- sudo -u postgres psql
- CREATE USER sonarqube WITH PASSWORD 'Password@123';
- CREATE DATABASE sonarqube OWNER sonarqube;
- GRANT ALL PRIVILEGES ON DATABASE sonarqube TO sonarqube;
- \l
- \du
- \q

- sudo useradd -b /opt/sonarqube -s /bin/bash sonarqube
- sudo vi /etc/sysctl.conf
    vm.max_map_count=524288
    fs.file-max=131072
- sudo sysctl --system

- ulimit -n 131072
- ulimit -u 8192

- sudo vi /etc/security/limits.d/99-sonarqube.conf
    sonarqube   -   nofile   131072
    sonarqube   -   nproc    8192

- sudo apt update
- sudo apt install unzip software-properties-common wget

- wget https://binaries.sonarsource.com/Dist...
- unzip sonarqube-9.9.6.92038.zip
- sudo mv sonarqube-9.9.6.92038 /opt/sonarqube
- sudo chown -R sonarqube:sonarqube /opt/sonarqube

- sudo vi /opt/sonarqube/conf/sonar.properties
      sonar.jdbc.username=sonarqube
      sonar.jdbc.password=Password@123
      sonar.jdbc.url=jdbc:postgresql://localhost:5432/sonarqube
      sonar.search.javaOpts=-Xmx512m -Xms512m -XX:MaxDirectMemorySize=256m -XX:+HeapDumpOnOutOfMemoryError
      sonar.web.host=127.0.0.1
      sonar.web.port=9000
      sonar.web.javaAdditionalOpts=server
      sonar.log.level=INFO
      sonar.path.logs=logs


- sudo vi /etc/systemd/system/sonarqube.service
    [Unit]
    Description=SonarQube service
    After=syslog.target network.target

    [Service]
    Type=forking
    ExecStart=/opt/sonarqube/bin/linux-x86-64/sonar.sh start
    ExecStop=/opt/sonarqube/bin/linux-x86-64/sonar.sh stop
    User=sonarqube
    Group=sonarqube
    Restart=always
    LimitNOFILE=65536
    LimitNPROC=4096

    [Install]
    WantedBy=multi-user.target