install_sql_server.yml

---
# ------------------------------------------------------------------------------
# Install MS-SQL/Server 
# Ref: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat?view=sql-server-ver15
# ------------------------------------------------------------------------------

- hosts:
    -                   sefton1.yaocm.id.au
    -                   sefton2.yaocm.id.au
  tasks:
  
  - name:               "Restrict Installation to OL7"
    assert:
      msg:              "Restrict Installation to OL7"
      that: >
                        ansible_distribution == "OracleLinux" and
                        ansible_distribution_major_version == '7'
  
  - name:               "Set MS-SQL/Server Configuration"
    set_fact:
      mssql_tcp_port:   1433
      db_password:      "MSsqlSA7"

  - name:               "Add Microsoft yum repositories for SQL Server 2019 on RHEL 7"
    get_url:
      url:              "https://packages.microsoft.com/config/rhel/7/{{ item.url }}"
      dest:             "/etc/yum.repos.d/{{ item.dest }}"
    become:             yes
    become_user:        root
    with_items:
      - { url: mssql-server-2019.repo, dest: mssql-server.repo }
      - { url: prod.repo, dest: msprod.repo }

  - name:               "Remove Old Packages"
    yum:
      name:
        -               unixODBC-utf16
        -               unixODBC-utf16-devel
      state:            absent
    become:             yes
    become_user:        root

  - name:               "Install Microsoft SQL Server package"
    yum:
      name:
        -               mssql-server
        -               mssql-tools 
        -               unixODBC-devel
      state:            present
    become:             yes
    become_user:        root
    environment:
      - ACCEPT_EULA:    Y

  - name:               "Get Current State of MS-SQL/Server Service"
    systemd:
      name:             mssql-server
    register:           sql_server
  
  - name:               "Run SQL Server setup mssql-conf"
    command:            /opt/mssql/bin/mssql-conf -n setup accept-eula
    environment:
      - MSSQL_SA_PASSWORD:
                        "{{ db_password }}"
      - MSSQL_PID:      "Developer"
      - MSSQL_TCP_PORT: "{{ mssql_tcp_port }}"
    become:             yes
    become_user:        root
    when:
      -                 sql_server.status.SubState is defined
      -                 sql_server.status.SubState == "dead"

  - name:               "Add firewalld settings"
    firewalld:
      zone:             public
      port:             "{{ mssql_tcp_port }}/tcp"
      permanent:        true
      state:            enabled
    become:             yes
    become_user:        root
    notify:             Reload FireWall Rules

  - name:               "Ensure the MSSQL service is started"
    service:
      name:             mssql-server
      state:            started
    become:             yes
    become_user:        root

  - name:               "Add mssql-tools to bash profile"
    lineinfile:
      path:             "{{ item }}"
      line:             export PATH="$PATH:/opt/mssql-tools/bin"
    loop:
      -                 ~/.bash_profile
      -                 ~/.bashrc

# ------------------------------------------------------------------------------
# Handlers
# ------------------------------------------------------------------------------
  
  handlers:
  - name:               "Reload FireWall Rules"
    command:
      argv:
        -               firewall-cmd
        -               "--reload"
    become:             yes
    become_user:        root
...