Install sonarqube 6.7.4 with MySQL Database on Ubuntu 16.04

Minimum Requirement:

Java 8
MySQL 5.6

Create user sonar and give them password

Create file create_database.sql

# Create SonarQube database and user.
#
# Command: mysql -u root -p < create_database.sql
#

    CREATE DATABASE sonar CHARACTER SET utf8 COLLATE utf8_general_ci;

    CREATE USER 'sonar' IDENTIFIED BY 'sonar';
    GRANT ALL ON sonar.* TO 'sonar'@'%' IDENTIFIED BY 'sonar';
    GRANT ALL ON sonar.* TO 'sonar'@'localhost' IDENTIFIED BY 'sonar';
    FLUSH PRIVILEGES;

Then run the script: mysql -u root -p < create_database.sql

Download sonarqube 6.7.4

Extract to /opt/sonarqube

Create directory in /var/sonarqube/data and /var/sonarqube/temp Change ownership of /opt/sonarqube and /var/sonarqube/ to sonar Log off then login to sonar

Edit file /opt/sonarqube/conf/sonar.properties

sonar.jdbc.username=sonar
sonar.jdbc.password=sonar

sonar.jdbc.url=jdbc:mysql://localhost:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSS$

sonar.web.host=$YOUR_IP
sonar.web.context=
sonar.web.port=9000

sonar.path.data=/var/sonarqube/data
sonar.path.data=/var/sonarqube/temp

Run elastic search : /opt/sonarqube/elasticsearch/bin/elasticsearch -d -Ecluster.name=sonar -Enode.name=sonar

Lastly run sonar: /opt/sonarqube/bin/linux-x86-64/sonar.sh start

zhadowz99/Install_SonarQube_6-7-4.md

Install sonarqube 6.7.4 with MySQL Database on Ubuntu 16.04