Initial commit of MariaDB role
Change-Id: I8d35374da716712ecf0ab1f748c952cbc2635969
diff --git a/molecule/default/converge.yml b/molecule/default/converge.yml
new file mode 100644
index 0000000..f73f499
--- /dev/null
+++ b/molecule/default/converge.yml
@@ -0,0 +1,19 @@
+---
+# mariadb molecule/default/verify.yml
+#
+# SPDX-FileCopyrightText: © 2020 Open Networking Foundation <support@opennetworking.org>
+# SPDX-License-Identifier: Apache-2.0
+
+- name: Converge
+ hosts: all
+ vars:
+ mariadb_users:
+ - name: "exampleuser"
+ password: "examplepass"
+ priv: "exampledb.*:ALL"
+ mariadb_databases:
+ - name: "exampledb"
+ tasks:
+ - name: "Include mariadb"
+ include_role:
+ name: "mariadb"
diff --git a/molecule/default/molecule.yml b/molecule/default/molecule.yml
new file mode 100644
index 0000000..b063272
--- /dev/null
+++ b/molecule/default/molecule.yml
@@ -0,0 +1,34 @@
+---
+# mariadb molecule/default/molecule.yml
+#
+# SPDX-FileCopyrightText: © 2020 Open Networking Foundation <support@opennetworking.org>
+# SPDX-License-Identifier: Apache-2.0
+
+dependency:
+ name: galaxy
+driver:
+ name: docker
+platforms:
+ - name: "ubuntu-18.04-priv"
+ image: "quay.io/paulfantom/molecule-systemd:ubuntu-18.04"
+ privileged: true
+ volumes:
+ - "/sys/fs/cgroup:/sys/fs/cgroup:ro"
+ - name: "debian-10-priv"
+ image: "quay.io/paulfantom/molecule-systemd:debian-10"
+ privileged: true
+ volumes:
+ - "/sys/fs/cgroup:/sys/fs/cgroup:ro"
+provisioner:
+ name: ansible
+ playbooks:
+ prepare: prepare.yml
+ inventory:
+ host_vars:
+ debian-10-priv:
+ ansible_python_interpreter: /usr/bin/python3
+ env:
+ ANSIBLE_COLLECTIONS_PATHS: >-
+ ~/Documents/onf/infra/ansible:~/.ansible/collections:/usr/share/ansible/collections
+verifier:
+ name: ansible
diff --git a/molecule/default/prepare.yml b/molecule/default/prepare.yml
new file mode 100644
index 0000000..fb8f1ed
--- /dev/null
+++ b/molecule/default/prepare.yml
@@ -0,0 +1,15 @@
+---
+# mariadb molecule/default/prepare.yml
+#
+# SPDX-FileCopyrightText: © 2020 Open Networking Foundation <support@opennetworking.org>
+# SPDX-License-Identifier: Apache-2.0
+
+- name: Prepare
+ hosts: all
+
+ pre_tasks:
+ - name: Install GPG to support adding apt repo keys
+ apt:
+ name: "gpg"
+ state: "present"
+ update_cache: true
diff --git a/molecule/default/verify.yml b/molecule/default/verify.yml
new file mode 100644
index 0000000..95b17a1
--- /dev/null
+++ b/molecule/default/verify.yml
@@ -0,0 +1,32 @@
+---
+# mariadb molecule/default/verify.yml
+#
+# SPDX-FileCopyrightText: © 2020 Open Networking Foundation <support@opennetworking.org>
+# SPDX-License-Identifier: Apache-2.0
+
+- name: Verify
+ hosts: all
+ tasks:
+
+ - name: Collect MariaDB information
+ mysql_info:
+ login_user: root
+ login_unix_socket: /var/run/mysqld/mysqld.sock
+ register: mariadb_info
+
+ - name: Print MariaDB info
+ debug:
+ var: mariadb_info
+
+ - name: Verify MariaDB version
+ assert:
+ that:
+ - mariadb_info['version']['major'] == 10
+ - mariadb_info['version']['minor'] == 5
+
+ - name: Check that user can connect to database
+ community.mysql.mysql_query:
+ login_db: "exampledb"
+ query: "show tables;"
+ login_user: "exampleuser"
+ login_password: "examplepass"