diff options
| author |   jhh <jorge.hernandez-herrero@att.com> | 2022-09-01 09:17:54 -0500 |
|---|---|---|
| committer | jhh <jorge.hernandez-herrero@att.com> | 2022-09-01 09:17:54 -0500 |
| commit | 545f221f4e4f734767d8b467d27a6ef67bd99720 (patch) | |
| tree | 2fb19c558cca30afa82410a27781ba774b7e699d /packages/policy-xacmlpdp-tarball/src/main/resources/postgres | |
| parent | bc80c460c83a8515b303b106cf22928de1f2ad11 (diff) | |
Compatibility with mariadb 10.x and mysql 8.x
Additional support for extra flags for example is secured mysql/mariadb server
is desired when provisioning tables at initialization.
Issue-ID: POLICY-4183
Issue-ID: POLICY-4340
Signed-off-by: jhh <jorge.hernandez-herrero@att.com>
Change-Id: Id873b3692237cd867815f2928b56492c9261082e
Diffstat (limited to 'packages/policy-xacmlpdp-tarball/src/main/resources/postgres')
| -rw-r--r-- | packages/policy-xacmlpdp-tarball/src/main/resources/postgres/bin/create-guard-table-pg.sh | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/packages/policy-xacmlpdp-tarball/src/main/resources/postgres/bin/create-guard-table-pg.sh b/packages/policy-xacmlpdp-tarball/src/main/resources/postgres/bin/create-guard-table-pg.sh index 1a71f8b4..bb2f2034 100644 --- a/packages/policy-xacmlpdp-tarball/src/main/resources/postgres/bin/create-guard-table-pg.sh +++ b/packages/policy-xacmlpdp-tarball/src/main/resources/postgres/bin/create-guard-table-pg.sh @@ -2,6 +2,7 @@ # # ============LICENSE_START======================================================= # Copyright (C) 2022 Nordix Foundation. All rights reserved. +# Modifications Copyright (C) 2022 AT&T Intellectual Property. # ================================================================================ # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. @@ -18,7 +19,11 @@ # SPDX-License-Identifier: Apache-2.0 # ============LICENSE_END========================================================= # + +set -x + SQL_FILE="${POLICY_HOME}/mysql/sql/createguardtable-pg.sql" +SQL_ADDON_FILE="${POLICY_HOME}/mysql/sql/db-pg.sql" # Remove escape backslashes if present and save output in temp file sed 's/\\//g' "${POLICY_HOME}"/apps/guard/xacml-pg.properties > /tmp/temp.xacml-pg.properties @@ -54,3 +59,10 @@ fi # Execute sql command using sql file to create table psql -U postgres -h ${DB_HOSTNAME} -f ${SQL_FILE} + +# Execute additional SQL configuration if provided +if [ -f "${POLICY_HOME}/mysql/sql/db-pg.sql" ]; then + echo "additional SQL to be loaded found" + psql -U postgres -h ${DB_HOSTNAME} -f ${SQL_ADDON_FILE} +fi + |