diff options
| author | Sacha Chua <sacha@sachachua.com> | 2022-10-16 18:11:09 -0400 |
|---|---|---|
| committer | Sacha Chua <sacha@sachachua.com> | 2022-10-16 18:11:09 -0400 |
| commit | 12c465a8f6e127a599b0477094552fc90c7e2ce0 (patch) | |
| tree | 81abef4c2a2d0230ca403eed1133815f2e37a740 /roles/pad/tasks/mariadb.yml | |
| parent | 84ccb907a14bd8bd06afec7b5ac836fa7a0883f6 (diff) | |
| parent | 54af5163644ef58a641e86288c7af8653970a319 (diff) | |
| download | emacsconf-ansible-12c465a8f6e127a599b0477094552fc90c7e2ce0.tar.xz emacsconf-ansible-12c465a8f6e127a599b0477094552fc90c7e2ce0.zip | |
Merge branch 'main' of git.emacsconf.org:pub/emacsconf-ansible into main
Diffstat (limited to 'roles/pad/tasks/mariadb.yml')
| -rw-r--r-- | roles/pad/tasks/mariadb.yml | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/roles/pad/tasks/mariadb.yml b/roles/pad/tasks/mariadb.yml new file mode 100644 index 0000000..ec81430 --- /dev/null +++ b/roles/pad/tasks/mariadb.yml @@ -0,0 +1,42 @@ +--- +- 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 }}" |