SonarQube Postgres

Basic SonarQube Postgres Database Setup

# Install SonarQube and dependencies on Ubuntu 16.04 LTS

# Create new user for future access
# Disable 'root' user SSH access

# Install and configure Postgres
sudo apt-get instal
sudo -u postgres psql postgres
CREATE DATABASE sonar;
CREATE USER sonar WITH PASSWORD 'verysecret';
GRANT ALL PRIVILEGES ON DATABASE sonar TO sonar;

# Install and configure Sonarqube


#Configure Sonarqube to run as a service
cp .sonarquberc /etc/init.d/sonar
sudo ln -s $SONAR_HOME/bin/linux-x86-64/sonar.sh /usr/bin/sonar
sudo chmod 755 /etc/init.d/sonar
sudo chkconfig --add sonar