From fff73af28171ee3f1f12a07fcf48ce8ad6080c5d Mon Sep 17 00:00:00 2001
From: Christian Pointner <equinox@spreadspace.org>
Date: Fri, 23 Oct 2020 03:59:00 +0200
Subject: clean up mysql role

---
 roles/mysql/files/percona.gpg                   | Bin 3299 -> 0 bytes
 roles/mysql/tasks/main.yml                      |  23 ++++++++++++++++++-----
 roles/mysql/tasks/mysql-secure-installation.yml |  22 ----------------------
 roles/mysql/tasks/percona.yml                   |  19 -------------------
 4 files changed, 18 insertions(+), 46 deletions(-)
 delete mode 100644 roles/mysql/files/percona.gpg
 delete mode 100644 roles/mysql/tasks/mysql-secure-installation.yml
 delete mode 100644 roles/mysql/tasks/percona.yml

(limited to 'roles/mysql')

diff --git a/roles/mysql/files/percona.gpg b/roles/mysql/files/percona.gpg
deleted file mode 100644
index 56220c91..00000000
Binary files a/roles/mysql/files/percona.gpg and /dev/null differ
diff --git a/roles/mysql/tasks/main.yml b/roles/mysql/tasks/main.yml
index 3f142f6b..3bb125d4 100644
--- a/roles/mysql/tasks/main.yml
+++ b/roles/mysql/tasks/main.yml
@@ -1,15 +1,28 @@
 ---
 - name: prepare package provider
   when: mysql_pkg_provider != 'distro'
-  include_tasks: "{{ mysql_pkg_provider }}.yml"
+  include_role:
+    name: "apt-repo/{{ mysql_pkg_provider }}"
 
 - name: install mysql packages
   apt:
     name:
-      - "{{ mysql_pkg_name }}"
-      - "{{ python_basename }}-pymysql"
+    - "{{ mysql_pkg_name }}"
+    - "{{ python_basename }}-pymysql"
     state: present
     force: yes
 
-- name: remove insecure defaults
-  import_tasks: mysql-secure-installation.yml
+- name: delete anonymous MySQL server user
+  mysql_user:
+    login_user: root
+    login_unix_socket: /var/run/mysqld/mysqld.sock
+    user: ""
+    state: absent
+  no_log: true
+
+- name: remove the MySQL test database
+  mysql_db:
+    login_user: root
+    login_unix_socket: /var/run/mysqld/mysqld.sock
+    db: test
+    state: absent
diff --git a/roles/mysql/tasks/mysql-secure-installation.yml b/roles/mysql/tasks/mysql-secure-installation.yml
deleted file mode 100644
index 28674cfd..00000000
--- a/roles/mysql/tasks/mysql-secure-installation.yml
+++ /dev/null
@@ -1,22 +0,0 @@
----
-- name: set mysql root password
-  mysql_user:
-    login_user: root
-    login_password: "{{ mysql_root_password }}"
-    user: root
-    password: "{{ mysql_root_password }}"
-    host: localhost
-
-- name: delete anonymous MySQL server user
-  mysql_user:
-    login_user: root
-    login_password: "{{ mysql_root_password }}"
-    user: ""
-    state: absent
-
-- name: remove the MySQL test database
-  mysql_db:
-    login_user: root
-    login_password: "{{ mysql_root_password }}"
-    db: test
-    state: absent
diff --git a/roles/mysql/tasks/percona.yml b/roles/mysql/tasks/percona.yml
deleted file mode 100644
index 72b4b9d9..00000000
--- a/roles/mysql/tasks/percona.yml
+++ /dev/null
@@ -1,19 +0,0 @@
----
-- name: add repository key
-  copy:
-    src: percona.gpg
-    dest: /etc/apt/trusted.gpg.d/mysql.gpg
-  register: apt_repo_percona_key
-
-- name: add repository entry
-  copy:
-    content: |
-      deb http://repo.percona.com/apt {{ ansible_distribution_release }} main
-    dest: /etc/apt/sources.list.d/mysql.list
-  register: apt_repo_percona_sources
-
-- name: update apt cache
-  when: apt_repo_percona_key is changed or
-        apt_repo_percona_sources is changed
-  apt:
-    update_cache: yes
-- 
cgit v1.2.3