Removed drop user user statement

Removed drop user user statement to
address MariaDB issues.

Change-Id: I668a2e9b7143aa3cce7ab67604d3e82f89a826d1
Issue-ID: SO-1674
Signed-off-by: Ramesh Parthasarathy(rp6768)<ramesh.parthasarathy@att.com>

diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/01-create-camundabpmn.sh b/volumes/mariadb/docker-entrypoint-initdb.d/01-create-camundabpmn.sh
index a12fd82..fdec4c3 100644 (file)
--- a/volumes/mariadb/docker-entrypoint-initdb.d/01-create-camundabpmn.sh
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/01-create-camundabpmn.sh
@@ -27,7 +27,6 @@ mysql -uroot -p$MYSQL_ROOT_PASSWORD << 'EOF' || exit 1
 DROP DATABASE IF EXISTS `camundabpmn`;
 CREATE DATABASE `camundabpmn`;
 DELETE FROM mysql.user WHERE User='camundauser';
-DROP USER IF EXISTS 'camundauser';
 CREATE USER 'camundauser';
 GRANT ALL on camundabpmn.* to 'camundauser' identified by 'camunda123' with GRANT OPTION;
 FLUSH PRIVILEGES;

diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/02-create-requestdb.sh b/volumes/mariadb/docker-entrypoint-initdb.d/02-create-requestdb.sh
index d09ce18..068a553 100644 (file)
--- a/volumes/mariadb/docker-entrypoint-initdb.d/02-create-requestdb.sh
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/02-create-requestdb.sh
@@ -27,7 +27,6 @@ mysql -uroot -p$MYSQL_ROOT_PASSWORD << 'EOF' || exit 1
 DROP DATABASE IF EXISTS `requestdb`;
 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `requestdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
 DELETE FROM mysql.user WHERE User='requestuser';
-DROP USER IF EXISTS 'requestuser';
 CREATE USER 'requestuser';
 GRANT ALL on requestdb.* to 'requestuser' identified by 'request123' with GRANT OPTION;
 FLUSH PRIVILEGES;

diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh b/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh
index 4cef914..0ce6c37 100644 (file)
--- a/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh
@@ -27,7 +27,6 @@ mysql -uroot -p$MYSQL_ROOT_PASSWORD << 'EOF' || exit 1
 DROP DATABASE IF EXISTS `catalogdb`;
 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `catalogdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
 DELETE FROM mysql.user WHERE User='cataloguser';
-DROP USER IF EXISTS 'cataloguser';
 CREATE USER 'cataloguser';
 GRANT ALL on catalogdb.* to 'cataloguser' identified by 'catalog123' with GRANT OPTION;
 FLUSH PRIVILEGES;

diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/04-create-so-user.sh b/volumes/mariadb/docker-entrypoint-initdb.d/04-create-so-user.sh
index 099d09f..307d553 100644 (file)
--- a/volumes/mariadb/docker-entrypoint-initdb.d/04-create-so-user.sh
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/04-create-so-user.sh
@@ -25,7 +25,6 @@ echo "Creating so user . . ." 1>/tmp/mariadb-so-user.log 2>&1
 
 mysql -uroot -p$MYSQL_ROOT_PASSWORD << 'EOF' || exit 1
 DELETE FROM mysql.user WHERE User='so_user';
-DROP USER IF EXISTS 'so_user';
 CREATE USER 'so_user';
 GRANT USAGE ON *.* TO 'so_user'@'%' IDENTIFIED BY 'so_User123';
 GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, SHOW VIEW ON `requestdb`.* TO 'so_user'@'%';

diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/05-create-so-admin.sh b/volumes/mariadb/docker-entrypoint-initdb.d/05-create-so-admin.sh
index 3b70d73..d31159a 100644 (file)
--- a/volumes/mariadb/docker-entrypoint-initdb.d/05-create-so-admin.sh
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/05-create-so-admin.sh
@@ -25,7 +25,6 @@ echo "Creating so admin user . . ." 1>/tmp/mariadb-so-admin.log 2>&1
 
 mysql -uroot -p$MYSQL_ROOT_PASSWORD << 'EOF' || exit 1
 DELETE FROM mysql.user WHERE User='so_admin';
-DROP USER IF EXISTS 'so_admin';
 CREATE USER 'so_admin';
 GRANT USAGE ON *.* TO 'so_admin'@'%' IDENTIFIED BY 'so_Admin123';
 GRANT ALL PRIVILEGES ON `camundabpmn`.* TO 'so_admin'@'%' WITH GRANT OPTION;