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
8 # http://www.apache.org/licenses/LICENSE-2.0
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
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.
22 [ -z "$RO_DB_OVIM_HOST" ] && export RO_DB_OVIM_HOST
="$RO_DB_HOST"
23 [ -z "$RO_DB_OVIM_ROOT_PASSWORD" ] && export RO_DB_OVIM_ROOT_PASSWORD
="$RO_DB_ROOT_PASSWORD"
25 function is_db_created
() {
31 db_version
=$6 # minimun database version
33 if mysqlshow
-h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" |
grep -v Wildcard |
grep -q -e "$db_name" ; then
34 if echo "SELECT comments FROM schema_version WHERE version_int=0;" |
35 mysql
-h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
36 grep -q -e "init" ; then
37 echo " DB $db_name exists BUT failed in previous init" >&2
39 elif echo "SELECT * FROM schema_version WHERE version_int=$db_version;" |
40 mysql
-h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
41 grep -q -e "$db_version" ; then
42 echo " DB $db_name exists and inited" >&2
45 echo " DB $db_name exists BUT not inited" >&2
49 echo " DB $db_name does not exist" >&2
59 # Database ovim parameters
60 #db_ovim_host: localhost # by default localhost
61 #db_ovim_user: mano # DB user
62 #db_ovim_passwd: manopw # DB password
63 #db_ovim_name: mano_vim_db # Name of the OVIM MANO DB
66 sed -i "s/^db_host:.*/db_host: $RO_DB_HOST/" /etc
/osm
/openmanod.cfg ||
return 1
67 sed -i "s/^db_user:.*/db_user: $RO_DB_USER/" /etc
/osm
/openmanod.cfg ||
return 1
68 sed -i "s/^db_passwd:.*/db_passwd: $RO_DB_PASSWORD/" /etc
/osm
/openmanod.cfg ||
return 1
69 sed -i "s/^db_name:.*/db_name: $RO_DB_NAME/" /etc
/osm
/openmanod.cfg ||
return 1
70 sed -i "s/^db_ovim_host:.*/db_ovim_host: $RO_DB_OVIM_HOST/" /etc
/osm
/openmanod.cfg ||
return 1
71 sed -i "s/^db_ovim_user:.*/db_ovim_user: $RO_DB_OVIM_USER/" /etc
/osm
/openmanod.cfg ||
return 1
72 sed -i "s/^db_ovim_passwd:.*/db_ovim_passwd: $RO_DB_OVIM_PASSWORD/" /etc
/osm
/openmanod.cfg ||
return 1
73 sed -i "s/^db_ovim_name:.*/db_ovim_name: $RO_DB_OVIM_NAME/" /etc
/osm
/openmanod.cfg ||
return 1
82 echo "Wait until $max_attempts seconds for MySQL mano Server ${db_host}:${db_port} "
83 while ! mysqladmin
ping -h"$db_host" -P"$db_port" --silent; do
85 if [ $attempt -ge $max_attempts ]; then
87 echo "Cannot connect to database ${db_host}:${db_port} during $max_attempts sec" >&2
98 echo "1/4 Apply config"
99 # this is not needed anymore because envioron overwrites config file
100 # configure || exit 1
103 echo "2/4 Wait for db up"
104 wait_db
"$RO_DB_HOST" "$RO_DB_PORT" ||
exit 1
105 [ "$RO_DB_OVIM_HOST" = "$RO_DB_HOST" ] || wait_db
"$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" ||
exit 1
108 echo "3/4 Init database"
109 RO_PATH
=`python3 -c 'import osm_ro; print(osm_ro.__path__[0])'`
110 echo "RO_PATH: $RO_PATH"
111 if ! is_db_created
"$RO_DB_HOST" "$RO_DB_PORT" "$RO_DB_USER" "$RO_DB_PASSWORD" "$RO_DB_NAME" "27"
113 if [ -n "$RO_DB_ROOT_PASSWORD" ] ; then
114 mysqladmin
-h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" create
"$RO_DB_NAME"
115 echo "CREATE USER '${RO_DB_USER}'@'%' IDENTIFIED BY '${RO_DB_PASSWORD}';" |
116 mysql
-h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" ||
echo "user ${RO_DB_USER} already created?"
117 echo "GRANT ALL PRIVILEGES ON ${RO_DB_NAME}.* TO '${RO_DB_USER}'@'%';" |
118 mysql
-h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" ||
echo "user ${RO_DB_USER} already granted?"
120 ${RO_PATH}/database_utils
/init_mano_db.sh
-u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
121 -P "${RO_DB_PORT}" -d "${RO_DB_NAME}" ||
exit 1
123 echo " migrate database version"
124 ${RO_PATH}/database_utils
/migrate_mano_db.sh
-u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
125 -P "$RO_DB_PORT" -d "$RO_DB_NAME" -b /var
/log
/osm
129 #OVIM_PATH=`python3 -c 'import lib_osm_openvim; print(lib_osm_openvim.__path__[0])'`
130 #echo "OVIM_PATH: $OVIM_PATH"
131 #if ! is_db_created "$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" "$RO_DB_OVIM_USER" "$RO_DB_OVIM_PASSWORD" "$RO_DB_OVIM_NAME" \
134 # if [ -n "$RO_DB_OVIM_ROOT_PASSWORD" ] ; then
135 # mysqladmin -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" create "$RO_DB_OVIM_NAME"
136 # echo "CREATE USER '${RO_DB_OVIM_USER}'@'%' IDENTIFIED BY '${RO_DB_OVIM_PASSWORD}';" |
137 # mysql -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" ||
138 # echo "user ${RO_DB_OVIM_USER} already created?"
139 # echo "GRANT ALL PRIVILEGES ON ${RO_DB_OVIM_NAME}.* TO '${RO_DB_OVIM_USER}'@'%';" |
140 # mysql -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" ||
141 # echo "user ${RO_DB_OVIM_USER} already granted?"
143 # ${OVIM_PATH}/database_utils/init_vim_db.sh -u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST" \
144 # -P "${RO_DB_OVIM_PORT}" -d "${RO_DB_OVIM_NAME}" || exit 1
146 # echo " migrate database version"
147 # ${OVIM_PATH}/database_utils/migrate_vim_db.sh -u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST"\
148 # -P "$RO_DB_OVIM_PORT" -d "$RO_DB_OVIM_NAME" -b /var/log/osm
152 echo "4/4 Try to start"
153 # look for openmanod.cfg
154 RO_CONFIG_FILE
="/etc/osm/openmanod.cfg"
155 [ -f "$RO_CONFIG_FILE" ] || RO_CONFIG_FILE
=$
(python3
-c 'import osm_ro; print(osm_ro.__path__[0])')/openmanod.cfg
156 [ -f "$RO_CONFIG_FILE" ] ||
! echo "configuration file 'openmanod.cfg' not found" ||
exit 1
158 python3
-m osm_ro.openmanod
-c "$RO_CONFIG_FILE" --create-tenant=osm
# --log-file=/var/log/osm/openmano.log