- name: Etckeeper commit if necessary
  ansible.builtin.command: etckeeper commit "commit by ansible because installing {{ DOMAIN }}/{{ config_ss_domain }}"
  ignore_errors: true

- name: Install ansible mysql required packages
  ansible.builtin.apt:
    name:
      - python3-pymysql

- name: Boucle d'ajout du user php dans plusieurs groupe
  ansible.builtin.user:
    name: "php_{{ SIGLE }}_{{ config_ss_domain }}"
    groups: "{{ item }}"
    append: true
  loop:
    - mysql
    - "site_{{ SIGLE }}_{{ config_ss_domain }}"

- name: Création de la nouvelle bdd Mariadb
  community.mysql.mysql_db:
    name: "php_{{ SIGLE }}_{{ config_ss_domain }}"
    state: present
    login_unix_socket: /run/mysqld/mysqld.sock
    encoding: utf8mb4  # pour WP

- name: Créer le user mysql
  community.mysql.mysql_user:
    name: "php_{{ SIGLE }}_{{ config_ss_domain }}"
    priv: "php_{{ SIGLE }}_{{ config_ss_domain }}.*:ALL"
    state: present
    login_unix_socket: /run/mysqld/mysqld.sock