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 18:29:00 GMT

    [ https://issues.apache.org/jira/browse/AIRAVATA-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16049491#comment-16049491
] 

Marcus Christie commented on AIRAVATA-2438:
-------------------------------------------


SQL scripts lowercase legacy usernames.

{code:sql}
-- experiment catalog
--- disable foreign key checks in MySQL/MariaDB
SET FOREIGN_KEY_CHECKS=0;
update GATEWAY set REQUESTER_USERNAME = lower(REQUESTER_USERNAME);
update USERS set AIRAVATA_INTERNAL_USER_ID = lower(AIRAVATA_INTERNAL_USER_ID), USER_NAME =
lower(USER_NAME);
update GATEWAY_WORKER set USER_NAME = lower(USER_NAME);
update PROJECT set USER_NAME = lower(USER_NAME);
update PROJECT_USER set USER_NAME = lower(USER_NAME);
update EXPERIMENT set USER_NAME = lower(USER_NAME);
update PROCESS set USERNAME = lower(USERNAME);
SET FOREIGN_KEY_CHECKS=1;
{code}




{code:sql}
-- credential store
update CREDENTIALS set PORTAL_USER_ID = lower(PORTAL_USER_ID);
{code}




{code:sql}
-- sharing catalog
--- disable foreign key checks in MySQL/MariaDB
SET FOREIGN_KEY_CHECKS=0;
update SHARING_USER set USER_ID = lower(USER_ID), USER_NAME = lower(USER_NAME);
update USER_GROUP set OWNER_ID = lower(OWNER_ID);
update ENTITY set OWNER_ID = lower(OWNER_ID);
update SHARING set GROUP_ID = lower(GROUP_ID);
SET FOREIGN_KEY_CHECKS=1;
{code}




{code:sql}
-- profile service
--- disable foreign key checks in MySQL/MariaDB
SET FOREIGN_KEY_CHECKS=0;
update GATEWAY set REQUESTER_USERNAME = lower(REQUESTER_USERNAME);
update USER_PROFILE set AIRAVATA_INTERNAL_USER_ID = lower(AIRAVATA_INTERNAL_USER_ID), USER_ID
= lower(USER_ID);
update USER_PROFILE_EMAIL set AIRAVATA_INTERNAL_USER_ID = lower(AIRAVATA_INTERNAL_USER_ID);
update USER_PROFILE_PHONE set AIRAVATA_INTERNAL_USER_ID = lower(AIRAVATA_INTERNAL_USER_ID);
SET FOREIGN_KEY_CHECKS=1;

{code}



> 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