From 3da6360c92ae865358398ae53220086bc8d54c7c Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 10 Jul 2018 08:20:10 +0200
Subject: replicate-db, update-kernel-config: now in devops

---
 replicate-db         | 100 ---------------------------------------------------
 update-kernel-config |  72 -------------------------------------
 2 files changed, 172 deletions(-)
 delete mode 100755 replicate-db
 delete mode 100755 update-kernel-config

diff --git a/replicate-db b/replicate-db
deleted file mode 100755
index 91706cb..0000000
--- a/replicate-db
+++ /dev/null
@@ -1,100 +0,0 @@
-#!/bin/bash
-
-set -e
-
-if [ -d '/var/lib/mysql' ]; then
-  read -p 'mariadb seems to be installed already - I will remove it first.' -r s
-  if [ -n "${s}" ]; then
-    echo 'Aborted.'
-    exit
-  fi
-  sudo systemctl stop mysqld || true
-  sudo systemctl disable mysqld || true
-  sudo pacman -Rs mariadb || true
-  sudo rm -rf --one-file-system '/var/lib/mysql' '/etc/mysql'
-fi
-
-if [ -d '/etc/stunnel' ]; then
-  read -p 'stunnel seems to be installed already - I will remove it first.' -r s
-  if [ -n "${s}" ]; then
-    echo 'Aborted.'
-    exit
-  fi
-  sudo systemctl stop stunnel || true
-  sudo systemctl disable stunnel || true
-  sudo pacman -Rs stunnel || true
-  sudo rm -rf --one-file-system '/etc/stunnel'
-fi
-
-read -p 'enter new root-pw: ' -s -r root_pw
-printf '\n'
-read -p 'enter replikat-pw: '  -s -r replikat_pw
-printf '\n'
-
-sudo pacman -S --noconfirm mariadb stunnel
-
-# set up mariadb
-sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
-sudo sed -i '
-  /myisam_sort_buffer_size/ a group_concat_max_len = 4096
-  /^#server-id/ {
-    s/^#//
-    s/[0-9]\+$/'"$RANDOM"'/
-    b
-  }
-  s/^server-id/#\0/
-  /^#skip-networking$/ s/^#//
-' '/etc/mysql/my.cnf'
-
-sudo systemctl start mysqld
-sudo systemctl enable mysqld
-
-printf '\n\n%s\n%s\n\n\n\n\n' "${root_pw}" "${root_pw}" | \
-  sudo mysql_secure_installation
-
-# set up stunnel
-
-sudo tee /etc/stunnel/stunnel.conf > /dev/null <<EOF
-[buildmaster-mysql]
-client = yes
-accept = 127.0.0.1:33061
-connect = buildmaster.archlinux32.org:3307
-verifyChain = yes
-CApath = /etc/ssl/certs
-checkHost = buildmaster.archlinux32.org
-EOF
-
-sudo systemctl start stunnel
-sudo systemctl enable stunnel
-
-tmp_file=$(mktemp)
-trap 'rm "${tmp_file}"' EXIT
-
-ssh buildmaster '
-  cd /var/backup;
-  ls -t | grep -m1 '"'"'^database-.*\.xz$'"'"' | xargs pv
-' > "${tmp_file}"
-
-{
-  printf 'SHOW SLAVE STATUS;\n'
-  printf "CREATE USER 'webserver'@'localhost' IDENTIFIED BY 'empty';\n" \
-  printf "GRANT USAGE ON *.* TO 'webserver'@'localhost' IDENTIFIED BY 'empty';\n"
-  printf "GRANT REPLICATION CLIENT ON *.* TO 'webserver'@'localhost';\n"
-  printf 'GRANT %s ON buildmaster.* TO '"'"'webserver'"'"'@'"'"'localhost'"'"';\n' \
-    'CREATE TEMPORARY TABLES'  \
-    'SELECT' \
-    'SHOW VIEW'
-  printf "CHANGE MASTER TO MASTER_HOST='%s', MASTER_PORT=%s, MASTER_USER='%s', MASTER_PASSWORD='%s';\n" \
-    '127.0.0.1' \
-    33061 \
-    'replikat' \
-    "${replikat_pw}"
-  xzcat "${tmp_file}" | pv
-  xzgrep -- '^-- CHANGE MASTER TO ' "${tmp_file}" | \
-    sed 's/^-- //'
-  printf 'START SLAVE;\n'
-  printf 'SHOW SLAVE STATUS;\n'
-} | \
-  mysql -u root -p"${root_pw}"
-
-printf '\n\nAll set up successfully.\n'
diff --git a/update-kernel-config b/update-kernel-config
deleted file mode 100755
index 37e414c..0000000
--- a/update-kernel-config
+++ /dev/null
@@ -1,72 +0,0 @@
-#!/bin/bash
-
-if [ $# -ne 2 ]; then
-  >&2 echo 'usage: update-kernel-config [repository] [kernel-name]'
-  exit 2
-fi
-
-old_revision=$(
-  sed -n '
-    s/^# upstream git\( revision\)\?: *//
-    T
-    p
-  ' "/usr/src/archlinux32/packages/$1/$2/PKGBUILD"
-)
-
-if [ -z "${old_revision}" ]; then
-  >&2 echo 'Cannot detemine old upstream git revision.'
-  >&2 echo '"# upstream git revision: ..." line is missing.'
-  exit 1
-fi
-
-diff=$(
-  git -C "/usr/src/archlinux/packages/$2/repos/$1-x86_64" diff "${old_revision}" HEAD -- config | \
-    grep '^[+-].' | \
-    grep -v '^+++\|^---'
-)
-
-if [ -z "${diff}" ]; then
-  >&2 echo 'nothing changed.'
-  exit 1
-fi
-
-{
-  grep -vxF "$(
-    printf '%s\n' "${diff}" | \
-      sed -n '
-        s/^-//
-        T
-        p
-      '
-  )" "/usr/src/archlinux32/packages/$1/$2/config"
-  printf '%s\n' "${diff}" | \
-    sed -n '
-      s/^+//
-      T
-      p
-    '
-} | \
-  sponge "/usr/src/archlinux32/packages/$1/$2/config"
-
-sed -i '
-  1 s/^#.*$/# upstream git revision: '"$(
-    git -C "/usr/src/archlinux/packages" rev-parse HEAD
-  )"'/
-  s/'"$(
-    git -C "/usr/src/archlinux/packages/$2/repos/$1-x86_64" archive "${old_revision}" -- config | \
-      tar -Ox | \
-      sha256sum | \
-      awk '{print $1}'
-  )"'/'"$(
-    git -C "/usr/src/archlinux/packages/$2/repos/$1-x86_64" archive HEAD -- config | \
-      tar -Ox | \
-      sha256sum | \
-      awk '{print $1}'
-  )"'/g
-  s/'"$(
-    git -C "/usr/src/archlinux32/packages/$1/$2" archive HEAD -- config | \
-      tar -Ox | \
-      sha256sum | \
-      awk '{print $1}'
-  )"'/SKIP/g
-' "/usr/src/archlinux32/packages/$1/$2/PKGBUILD"
-- 
cgit v1.2.3-70-g09d2