start-db.sh

#!/bin/bash

#
# script to set up container with mariadb in and initialize db for hotel
#

#
# to stop:
# $ docker stop sigmadb
#
# to remove
# $ docker rm -v sigmadb
#

usage() {
  echo "Usage: $0 yml..."
}

PORT=4406  # use non-default port number on host
MONGO_PORT=4407

docker pull mariadb:10.4
if ! docker ps | grep -q sigmadb; then
    echo "start db"
    docker run --name sigmadb -e MYSQL_ROOT_PASSWORD=sigmadb -p $PORT:3306 -d mariadb
fi

until [ "`docker inspect -f {{.State.Running}} sigmadb`"=="true" ]; do
    echo -n "." 1>&2
    sleep 0.1;
done;

ip=$(docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' sigmadb)

echo "db IP: $ip"

until mariadb-show --skip-ssl -h $ip -u root -psigmadb 2> /dev/null; do
    echo -n "." 1>&2
    sleep 0.1;
done;    

if ! mariadb-show --skip-ssl -h $ip -u root -psigmadb | grep -q sigmaos; then
    echo "initialize db"
    mariadb --skip-ssl -h $ip -u root -psigmadb <<ENDOFSQL
CREATE database sigmaos;
USE sigmaos;
source apps/hotel/init-db.sql;
CREATE USER 'sigma1'@'172.17.%.%' IDENTIFIED BY 'sigmaos1';
GRANT ALL PRIVILEGES ON sigmaos.* TO 'sigma1'@'172.17.%.%';
CREATE USER 'sigma1'@'192.168.%.%' IDENTIFIED BY 'sigmaos1';
GRANT ALL PRIVILEGES ON sigmaos.* TO 'sigma1'@'192.168.%.%';
CREATE USER 'sigma1'@'10.10.%.%' IDENTIFIED BY 'sigmaos1';
GRANT ALL PRIVILEGES ON sigmaos.* TO 'sigma1'@'10.10.%.%';
CREATE USER 'sigma1'@'10.0.%.%' IDENTIFIED BY 'sigmaos1';
GRANT ALL PRIVILEGES ON sigmaos.* TO 'sigma1'@'10.0.%.%';
FLUSH PRIVILEGES;
SET GLOBAL max_connections = 100000;
ENDOFSQL
fi

docker pull mongo:4.4.6
if ! docker ps | grep -q sigmamongo; then
    echo "start mongodb"
    docker run --name sigmamongo -p $MONGO_PORT:27017 -d mongo:4.4.6
fi

until [ "`docker inspect -f {{.State.Running}} sigmamongo`"=="true" ]; do
    echo -n "." 1>&2
    sleep 0.1;
done;

ip=$(docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' sigmamongo)

echo "mongo IP: $ip"