Prerequiste

I assume that you have a Centos installation.

Installation

You can copy/paste this script and use it to configure automatically your server.

#!/bin/bash
 
echo "import sonar repository"
sudo wget -O /etc/yum.repos.d/sonar.repo http://downloads.sourceforge.net/project/sonar-pkg/rpm/sonar.repo
 
echo "create database sonar, user/password sonar/sonar":
mysql --user=root --password=root -e "CREATE USER 'sonar'@'localhost' IDENTIFIED BY 'sonar';"
mysql --user=root --password=root -e "CREATE DATABASE IF NOT EXISTS sonar;"
mysql --user=root --password=root -e "use sonar; GRANT ALL PRIVILEGES ON sonar.* TO 'sonar'@'localhost' WITH GRANT OPTION;"
 
echo "install sonar"
dnf -y install sonar
 
echo "start sonar on boot"
systemctl enable sonar.service
 
echo "Configure sonar"
# add # before each sonar.jdbc.url that are not commented:
sed -i "s/^\(sonar.jdbc.url\)/#\1/" /opt/sonar/conf/sonar.properties
 
# remove comment for the sonar.jdbc.url in mysql part:
sed -i "s/^#\(sonar.jdbc.url=.*jdbc:mysql\)/\1/" /opt/sonar/conf/sonar.properties
 
# user creditential:
sed -i "s/^#\(sonar.jdbc.username=\).*/\1sonar/" /opt/sonar/conf/sonar.properties
sed -i "s/^#\(sonar.jdbc.password=\).*/\1sonar/" /opt/sonar/conf/sonar.properties
 
# sonar web context
sed -i "s/^#\(sonar.web.context=\).*/\1\/sonar/" /opt/sonar/conf/sonar.properties
sed -i "s/^\(sonar.web.context=\).*/\1\/sonar/" /opt/sonar/conf/sonar.properties
 
echo "configure httpd (create /etc/httpd/conf.d/sonar.conf)"
cat > /etc/httpd/conf.d/sonar.conf << "EOF"
ProxyPreserveHost On
Proxypass /sonar http://localhost:9000/sonar
Proxypassreverse /sonar http://localhost:9000/sonar
ProxyRequests     Off
EOF
 
echo "start service"
systemctl restart httpd.service
systemctl start sonar.service
 
myip=`hostname -I`
echo "Now meet you here: http://$myip/sonar"
 

That’s all 🙂