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 # if New Generation RO just launch it
23 if [ -n "$OSMRO_NG" ] ; then
24 python3
-m osm_ng_ro.ro_main ||
exit 1
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"
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
35 function is_db_created
() {
41 db_version
=$6 # minimun database version
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
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
55 echo " DB $db_name exists BUT not inited" >&2
59 echo " DB $db_name does not exist" >&2
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
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
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
95 if [ $attempt -ge $max_attempts ]; then
97 echo "Cannot connect to database ${db_host}:${db_port} during $max_attempts sec" >&2
100 attempt
=$
[$attempt+1]
108 echo "1/4 Apply config"
109 # this is not needed anymore because envioron overwrites config file
110 # configure || exit 1
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
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"
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?"
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
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
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" \
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?"
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
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
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
168 python3
-m osm_ro.openmanod
-c "$RO_CONFIG_FILE" --create-tenant=osm
# --log-file=/var/log/osm/openmano.log