aboutsummaryrefslogtreecommitdiffstats
path: root/policy-db/dbinit.sh
diff options
context:
space:
mode:
authorJorge Hernandez <jh1730@att.com>2018-02-27 11:41:54 -0600
committerJorge Hernandez <jh1730@att.com>2018-02-27 20:34:47 +0000
commitbd14de825f1ad7ce911162c659bd81725226232d (patch)
treec6ee8fa12a6675604adc0b15280c0bc16212208b /policy-db/dbinit.sh
parent7228882abaed47068a8efd400ca7d2a13bfa1c6b (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.sh38
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