#!/bin/sh
# Start/stop/restart mariadbd.
# Copyright 2026 ANNE Media - https://anne.media
# All rights reserved.
#
# Redistribution and use of this script, with or without modification, is
# permitted provided that the following conditions are met:
#
# 1. Redistributions of this script must retain the above copyright
#    notice, this list of conditions and the following disclaimer.
#
#  THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR IMPLIED
#  WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
#  MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO
#  EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
#  SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
#  PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
#  OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
#  WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
#  OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
#  ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
#
# Bind only to the annode veth address (10.200.2.1)
# Run as the mysql user.

# To start MariaDB automatically at boot, be sure this script is executable:
# chmod 755 /etc/rc.d/rc.mysqld

BIND_ADDRESS="10.200.2.1"
DATADIR="/var/lib/mysql"
PIDFILE="/var/run/mysql/mysql.pid"
SOCKET="/var/run/mysql/mysql.sock"

# Ensure runtime directory exists and is owned by mysql
prepare_runtime() {
  mkdir -p /var/run/mysql
  chown mysql:mysql /var/run/mysql
  chmod 755 /var/run/mysql

  mkdir -p /var/log/mysql
  chown mysql:mysql /var/log/mysql
  chmod 755 /var/log/mysql
  touch /var/log/mysql/mysqld.log
  chown mysql:mysql /var/log/mysql/mysqld.log
}

mariadbd_start() {
  if [ ! -x /usr/libexec/mariadbd ]; then
    echo "mariadbd binary not found"
    return 1
  fi

  prepare_runtime

  # Clean stale PID file if no process is running
  if [ -r "$PIDFILE" ]; then
    if ! ps axc | grep -q mariadbd; then
      echo "Cleaning up old $PIDFILE"
      rm -f "$PIDFILE"
    fi
  fi

  echo "Starting MariaDB (bind-address=$BIND_ADDRESS)..."
  su -s /bin/sh mysql -c "/usr/libexec/mariadbd \
    --datadir=$DATADIR \
    --pid-file=$PIDFILE \
    --socket=$SOCKET \
    --bind-address=$BIND_ADDRESS \
    --port=3306 \
    >/var/log/mysql/mysqld.log 2>&1 &"

  # Brief wait so the PID file appears
  sleep 1
}

mariadbd_stop() {
  if [ -r "$PIDFILE" ]; then
    PID=$(cat "$PIDFILE")
    echo "Stopping MariaDB (PID $PID)..."
    kill "$PID" 2>/dev/null || true

    # Wait up to 60 seconds
    for i in $(seq 1 60); do
      if [ ! -r "$PIDFILE" ]; then
        break
      fi
      sleep 1
    done

    if [ -r "$PIDFILE" ]; then
      echo "WARNING: MariaDB did not exit cleanly, sending KILL"
      kill -9 "$PID" 2>/dev/null || true
      rm -f "$PIDFILE"
    fi
  else
    echo "MariaDB is not running (no PID file)"
  fi
}

mariadbd_restart() {
  mariadbd_stop
  sleep 1
  mariadbd_start
}

case "$1" in
  start)
    mariadbd_start
    ;;
  stop)
    mariadbd_stop
    ;;
  restart)
    mariadbd_restart
    ;;
  *)
    echo "usage: $0 start|stop|restart"
    exit 1
    ;;
esac
