path: root/pad/tasks/mariadb.yml

---
- name: Install MySQL packages
  apt:
    name:
      - mariadb-server
      - mariadb-client
      - python3-mysqldb
- name: Ensure anonymous users are not in the database
  mysql_user:
    name: ""
    host: "{{ item }}"
    state: absent
  with_items:
    - localhost
    - 127.0.0.1
    - ::1
    - "%"
- name: Ensure mysql is configured to bind only to localhost
  ini_file:
    dest: /etc/mysql/my.cnf
    section: mysqld
    option: "bind-address"
    value: "127.0.0.1"
- name: Start MariaDB
  service:
    name: mysql
    state: restarted
    enabled: yes
    runlevel:
      - 3
      - 5
- name: Ensure emacsconf-pad database exists
  mysql_db:
    name: "{{ etherpad_database_name }}"
    collation: utf8mb4_general_ci
    state: present
- name: Grant permissions to user
  mysql_user:
    name: "{{ etherpad_database_user }}"
    state: present
    priv: "{{ etherpad_database_name }}.*:ALL"
    password: "{{ etherpad_database_password }}"