Story #54 - Tool to reset password of the "gluster" user

2 files changed, 5 insertions, 8 deletions

diff --git a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql
index fdde5823..4f61fc9d 100644
--- a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql
+++ b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql
@@ -1,11 +1,11 @@
 create table users(
-	username varchar(50) not null primary key,
-    password varchar(50) not null,
+	username varchar(32) not null primary key,
+    password varchar(124) not null,
     enabled smallint not null
     );
 
  create table authorities (
- 	username varchar(50) not null,
+ 	username varchar(32) not null,
     authority varchar(50) not null,
     constraint fk_authorities_users foreign key(username) references users(username));
     create unique index ix_auth_username on authorities (username,authority);
@@ -21,6 +21,6 @@ create table group_authorities (
 
 create table group_members (
 	id bigint generated by default as identity(start with 0) primary key, 
-	username varchar(50) not null, 
+	username varchar(32) not null, 
 	group_id bigint not null, 
 	constraint fk_group_members_group foreign key(group_id) references groups(id));
diff --git a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql
index 35ccf965..5bd73813 100644
--- a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql
+++ b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql
@@ -1,11 +1,9 @@
 -- Create users
-insert into users(username, password, enabled) values ('gluster','gluster',1);
-insert into users(username, password, enabled) values ('guest','guest',1);
+insert into users(username, password, enabled) values ('gluster','syst3m',1);
 
 -- Assign authorities to users (to be removed after implementing user group functionality)
 insert into authorities(username,authority) values ('gluster','ROLE_USER');
 insert into authorities(username,authority) values ('gluster','ROLE_ADMIN');
-insert into authorities(username,authority) values ('guest','ROLE_USER');
 
 -- Create user groups
 insert into groups(group_name) values ('Users');
@@ -17,5 +15,4 @@ insert into group_authorities(group_id, authority) select id,'ROLE_USER' from gr
 insert into group_authorities(group_id, authority) select id,'ROLE_ADMIN' from groups where group_name='Administrators';
 
 -- Assign group members
-insert into group_members(group_id, username) select id,'guest' from groups where group_name='Users';
 insert into group_members(group_id, username) select id,'gluster' from groups where group_name='Administrators';
\ No newline at end of file