Test user auth plugin on mariadb

[rsicart]

SUMMARY

Integration tests in test_user_plugin_auth.yml are only played for mysql. We shoud do the same tests for mariadb.

Search FIXME: mariadb sql syntax for create/update user is not compatible in the repo for more details.

This Issue is related to https://github.com/ansible-collections/community.mysql/pull/246

ISSUE TYPE

• Bug Report

COMPONENT NAME

mariadb integration tests

ANSIBLE VERSION

ansible 2.10.15
  config file = None
  configured module search path = ['/home/rsicart/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /home/rsicart/virtualenvs/ansible/venv_2_10_7/lib/python3.7/site-packages/ansible
  executable location = /home/rsicart/virtualenvs/ansible/venv_2_10_7/bin/ansible
  python version = 3.7.3 (default, Jan 22 2021, 20:04:44) [GCC 8.3.0]

COLLECTION VERSION

(venv_2_10_7) rsi-oxalide k8s:rsi-sandbox  :: ~ » ansible-galaxy collection list community.mysql  

# /home/rsicart/virtualenvs/ansible/venv_2_10_7/lib/python3.7/site-packages/ansible_collections
Collection      Version
--------------- -------
community.mysql 3.0.0

CONFIGURATION

(venv_2_10_7) rsi-oxalide k8s:rsi-sandbox  :: ~ » ansible-config dump --only-changed
(venv_2_10_7) rsi-oxalide k8s:rsi-sandbox  :: ~ »

OS / ENVIRONMENT

Debian Buster

STEPS TO REPRODUCE

ansible-test integration test_mysql_user --docker quay.io/ansible/default-test-container:4.1.1 -v

EXPECTED RESULTS

Tests in test_user_plugin_auth.yml file are not executed on mariadb.

ACTUAL RESULTS

Tests in test_user_plugin_auth.yml file are should be executed on mariadb.

N/A

[Andersson007]

@rsicart thank you for creating all of the related issues!