[
https://issues.apache.org/jira/browse/AIRAVATA-2232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15705882#comment-15705882
]
Marcus Christie commented on AIRAVATA-2232:
-------------------------------------------
Here's the migration script for the dev database to populate the
credential_owner_type column with USER for any user credentials
{code:sql}
update dev_credentialstore_gw56.credentials
set credential_owner_type = 'USER'
where token_id in (
select resource_cs_token from
dev_appcatalog_gw56.USER_COMPUTE_RESOURCE_PREFERENCE
union
select RESOURCE_CS_TOKEN from dev_appcatalog_gw56.USER_STORAGE_PREFERENCE
UNION
select cs_token from dev_appcatalog_gw56.USER_RESOURCE_PROFILE
);
{code}
This isn't perfect since it only sets credential_owner_type='USER' for user
credentials that are associated with a user preference. It will miss unused
credentials.
> All SSH keys generated by a gateway admin are listed in user's settings -->
> credential store
> --------------------------------------------------------------------------------------------
>
> Key: AIRAVATA-2232
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2232
> Project: Airavata
> Issue Type: Bug
> Components: Airavata System, PGA PHP Web Gateway
> Environment: dev.seagrid.org
> Reporter: Eroma
> Assignee: Marcus Christie
>
> Gateway admins generates SSH keys for the gateway, to be used in community
> account usage. Also admins will generate SSH keys to be used with their own
> user settings for compute resources.
> All these keys are listed under users own credential store. Users own
> crendetial store should only have keys generated for own resource logins.
> This is through User settings in PGA.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
