From 23ff2b6c3f4ca6335086a0336708035432bd9a09 Mon Sep 17 00:00:00 2001
From: jerome <jerome@xlinfo.fr>
Date: Wed, 29 Jan 2025 12:16:12 +0100
Subject: includes et imports

---
 lamp/tasks/Debian-phpmyadmin.yml | 23 ++++++++++++++++++++
 lamp/tasks/RedHat-phpmyadmin.yml | 23 ++++++++++++++++++++
 lamp/tasks/clean.yml             | 15 ++++++++++++++
 lamp/tasks/main.yml              | 45 +++++++++++++++++++++++++++++++++++-----
 lamp/tasks/test.yml              | 19 +++++++++++++++++
 5 files changed, 120 insertions(+), 5 deletions(-)
 create mode 100644 lamp/tasks/Debian-phpmyadmin.yml
 create mode 100644 lamp/tasks/RedHat-phpmyadmin.yml
 create mode 100644 lamp/tasks/clean.yml
 create mode 100644 lamp/tasks/test.yml

(limited to 'lamp/tasks')

diff --git a/lamp/tasks/Debian-phpmyadmin.yml b/lamp/tasks/Debian-phpmyadmin.yml
new file mode 100644
index 0000000..8bfb478
--- /dev/null
+++ b/lamp/tasks/Debian-phpmyadmin.yml
@@ -0,0 +1,23 @@
+---
+- name: configuration debconf
+  block:
+    - debconf:
+        name: phpmyadmin
+        question: 'phpmyadmin/reconfigure-webserver'
+        value: 'apache2'
+        vtype: select
+    - debconf:
+        name: phpmyadmin
+        question: 'phpmyadmin/mysql/admin-pass'
+        value: '(password omitted)'
+        vtype: string
+    - debconf:
+        name: phpmyadmin
+        question: 'phpmyadmin/dbconfig-install'
+        value : 'true'
+        vtype: boolean
+
+- name: installation phpmyadmin
+  package:
+    name: phpmyadmin
+    state: present
diff --git a/lamp/tasks/RedHat-phpmyadmin.yml b/lamp/tasks/RedHat-phpmyadmin.yml
new file mode 100644
index 0000000..569ddd2
--- /dev/null
+++ b/lamp/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/lamp/tasks/clean.yml b/lamp/tasks/clean.yml
new file mode 100644
index 0000000..7e3571e
--- /dev/null
+++ b/lamp/tasks/clean.yml
@@ -0,0 +1,15 @@
+---
+- name: supprimer la base de données test
+  community.mysql.mysql_db:
+    name: toto
+    state: absent
+    login_unix_socket: '{{mariadb.socket}}'
+
+- name: supprimer l'utilisateur test
+  community.mysql.mysql_user:
+    name: toto
+    password: secret
+    priv: 'toto.*:ALL'
+    state: absent
+    login_unix_socket: '{{mariadb.socket}}'
+
diff --git a/lamp/tasks/main.yml b/lamp/tasks/main.yml
index 634252f..17cf4d8 100644
--- a/lamp/tasks/main.yml
+++ b/lamp/tasks/main.yml
@@ -1,17 +1,34 @@
 ---
 # tasks file for lamp
-- name: installation des variables
-  include_vars: '{{ansible_distribution_file_variety}}.yml'
+- include_vars: '{{ansible_os_family}}.yml'
+  tags:
+    - test
+    - clean
 
 - name: installation de lamp
   package:
+    update_cache: true
     name: "{{item}}"
     state: present
   with_items: '{{lamp_packages}}'
-  notify:
-    - starting_apache
-    - starting_mariadb
 
+- 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
+  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
@@ -20,3 +37,21 @@
     group: "{{apache.user}}"
     mode: 0644
 
+- name: installation de phpmyadmin
+  include_tasks: '{{ansible_os_family}}-phpmyadmin.yml'
+  vars: 
+    - apache: '{{apache}}'
+  tags: phpmyadmin
+
+- name: test user
+  import_tasks: test.yml
+  tags:
+    - never
+    - test
+
+- name: clean user
+  import_tasks: clean.yml
+  tags:
+    - never
+    - clean
+
diff --git a/lamp/tasks/test.yml b/lamp/tasks/test.yml
new file mode 100644
index 0000000..46d10e7
--- /dev/null
+++ b/lamp/tasks/test.yml
@@ -0,0 +1,19 @@
+---
+- name: install dépendances python
+  package:
+    name: '{{ mariadb.pythonlib }}'
+    state: present
+
+- name: Créerla base de données test
+  community.mysql.mysql_db:
+    name: toto
+    state: present
+    login_unix_socket: '{{mariadb.socket}}'
+
+- name: Créer un utilisateur test
+  community.mysql.mysql_user:
+    name: toto
+    password: secret
+    priv: 'toto.*:ALL'
+    state: present
+    login_unix_socket: '{{mariadb.socket}}'
-- 
cgit v1.2.3