scripts/RO-start.sh

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