diff options
Diffstat (limited to 'csit/config/db/db.sh')
| -rwxr-xr-x | csit/config/db/db.sh | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/csit/config/db/db.sh b/csit/config/db/db.sh index d1300091..0363ed8a 100755 --- a/csit/config/db/db.sh +++ b/csit/config/db/db.sh @@ -1,5 +1,6 @@ #!/bin/bash -xv # Copyright 2019,2021 AT&T Intellectual Property. All rights reserved +# Modifications Copyright (c) 2022 Nordix Foundation. # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. @@ -13,10 +14,11 @@ # See the License for the specific language governing permissions and # limitations under the License. -for db in migration pooling policyadmin operationshistory clampacm +for db in migration pooling policyadmin operationshistory clampacm policyclamp do mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "CREATE DATABASE IF NOT EXISTS ${db};" mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "GRANT ALL PRIVILEGES ON \`${db}\`.* TO '${MYSQL_USER}'@'%' ;" done mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "FLUSH PRIVILEGES;" +mysql -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" -f policyclamp < /tmp/policy-clamp-create-tables.sql |