GROWIの起動・終了を実行するとともに、その際に稼働状況をリモートのMariaDBに作成したテーブルに書き込むためのshell script

startgrowi.sh

#!/bin/bash
#
# See https://pandanote.info/?p=7259 for details.
#

MODE="start"
SERVER="192.168.11.11"
if [ -n "$1" ]; then
    MODE="stop"
fi

if [ ${MODE} != "stop" ]; then
    mysql -h ${SERVER} -u serverstatus -p'Some password to store the status of the remote server.' -e "insert into serverstatus(status) value(1)" serverstatus
    cd /opt/wiki/growi
    npm run server:prod
else
    mysql -h ${SERVER} -u serverstatus -p'Some password to store the status of the remote server.' -e "insert into serverstatus(status) value(0)" serverstatus
    pkill --signal SIGINT node
fi