airavata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcus Christie (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AIRAVATA-2438) Cannot clone or share old experiments
Date Wed, 14 Jun 2017 14:05:00 GMT

    [ 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)

Mime
View raw message