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 # IF OSMRO_SERVER_NG use new server that not need any database init
26 [ -n "$OSMRO_SERVER_NG" ] && python3
-m osm_ng_ro.ro_main
29 function is_db_created
() {
35 db_version
=$6 # minimun database version
37 if mysqlshow
-h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" |
grep -v Wildcard |
grep -q -e "$db_name" ; then
38 if echo "SELECT comments FROM schema_version WHERE version_int=0;" |
39 mysql
-h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
40 grep -q -e "init" ; then
41 echo " DB $db_name exists BUT failed in previous init" >&2
43 elif echo "SELECT * FROM schema_version WHERE version_int=$db_version;" |
44 mysql
-h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
45 grep -q -e "$db_version" ; then
46 echo " DB $db_name exists and inited" >&2
49 echo " DB $db_name exists BUT not inited" >&2
53 echo " DB $db_name does not exist" >&2
63 # Database ovim parameters
64 #db_ovim_host: localhost # by default localhost
65 #db_ovim_user: mano # DB user
66 #db_ovim_passwd: manopw # DB password
67 #db_ovim_name: mano_vim_db # Name of the OVIM MANO DB
70 sed -i "s/^db_host:.*/db_host: $RO_DB_HOST/" /etc
/osm
/openmanod.cfg ||
return 1
71 sed -i "s/^db_user:.*/db_user: $RO_DB_USER/" /etc
/osm
/openmanod.cfg ||
return 1
72 sed -i "s/^db_passwd:.*/db_passwd: $RO_DB_PASSWORD/" /etc
/osm
/openmanod.cfg ||
return 1
73 sed -i "s/^db_name:.*/db_name: $RO_DB_NAME/" /etc
/osm
/openmanod.cfg ||
return 1
74 sed -i "s/^db_ovim_host:.*/db_ovim_host: $RO_DB_OVIM_HOST/" /etc
/osm
/openmanod.cfg ||
return 1
75 sed -i "s/^db_ovim_user:.*/db_ovim_user: $RO_DB_OVIM_USER/" /etc
/osm
/openmanod.cfg ||
return 1
76 sed -i "s/^db_ovim_passwd:.*/db_ovim_passwd: $RO_DB_OVIM_PASSWORD/" /etc
/osm
/openmanod.cfg ||
return 1
77 sed -i "s/^db_ovim_name:.*/db_ovim_name: $RO_DB_OVIM_NAME/" /etc
/osm
/openmanod.cfg ||
return 1
86 echo "Wait until $max_attempts seconds for MySQL mano Server ${db_host}:${db_port} "
87 while ! mysqladmin
ping -h"$db_host" -P"$db_port" --silent; do
89 if [ $attempt -ge $max_attempts ]; then
91 echo "Cannot connect to database ${db_host}:${db_port} during $max_attempts sec" >&2
102 echo "1/4 Apply config"
103 # this is not needed anymore because envioron overwrites config file
104 # configure || exit 1
107 echo "2/4 Wait for db up"
108 wait_db
"$RO_DB_HOST" "$RO_DB_PORT" ||
exit 1
109 [ "$RO_DB_OVIM_HOST" = "$RO_DB_HOST" ] || wait_db
"$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" ||
exit 1
112 echo "3/4 Init database"
113 RO_PATH
=`python3 -c 'import osm_ro; print(osm_ro.__path__[0])'`
114 echo "RO_PATH: $RO_PATH"
115 if ! is_db_created
"$RO_DB_HOST" "$RO_DB_PORT" "$RO_DB_USER" "$RO_DB_PASSWORD" "$RO_DB_NAME" "27"
117 if [ -n "$RO_DB_ROOT_PASSWORD" ] ; then
118 mysqladmin
-h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" create
"$RO_DB_NAME"
119 echo "CREATE USER '${RO_DB_USER}'@'%' IDENTIFIED BY '${RO_DB_PASSWORD}';" |
120 mysql
-h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" ||
echo "user ${RO_DB_USER} already created?"
121 echo "GRANT ALL PRIVILEGES ON ${RO_DB_NAME}.* TO '${RO_DB_USER}'@'%';" |
122 mysql
-h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" ||
echo "user ${RO_DB_USER} already granted?"
124 ${RO_PATH}/database_utils
/init_mano_db.sh
-u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
125 -P "${RO_DB_PORT}" -d "${RO_DB_NAME}" ||
exit 1
127 echo " migrate database version"
128 ${RO_PATH}/database_utils
/migrate_mano_db.sh
-u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
129 -P "$RO_DB_PORT" -d "$RO_DB_NAME" -b /var
/log
/osm
133 #OVIM_PATH=`python3 -c 'import lib_osm_openvim; print(lib_osm_openvim.__path__[0])'`
134 #echo "OVIM_PATH: $OVIM_PATH"
135 #if ! is_db_created "$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" "$RO_DB_OVIM_USER" "$RO_DB_OVIM_PASSWORD" "$RO_DB_OVIM_NAME" \
138 # if [ -n "$RO_DB_OVIM_ROOT_PASSWORD" ] ; then
139 # mysqladmin -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" create "$RO_DB_OVIM_NAME"
140 # echo "CREATE USER '${RO_DB_OVIM_USER}'@'%' IDENTIFIED BY '${RO_DB_OVIM_PASSWORD}';" |
141 # mysql -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" ||
142 # echo "user ${RO_DB_OVIM_USER} already created?"
143 # echo "GRANT ALL PRIVILEGES ON ${RO_DB_OVIM_NAME}.* TO '${RO_DB_OVIM_USER}'@'%';" |
144 # mysql -h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" ||
145 # echo "user ${RO_DB_OVIM_USER} already granted?"
147 # ${OVIM_PATH}/database_utils/init_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}" || exit 1
150 # echo " migrate database version"
151 # ${OVIM_PATH}/database_utils/migrate_vim_db.sh -u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST"\
152 # -P "$RO_DB_OVIM_PORT" -d "$RO_DB_OVIM_NAME" -b /var/log/osm
156 echo "4/4 Try to start"
157 # look for openmanod.cfg
158 RO_CONFIG_FILE
="/etc/osm/openmanod.cfg"
159 [ -f "$RO_CONFIG_FILE" ] || RO_CONFIG_FILE
=$
(python3
-c 'import osm_ro; print(osm_ro.__path__[0])')/openmanod.cfg
160 [ -f "$RO_CONFIG_FILE" ] ||
! echo "configuration file 'openmanod.cfg' not found" ||
exit 1
162 python3
-m osm_ro.openmanod
-c "$RO_CONFIG_FILE" --create-tenant=osm
# --log-file=/var/log/osm/openmano.log