diff options
author | 2018-02-27 11:41:54 -0600 | |
---|---|---|
committer | 2018-02-27 20:34:47 +0000 | |
commit | bd14de825f1ad7ce911162c659bd81725226232d (patch) | |
tree | c6ee8fa12a6675604adc0b15280c0bc16212208b /policy-db/dbinit.sh | |
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 'policy-db/dbinit.sh')
-rw-r--r-- | policy-db/dbinit.sh | 38 |
1 files changed, 0 insertions, 38 deletions
diff --git a/policy-db/dbinit.sh b/policy-db/dbinit.sh deleted file mode 100644 index 19f4a5bd..00000000 --- a/policy-db/dbinit.sh +++ /dev/null @@ -1,38 +0,0 @@ -#sed -i '/^bind-address/s/127\.0\.0\.1/0.0.0.0/' /etc/mysql/my.cnf -cat >/etc/mysql/conf.d/policy.cnf <<-'EOF' - [mysqld] - lower_case_table_names = 1 - bind-address = 0.0.0.0 -EOF - -echo "Starting mysqld" -service mysql start - -echo "Run mysql_secure_installation" -/usr/bin/mysql_secure_installation <<-EOF - - y - secret - secret - y - y - y - y -EOF - -echo "Creating db schemas and user" -mysql -uroot -psecret <<-EOF - create database xacml; - create database log; - create database support; - create table support.db_version(the_key varchar(20) not null, version varchar(20), primary key(the_key)); - insert into support.db_version values('VERSION', '00'); - insert into support.db_version values('DROOLS_VERSION', '00'); - create user 'policy_user'@'localhost' identified by 'policy_user'; - grant all privileges on *.* to 'policy_user'@'localhost' with grant option; - flush privileges; - select * from support.db_version; -EOF - -echo "Stopping mysqld" -service mysql stop |