From 6d1743c83e239806b1b6fb635e184a59a5f28f5a Mon Sep 17 00:00:00 2001
From: Sacha Chua <sacha@sachachua.com>
Date: Tue, 11 Oct 2022 12:19:46 -0400
Subject: Etherpad starting setup

---
 pad/tasks/mariadb.yml | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 pad/tasks/mariadb.yml

(limited to 'pad/tasks/mariadb.yml')

diff --git a/pad/tasks/mariadb.yml b/pad/tasks/mariadb.yml
new file mode 100644
index 0000000..7a406c9
--- /dev/null
+++ b/pad/tasks/mariadb.yml
@@ -0,0 +1,22 @@
+---
+- name: Install MySQL packages
+  apt:
+    name:
+      - mariadb-server
+      - mariadb-client
+      - python3-mysqldb
+- name: Start MariaDB
+  service:
+    name: mysql
+    state: started
+- 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 }}"
-- 
cgit v1.2.3