entrypoint.sh

#!/bin/bash
export MYSQL_PWD="$MYSQL_PASSWORD"

# Version of the dockerfile
FRND_CONTAINER_VERSION="1"

# Check for old file structure
if [[ ! "$FRND_CONTAINER_VERSION" == "$FRND_DOCKER_VERSION" ]]; then
    echo "[ERROR] Old docker-compose.yml version found! Please update the docker-compose file from this url:"
    echo "https://github.com/Aperture-Development/friendup-docker"
    exit 1
fi

# Check if MYSQL_HOST enviroment variable is empty, if yes set it to default value
if [ -z "$MYSQL_HOST" ]; then
    MYSQL_HOST="friendup-db"
fi

# Check if database is ready
RESULT=$(mysqladmin ping -u"$MYSQL_USER" -p"$MYSQL_PASSWORD" -h"$MYSQL_HOST" --protocol=tcp)
until [ "$RESULT" == "mysqld is alive" ]
do
    echo "[INFO] Could not connect to Database, retrying in 10 seconds"
    sleep 10s
    RESULT=$(mysqladmin ping -u"$MYSQL_USER" -p"$MYSQL_PASSWORD" -h"$MYSQL_HOST" --protocol=tcp)
done

# Check if Database Exists, if not create it
RESULT=$(echo $(mysql -u"$MYSQL_USER" -h"$MYSQL_HOST" --protocol=tcp -D"$MYSQL_DATABASE" -Bse 'SHOW TABLES' -D"$MYSQL_DATABASE" | wc -l))
if [ "$RESULT" == "0" ]; then
    echo '[INFO] Creating Database'
    mysql -u"$MYSQL_USER" -D"$MYSQL_DATABASE" -h"$MYSQL_HOST" --protocol=tcp < /opt/friendup/db/FriendCoreDatabase.sql

    #for i in $(ls -v /opt/friendup/sqlupdatescripts/); do
    #    echo "[INFO] Running $i"
    #    mysql -u"$MYSQL_USER" -D"$MYSQL_DATABASE" -h"$MYSQL_HOST" --protocol=tcp < /opt/friendup/sqlupdatescripts/"$i"
    #done;
fi

# SSL Certificate
if [ ! -f '/opt/friendup/cfg/crt/key.pem' ]; then
    # generate new ssl certificate
    echo '[INFO] Generating new SSL certificate'
    openssl req -nodes -sha512 -x509 -days 3650 -newkey rsa:2048 -keyout /opt/friendup/cfg/crt/key.pem -out /opt/friendup/cfg/crt/certificate.pem -subj "/C=GB/ST=London/L=London/O=Global Security/OU=IT Department/CN=$DOCKER_FRIEND_DOMAIN"
else
    # Check if certificate will expire within the next 30 days and renew it if yes
    if ! openssl x509 -checkend 2592000 -noout -in /opt/friendup/cfg/crt/certificate.pem; then
        echo '[INFO] Updating SSL certificate'
        openssl req -new -sha512 -x509 -nodes -days 3650 -key /opt/friendup/cfg/crt/key.pem -out /opt/friendup/cfg/crt/certificate.pem -subj "/C=GB/ST=London/L=London/O=Global Security/OU=IT Department/CN=$DOCKER_FRIEND_DOMAIN"
    fi
fi

# Check if the config File already exists, if not create it
if [ ! -f '/opt/friendup/cfg/cfg.ini' ]; then
    cp /opt/friendup/cfg/cfg.ini.sample /opt/friendup/cfg/cfg.ini
    sed -i "s|#DB_USER#|$MYSQL_USER|g" /opt/friendup/cfg/cfg.ini
    sed -i "s|#DB_PASS#|$MYSQL_PASSWORD|g" /opt/friendup/cfg/cfg.ini
    sed -i "s|#DB_HOST#|$MYSQL_HOST|g" /opt/friendup/cfg/cfg.ini
    sed -i "s|#DB_NAME#|$MYSQL_DATABASE|g" /opt/friendup/cfg/cfg.ini
    sed -i "s|#FRND_DOMAIN#|$DOCKER_FRIEND_DOMAIN|g" /opt/friendup/cfg/cfg.ini
    echo '[INFO] Created new config file'
fi

# Finish up and start Friend
unset MYSQL_PWD
cd /opt/friendup/
/opt/friendup/FriendCore