summaryrefslogtreecommitdiffstats
path: root/pad/tasks/mariadb.yml
diff options
context:
space:
mode:
authorSacha Chua <sacha@sachachua.com>2022-10-11 12:19:46 -0400
committerSacha Chua <sacha@sachachua.com>2022-10-11 12:19:59 -0400
commit6d1743c83e239806b1b6fb635e184a59a5f28f5a (patch)
tree8e82342f150f4ec623b0ebd8291db1d88178d42c /pad/tasks/mariadb.yml
parent1151e1fac5e7805e0cfeea89acc3b2efedb89940 (diff)
downloademacsconf-ansible-6d1743c83e239806b1b6fb635e184a59a5f28f5a.tar.xz
emacsconf-ansible-6d1743c83e239806b1b6fb635e184a59a5f28f5a.zip
Etherpad starting setup
Diffstat (limited to 'pad/tasks/mariadb.yml')
-rw-r--r--pad/tasks/mariadb.yml22
1 files changed, 22 insertions, 0 deletions
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 }}"