summaryrefslogtreecommitdiff
path: root/test/integration/targets/setup_mysql_db/tasks/main.yml
blob: 990cdb6e63d1c0c2fb03b356a1bc78baf0682722 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
# setup code for the mysql_db module
# (c) 2014,  Wayne Rosario <wrosario@ansible.com>

# This file is part of Ansible
#
# Ansible is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# Ansible is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with Ansible.  If not, see <http://www.gnu.org/licenses/>.

# ============================================================
- name: python 2
  set_fact:
    python_suffix: ""
  when: ansible_python_version is version('3', '<')

- name: python 3
  set_fact:
    python_suffix: "-py3"
  when: ansible_python_version is version('3', '>=')

- name: Include distribution specific variables
  include_vars: "{{ lookup('first_found', params) }}"
  vars:
    params:
      files:
        - '{{ ansible_facts.distribution }}-{{ ansible_facts.distribution_major_version }}{{ python_suffix }}.yml'
        - '{{ ansible_facts.distribution }}-{{ ansible_facts.distribution_major_version }}.yml'
        - '{{ ansible_facts.os_family }}-{{ ansible_facts.distribution_major_version }}{{ python_suffix }}.yml'
        - '{{ ansible_facts.os_family }}-{{ ansible_facts.distribution_major_version }}.yml'
        - '{{ ansible_facts.distribution }}{{ python_suffix }}.yml'
        - '{{ ansible_facts.os_family }}{{ python_suffix }}.yml'
        - 'default{{ python_suffix }}.yml'
      paths: "{{ role_path }}/vars"

- name: install mysqldb_test rpm dependencies
  yum:
    name: "{{ mysql_packages }}"
    state: latest
  when: ansible_pkg_mgr == 'yum'
  notify: cleanup mysql

- name: install mysqldb_test rpm dependencies
  dnf:
    name: '{{ mysql_packages }}'
    state: latest
    install_weak_deps: False  # mariadb-server has a weak dep on python2 which break Python 3 test environments
  when: ansible_pkg_mgr == 'dnf'
  notify: cleanup mysql

- name: install mysqldb_test debian dependencies
  apt:
    name: "{{ mysql_packages }}"
    state: latest
  when: ansible_pkg_mgr == 'apt'
  notify: cleanup mysql

- name: install mysqldb_test FreeBSD dependencies
  package:
    name: "{{ mysql_packages }}"
    state: present
  when: ansible_os_family == "FreeBSD"
  notify: cleanup mysql

- name: install mysql-python package via pip (FreeBSD)
  pip:
    name: mysql-python
    state: present
  when: ansible_os_family == "FreeBSD"
  notify:
    - cleanup mysql
    - remove pip packages

- name: enable mysql-server service (FreeBSD)
  lineinfile:
    path: /etc/rc.conf
    line: 'mysql_server_enable="YES"'
  when: ansible_os_family == "FreeBSD"

- name: apply work-around for OverlayFS issue
  # https://github.com/docker/for-linux/issues/72#issuecomment-319904698
  command: find {{ mysql_data_dirs[0] }} -type f -exec touch {} ;
  # find will fail if mysql has never been started, as the directory won't exist
  ignore_errors: yes

- name: restart mysql_db service
  service:
    name: "{{ mysql_service }}"
    state: restarted

- name: Detect socket path
  shell: 'echo "show variables like ''socket''\G" | mysql | grep ''Value: '' | sed ''s/[ ]\+Value: //'''
  register: _socket_path

- name: Set socket path
  set_fact:
    mysql_socket: '{{ _socket_path["stdout"] }}'