docker/scripts/start.sh

   1 #!/bin/bash
   2
   3
   4 [ -z "$RO_DB_OVIM_HOST" ] && export RO_DB_OVIM_HOST="$RO_DB_HOST"
   5 [ -z "$RO_DB_OVIM_ROOT_PASSWORD" ] && export RO_DB_OVIM_ROOT_PASSWORD="$RO_DB_ROOT_PASSWORD"
   6
   7 function is_db_created() {
   8     db_host=$1
   9     db_port=$2
  10     db_user=$3
  11     db_pswd=$4
  12     db_name=$5
  13
  14     RESULT=`mysqlshow -h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" | grep -v Wildcard | grep -o $db_name`
  15     if [ "$RESULT" == "$db_name" ]; then
  16
  17         RESULT=`mysqlshow -h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" | grep -v Wildcard | grep schema_version`
  18         #TODO validate version
  19         if [ -n "$RESULT" ]; then
  20             echo " DB $db_name exists and inited"
  21             return 0
  22         else
  23             echo " DB $db_name exists BUT not inited"
  24             return 1
  25         fi
  26     fi
  27     echo " DB $db_name does not exist"
  28     return 1
  29 }
  30
  31 function configure(){
  32     #Database parameters
  33     #db_host:   localhost
  34     #db_user:   mano
  35     #db_passwd: manopw
  36     #db_name:   mano_db
  37     # Database ovim parameters
  38     #db_ovim_host:   localhost          # by default localhost
  39     #db_ovim_user:   mano               # DB user
  40     #db_ovim_passwd: manopw             # DB password
  41     #db_ovim_name:   mano_vim_db        # Name of the OVIM MANO DB
  42
  43
  44     sed -i "s/^db_host:.*/db_host: $RO_DB_HOST/" /etc/osm/openmanod.cfg || return 1
  45     sed -i "s/^db_user:.*/db_user: $RO_DB_USER/" /etc/osm/openmanod.cfg || return 1
  46     sed -i "s/^db_passwd:.*/db_passwd: $RO_DB_PASSWORD/" /etc/osm/openmanod.cfg || return 1
  47     sed -i "s/^db_name:.*/db_name: $RO_DB_NAME/" /etc/osm/openmanod.cfg || return 1
  48     sed -i "s/^db_ovim_host:.*/db_ovim_host: $RO_DB_OVIM_HOST/" /etc/osm/openmanod.cfg || return 1
  49     sed -i "s/^db_ovim_user:.*/db_ovim_user: $RO_DB_OVIM_USER/" /etc/osm/openmanod.cfg || return 1
  50     sed -i "s/^db_ovim_passwd:.*/db_ovim_passwd: $RO_DB_OVIM_PASSWORD/" /etc/osm/openmanod.cfg || return 1
  51     sed -i "s/^db_ovim_name:.*/db_ovim_name: $RO_DB_OVIM_NAME/" /etc/osm/openmanod.cfg || return 1
  52     return 0
  53 }
  54
  55 max_attempts=120
  56 function wait_db(){
  57     db_host=$1
  58     db_port=$2
  59     attempt=0
  60     echo "Wait until $max_attempts seconds for MySQL mano Server ${db_host}:${db_port} "
  61     while ! mysqladmin ping -h"$db_host" -P"$db_port" --silent; do
  62         #wait 120 sec
  63         if [ $attempt -ge $max_attempts ]; then
  64             echo
  65             echo "Can not connect to database ${db_host}:${db_port} during $max_attempts sec"
  66             return 1
  67         fi
  68         attempt=$[$attempt+1]
  69         echo -n "."
  70         sleep 1
  71     done
  72     return 0
  73 }
  74
  75
  76 echo "1/4 Apply config"
  77 configure || exit 1
  78
  79
  80 echo "2/4 Wait for db up"
  81 wait_db "$RO_DB_HOST" "$RO_DB_PORT" || exit 1
  82 [ "$RO_DB_OVIM_HOST" = "$RO_DB_HOST" ] ||  wait_db "$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" || exit 1
  83
  84
  85 echo "3/4 Init database"
  86 RO_PATH=`python -c 'import osm_ro; print(osm_ro.__path__[0])'`
  87 echo "RO_PATH: $RO_PATH"
  88 if ! is_db_created "$RO_DB_HOST" "$RO_DB_PORT" "$RO_DB_USER" "$RO_DB_PASSWORD" "$RO_DB_NAME"
  89 then
  90     if [ -n "$RO_DB_ROOT_PASSWORD" ] ; then
  91         mysqladmin -h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" create "$RO_DB_NAME"
  92         echo "CREATE USER '${RO_DB_USER}'@'%' IDENTIFIED BY '${RO_DB_PASSWORD}';" |
  93             mysql -h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" || echo "user ${RO_DB_USER} already created?"
  94         echo "GRANT ALL PRIVILEGES ON ${RO_DB_NAME}.* TO '${RO_DB_USER}'@'%';" |
  95             mysql -h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD"  || echo "user ${RO_DB_USER} already granted?"
  96     fi
  97     ${RO_PATH}/database_utils/init_mano_db.sh  -u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
  98         -P "${RO_DB_PORT}" -d "${RO_DB_NAME}" || exit 1
  99 else
 100     echo "    migrage database version"
 101     ${RO_PATH}/database_utils/migrate_mano_db.sh -u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
 102         -P "$RO_DB_PORT" -d "$RO_DB_NAME"
 103 fi
 104
 105 OVIM_PATH=`python -c 'import lib_osm_openvim; print(lib_osm_openvim.__path__[0])'`
 106 echo "OVIM_PATH: $OVIM_PATH"
 107 if ! is_db_created "$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" "$RO_DB_OVIM_USER" "$RO_DB_OVIM_PASSWORD" "$RO_DB_OVIM_NAME"
 108 then
 109     if [ -n "$RO_DB_OVIM_ROOT_PASSWORD" ] ; then
 110         mysqladmin -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" create "$RO_DB_OVIM_NAME"
 111         echo "CREATE USER '${RO_DB_OVIM_USER}'@'%' IDENTIFIED BY '${RO_DB_OVIM_PASSWORD}';" |
 112             mysql -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" ||
 113             echo "user ${RO_DB_OVIM_USER} already created?"
 114         echo "GRANT ALL PRIVILEGES ON ${RO_DB_OVIM_NAME}.* TO '${RO_DB_OVIM_USER}'@'%';" |
 115             mysql -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD"  ||
 116             echo "user ${RO_DB_OVIM_USER} already granted?"
 117     fi
 118     ${OVIM_PATH}/database_utils/init_vim_db.sh  -u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST" \
 119         -P "${RO_DB_OVIM_PORT}" -d "${RO_DB_OVIM_NAME}" || exit 1
 120 else
 121     echo "    migrage database version"
 122     ${OVIM_PATH}/database_utils/migrate_vim_db.sh -u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST"\
 123         -P "$RO_DB_OVIM_PORT" -d "$RO_DB_OVIM_NAME"
 124 fi
 125
 126
 127 echo "4/4 Try to start"
 128 /usr/bin/openmanod -c /etc/osm/openmanod.cfg --log-file=/var/log/osm/openmano.log --create-tenant=osm