diff options
author | Guilhem Moulin <guilhem@fripost.org> | 2020-05-16 02:49:28 +0200 |
---|---|---|
committer | Guilhem Moulin <guilhem@fripost.org> | 2020-05-16 02:49:28 +0200 |
commit | c4f24043baeccc95556fb9c3c032505ecadb5fbd (patch) | |
tree | bedc67294a64020ed90e97917cd1283f79c2c5e8 /roles | |
parent | 8e1f45e5e68e1cc54b258b791e84afe902ffd561 (diff) |
wibble
Diffstat (limited to 'roles')
-rw-r--r-- | roles/common-SQL/tasks/main.yml | 2 |
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_ |