You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@airavata.apache.org by "Marcus Christie (JIRA)" <ji...@apache.org> on 2017/06/14 14:05:00 UTC
[jira] [Commented] (AIRAVATA-2438) Cannot clone or share old
experiments
[ https://issues.apache.org/jira/browse/AIRAVATA-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16049210#comment-16049210 ]
Marcus Christie commented on AIRAVATA-2438:
-------------------------------------------
This is coming from the fact that Keycloak lowercases usernames. PGA is comparing the logged in username proderoma2017 against who has read/write permissions but the permissions are going to say that ProdEroma2017 has read/write permissions. So the comparison fails.
One way to fix this for legacy accounts is to update all records in the database to lowercase those usernames. I did some research to see which tables and columns would need to be updated:
* app catalog - none
* exp catalog
** GATEWAY - REQUESTER_USERNAME
** USERS - AIRAVATA_INTERNAL_USER_ID, USER_NAME
** GATEWAY_WORKER - USER_NAME
** PROJECT - USER_NAME
** PROJECT_USER - USER_NAME
** EXPERIMENT - USER_NAME
** PROCESS - USERNAME
* credential store
** CREDENTIALS - PORTAL_USER_ID
* replica catalog - none
* workflow catalog - none
* sharing catalog
** SHARING_USER - USER_ID, USER_NAME
** USER_GROUP - OWNER_ID
** ENTITY - OWNER_ID
** SHARING - GROUP_ID
* profile service
** GATEWAY - REQUESTER_USERNAME
** USER_PROFILE - AIRAVATA_INTERNAL_USER_ID, USER_ID
** USER_PROFILE_EMAIL - AIRAVATA_INTERNAL_USER_ID
** USER_PROFILE_PHONE - AIRAVATA_INTERNAL_USER_ID
> Cannot clone or share old experiments
> -------------------------------------
>
> Key: AIRAVATA-2438
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2438
> Project: Airavata
> Issue Type: Bug
> Components: PGA PHP Web Gateway
> Affects Versions: 0.17
> Environment: http://149.165.156.11/
> Reporter: Eroma
> Assignee: Marcus Christie
> Fix For: 0.17
>
>
> After the password reset with initial keycloak login cannot clone or share existing old experiments. Clone and Share buttons are not visible.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)