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 2020/02/26 15:58:00 UTC
[jira] [Commented] (AIRAVATA-3296) Missing sharing_catalog records
for credential
[ https://issues.apache.org/jira/browse/AIRAVATA-3296?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17045645#comment-17045645 ]
Marcus Christie commented on AIRAVATA-3296:
-------------------------------------------
Here's how I manually fixed this by creating a ENTITY/SHARING records for each credential:
{code:sql}
MariaDB [sharing_catalog]> begin;
Query OK, 0 rows affected (0.00 sec)
MariaDB [sharing_catalog]> set @token = @deftoken;
Query OK, 0 rows affected (0.00 sec)
MariaDB [sharing_catalog]> select @token;
+--------------------------------------+
| @token |
+--------------------------------------+
| 3d65bf6d-2c9f-4166-a51b-e76e0022bd3b |
+--------------------------------------+
1 row in set (0.00 sec)
MariaDB [sharing_catalog]> set @domain = 'seagrid';
Query OK, 0 rows affected (0.00 sec)
MariaDB [sharing_catalog]> set @etid = 'seagrid:CREDENTIAL_TOKEN';
Query OK, 0 rows affected (0.00 sec)
MariaDB [sharing_catalog]> set @owner = 'admin@seagrid';
Query OK, 0 rows affected (0.00 sec)
MariaDB [sharing_catalog]> set @ptid = 'seagrid:OWNER';
Query OK, 0 rows affected (0.00 sec)
MariaDB [sharing_catalog]> insert into ENTITY (ENTITY_ID, DOMAIN_ID, ENTITY_TYPE_ID, OWNER_ID, NAME, DESCRIPTION, ORIGINAL_ENTITY_CREATION_TIME, CREATED_TIME, UPDATED_TIME)
-> values (@token, @domain, @etid, @owner, @token, @token, UNIX_TIMESTAMP() * 1000, UNIX_TIMESTAMP() * 1000, UNIX_TIMESTAMP() * 1000);
Query OK, 1 row affected (0.01 sec)
MariaDB [sharing_catalog]> insert into SHARING (PERMISSION_TYPE_ID, ENTITY_ID, DOMAIN_ID, GROUP_ID, SHARING_TYPE, INHERITED_PARENT_ID, CREATED_TIME, UPDATED_TIME)
-> values (@ptid, @token, @domain, @owner, 'DIRECT_CASCADING', @token, UNIX_TIMESTAMP() * 1000, UNIX_TIMESTAMP() * 1000);
Query OK, 1 row affected (0.01 sec)
MariaDB [sharing_catalog]> select * from ENTITY where ENTITY_TYPE_ID = @etid and OWNER_ID = @owner;
+--------------------------------------+-----------+--------------------------+---------------+------------------+--------------------------------------+-------------------------------------------+-------------+-----------+--------------+-------------------------------+---------------+---------------+
| ENTITY_ID | DOMAIN_ID | ENTITY_TYPE_ID | OWNER_ID | PARENT_ENTITY_ID | NAME | DESCRIPTION | BINARY_DATA | FULL_TEXT | SHARED_COUNT | ORIGINAL_ENTITY_CREATION_TIME | CREATED_TIME | UPDATED_TIME |
+--------------------------------------+-----------+--------------------------+---------------+------------------+--------------------------------------+-------------------------------------------+-------------+-----------+--------------+-------------------------------+---------------+---------------+
| 1fbb3180-f7fe-479b-ab60-2633cd369dd3 | seagrid | seagrid:CREDENTIAL_TOKEN | admin@seagrid | NULL | 1fbb3180-f7fe-479b-ab60-2633cd369dd3 | | NULL | NULL | 3 | 1572800293247 | 1572800293247 | 1572800293247 |
| 3d65bf6d-2c9f-4166-a51b-e76e0022bd3b | seagrid | seagrid:CREDENTIAL_TOKEN | admin@seagrid | NULL | 3d65bf6d-2c9f-4166-a51b-e76e0022bd3b | 3d65bf6d-2c9f-4166-a51b-e76e0022bd3b | NULL | NULL | 0 | 1582732292000 | 1582732292000 | 1582732292000 |
| 6f53ac94-9708-497c-964a-e3dd68ef7be1 | seagrid | seagrid:CREDENTIAL_TOKEN | admin@seagrid | NULL | 6f53ac94-9708-497c-964a-e3dd68ef7be1 | Default SSH Key | NULL | NULL | 4 | 1572800091527 | 1572800091527 | 1572800091527 |
| c45d4eb1-c219-407a-b0dc-8c547673d4fc | seagrid | seagrid:CREDENTIAL_TOKEN | admin@seagrid | NULL | c45d4eb1-c219-407a-b0dc-8c547673d4fc | Keycloak admin password for realm seagrid | NULL | NULL | 3 | 1572800293292 | 1572800293292 | 1572800293292 |
+--------------------------------------+-----------+--------------------------+---------------+------------------+--------------------------------------+-------------------------------------------+-------------+-----------+--------------+-------------------------------+---------------+---------------+
4 rows in set (0.21 sec)
MariaDB [sharing_catalog]> set @token = @token1;
Query OK, 0 rows affected (0.00 sec)
MariaDB [sharing_catalog]> insert into ENTITY (ENTITY_ID, DOMAIN_ID, ENTITY_TYPE_ID, OWNER_ID, NAME, DESCRIPTION, ORIGINAL_ENTITY_CREATION_TIME, CREATED_TIME, UPDATED_TIME)
-> values (@token, @domain, @etid, @owner, @token, @token, UNIX_TIMESTAMP() * 1000, UNIX_TIMESTAMP() * 1000, UNIX_TIMESTAMP() * 1000);
Query OK, 1 row affected (0.00 sec)
MariaDB [sharing_catalog]> insert into SHARING (PERMISSION_TYPE_ID, ENTITY_ID, DOMAIN_ID, GROUP_ID, SHARING_TYPE, INHERITED_PARENT_ID, CREATED_TIME, UPDATED_TIME)
-> values (@ptid, @token, @domain, @owner, 'DIRECT_CASCADING', @token, UNIX_TIMESTAMP() * 1000, UNIX_TIMESTAMP() * 1000);
Query OK, 1 row affected (0.01 sec)
MariaDB [sharing_catalog]> commit;
Query OK, 0 rows affected (0.01 sec)
{code}
I had earlier queries for the @deftoken and @token1 token ids.
> Missing sharing_catalog records for credential
> ----------------------------------------------
>
> Key: AIRAVATA-3296
> URL: https://issues.apache.org/jira/browse/AIRAVATA-3296
> Project: Airavata
> Issue Type: Bug
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Priority: Major
>
> SEAGrid credentials in Default group resource profile are missing sharing_catalog records. Perhaps because the owning user is not in the sharing catalog.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)