RO/osm_ro/scripts/RO-start.sh

   1 #!/bin/bash
   2 ##
   3 # Copyright 2015 Telefonica Investigacion y Desarrollo, S.A.U.
   4 # Licensed under the Apache License, Version 2.0 (the "License"); you may
   5 # not use this file except in compliance with the License. You may obtain
   6 # a copy of the License at
   7 #
   8 #         http://www.apache.org/licenses/LICENSE-2.0
   9 #
  10 # Unless required by applicable law or agreed to in writing, software
  11 # distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
  12 # WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
  13 # License for the specific language governing permissions and limitations
  14 # under the License.
  15 ##
  16
  17 # This script is intended for launching RO from a docker container.
  18 # It waits for mysql server ready, normally running on a separate container, ...
  19 # then it checks if database is present and creates it if needed.
  20 # Finally it launches RO server.
  21
  22 #  if New Generation RO just launch it
  23 if [ -n "$OSMRO_NG" ] ; then
  24     python3 -m osm_ng_ro.ro_main || exit 1
  25     exit 0
  26 fi
  27
  28 [ -z "$RO_DB_OVIM_HOST" ] && export RO_DB_OVIM_HOST="$RO_DB_HOST"
  29 [ -z "$RO_DB_OVIM_ROOT_PASSWORD" ] && export RO_DB_OVIM_ROOT_PASSWORD="$RO_DB_ROOT_PASSWORD"
  30
  31 # IF OSMRO_SERVER_NG use new server that not need any database init
  32 [ -n "$OSMRO_SERVER_NG" ] && python3 -m osm_ng_ro.ro_main
  33
  34
  35 function is_db_created() {
  36     db_host=$1
  37     db_port=$2
  38     db_user=$3
  39     db_pswd=$4
  40     db_name=$5
  41     db_version=$6  # minimun database version
  42
  43     if mysqlshow -h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" | grep -v Wildcard | grep -q -e "$db_name" ; then
  44         if echo "SELECT comments FROM schema_version WHERE version_int=0;" |
  45                 mysql -h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
  46                 grep -q -e "init" ; then
  47             echo " DB $db_name exists BUT failed in previous init" >&2
  48             return 1
  49         elif echo "SELECT * FROM schema_version WHERE version_int=$db_version;" |
  50                 mysql -h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
  51                 grep -q -e "$db_version" ; then
  52             echo " DB $db_name exists and inited" >&2
  53             return 0
  54         else
  55             echo " DB $db_name exists BUT not inited" >&2
  56             return 1
  57         fi
  58     fi
  59     echo " DB $db_name does not exist" >&2
  60     return 1
  61 }
  62
  63 function configure(){
  64     #Database parameters
  65     #db_host:   localhost
  66     #db_user:   mano
  67     #db_passwd: manopw
  68     #db_name:   mano_db
  69     # Database ovim parameters
  70     #db_ovim_host:   localhost          # by default localhost
  71     #db_ovim_user:   mano               # DB user
  72     #db_ovim_passwd: manopw             # DB password
  73     #db_ovim_name:   mano_vim_db        # Name of the OVIM MANO DB
  74
  75
  76     sed -i "s/^db_host:.*/db_host: $RO_DB_HOST/" /etc/osm/openmanod.cfg || return 1
  77     sed -i "s/^db_user:.*/db_user: $RO_DB_USER/" /etc/osm/openmanod.cfg || return 1
  78     sed -i "s/^db_passwd:.*/db_passwd: $RO_DB_PASSWORD/" /etc/osm/openmanod.cfg || return 1
  79     sed -i "s/^db_name:.*/db_name: $RO_DB_NAME/" /etc/osm/openmanod.cfg || return 1
  80     sed -i "s/^db_ovim_host:.*/db_ovim_host: $RO_DB_OVIM_HOST/" /etc/osm/openmanod.cfg || return 1
  81     sed -i "s/^db_ovim_user:.*/db_ovim_user: $RO_DB_OVIM_USER/" /etc/osm/openmanod.cfg || return 1
  82     sed -i "s/^db_ovim_passwd:.*/db_ovim_passwd: $RO_DB_OVIM_PASSWORD/" /etc/osm/openmanod.cfg || return 1
  83     sed -i "s/^db_ovim_name:.*/db_ovim_name: $RO_DB_OVIM_NAME/" /etc/osm/openmanod.cfg || return 1
  84     return 0
  85 }
  86
  87 max_attempts=120
  88 function wait_db(){
  89     db_host=$1
  90     db_port=$2
  91     attempt=0
  92     echo "Wait until $max_attempts seconds for MySQL mano Server ${db_host}:${db_port} "
  93     while ! mysqladmin ping -h"$db_host" -P"$db_port" --silent; do
  94         #wait 120 sec
  95         if [ $attempt -ge $max_attempts ]; then
  96             echo
  97             echo "Cannot connect to database ${db_host}:${db_port} during $max_attempts sec" >&2
  98             return 1
  99         fi
 100         attempt=$[$attempt+1]
 101         echo -n "."
 102         sleep 1
 103     done
 104     return 0
 105 }
 106
 107
 108 echo "1/4 Apply config"
 109 # this is not needed anymore because envioron overwrites config file
 110 # configure || exit 1
 111
 112
 113 echo "2/4 Wait for db up"
 114 wait_db "$RO_DB_HOST" "$RO_DB_PORT" || exit 1
 115 [ "$RO_DB_OVIM_HOST" = "$RO_DB_HOST" ] ||  wait_db "$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" || exit 1
 116
 117
 118 echo "3/4 Init database"
 119 RO_PATH=`python3 -c 'import osm_ro; print(osm_ro.__path__[0])'`
 120 echo "RO_PATH: $RO_PATH"
 121 if ! is_db_created "$RO_DB_HOST" "$RO_DB_PORT" "$RO_DB_USER" "$RO_DB_PASSWORD" "$RO_DB_NAME" "27"
 122 then
 123     if [ -n "$RO_DB_ROOT_PASSWORD" ] ; then
 124         mysqladmin -h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" create "$RO_DB_NAME"
 125         echo "CREATE USER '${RO_DB_USER}'@'%' IDENTIFIED BY '${RO_DB_PASSWORD}';" |
 126             mysql -h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" || echo "user ${RO_DB_USER} already created?"
 127         echo "GRANT ALL PRIVILEGES ON ${RO_DB_NAME}.* TO '${RO_DB_USER}'@'%';" |
 128             mysql -h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD"  || echo "user ${RO_DB_USER} already granted?"
 129     fi
 130     ${RO_PATH}/database_utils/init_mano_db.sh  -u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
 131         -P "${RO_DB_PORT}" -d "${RO_DB_NAME}" || exit 1
 132 else
 133     echo "  migrate database version"
 134     ${RO_PATH}/database_utils/migrate_mano_db.sh -u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
 135         -P "$RO_DB_PORT" -d "$RO_DB_NAME" -b /var/log/osm
 136 fi
 137
 138 # TODO py3 BEGIN
 139 #OVIM_PATH=`python3 -c 'import lib_osm_openvim; print(lib_osm_openvim.__path__[0])'`
 140 #echo "OVIM_PATH: $OVIM_PATH"
 141 #if ! is_db_created "$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" "$RO_DB_OVIM_USER" "$RO_DB_OVIM_PASSWORD" "$RO_DB_OVIM_NAME" \
 142 #    "22"
 143 #then
 144 #    if [ -n "$RO_DB_OVIM_ROOT_PASSWORD" ] ; then
 145 #        mysqladmin -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" create "$RO_DB_OVIM_NAME"
 146 #        echo "CREATE USER '${RO_DB_OVIM_USER}'@'%' IDENTIFIED BY '${RO_DB_OVIM_PASSWORD}';" |
 147 #            mysql -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" ||
 148 #            echo "user ${RO_DB_OVIM_USER} already created?"
 149 #        echo "GRANT ALL PRIVILEGES ON ${RO_DB_OVIM_NAME}.* TO '${RO_DB_OVIM_USER}'@'%';" |
 150 #            mysql -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD"  ||
 151 #            echo "user ${RO_DB_OVIM_USER} already granted?"
 152 #    fi
 153 #    ${OVIM_PATH}/database_utils/init_vim_db.sh  -u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST" \
 154 #        -P "${RO_DB_OVIM_PORT}" -d "${RO_DB_OVIM_NAME}" || exit 1
 155 #else
 156 #    echo "  migrate database version"
 157 #    ${OVIM_PATH}/database_utils/migrate_vim_db.sh -u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST"\
 158 #        -P "$RO_DB_OVIM_PORT" -d "$RO_DB_OVIM_NAME" -b /var/log/osm
 159 #fi
 160 # TODO py3 END
 161
 162 echo "4/4 Try to start"
 163 # look for openmanod.cfg
 164 RO_CONFIG_FILE="/etc/osm/openmanod.cfg"
 165 [ -f "$RO_CONFIG_FILE" ] || RO_CONFIG_FILE=$(python3 -c 'import osm_ro; print(osm_ro.__path__[0])')/openmanod.cfg
 166 [ -f "$RO_CONFIG_FILE" ] || ! echo "configuration file 'openmanod.cfg' not found" || exit 1
 167
 168 python3 -m osm_ro.openmanod -c "$RO_CONFIG_FILE"  --create-tenant=osm  # --log-file=/var/log/osm/openmano.log
 169