summaryrefslogtreecommitdiffstats
path: root/roles/common-SQL/tasks
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2020-05-16 02:49:28 +0200
committerGuilhem Moulin <guilhem@fripost.org>2020-05-16 02:49:28 +0200
commitc4f24043baeccc95556fb9c3c032505ecadb5fbd (patch)
treebedc67294a64020ed90e97917cd1283f79c2c5e8 /roles/common-SQL/tasks
parent8e1f45e5e68e1cc54b258b791e84afe902ffd561 (diff)
wibble
Diffstat (limited to 'roles/common-SQL/tasks')
-rw-r--r--roles/common-SQL/tasks/main.yml2
1 files changed, 1 insertions, 1 deletions
diff --git a/roles/common-SQL/tasks/main.yml b/roles/common-SQL/tasks/main.yml
index 3df2cab..cd1d091 100644
--- a/roles/common-SQL/tasks/main.yml
+++ b/roles/common-SQL/tasks/main.yml
@@ -6,41 +6,41 @@
- mariadb-server
- python-mysqldb
# for the 'mysql_' munin plugin
- libcache-cache-perl
- name: Copy MySQL/MariaDB configuration
copy: src=etc/mysql/my.cnf
dest=/etc/mysql/my.cnf
owner=root group=root
mode=0644
register: r
notify:
- Restart MariaDB
# We need to restart now and load the relevant authplugin before we
# connect to the database.
- meta: flush_handlers
# XXX Dirty fix for #742046
- name: Force root to use UNIX permissions
- mysql_user2: name=root password= auth_plugin=unix_socket soname=auth_socket.so
+ mysql_user2: name=root password="" auth_plugin=unix_socket soname=auth_socket.so
state=present
- name: Disallow anonymous and TCP/IP root login
mysql_user2: name={{ item.name|default('') }} host={{ item.host }}
state=absent
with_items:
- { host: '{{ inventory_hostname_short }}' }
- { host: 'localhost' }
- { host: '127.0.0.1'}
- { host: '::1'}
- { name: root, host: '{{ inventory_hostname_short }}' }
- { name: root, host: '127.0.0.1'}
- { name: root, host: '::1'}
- name: Start MariaDB
service: name=mariadb state=started
- name: Install 'mysql_' Munin wildcard plugin
file: src=/usr/share/munin/plugins/mysql_