Sonarqube Ansible Play: Part 2 - PostgreSQL

sonarqube.part2.yml

#    - name: Create postgres user for SonarQube
#      become: yes
#      become_user: postgres
#      postgresql_user:
#        name: "{{ sonar_db_user }}"
#        password: 'str[\"md5\"] + md5[ {{ sonar_db_pass }} + {{ sonar_db_user }} ]'
#        encrypted: yes
#
#    - name: Create the sonar database
#      postgresql_db:
#        name: "{{ sonar_db_name }}"
#        owner: "{{ sonar_db_user }}"

    - name: Copy the SonarQube PostgreSQL setup script
      copy:
        src: "../files/sonar/dbSetup.sh"
        dest: "/tmp/dbSetup.sh"
        mode: 0744
        owner: "postgres"

    - name: Strip carriage returns from scripts to ensure this works from Windows VMs
      replace:
        path: "/tmp/dbSetup.sh"
        regexp: "[\r]$"
        replace: ""

    - name: Create postgres user and DB for SonarQube
      become: yes
      become_user: postgres
      command: "/tmp/dbSetup.sh {{ sonar_db_pass }}"