8 echo "Wait until $max_attempts seconds for MySQL mano Server ${db_host}:${db_port} "
9 while ! mysqladmin
ping -h"$db_host" -P"$db_port" --silent; do
11 if [ $attempt -ge $max_attempts ]; then
13 echo "Can not connect to database ${db_host}:${db_port} during $max_attempts sec"
23 function is_db_created
() {
30 if mysqlshow
-h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" |
grep -v Wildcard |
grep -q $db_name; then
31 echo "DB $db_name exists"
34 echo "DB $db_name does not exist"
39 if [[ $OSMPOL_SQL_DATABASE_URI == *'mysql'* ]]; then
40 DB_HOST
=$
(echo $OSMPOL_SQL_DATABASE_URI |
sed -r 's|^.+://.+:.+@(.+):.*$|\1|')
41 DB_PORT
=$
(echo $OSMPOL_SQL_DATABASE_URI |
sed -r 's|^.+://.*:([0-9]+).*$|\1|')
42 DB_USER
=$
(echo $OSMPOL_SQL_DATABASE_URI |
sed -r 's|^.+://(.+):.+@.+$|\1|')
43 DB_PASSWORD
=$
(echo $OSMPOL_SQL_DATABASE_URI |
sed -r 's|^.+://.+:(.+)@.*$|\1|')
44 DB_NAME
=$
(echo $OSMPOL_SQL_DATABASE_URI |
sed -r 's|^.+://.+:.+@.+:.*/(\w+)(\?.*)?$|\1|')
46 wait_db
"$DB_HOST" "$DB_PORT" ||
exit 1
48 is_db_created
"$DB_HOST" "$DB_PORT" "$DB_USER" "$DB_PASSWORD" "$DB_NAME" && DB_EXISTS
="Y"
50 if [ -z $DB_EXISTS ]; then
51 mysql
-h"$DB_HOST" -P"$DB_PORT" -u"$DB_USER" -p"$DB_PASSWORD" --default_character_set utf8
-e "CREATE DATABASE $DB_NAME"