Skip to content

Latest commit

 

History

History
206 lines (183 loc) · 5.9 KB

sonarqube_installation.md

File metadata and controls

206 lines (183 loc) · 5.9 KB
Raw

SonarQube Installation

Prerequisites

  1. Install OpenJDK 8
  2. MySQL 5.x Install and Database Create

Installation OpenJDK 8

Install OpenJDK 8

yum -y install java-1.8.0-openjdk java-1.8.0-openjdk-devel
cat > /etc/profile.d/java8.sh <<EOF
export JAVA_HOME=$(dirname $(dirname $(readlink $(readlink $(which javac)))))
export PATH=\$PATH:\$JAVA_HOME/bin
export CLASSPATH=.:\$JAVA_HOME/jre/lib:\$JAVA_HOME/lib:\$JAVA_HOME/lib/tools.jar
EOF
source /etc/profile.d/java8.sh

If another version of JDK had been installed, change the default like follows.

alternatives --config java
#output it as below and select version as shown
There are 2 programs which provide 'java'.

  Selection    Command
-----------------------------------------------
   1           /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.102-1.b14.el7.x86_64/jre/bin/java

Enter to keep the current selection[+], or type selection number: 1

Create a test program and make sure if it works normally.

 vi day.java
import java.util.Calendar;

class day {
    public static void main(String[] args) {
        Calendar cal = Calendar.getInstance();
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH) + 1;
        int day = cal.get(Calendar.DATE);
        int hour = cal.get(Calendar.HOUR_OF_DAY);
        int minute = cal.get(Calendar.MINUTE);
        System.out.println(year + "/" + month + "/" + day + " " + hour + ":" + minute);
    }
}

compile

javac day.java

run

java day
# output
2021/05/304 19:46

MySQL 5.x Installation

Download, install and enable mysql 5.7 repo for your linux destro

yum install wget unzip -y
sudo rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
rpm --import /etc/pki/rpm-gpg/*

Install mysql package

yum install mysql-community-server

start the mysql service

systemctl start mysqld

OR

service mysqld Start

get the mysql root password

grep 'temporary password' /var/log/mysqld.log

execute mysql_secure_installation and follow the steps and change root password

mysql_secure_installation

Create sonarqube database

Install MySQL client to connect and create DataBase for sonarqube

yum install mysql

Allow RDS instance security group to access SonarQube server

Connect to MYSQL server OR RDS instance with database credentials (my case localhost).

mysql -h <MYSQL_SERVER_IP> -u root -p
password:

OR

mysql -h <MYSQL_SERVER_IP>:3306 -u root -p
password:

Create a new database for sonarqube

CREATE DATABASE sonardb CHARACTER SET utf8 COLLATE utf8_general_ci;

Create a local and a remote user for new database

CREATE USER sonaruser@localhost IDENTIFIED BY 'SonarPass@123';
CREATE USER sonaruser@'%' IDENTIFIED BY 'SonarPass@123';

Grant database access permissions to users

GRANT ALL ON sonardb.* TO sonaruser@localhost;
GRANT ALL ON sonardb.* TO sonaruser@'%';

check users and databases

use mysql
show databases;
SELECT User FROM mysql.user;
FLUSH PRIVILEGES;
QUIT

So for you have configured required database information on RDS. Let’s Jump back to your EC2 instance and enable SonarQube properties file to connect his Database.

ON SonarQube server (EC2)

Download stable SonarQube version from below website.

Download & unzip SonarQube 6.0

cd /opt
wget https://binaries.sonarsource.com/Distribution/sonarqube/sonarqube-6.0.zip
unzip sonarqube-6.0.zip
mv /opt/sonarqube-6.0 /opt/sonar

if unzip not available installed it as follow

yum install unzip -y

Edit sonar properties file to uncomment and provide required information for below properties. (my case MYSQL_SERVER_IP is localhost).

vi /opt/sonar/conf/sonar.properties
  sonar.jdbc.username=sonaruser
  sonar.jdbc.password=SonarPass@123
  sonar.jdbc.url=jdbc:mysql://<MYSQL_SERVER_IP>:3306/sonardb?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false
  sonar.web.host=0.0.0.0
  sonar.web.context=/sonar

Start SonarQube service

cd /opt/sonar/bin/linux-x86-64/
./sonar.sh start

When start service first time it will take little bit time to up and run the service after creating database tables as follows and wait upto computer engine is up from /opt/sonar/logs/sonar.log.

sonarqube DB table

Add SonarQube service to systemd settings

Copying sonar.sh to /etc/init.d/sonar and modify it according to your platform.

sudo cp /opt/sonar/bin/linux-x86-64/sonar.sh /etc/init.d/sonar
sudo vi /etc/init.d/sonar

Add below values to your /etc/init.d/sonar file

#Insert/modify below values
SONAR_HOME=/opt/sonar
PLATFORM=linux-x86-64

WRAPPER_CMD="${SONAR_HOME}/bin/${PLATFORM}/wrapper"
WRAPPER_CONF="${SONAR_HOME}/conf/wrapper.conf"
PIDDIR="/var/run"

Start SonarQube server

service sonar start

SonarQube application uses port 9000. access SonarQube from browser and login with username admin, password is admin http://<sonarqube_server_PUBLIC_IP>:9000/sonar

Change the password after login Sonarqube homepage >> administrator top right > MY Account > Security Tab > Change password.

Troubleshooting

  1. Check whether you enabled port 9000 in EC2 instance security group
  2. Check whether you enabled EC2 instance IP range in RDS security group
  3. If you using RHEL or CentOS check the firewalld port allow on both servers

Next Step

Resource

MYSQL INSTALLATION

I'm Happy To Get Suggestions 😄