From b1ca188b8a16a49b79cd18ae39261fe9c666edf1 Mon Sep 17 00:00:00 2001 From: heqnx Date: Mon, 14 Jul 2025 11:54:51 +0300 Subject: working iis + mssql setup --- ansible/roles/mssql01/tasks/cleanup.yaml | 3 -- ansible/roles/mssql01/tasks/init.yaml | 9 ------ ansible/roles/mssql01/tasks/install_software.yaml | 3 -- ansible/roles/mssql01/tasks/join_domain.yaml | 13 --------- ansible/roles/mssql01/tasks/main.yaml | 34 ---------------------- ansible/roles/mssql01/tasks/reboot.yaml | 3 -- ansible/roles/mssql01/tasks/set_hostname.yaml | 2 -- ansible/roles/mssql01/tasks/setup_mssql.yaml | 7 ----- ansible/roles/proxmox_vm/tasks/set_network.yaml | 16 +++++----- ansible/roles/websql01/tasks/cleanup.yaml | 3 ++ ansible/roles/websql01/tasks/init.yaml | 9 ++++++ ansible/roles/websql01/tasks/install_software.yaml | 3 ++ ansible/roles/websql01/tasks/join_domain.yaml | 13 +++++++++ ansible/roles/websql01/tasks/main.yaml | 34 ++++++++++++++++++++++ ansible/roles/websql01/tasks/reboot.yaml | 3 ++ ansible/roles/websql01/tasks/set_hostname.yaml | 2 ++ ansible/roles/websql01/tasks/setup_websql.yaml | 7 +++++ 17 files changed, 82 insertions(+), 82 deletions(-) delete mode 100644 ansible/roles/mssql01/tasks/cleanup.yaml delete mode 100644 ansible/roles/mssql01/tasks/init.yaml delete mode 100644 ansible/roles/mssql01/tasks/install_software.yaml delete mode 100644 ansible/roles/mssql01/tasks/join_domain.yaml delete mode 100644 ansible/roles/mssql01/tasks/main.yaml delete mode 100644 ansible/roles/mssql01/tasks/reboot.yaml delete mode 100644 ansible/roles/mssql01/tasks/set_hostname.yaml delete mode 100644 ansible/roles/mssql01/tasks/setup_mssql.yaml create mode 100644 ansible/roles/websql01/tasks/cleanup.yaml create mode 100644 ansible/roles/websql01/tasks/init.yaml create mode 100644 ansible/roles/websql01/tasks/install_software.yaml create mode 100644 ansible/roles/websql01/tasks/join_domain.yaml create mode 100644 ansible/roles/websql01/tasks/main.yaml create mode 100644 ansible/roles/websql01/tasks/reboot.yaml create mode 100644 ansible/roles/websql01/tasks/set_hostname.yaml create mode 100644 ansible/roles/websql01/tasks/setup_websql.yaml (limited to 'ansible/roles') diff --git a/ansible/roles/mssql01/tasks/cleanup.yaml b/ansible/roles/mssql01/tasks/cleanup.yaml deleted file mode 100644 index 0e59407..0000000 --- a/ansible/roles/mssql01/tasks/cleanup.yaml +++ /dev/null @@ -1,3 +0,0 @@ -- name: execute cleanup.ps1 - ansible.windows.win_powershell: - script: C:\scripts\cleanup.ps1 diff --git a/ansible/roles/mssql01/tasks/init.yaml b/ansible/roles/mssql01/tasks/init.yaml deleted file mode 100644 index a75d6cc..0000000 --- a/ansible/roles/mssql01/tasks/init.yaml +++ /dev/null @@ -1,9 +0,0 @@ -- name: execute init.ps1 - ansible.windows.win_powershell: - script: C:\scripts\init.ps1 - -- name: copy mssql installer - ansible.builtin.copy: - src: files/SQL2019-SSEI-Expr.exe - dest: C:\setup\SQL2019-SSEI-Expr.exe - diff --git a/ansible/roles/mssql01/tasks/install_software.yaml b/ansible/roles/mssql01/tasks/install_software.yaml deleted file mode 100644 index a5018a8..0000000 --- a/ansible/roles/mssql01/tasks/install_software.yaml +++ /dev/null @@ -1,3 +0,0 @@ -- name: execute install-software.ps1 - ansible.windows.win_powershell: - script: C:\scripts\install-software.ps1 diff --git a/ansible/roles/mssql01/tasks/join_domain.yaml b/ansible/roles/mssql01/tasks/join_domain.yaml deleted file mode 100644 index 6736ba2..0000000 --- a/ansible/roles/mssql01/tasks/join_domain.yaml +++ /dev/null @@ -1,13 +0,0 @@ -- name: join domain - ansible.windows.win_domain_membership: - dns_domain_name: "{{ main_domain_name }}" - domain_admin_user: "{{ main_domain_name }}\\Administrator" - domain_admin_password: "{{ default_win_password }}" - state: domain - register: domain_state - -- name: reboot - win_reboot: - reboot_timeout: 3600 - when: domain_state.reboot_required - diff --git a/ansible/roles/mssql01/tasks/main.yaml b/ansible/roles/mssql01/tasks/main.yaml deleted file mode 100644 index 3822369..0000000 --- a/ansible/roles/mssql01/tasks/main.yaml +++ /dev/null @@ -1,34 +0,0 @@ -- name: wait for winrm to be available - ansible.builtin.wait_for: - host: "{{ ansible_host }}" - port: "{{ ansible_port }}" - timeout: 300 - delegate_to: localhost - -- name: execute init.ps1 - import_tasks: init.yaml - -- name: set hostname - import_tasks: set_hostname.yaml - -- name: reboot after hostname change - import_tasks: reboot.yaml - -- name: join domain and reboot - import_tasks: join_domain.yaml - -- name: execute setup-mssql.ps1 - import_tasks: setup_mssql.yaml - -- name: reboot after mssql setup - import_tasks: reboot.yaml - -- name: pause 5 minutes for mssql setup to complete - pause: - minutes: 5 - -- name: execute install-software.ps1 - import_tasks: install_software.yaml - -- name: execute cleanup.ps1 - import_tasks: cleanup.yaml diff --git a/ansible/roles/mssql01/tasks/reboot.yaml b/ansible/roles/mssql01/tasks/reboot.yaml deleted file mode 100644 index a7266d0..0000000 --- a/ansible/roles/mssql01/tasks/reboot.yaml +++ /dev/null @@ -1,3 +0,0 @@ -- name: reboot - win_reboot: - reboot_timeout: 3600 diff --git a/ansible/roles/mssql01/tasks/set_hostname.yaml b/ansible/roles/mssql01/tasks/set_hostname.yaml deleted file mode 100644 index de974a4..0000000 --- a/ansible/roles/mssql01/tasks/set_hostname.yaml +++ /dev/null @@ -1,2 +0,0 @@ -- name: set hostname - win_shell: Rename-Computer -NewName "{{ main_mssql01_hostname }}" -Force diff --git a/ansible/roles/mssql01/tasks/setup_mssql.yaml b/ansible/roles/mssql01/tasks/setup_mssql.yaml deleted file mode 100644 index 4602242..0000000 --- a/ansible/roles/mssql01/tasks/setup_mssql.yaml +++ /dev/null @@ -1,7 +0,0 @@ -- name: setup mssql - ansible.windows.win_powershell: - script: C:\scripts\setup-mssql.ps1 - parameters: - DomainName: "{{ main_domain_name }}" - SvcUsername: svc_mssql01 - SvcPassword: "{{ default_win_svc_password }}" diff --git a/ansible/roles/proxmox_vm/tasks/set_network.yaml b/ansible/roles/proxmox_vm/tasks/set_network.yaml index c75aa0f..da809d5 100644 --- a/ansible/roles/proxmox_vm/tasks/set_network.yaml +++ b/ansible/roles/proxmox_vm/tasks/set_network.yaml @@ -1,4 +1,4 @@ -- name: "{{ fqdn }} : set up static ip address on windows" +- name: "{{ fqdn }} : (windows) set up static ip address on" win_shell: | Start-Transcript -Path C:\set_domain_network_log.txt -Append Get-NetIpAddress -InterfaceAlias 'Ethernet' | Remove-NetIPAddress -Confirm:$false @@ -18,36 +18,36 @@ ansible_winrm_transport: basic ansible_winrm_server_cert_validation: ignore -- name: "{{ fqdn }} : configure network for linux" +- name: "{{ fqdn }} : (linux) configure network" block: - - name: "{{ fqdn }} : get default interface" + - name: "{{ fqdn }} : (linux) get default interface" ansible.builtin.shell: ip route get 8.8.8.8 | sed -n 's/.*dev \([^\ ]*\).*/\1/p' register: interface_result - - name: "{{ fqdn }} : set default interface variable" + - name: "{{ fqdn }} : (linux) set default interface variable" ansible.builtin.set_fact: linux_interface_name: "{{ interface_result.stdout }}" netplan_ip_address: "{{ ip }}" - - name: "{{ fqdn }} : find netplan configs in /etc/netplan" + - name: "{{ fqdn }} : (linux) find netplan configs in /etc/netplan" ansible.builtin.find: paths: /etc/netplan recurse: yes register: yaml_configs - - name: "{{ fqdn }} : remove all netplan configs in /etc/netplan" + - name: "{{ fqdn }} : (linux) remove all netplan configs in /etc/netplan" ansible.builtin.file: path: "{{ item.path }}" state: absent loop: "{{ yaml_configs.files }}" - - name: "{{ fqdn }} : set netplan static ip address" + - name: "{{ fqdn }} : (linux) set netplan static ip address" ansible.builtin.template: src: static_ip_netplan.yaml.j2 dest: /etc/netplan/01-netcfg.yaml mode: '0644' - - name: "{{ fqdn }} : apply netplan configuration" + - name: "{{ fqdn }} : (linux) apply netplan configuration" ansible.builtin.command: netplan apply async: 15 poll: 0 diff --git a/ansible/roles/websql01/tasks/cleanup.yaml b/ansible/roles/websql01/tasks/cleanup.yaml new file mode 100644 index 0000000..0e59407 --- /dev/null +++ b/ansible/roles/websql01/tasks/cleanup.yaml @@ -0,0 +1,3 @@ +- name: execute cleanup.ps1 + ansible.windows.win_powershell: + script: C:\scripts\cleanup.ps1 diff --git a/ansible/roles/websql01/tasks/init.yaml b/ansible/roles/websql01/tasks/init.yaml new file mode 100644 index 0000000..a75d6cc --- /dev/null +++ b/ansible/roles/websql01/tasks/init.yaml @@ -0,0 +1,9 @@ +- name: execute init.ps1 + ansible.windows.win_powershell: + script: C:\scripts\init.ps1 + +- name: copy mssql installer + ansible.builtin.copy: + src: files/SQL2019-SSEI-Expr.exe + dest: C:\setup\SQL2019-SSEI-Expr.exe + diff --git a/ansible/roles/websql01/tasks/install_software.yaml b/ansible/roles/websql01/tasks/install_software.yaml new file mode 100644 index 0000000..a5018a8 --- /dev/null +++ b/ansible/roles/websql01/tasks/install_software.yaml @@ -0,0 +1,3 @@ +- name: execute install-software.ps1 + ansible.windows.win_powershell: + script: C:\scripts\install-software.ps1 diff --git a/ansible/roles/websql01/tasks/join_domain.yaml b/ansible/roles/websql01/tasks/join_domain.yaml new file mode 100644 index 0000000..6736ba2 --- /dev/null +++ b/ansible/roles/websql01/tasks/join_domain.yaml @@ -0,0 +1,13 @@ +- name: join domain + ansible.windows.win_domain_membership: + dns_domain_name: "{{ main_domain_name }}" + domain_admin_user: "{{ main_domain_name }}\\Administrator" + domain_admin_password: "{{ default_win_password }}" + state: domain + register: domain_state + +- name: reboot + win_reboot: + reboot_timeout: 3600 + when: domain_state.reboot_required + diff --git a/ansible/roles/websql01/tasks/main.yaml b/ansible/roles/websql01/tasks/main.yaml new file mode 100644 index 0000000..f176701 --- /dev/null +++ b/ansible/roles/websql01/tasks/main.yaml @@ -0,0 +1,34 @@ +- name: wait for winrm to be available + ansible.builtin.wait_for: + host: "{{ ansible_host }}" + port: "{{ ansible_port }}" + timeout: 300 + delegate_to: localhost + +- name: execute init.ps1 + import_tasks: init.yaml + +- name: set hostname + import_tasks: set_hostname.yaml + +- name: reboot after hostname change + import_tasks: reboot.yaml + +- name: join domain and reboot + import_tasks: join_domain.yaml + +- name: execute setup-websql.ps1 + import_tasks: setup_websql.yaml + +- name: reboot after mssql setup + import_tasks: reboot.yaml + +- name: pause 5 minutes for mssql setup to complete + pause: + minutes: 5 + +- name: execute install-software.ps1 + import_tasks: install_software.yaml + +- name: execute cleanup.ps1 + import_tasks: cleanup.yaml diff --git a/ansible/roles/websql01/tasks/reboot.yaml b/ansible/roles/websql01/tasks/reboot.yaml new file mode 100644 index 0000000..a7266d0 --- /dev/null +++ b/ansible/roles/websql01/tasks/reboot.yaml @@ -0,0 +1,3 @@ +- name: reboot + win_reboot: + reboot_timeout: 3600 diff --git a/ansible/roles/websql01/tasks/set_hostname.yaml b/ansible/roles/websql01/tasks/set_hostname.yaml new file mode 100644 index 0000000..7c53a16 --- /dev/null +++ b/ansible/roles/websql01/tasks/set_hostname.yaml @@ -0,0 +1,2 @@ +- name: set hostname + win_shell: Rename-Computer -NewName "{{ main_websql01_hostname }}" -Force diff --git a/ansible/roles/websql01/tasks/setup_websql.yaml b/ansible/roles/websql01/tasks/setup_websql.yaml new file mode 100644 index 0000000..ea527b6 --- /dev/null +++ b/ansible/roles/websql01/tasks/setup_websql.yaml @@ -0,0 +1,7 @@ +- name: setup websql + ansible.windows.win_powershell: + script: C:\scripts\setup-websql.ps1 + parameters: + DomainName: "{{ main_domain_name }}" + SvcUsername: svc_mssql02 + SvcPassword: "{{ default_win_svc_password }}" -- cgit v1.2.3