lucasdpt
28 lines
827 B
YAML
28 lines
827 B
YAML
---
|
|
- name: Installer le client MySQL sur Debian et tester le port
|
|
hosts: debian
|
|
become: yes
|
|
tasks:
|
|
- name: Installer le client MySQL/MariaDB
|
|
ansible.builtin.apt:
|
|
name: default-mysql-client
|
|
state: present
|
|
|
|
- name: Vérifier que le port 3306 est joignable depuis Debian
|
|
ansible.builtin.wait_for:
|
|
host: "{{ mysql_host }}"
|
|
port: "{{ mysql_port }}"
|
|
timeout: 30
|
|
|
|
- name: Tester la connexion MySQL depuis Debian
|
|
ansible.builtin.command: >-
|
|
mysql -h {{ mysql_host }} -P {{ mysql_port }}
|
|
-uroot -p{{ mysql_root_password }}
|
|
-e "SELECT 'Connexion OK depuis Debian' AS test;"
|
|
register: mysql_test
|
|
changed_when: false
|
|
|
|
- name: Afficher le test de connexion
|
|
ansible.builtin.debug:
|
|
var: mysql_test.stdout_lines
|