majic-ansible-roles Changeset

Changeset - 0ffaf31692ce

Parent rev.

Child rev.

[Not reviewed]

0 3 0

Branko Majic (branko) - 7 years ago 2017-08-08 15:39:49
branko@majic.rs

MAR-114: Updated task syntax for database roles:

- Updated database and database_server roles.
- Added and removed quoting where it makes sense.
- Switched to using expanded syntax (instead of one-liners).

3 files changed with 37 insertions and 13 deletions:

roles/database/tasks/main.yml

roles/database_server/handlers/main.yml

roles/database_server/tasks/main.yml

0 comments (0 inline, 0 general)

roles/database/tasks/main.yml

➞

Show inline comments

 ---
 - name: "Create database {{ db_name }}"
   mysql_db: name="{{ db_name }}" state=present
   mysql_db:
     name: "{{ db_name }}"
     state: present
 - name: "Create database user {{ db_name }}"
   mysql_user: name="{{ db_name }}" password="{{ db_password }}"
               priv="{{ db_name }}.*:ALL" state=present
   mysql_user:
     name: "{{ db_name }}"
     password: "{{ db_password }}"
     priv: "{{ db_name }}.*:ALL"
     state: present
 - name: Enable backup
   include: backup.yml
@@ @@ -15,4 +20,4 @@ @@
   include: ../handlers/main.yml
   when: "handlers | default(False) | bool() == True"
   tags:
     - handlers
@@ \ No newline at end of file @@
     - handlers

roles/database_server/handlers/main.yml

➞

Show inline comments

 ---
 - name: Restart MariaDB
   service: name=mysql state=restarted
@@ \ No newline at end of file @@
   service:
     name: mysql
     state: restarted

roles/database_server/tasks/main.yml

➞

Show inline comments

 ---
 - name: Install MariaDB
   apt: name="{{ item }}" state=installed
   apt:
     name: "{{ item }}"
     state: installed
   with_items:
     - mariadb-client
     - mariadb-server
@@ @@ -13,22 +15,37 @@ @@
   changed_when: result.stderr == ""
 - name: Enable and start MariaDB
   service: name=mysql state=started
   service:
     name: mysql
     state: started
 - name: Set password for the root database user
   mysql_user: check_implicit_admin=yes name=root password="{{ db_root_password }}"
   mysql_user:
     check_implicit_admin: yes
     name: root
     password: "{{ db_root_password }}"
 - name: Deploy username and password for the root database user
   template: src="root_my.cnf.j2" dest="/root/.my.cnf"
             owner=root group=root mode=0400
   template:
     src: "root_my.cnf.j2"
     dest: "/root/.my.cnf"
     owner: root
     group: root
     mode: 0400
 - name: Set UTF-8 encoding as default for MariaDB
   copy: src="utf8.cnf" dest="/etc/mysql/conf.d/utf8.cnf"
         owner=root group=root mode=0644
   copy:
     src: "utf8.cnf"
     dest: "/etc/mysql/conf.d/utf8.cnf"
     owner: root
     group: root
     mode: 0644
   register: mariadb_utf8_configuration
 - name: Restart MariaDB in order to use UTF-8 as default character set
   service: name=mysql state=restarted
   service:
     name: mysql
     state: restarted
   when: mariadb_utf8_configuration.changed
   tags:
     # [ANSIBLE0016] Tasks that run when changed should likely be handlers

0 comments (0 inline, 0 general)