5 files changed, 136 insertions, 0 deletions
diff --git a/tasks/Debian-phpmyadmin.yml b/tasks/Debian-phpmyadmin.yml
new file mode 100644
index 0000000..9da9a1b
--- /dev/null
+++ b/tasks/Debian-phpmyadmin.yml
@@ -0,0 +1,24 @@
+---
+- name: configuration debconf
+  debconf:
+    name: phpmyadmin
+    question: 'phpmyadmin/reconfigure-webserver'
+    value: 'apache2'
+    vtype: select
+- name: configuration debconf
+  debconf:
+    name: phpmyadmin
+    question: 'phpmyadmin/mysql/admin-pass'
+    value: '(password omitted)'
+    vtype: string
+- name: configuration debconf
+  debconf:
+    name: phpmyadmin
+    question: 'phpmyadmin/dbconfig-install'
+    value : 'true'
+    vtype: boolean
+
+- name: installation phpmyadmin
+  package:
+    name: phpmyadmin
+    state: present
diff --git a/tasks/RedHat-phpmyadmin.yml b/tasks/RedHat-phpmyadmin.yml
new file mode 100644
index 0000000..569ddd2
--- /dev/null
+++ b/tasks/RedHat-phpmyadmin.yml
@@ -0,0 +1,23 @@
+---
+- name: installation epel-release
+  package:
+    name: epel-release
+    state: present
+
+- name: installation phpmyadmin
+  package:
+    name: phpmyadmin
+    state: present
+
+- name: phpmyadmin.conf
+  replace:
+    path: /etc/httpd/conf.d/phpMyAdmin.conf
+    regexp: "Require local"
+    replace: "Require all granted"
+    after: "<Directory /usr/share/phpMyAdmin/>"
+    before: "</Directory>"
+  notify: restarting_apache
+
+- name: database
+  shell: mysql < /usr/share/phpMyAdmin/sql/create_tables.sql
+
diff --git a/tasks/clean_dbuser.yml b/tasks/clean_dbuser.yml
new file mode 100644
index 0000000..8d7d0cd
--- /dev/null
+++ b/tasks/clean_dbuser.yml
@@ -0,0 +1,13 @@
+---
+- name: supprimer la base de données {{ db_user }}
+  community.mysql.mysql_db:
+    name: '{{ db_user }}' 
+    state: absent
+    login_unix_socket: '{{mariadb.socket}}'
+
+- name: supprimer l'utilisateur {{ db_user }}
+  community.mysql.mysql_user:
+    name: '{{ db_user }}'
+    state: absent
+    login_unix_socket: '{{mariadb.socket}}'
+
diff --git a/tasks/main.yml b/tasks/main.yml
new file mode 100644
index 0000000..0445a69
--- /dev/null
+++ b/tasks/main.yml
@@ -0,0 +1,57 @@
+---
+# tasks file for lamp
+- include_vars: '{{ansible_os_family}}.yml'
+  tags:
+    - test
+    - clean
+
+- name: installation de lamp
+  package:
+    update_cache: true
+    name: "{{ lamp_packages }}"
+    state: present
+
+- name: activation des services sur Redhat
+  service:
+    state: started
+    name: '{{item}}'
+  with_items:
+    - httpd
+    - mariadb
+  when: ansible_os_family == 'RedHat'
+
+- name : activation du mod_rewrite d'apache sur Debian
+  community.general.apache2_module:
+    state: present
+    name: rewrite
+  when: ansible_os_family == 'Debian'
+  notify:
+    - restarting_apache
+      
+- name: mise en place de index.html
+  template:
+    src: templates/index.j2
+    dest: /var/www/html/index.html
+    owner: "{{apache.user}}"
+    group: "{{apache.user}}"
+    mode: 0644
+
+- name: installation de phpmyadmin
+  include_tasks: 
+    file: '{{ansible_os_family}}-phpmyadmin.yml'
+    apply:
+      tags: phpmyadmin
+  tags: phpmyadmin
+
+- name: test dbuser
+  import_tasks: test_dbuser.yml
+  tags:
+    - never
+    - test
+
+- name: clean dbuser
+  import_tasks: clean_dbuser.yml
+  tags:
+    - never
+    - clean
+
diff --git a/tasks/test_dbuser.yml b/tasks/test_dbuser.yml
new file mode 100644
index 0000000..c2243f3
--- /dev/null
+++ b/tasks/test_dbuser.yml
@@ -0,0 +1,19 @@
+---
+- name: install dépendances python
+  package:
+    name: '{{ mariadb.pythonlib }}'
+    state: present
+
+- name: Créer la base de données {{ db_user }}
+  community.mysql.mysql_db:
+    name: '{{ db_user }}'
+    state: present
+    login_unix_socket: '{{mariadb.socket}}'
+
+- name: Créer un utilisateur {{ db_user }}
+  community.mysql.mysql_user:
+    name: '{{ db_user }}'
+    password: '{{ db_passwd }}'
+    priv: '{{ db_user }}.*:ALL'
+    state: present
+    login_unix_socket: '{{mariadb.socket}}'