SonarQube Tutorial | Installing & Configuring SonarQube with Postgresql database смотреть онлайн

LIST OF COMMANDS
#sonarqube #devops #devopspracticals #aws #ubuntu #devopstutorial

increase the vm.max_map_count kernal, file discriptor and ulimit for current session at runtime

#sudo sysctl -w vm.max_map_count=262144

#sudo sysctl -w fs.file-max=65536

#ulimit -n 65536

#ulimit -u 4096

lets update the repository & install unzip wget packages

#apt update && apt install wget unzip -y

STEP 1 INSTALL JAVA
#apt install openjdk-11-jdk openjdk-11-jre -y

To select default jdk or switch to OPENJDK

#sudo update-alternatives --config java

#java --version

STEP 2 : INSTALL AND SETUP POSTGRESS DATABASE FOR SONARQUBE

Add and download the postgreSQL Repo

#sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt `lsb_release -cs`-pgdg main"
/etc/apt/sources.list.d/pgdg.list'

#wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
#sudo apt-get update
#sudo apt-get -y install postgresql postgresql-contrib
#service postgresql start
#service postgresql enable
#passwd postgres
-give new password

switch to postgres user
#su - postgres
Add a new user ---SONAr
#createuser sonar

#psql (to switch to postgresql shell)

-- setup a password for newly created user for sonarqube database.
#ALTER USER sonar WITH ENCRYPTED password 'abcd@123'; ---------- use this command to set a password

-- create a new database for PostgreSQL
#CREATE DATABASE sonarqube OWNER sonar;

-- grant all privileges to sonar user on sonarqube database.
#grant all privileges on DATABASE sonarqube to sonar;

-- exit from the postgre shell.
# \q

-- switch back to the root user of ubuntu
# exit

STEP 3 INSTALL SONARQUBE ON UBUNTU
#wget https://binaries.sonarsource.com/Distribution/sonarqube/sonarqube-7.9.6.zip
#unzip sonarqube-7.9.6.zip
#mv sonarqube-7.9.6 /opt/sonarqube

Step 4 CONFIGURE SONARQUBE

1. cREATE GROUP AND USER . CREATE A GROUP AS SONAR
#sudo groupadd sonar

2. Now add the user with directory access
#sudo useradd -c "user to run SonarQube" -d /opt/sonarqube -g sonar sonar
#sudo chown sonar:sonar /opt/sonarqube -R

3. Open sonarqube configuration file
#sudo vi /opt/sonarqube/conf/sonar.properties

find the following lines
#user credentials
uncomment the below lines by removing the #

sonar.jdbc.username=sonar
sonar.jdbc.password=abcd@123
sonar.jdbc.url=jdbc:postgresql://localhost:5432/sonarqube

:wq (save & quit)

4. Edit the sonar script file and set RUN_AS_USER

vi /opt/sonarqube/bin/linux-x86-64/sonar.sh

RUN_AS_USER=sonar

:wq

5. To Start the sonarqube switch to sonar user
#sudo su sonar
#cd /opt/sonarqube/bin/linux-x86-64/
#./sonar.sh start
----- sonarqube is started now

6. open logs

cd ../..
cd logs
less sonar.log

we can check the process is up

we can now access the sonarqube webpage at

http://publicip:9000/

to login use

username admin
password admin