summaryrefslogtreecommitdiffstats
path: root/pad/tasks/mariadb.yml
diff options
context:
space:
mode:
authorSacha Chua <sacha@sachachua.com>2022-10-16 18:11:09 -0400
committerSacha Chua <sacha@sachachua.com>2022-10-16 18:11:09 -0400
commit12c465a8f6e127a599b0477094552fc90c7e2ce0 (patch)
tree81abef4c2a2d0230ca403eed1133815f2e37a740 /pad/tasks/mariadb.yml
parent84ccb907a14bd8bd06afec7b5ac836fa7a0883f6 (diff)
parent54af5163644ef58a641e86288c7af8653970a319 (diff)
downloademacsconf-ansible-12c465a8f6e127a599b0477094552fc90c7e2ce0.tar.xz
emacsconf-ansible-12c465a8f6e127a599b0477094552fc90c7e2ce0.zip
Merge branch 'main' of git.emacsconf.org:pub/emacsconf-ansible into main
Diffstat (limited to 'pad/tasks/mariadb.yml')
-rw-r--r--pad/tasks/mariadb.yml42
1 files changed, 0 insertions, 42 deletions
diff --git a/pad/tasks/mariadb.yml b/pad/tasks/mariadb.yml
deleted file mode 100644
index ec81430..0000000
--- a/pad/tasks/mariadb.yml
+++ /dev/null
@@ -1,42 +0,0 @@
----
-- name: Install MySQL packages
- apt:
- name:
- - mariadb-server
- - mariadb-client
- - python3-mysqldb
-- name: Ensure mysql is configured to bind only to localhost
- ini_file:
- dest: /etc/mysql/my.cnf
- section: mysqld
- option: "bind-address"
- value: "127.0.0.1"
-- name: Start MariaDB
- service:
- name: mysql
- state: restarted
- enabled: yes
- runlevel:
- - 3
- - 5
-- name: Ensure anonymous users are not in the database
- mysql_user:
- name: ""
- host: "{{ item }}"
- state: absent
- with_items:
- - localhost
- - 127.0.0.1
- - ::1
- - "%"
-- 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 }}"