majic-ansible-roles Changeset

Changeset - acd104ed9b5e

Parent rev.

Child rev.

[Not reviewed]

0 4 0

Branko Majic (branko) - 3 years ago 2021-01-17 14:03:16
branko@majic.rs

MAR-151: Switch to using PyMySQL module for database and database_server role:

- Explicitly specify the path to MariaDB unix socket to enforce unix
socket authentication.

4 files changed with 8 insertions and 3 deletions:

roles/database/tasks/main.yml

roles/database_server/molecule/default/prepare.yml

roles/database_server/molecule/default/tests/test_default.py

roles/database_server/tasks/main.yml

0 comments (0 inline, 0 general)

roles/database/tasks/main.yml

➞

Show inline comments

@@ @@ -4,6 +4,7 @@ @@
   mysql_db:
     name: "{{ db_name }}"
     state: present
     login_unix_socket: "/var/run/mysqld/mysqld.sock"
 - name: "Create database user {{ db_name }}"
   mysql_user:
@@ @@ -11,6 +12,7 @@ @@
     password: "{{ db_password }}"
     priv: "{{ db_name }}.*:ALL"
     state: present
     login_unix_socket: "/var/run/mysqld/mysqld.sock"
 - name: Enable backup
   include: backup.yml

roles/database_server/molecule/default/prepare.yml

➞

Show inline comments

@@ @@ -27,7 +27,7 @@ @@
         name:
           - mariadb-client
           - mariadb-server
-          - python3-mysqldb
+          - python3-pymysql
         state: present
     - name: Enable and start MariaDB
@@ @@ -50,6 +50,7 @@ @@
         name: root
         host: "{{ item }}"
         password: "root_password"
         login_unix_socket: "/var/run/mysqld/mysqld.sock"
       with_items:
         - "localhost"
         - "127.0.0.1"
@@ @@ -63,6 +64,7 @@ @@
       mysql_user:
         name: debian-sys-maint
         password: debian-sys-maint-password
         login_unix_socket: "/var/run/mysqld/mysqld.sock"
     - name: Deploy Debian system maintenance user login configuration
       copy:

roles/database_server/molecule/default/tests/test_default.py

➞

Show inline comments

@@ @@ -19,7 +19,7 @@ def test_installed_packages(host): @@
     assert host.package('mariadb-client').is_installed
     assert host.package('mariadb-server').is_installed
-    assert host.package('python3-mysqldb').is_installed
+    assert host.package('python3-pymysql').is_installed
 def test_service(host):

roles/database_server/tasks/main.yml

➞

Show inline comments

@@ @@ -5,7 +5,7 @@ @@
     name:
       - mariadb-client
       - mariadb-server
-      - python3-mysqldb
+      - python3-pymysql
     state: present
 - name: Enable and start MariaDB
@@ @@ -68,6 +68,7 @@ @@
   mysql_user:
     name: "debian-sys-maint"
     state: absent
     login_unix_socket: "/var/run/mysqld/mysqld.sock"
 - name: Set UTF-8 encoding as default for MariaDB
   copy:

0 comments (0 inline, 0 general)