diff options
| author |   Jorge Hernandez <jh1730@att.com> | 2018-02-27 11:41:54 -0600 |
|---|---|---|
| committer | Jorge Hernandez <jh1730@att.com> | 2018-02-27 20:34:47 +0000 |
| commit | bd14de825f1ad7ce911162c659bd81725226232d (patch) | |
| tree | c6ee8fa12a6675604adc0b15280c0bc16212208b /config/db | |
| parent | 7228882abaed47068a8efd400ca7d2a13bfa1c6b (diff) | |
docker db image simplification
1. use mariadb image from docker registry to simplify set up.
2. remove harcoded root and user mariadb accounts
3. restrict access to user account to just specific databases.
Change-Id: Iaa916dbf2de2474fcc483a4be6167b4b92a2de61
Issue-ID: POLICY-650
Signed-off-by: Jorge Hernandez <jh1730@att.com>
Diffstat (limited to 'config/db')
| -rw-r--r-- | config/db/db.conf | 3 | ||||
| -rw-r--r-- | config/db/db.sh | 9 |
2 files changed, 12 insertions, 0 deletions
diff --git a/config/db/db.conf b/config/db/db.conf new file mode 100644 index 00000000..958f8bf0 --- /dev/null +++ b/config/db/db.conf @@ -0,0 +1,3 @@ +MYSQL_ROOT_PASSWORD=secret +MYSQL_USER=policy_user +MYSQL_PASSWORD=policy_user diff --git a/config/db/db.sh b/config/db/db.sh new file mode 100644 index 00000000..0de1deb1 --- /dev/null +++ b/config/db/db.sh @@ -0,0 +1,9 @@ +#!/bin/bash -xv + +for db in support onap_sdk log +do + mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "CREATE DATABASE IF NOT EXISTS ${db};" + mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "GRANT ALL PRIVILEGES ON \`${db}\`.* TO '${MYSQL_USER}'@'%' ;" +done + +mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "FLUSH PRIVILEGES;" |