diff options
| -rw-r--r-- | packages/policy-xacmlpdp-tarball/src/main/resources/mysql/bin/create-guard-table.sh | 42 |
1 files changed, 40 insertions, 2 deletions
diff --git a/packages/policy-xacmlpdp-tarball/src/main/resources/mysql/bin/create-guard-table.sh b/packages/policy-xacmlpdp-tarball/src/main/resources/mysql/bin/create-guard-table.sh index 1c60cb0e..e7226078 100644 --- a/packages/policy-xacmlpdp-tarball/src/main/resources/mysql/bin/create-guard-table.sh +++ b/packages/policy-xacmlpdp-tarball/src/main/resources/mysql/bin/create-guard-table.sh @@ -1,4 +1,4 @@ -#!/bin/bash -xv +#!/bin/bash # # ============LICENSE_START======================================================= # Copyright (C) 2019 AT&T Intellectual Property. All rights reserved. @@ -20,4 +20,42 @@ # SQL_FILE="${POLICY_HOME}/mysql/sql/createguardtable.sql" -mysql -upolicy_user -ppolicy_user < "${SQL_FILE}" +# Remove escape backslashes if present and save output in temp file +sed 's/\\//g' "${POLICY_HOME}"/apps/guard/xacml.properties > /tmp/temp.xacml.properties + +# Remove temp file +if [ ! -f /tmp/temp.xacml.properties ] + then + echo "Temporary guard xacml properties file not found!" + exit 1 +fi + +# Extract Maria DB Credential properties from xacml.properties file +DB_HOSTNAME=$(awk -F[/:] '$1 == "javax.persistence.jdbc.url=jdbc" { print $3 $5 }' /tmp/temp.xacml.properties) +DB_USERNAME=$(awk -F= '$1 == "javax.persistence.jdbc.user" { print $2 }' /tmp/temp.xacml.properties) +DB_PASSWORD=$(awk -F= '$1 == "javax.persistence.jdbc.password" { print $2 }' /tmp/temp.xacml.properties | base64 -d) + +# Remove temp file +rm /tmp/temp.xacml.properties + +if [ -z "$DB_HOSTNAME" ] + then + echo "No Mariadb host provided in guard xacml.properties." + exit 2 +fi + +if [ -z "$DB_USERNAME" ] + then + echo "No Mariadb username provided in guard xacml.properties." + exit 2 +fi + +if [ -z "$DB_PASSWORD" ] + then + echo "No Mariadb password provided in guard xacml.properties." + exit 2 +fi + +# Execute mysql command using sql file to create table +mysql -u${DB_USERNAME} -p${DB_PASSWORD} -h${DB_HOSTNAME} < "${SQL_FILE}" + |