This is an automated email from the ASF dual-hosted git repository.
yasithdev pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/airavata.git
The following commit(s) were added to refs/heads/master by this push:
new b379c3956a seed: register dev SFTP credential as sharing entity; set
gateway default token (#687)
b379c3956a is described below
commit b379c3956a607ec798bd7577350dc209168e3e32
Author: Yasith Jayawardana <[email protected]>
AuthorDate: Sat Jun 13 22:39:33 2026 -0400
seed: register dev SFTP credential as sharing entity; set gateway default
token (#687)
The seeded SFTP credential token had a credentials-store row but no sharing
registry entity, so getAllCredentialSummaries (sharing-scoped) returned
nothing
and /admin/credentials was empty; the gateway resource profile likewise
showed
no default SSH credential. Add the CREDENTIAL_TOKEN sharing entity + OWNER
grant
for default-admin (mirroring generateAndRegisterSSHKeys), and set
gateway_profile.CS_TOKEN to the token.
---
conf/db/seed.sql | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/conf/db/seed.sql b/conf/db/seed.sql
index 709e6b4324..6ade31bdb2 100644
--- a/conf/db/seed.sql
+++ b/conf/db/seed.sql
@@ -122,7 +122,7 @@ INSERT INTO `gateway_groups` (`GATEWAY_ID`,
`ADMINS_GROUP_ID`, `DEFAULT_GATEWAY_
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;
SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
-INSERT INTO `gateway_profile` (`GATEWAY_ID`, `CREATION_TIME`, `CS_TOKEN`,
`IDENTITY_SERVER_PWD_CRED_TOKEN`, `IDENTITY_SERVER_TENANT`, `UPDATE_TIME`)
VALUES ('default','2026-06-12 19:41:14.010000','','','default',NULL);
+INSERT INTO `gateway_profile` (`GATEWAY_ID`, `CREATION_TIME`, `CS_TOKEN`,
`IDENTITY_SERVER_PWD_CRED_TOKEN`, `IDENTITY_SERVER_TENANT`, `UPDATE_TIME`)
VALUES ('default','2026-06-12
19:41:14.010000','24bc9035-9bf9-4f4e-ad0b-0ca18651c475','','default',NULL);
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;
SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
@@ -268,6 +268,7 @@ SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
INSERT INTO `entity` (`ENTITY_ID`, `DOMAIN_ID`, `BINARY_DATA`, `CREATED_TIME`,
`DESCRIPTION`, `ENTITY_TYPE_ID`, `FULL_TEXT`, `NAME`,
`ORIGINAL_ENTITY_CREATION_TIME`, `OWNER_ID`, `PARENT_ENTITY_ID`,
`SHARED_COUNT`, `UPDATED_TIME`) VALUES
('9ccebd74-1dfb-404d-820d-be16c03af5b6','default',NULL,1781293276387,NULL,'default:GROUP_RESOURCE_PROFILE',NULL,'Dev
SLURM Group Resource
Profile',1781293276387,'default-admin@default',NULL,4,1781293276387);
INSERT INTO `entity` (`ENTITY_ID`, `DOMAIN_ID`, `BINARY_DATA`, `CREATED_TIME`,
`DESCRIPTION`, `ENTITY_TYPE_ID`, `FULL_TEXT`, `NAME`,
`ORIGINAL_ENTITY_CREATION_TIME`, `OWNER_ID`, `PARENT_ENTITY_ID`,
`SHARED_COUNT`, `UPDATED_TIME`) VALUES
('Default_Project_ec7e6de9-2270-4b42-92bb-8f923fb5aac0','default',NULL,1781293276487,'Default
project seeded for the dev stack','default:PROJECT',NULL,'Default
Project',1781293276487,'default-admin@default',NULL,NULL,1781293276487);
INSERT INTO `entity` (`ENTITY_ID`, `DOMAIN_ID`, `BINARY_DATA`, `CREATED_TIME`,
`DESCRIPTION`, `ENTITY_TYPE_ID`, `FULL_TEXT`, `NAME`,
`ORIGINAL_ENTITY_CREATION_TIME`, `OWNER_ID`, `PARENT_ENTITY_ID`,
`SHARED_COUNT`, `UPDATED_TIME`) VALUES
('slurm_Echo_da1c0c0f-5b47-4da2-a4fb-b6a6792b910d','default',NULL,1781293276460,'Echo
deployment on the dev SLURM
cluster','default:APPLICATION_DEPLOYMENT',NULL,'slurm_Echo_da1c0c0f-5b47-4da2-a4fb-b6a6792b910d',1781293276460,'default-admin@default',NULL,4
[...]
+INSERT INTO `entity` (`ENTITY_ID`, `DOMAIN_ID`, `BINARY_DATA`, `CREATED_TIME`,
`DESCRIPTION`, `ENTITY_TYPE_ID`, `FULL_TEXT`, `NAME`,
`ORIGINAL_ENTITY_CREATION_TIME`, `OWNER_ID`, `PARENT_ENTITY_ID`,
`SHARED_COUNT`, `UPDATED_TIME`) VALUES
('24bc9035-9bf9-4f4e-ad0b-0ca18651c475','default',NULL,1781293276500,'Dev
SFTP','default:CREDENTIAL_TOKEN',NULL,'24bc9035-9bf9-4f4e-ad0b-0ca18651c475',1781293276500,'default-admin@default',NULL,0,1781293276500);
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;
@@ -284,6 +285,7 @@ INSERT INTO `sharing` (`PERMISSION_TYPE_ID`,
`INHERITED_PARENT_ID`, `GROUP_ID`,
INSERT INTO `sharing` (`PERMISSION_TYPE_ID`, `INHERITED_PARENT_ID`,
`GROUP_ID`, `ENTITY_ID`, `DOMAIN_ID`, `CREATED_TIME`, `SHARING_TYPE`,
`UPDATED_TIME`) VALUES
('default:WRITE','slurm_Echo_da1c0c0f-5b47-4da2-a4fb-b6a6792b910d','Admin_Users_05989da3-cb34-4c74-8a73-3f44b6a6a2b2','slurm_Echo_da1c0c0f-5b47-4da2-a4fb-b6a6792b910d','default',1781293276471,'DIRECT_CASCADING',1781293276471);
INSERT INTO `sharing` (`PERMISSION_TYPE_ID`, `INHERITED_PARENT_ID`,
`GROUP_ID`, `ENTITY_ID`, `DOMAIN_ID`, `CREATED_TIME`, `SHARING_TYPE`,
`UPDATED_TIME`) VALUES
('default:OWNER','slurm_Echo_da1c0c0f-5b47-4da2-a4fb-b6a6792b910d','default-admin@default','slurm_Echo_da1c0c0f-5b47-4da2-a4fb-b6a6792b910d','default',1781293276462,'DIRECT_CASCADING',1781293276462);
INSERT INTO `sharing` (`PERMISSION_TYPE_ID`, `INHERITED_PARENT_ID`,
`GROUP_ID`, `ENTITY_ID`, `DOMAIN_ID`, `CREATED_TIME`, `SHARING_TYPE`,
`UPDATED_TIME`) VALUES
('default:READ','slurm_Echo_da1c0c0f-5b47-4da2-a4fb-b6a6792b910d','Read_Only_Admin_Users_d99f80d1-ddbb-4433-8fea-ca5c4ba1aa87','slurm_Echo_da1c0c0f-5b47-4da2-a4fb-b6a6792b910d','default',1781293276475,'DIRECT_CASCADING',1781293276475);
+INSERT INTO `sharing` (`PERMISSION_TYPE_ID`, `INHERITED_PARENT_ID`,
`GROUP_ID`, `ENTITY_ID`, `DOMAIN_ID`, `CREATED_TIME`, `SHARING_TYPE`,
`UPDATED_TIME`) VALUES
('default:OWNER','24bc9035-9bf9-4f4e-ad0b-0ca18651c475','default-admin@default','24bc9035-9bf9-4f4e-ad0b-0ca18651c475','default',1781293276500,'DIRECT_CASCADING',1781293276500);
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;
