47547cdd6f7295d4b1420c784a44ec2c21de5085
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.
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"
11 function is_db_created
() {
17 db_version
=$6 # minimun database version
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 comments FROM schema_version WHERE version_int=0;" |
21 mysql
-h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
22 grep -q -e "init" ; then
23 echo " DB $db_name exists BUT failed in previous init" >&2
25 elif echo "SELECT * FROM schema_version WHERE version_int=$db_version;" |
26 mysql
-h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
27 grep -q -e "$db_version" ; then
28 echo " DB $db_name exists and inited" >&2
31 echo " DB $db_name exists BUT not inited" >&2
35 echo " DB $db_name does not exist" >&2
45 # Database ovim parameters
46 #db_ovim_host: localhost # by default localhost
47 #db_ovim_user: mano # DB user
48 #db_ovim_passwd: manopw # DB password
49 #db_ovim_name: mano_vim_db # Name of the OVIM MANO DB
52 sed -i "s/^db_host:.*/db_host: $RO_DB_HOST/" /etc
/osm
/openmanod.cfg ||
return 1
53 sed -i "s/^db_user:.*/db_user: $RO_DB_USER/" /etc
/osm
/openmanod.cfg ||
return 1
54 sed -i "s/^db_passwd:.*/db_passwd: $RO_DB_PASSWORD/" /etc
/osm
/openmanod.cfg ||
return 1
55 sed -i "s/^db_name:.*/db_name: $RO_DB_NAME/" /etc
/osm
/openmanod.cfg ||
return 1
56 sed -i "s/^db_ovim_host:.*/db_ovim_host: $RO_DB_OVIM_HOST/" /etc
/osm
/openmanod.cfg ||
return 1
57 sed -i "s/^db_ovim_user:.*/db_ovim_user: $RO_DB_OVIM_USER/" /etc
/osm
/openmanod.cfg ||
return 1
58 sed -i "s/^db_ovim_passwd:.*/db_ovim_passwd: $RO_DB_OVIM_PASSWORD/" /etc
/osm
/openmanod.cfg ||
return 1
59 sed -i "s/^db_ovim_name:.*/db_ovim_name: $RO_DB_OVIM_NAME/" /etc
/osm
/openmanod.cfg ||
return 1
68 echo "Wait until $max_attempts seconds for MySQL mano Server ${db_host}:${db_port} "
69 while ! mysqladmin
ping -h"$db_host" -P"$db_port" --silent; do
71 if [ $attempt -ge $max_attempts ]; then
73 echo "Cannot connect to database ${db_host}:${db_port} during $max_attempts sec" >&2
84 echo "1/4 Apply config"
85 # this is not needed anymore because envioron overwrites config file
89 echo "2/4 Wait for db up"
90 wait_db
"$RO_DB_HOST" "$RO_DB_PORT" ||
exit 1
91 [ "$RO_DB_OVIM_HOST" = "$RO_DB_HOST" ] || wait_db
"$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" ||
exit 1
94 echo "3/4 Init database"
95 RO_PATH
=`python -c 'import osm_ro; print(osm_ro.__path__[0])'`
96 echo "RO_PATH: $RO_PATH"
97 if ! is_db_created
"$RO_DB_HOST" "$RO_DB_PORT" "$RO_DB_USER" "$RO_DB_PASSWORD" "$RO_DB_NAME" "27"
99 if [ -n "$RO_DB_ROOT_PASSWORD" ] ; then
100 mysqladmin
-h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" create
"$RO_DB_NAME"
101 echo "CREATE USER '${RO_DB_USER}'@'%' IDENTIFIED BY '${RO_DB_PASSWORD}';" |
102 mysql
-h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" ||
echo "user ${RO_DB_USER} already created?"
103 echo "GRANT ALL PRIVILEGES ON ${RO_DB_NAME}.* TO '${RO_DB_USER}'@'%';" |
104 mysql
-h"$RO_DB_HOST" -uroot -p"$RO_DB_ROOT_PASSWORD" ||
echo "user ${RO_DB_USER} already granted?"
106 ${RO_PATH}/database_utils
/init_mano_db.sh
-u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
107 -P "${RO_DB_PORT}" -d "${RO_DB_NAME}" ||
exit 1
109 echo " migrate database version"
110 ${RO_PATH}/database_utils
/migrate_mano_db.sh
-u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
111 -P "$RO_DB_PORT" -d "$RO_DB_NAME" -b /var
/log
/osm
114 OVIM_PATH
=`python -c 'import lib_osm_openvim; print(lib_osm_openvim.__path__[0])'`
115 echo "OVIM_PATH: $OVIM_PATH"
116 if ! is_db_created
"$RO_DB_OVIM_HOST" "$RO_DB_OVIM_PORT" "$RO_DB_OVIM_USER" "$RO_DB_OVIM_PASSWORD" "$RO_DB_OVIM_NAME" \
119 if [ -n "$RO_DB_OVIM_ROOT_PASSWORD" ] ; then
120 mysqladmin
-h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" create
"$RO_DB_OVIM_NAME"
121 echo "CREATE USER '${RO_DB_OVIM_USER}'@'%' IDENTIFIED BY '${RO_DB_OVIM_PASSWORD}';" |
122 mysql
-h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" ||
123 echo "user ${RO_DB_OVIM_USER} already created?"
124 echo "GRANT ALL PRIVILEGES ON ${RO_DB_OVIM_NAME}.* TO '${RO_DB_OVIM_USER}'@'%';" |
125 mysql
-h"$RO_DB_OVIM_HOST" -uroot -p"$RO_DB_OVIM_ROOT_PASSWORD" ||
126 echo "user ${RO_DB_OVIM_USER} already granted?"
128 ${OVIM_PATH}/database_utils
/init_vim_db.sh
-u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST" \
129 -P "${RO_DB_OVIM_PORT}" -d "${RO_DB_OVIM_NAME}" ||
exit 1
131 echo " migrate database version"
132 ${OVIM_PATH}/database_utils
/migrate_vim_db.sh
-u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST"\
133 -P "$RO_DB_OVIM_PORT" -d "$RO_DB_OVIM_NAME" -b /var
/log
/osm
137 echo "4/4 Try to start"
138 # look for openmanod.cfg
139 RO_CONFIG_FILE
="/etc/osm/openmanod.cfg"
140 [ -f "$RO_CONFIG_FILE" ] || RO_CONFIG_FILE
=$
(python
-c 'import osm_ro; print(osm_ro.__path__[0])')/openmanod.cfg
141 [ -f "$RO_CONFIG_FILE" ] ||
! echo "configuration file 'openmanod.cfg' not found" ||
exit 1
143 openmanod
-c "$RO_CONFIG_FILE" --create-tenant=osm
# --log-file=/var/log/osm/openmano.log