vname=sonarqube
az group create -n ${vname}-rg
az vm create --name ${vname}-vm --resource-group ${vname}-rg --image UbuntuLTS --admin-username azureadmin
az vm open-port --name ${vname}-vm --resource-group ${vname}-rg --port 9000

curl -sLo - https://raw.githubusercontent.com/ampacheco/azure-sonar-qube/main/setup.sh | sudo bash -

curl -sLo - https://raw.githubusercontent.com/ampacheco/azure-sonar-qube/main/setup-sq.sh |sudo bash -

curl -sLo - https://raw.githubusercontent.com/ampacheco/azure-sonar-qube/main/configure-sq.sh |sudo bash -

# Login as postgres user
sudo su - postgres

# Now create a user below by executing below command
createuser sonar

# Switch to sql shell by entering 
psql
# Execute the below three lines (one by one)
ALTER USER sonar WITH ENCRYPTED password 'password';
CREATE DATABASE sonarqube OWNER sonar;
GRANT ALL PRIVILEGES ON DATABASE sonarqube to sonar;
# Exit psql
\q

# Modify sonar.properties file
cat << EOF | sudo tee -a /opt/sonarqube/conf/sonar.properties
sonar.jdbc.username=sonar
sonar.jdbc.password=password
sonar.jdbc.url=jdbc:postgresql://localhost/sonarqube
# EOF