docker-entrypoint.sh

#!/bin/bash

#Environment variables
SHIN_BIN_DIR=/opt/shinobi
MYSQL_HOST="${MYSQL_HOST:-127.0.0.1}"
MYSQL_DATABASE="${MYSQL_DATABASE:-shinobi}"
MYSQL_ROOT_USER="${MYSQL_ROOT_USER:-root}"
MYSQL_ROOT_PASSWORD="${MYSQL_ROOT_PASSWORD:-rootpass}"
MYSQL_USER="${MYSQL_USER:-ccio}"
MYSQL_PASSWORD="${MYSQL_PASSWORD:-shinobi}"
TIMEZONE="${TIMEZONE:-UTC}"

#Port check function
check_port() {
    timeout 3 bash -c "</dev/tcp/$1/$2" 2>/dev/null
}

#Mysql login function
_mysql() {
    mysql -u "${MYSQL_ROOT_USER}" -p"${MYSQL_ROOT_PASSWORD}" -h "${MYSQL_HOST}" "$@"
}

cd "$SHIN_BIN_DIR" || exit 9

#Initialize db if running locally and it currently doesn't exist
if [ "$MYSQL_HOST" == "127.0.0.1" ] && [ ! -f /var/lib/mysql/ibdata1 ]; then
	echo -n "Local database doesn't exist, initializing..."
	echo -n "Please wait, this may take a while"
    mysqld --initialize
	touch /opt/shinobi/mysql-init.txt
	echo "ALTER USER 'root'@'localhost' IDENTIFIED BY '"$MYSQL_ROOT_PASSWORD"';" >> /opt/shinobi/mysql-init.txt
	/usr/bin/mysqld_safe --init-file=/opt/shinobi/mysql-init.txt > /dev/null 2>&1 &
	sleep 10s
	echo "GRANT ALL ON *.* TO root@'%' IDENTIFIED BY '"$MYSQL_ROOT_PASSWORD"' WITH GRANT OPTION; FLUSH PRIVILEGES" | mysql -u root -p"$MYSQL_ROOT_PASSWORD" -h 127.0.0.1
	killall mysqld
	sleep 5s
fi

#Start mysql-server if running locally
if [ "$MYSQL_HOST" == "127.0.0.1" ]; then
	echo -n "Starting mysql server..."
	touch /opt/shinobi/mysql-init.txt
	echo "ALTER USER 'root'@'localhost' IDENTIFIED BY '"$MYSQL_ROOT_PASSWORD"';" >> /opt/shinobi/mysql-init.txt
	/usr/bin/mysqld_safe --init-file=/opt/shinobi/mysql-init.txt > /dev/null 2>&1 &
fi

#Set timezone
echo "${TIMEZONE}" > /etc/timezone
rm /etc/localtime
dpkg-reconfigure -f noninteractive tzdata

#Check that mysql server is reachable
echo -n "Waiting for MYSQL server port..."
while ! check_port "$MYSQL_HOST" 3306
do
    :
done
echo 'Done!'

#Check for shinobi database data and if not present then install
tables_check="select count(*) from information_schema.tables where table_schema='${MYSQL_DATABASE}' and table_name='API';"
tables_num=$(mysql -N -s -u "${MYSQL_ROOT_USER}" -p"${MYSQL_ROOT_PASSWORD}" -h "${MYSQL_HOST}" -e "${tables_check}")

if [[ "${tables_num}" -eq "0" ]]
then
    # install stuff if not installed
    _mysql -e "CREATE DATABASE IF NOT EXISTS \`$MYSQL_DATABASE\` ;"
    _mysql -e "CREATE USER '$MYSQL_USER'@'%' IDENTIFIED BY '$MYSQL_PASSWORD';"
    _mysql -e "GRANT ALL ON $MYSQL_DATABASE.* TO '$MYSQL_USER'@'%';"
    _mysql -e "FLUSH PRIVILEGES;"
    _mysql --database "$MYSQL_DATABASE" < "${SHIN_BIN_DIR}/sql/tables.sql"
    _mysql --database "$MYSQL_DATABASE" < "${SHIN_BIN_DIR}/sql/default_data.sql"
    npm cache clean -f && npm install -g n && n stable
fi

#set config data from variables
    sed -i 's/"user": "majesticflame"/"user": "'"${MYSQL_USER}"'"/g' "$SHIN_BIN_DIR/conf.json"
    sed -i 's/"password": ""/"password": "'"${MYSQL_PASSWORD}"'"/g' "$SHIN_BIN_DIR/conf.json"
    sed -i 's/"host": "127.0.0.1"/"host": "'"${MYSQL_HOST}"'"/g' "$SHIN_BIN_DIR/conf.json"
    sed -i 's/"database": "ccio"/"database": "'"${MYSQL_DATABASE}"'"/g' "$SHIN_BIN_DIR/conf.json"

#start shinobi daemon
pm2 start "${SHIN_BIN_DIR}/cron.js"
pm2 start "${SHIN_BIN_DIR}/camera.js"
pm2 start "${SHIN_BIN_DIR}/plugins/motion/shinobi-motion.js"
pm2 logs