community.mysql/tests/integration/targets/test_mysql_replication/tasks/issue-689.yml

---

- vars:
    mysql_parameters: &mysql_params
      login_user: '{{ mysql_user }}'
      login_password: '{{ mysql_password }}'
      login_host: '{{ mysql_host }}'
      login_port: '{{ mysql_primary_port }}'
  block:

    - name: Disable ssl verification
      community.mysql.mysql_replication:
        <<: *mysql_params
        login_port: '{{ mysql_replica1_port }}'
        mode: changeprimary
        primary_ssl_verify_server_cert: false
      register: result

    - name: Assert that changeprimmary is changed and return expected query for MariaDB and MySQL < 8.0.23
      ansible.builtin.assert:
        that:
          - result is changed
          - result.queries == expected_queries
      when:
        - >
          db_engine == 'mariadb' or
          (db_engine == 'mysql' and db_version is version('8.0.23', '<'))
      vars:
        expected_queries: ["CHANGE MASTER TO MASTER_SSL_VERIFY_SERVER_CERT=0"]

    - name: Assert that changeprimmary is changed and return expected query for MySQL > 8.0.23
      ansible.builtin.assert:
        that:
          - result is changed
          - result.queries == expected_queries
      when:
        - db_engine == 'mysql'
        - db_version is version('8.0.23', '>=')
      vars:
        expected_queries: ["CHANGE REPLICATION SOURCE TO SOURCE_SSL_VERIFY_SERVER_CERT=0"]

    - name: Disable ssl verification for MySQL 8.0.23+
      community.mysql.mysql_replication:
        <<: *mysql_params
        login_port: '{{ mysql_replica1_port }}'
        mode: changereplication
        primary_ssl_verify_server_cert: false
      register: result
      when:
        - db_engine == 'mysql'
        - db_version is version('8.0.23', '>=')

    - name: Assert that changereplication is changed and return expected query for MySQL > 8.0.23
      ansible.builtin.assert:
        that:
          - result is changed
          - result.queries == expected_queries
      when:
        - db_engine == 'mysql'
        - db_version is version('8.0.23', '>=')
      vars:
        expected_queries: ["CHANGE REPLICATION SOURCE TO SOURCE_SSL_VERIFY_SERVER_CERT=0"]