Initial OpenECOMP policy/docker commit

Change-Id: Ib37c3693614ee21a78f838e63eb40319cc85bdc6
Signed-off-by: Pamela Dragosh <pdragosh@research.att.com>

1 files changed, 38 insertions, 0 deletions

diff --git a/policy-db/dbinit.sh b/policy-db/dbinit.sh
new file mode 100644
index 00000000..19f4a5bd
--- /dev/null
+++ b/policy-db/dbinit.sh
@@ -0,0 +1,38 @@
+#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