summaryrefslogtreecommitdiffstats
path: root/test/docker/docker-entrypoint-initdb.d/icinga.sh
blob: b0538d42549c5b65c7886c2b255ef468a9b92c7a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
#!/bin/bash

set -ex

: ${MYSQL_ROOT_PASSWORD:=}
: ${MYSQL_USER:=}

export MYSQL_PWD="${MYSQL_ROOT_PASSWORD}"

mysql -e "DROP DATABASE IF EXISTS icinga"
mysql -e "CREATE DATABASE icinga"
mysql -e "GRANT ALL ON icinga.* TO '${MYSQL_USER}'@'%'"
mysql -e "DROP DATABASE IF EXISTS icinga_legacy"
mysql -e "CREATE DATABASE icinga_legacy"
mysql -e "GRANT ALL ON icinga_legacy.* TO '${MYSQL_USER}'@'%'"
mysql icinga < /docker-entrypoint-initdb.d/icinga/ido-mysql.sql
mysql icinga < /docker-entrypoint-initdb.d/icinga/ido-data.sql
mysql icinga_legacy < /docker-entrypoint-initdb.d/icinga/ido-mysql.sql
mysql icinga_legacy < /docker-entrypoint-initdb.d/icinga/ido-legacy-data.sql