#!/usr/bin/env bash # ============================================================================== # ClassNotify Off-site Database Backup Script (rclone / Object Storage) # Reads configuration strictly from /etc/classnotify/backup.env (chmod 600) # ============================================================================== set -euo pipefail BACKUP_ENV="/etc/classnotify/backup.env" LOCAL_BACKUP_DIR="/var/backups/classnotify/daily" echo "==========================================================" echo " ClassNotify Off-site Database Backup Runner " echo "==========================================================" if [ ! -f "${BACKUP_ENV}" ]; then echo "WARNING: ${BACKUP_ENV} does not exist. Creating secure template..." cat << 'EOF' > "${BACKUP_ENV}" # ClassNotify Off-site Backup Configuration # Permissions must be strictly 600 root:root CLASSNOTIFY_OFFSITE_REMOTE= CLASSNOTIFY_OFFSITE_PATH= EOF chmod 600 "${BACKUP_ENV}" chown root:root "${BACKUP_ENV}" fi # Read configurations source "${BACKUP_ENV}" # Find newest local backup LATEST_BACKUP=$(ls -t "${LOCAL_BACKUP_DIR}"/classnotify_*.sql.gz 2>/dev/null | head -n 1 || true) if [ -z "${LATEST_BACKUP}" ] || [ ! -f "${LATEST_BACKUP}" ]; then echo "ERROR: No local backup files found in ${LOCAL_BACKUP_DIR}!" >&2 exit 1 fi LOCAL_SIZE=$(stat -c%s "${LATEST_BACKUP}") LOCAL_SHA256=$(sha256sum "${LATEST_BACKUP}" | awk '{print $1}') echo "Latest Local Backup: $(basename "${LATEST_BACKUP}") (${LOCAL_SIZE} bytes)" echo "Local SHA256: ${LOCAL_SHA256}" # Check for offsite configuration REMOTE="${CLASSNOTIFY_OFFSITE_REMOTE:-}" DEST_PATH="${CLASSNOTIFY_OFFSITE_PATH:-}" if [ -z "${REMOTE}" ] || [ -z "${DEST_PATH}" ]; then echo "" echo "==========================================================" echo "OFFSITE BACKUP STATUS:" echo "BLOCKED - external storage credentials required" echo "Details: CLASSNOTIFY_OFFSITE_REMOTE or CLASSNOTIFY_OFFSITE_PATH not configured in ${BACKUP_ENV}" echo "==========================================================" exit 0 fi if ! command -v rclone &> /dev/null; then echo "" echo "==========================================================" echo "OFFSITE BACKUP STATUS:" echo "BLOCKED - external storage credentials required" echo "Details: rclone is not installed on this host" echo "==========================================================" exit 0 fi echo "Syncing $(basename "${LATEST_BACKUP}") to remote ${REMOTE}:${DEST_PATH}..." rclone copy "${LATEST_BACKUP}" "${REMOTE}:${DEST_PATH}" # Verification REMOTE_FILE="${DEST_PATH}/$(basename "${LATEST_BACKUP}")" echo "Verifying remote object existence: ${REMOTE}:${REMOTE_FILE}..." rclone lsf "${REMOTE}:${REMOTE_FILE}" echo "Downloading test copy from remote for restoration drill..." RESTORE_TEST_DIR="/tmp/classnotify_offsite_verify" mkdir -p "${RESTORE_TEST_DIR}" rclone copy "${REMOTE}:${REMOTE_FILE}" "${RESTORE_TEST_DIR}" DOWNLOADED_BACKUP="${RESTORE_TEST_DIR}/$(basename "${LATEST_BACKUP}")" DOWN_SHA256=$(sha256sum "${DOWNLOADED_BACKUP}" | awk '{print $1}') if [ "${LOCAL_SHA256}" != "${DOWN_SHA256}" ]; then echo "ERROR: Checksum mismatch! Local: ${LOCAL_SHA256}, Downloaded: ${DOWN_SHA256}" >&2 rm -rf "${RESTORE_TEST_DIR}" exit 1 fi echo "Checksum verification passed: ${DOWN_SHA256}" # Restoration test against temporary DB classnotify_restore_test echo "Performing restoration drill into classnotify_restore_test..." sudo -u postgres dropdb --if-exists classnotify_restore_test sudo -u postgres createdb classnotify_restore_test gunzip -c "${DOWNLOADED_BACKUP}" | sudo -u postgres psql -d classnotify_restore_test -q TABLE_COUNT=$(sudo -u postgres psql -d classnotify_restore_test -t -c "SELECT count(*) FROM information_schema.tables WHERE table_schema = 'public';") echo "Restored table count: ${TABLE_COUNT}" sudo -u postgres dropdb classnotify_restore_test rm -rf "${RESTORE_TEST_DIR}" echo "==========================================================" echo "OFFSITE BACKUP STATUS:" echo "SUCCESS - verified and restore-tested" echo "==========================================================" exit 0