summaryrefslogtreecommitdiff
path: root/baserock_database/image-config.yml
diff options
context:
space:
mode:
Diffstat (limited to 'baserock_database/image-config.yml')
-rw-r--r--baserock_database/image-config.yml46
1 files changed, 46 insertions, 0 deletions
diff --git a/baserock_database/image-config.yml b/baserock_database/image-config.yml
new file mode 100644
index 00000000..7b89e700
--- /dev/null
+++ b/baserock_database/image-config.yml
@@ -0,0 +1,46 @@
+# System configuration for Baserock database server.
+#
+# This Ansible playbook expects to be run on a Fedora 23 Cloud image.
+---
+- hosts: database-mariadb
+ gather_facts: False
+ sudo: True
+ tasks:
+ # See: https://fedoramagazine.org/getting-ansible-working-fedora-23/
+ - name: install Python2 and required deps for Ansible modules
+ raw: dnf install -y python2 python2-dnf libselinux-python
+
+ - name: ensure system up to date
+ dnf: name=* state=latest
+
+ - name: enable persistant journal
+ shell: mkdir /var/log/journal
+ args:
+ creates: /var/log/journal
+
+ - name: install lvm2 tools
+ dnf: name=lvm2 state=latest
+
+ - name: install MariaDB
+ dnf: name={{ item }} state=latest
+ with_items:
+ - mariadb
+ - mariadb-server
+ - MySQL-python
+
+ # By default this is set to /var/lib/mysql, but this causes a hidden
+ # directory to be created in /var/lib/mysql (.local/share/systemd) which
+ # breaks MariaDB because it expects each directory in there to represent a
+ # database, and you see this when upgrading:
+ #
+ # Phase 2/6: Fixing views
+ # mysqlcheck: Got error: 1102: Incorrect database name '#mysql50#.local' when selecting the database
+ #
+ - name: fix home directory of MySQL user
+ user: name=mysql home=/
+
+ - name: disable SELinux on subsequent boots
+ selinux: state=disabled
+
+ - name: disable SELinux on current boot
+ command: setenforce 0