Skip to Content.
Sympa Menu

comanage-users - Re: [comanage-users] Deleting an eppn

Subject: COmanage Users List

List archive

Re: [comanage-users] Deleting an eppn


Chronological Thread 
  • From: Duncan Brown <>
  • To: William Kaufman <>
  • Cc: Scott Koranda <>, "" <>
  • Subject: Re: [comanage-users] Deleting an eppn
  • Date: Mon, 5 Oct 2020 16:41:23 +0000

Hi Bill,

This is the same use case for me. I'm testing with my ORCID to act like a
random user, rather than my own ePPN. I had an enrollment flow not complete,
so I wanted to expunge and try again. I ran your query and I see one
undeleted record:

MariaDB [registry]> select actor_identifier,deleted,modified from
cm_org_identities where actor_identifier like '%0000-0002-9180-5765%';
+----------------------------------------------+---------+---------------------+
| actor_identifier | deleted | modified
|
+----------------------------------------------+---------+---------------------+
| | 1 | 2020-10-01
12:20:55 |
| | 0 | 2020-09-29
16:08:18 |
| | 1 | 2020-10-01
12:22:24 |
+----------------------------------------------+---------+---------------------+
3 rows in set (0.03 sec)

Cheers,
Duncan.

> On Oct 2, 2020, at 1:53 PM, William Kaufman <> wrote:
>
> We have been seeing this issue for some time Scott.
>
> It is primarily around identities I am trying to use for Demos and Testing
> and I believe it is somehow tied to enrollments that go south somehow.
>
> I have a gmail account that has multiple deleted entries in the DB and I
> know there are others.
>
> mysql> select actor_identifier,deleted,modified from cm_org_identities
> where actor_identifier like '%%';
> +----------------------------------+---------+---------------------+
> | actor_identifier | deleted | modified |
> +----------------------------------+---------+---------------------+
> | | 1 | 2020-05-06 18:27:03 |
> | | 1 | 2020-05-06 18:43:17 |
> | | 1 | 2020-05-14 19:42:23 |
> +----------------------------------+---------+---------------------+
> 3 rows in set (0.00 sec)
>
> I cannot find any occurrence of a CO Person or Organizational Identity,
> however, if I try to enroll I get an error:
>
> The identifier "" is not registered. If
> your request for enrollment is still being processed, you will not be able
> to login until it is approved. Please contact an administrator for
> assistance.
>
> Thanks,
> ´╗┐Bill
>
>
> On 10/2/20, 11:56 AM, " on behalf of
> Scott Koranda" < on behalf of
> > wrote:
>
> Hi Duncan,
>
>> What's the right way to remove an eppn identity from COmanage so it
>> looks like that user never registered? I have tried expunging the CO
>> person, but if the same eppn tries to go back in and register, then I
>> get a permission denied error in the enrollment flow.
>>
>> Looking at the database, the expunged eppn is still there but marked
>> as deleted:
>>
>> | 287 | | eppn
>> | 1 | A | NULL | 247 | NULL |
>> NULL | NULL | 2020-10-01 12:04:03 | 2020-10-01
>> 12:22:24 | NULL | 0 | 1 |
>> |
>>
>> Should I just delete the identifiers manually in mariadb? I'm running
>> 3.2.4.
>
> Expunging the CO Person record should have worked because it should have
> also marked as deleted the Organizational Identity that had the ePPN
> identifier attached to it.
>
> Do you have another Organizational Identity in the same CO that has that
> ePPN as an identifier?
>
> Thanks,
>
> Scott
>

--

Duncan Brown Room 263-1, Physics Department
Charles Brightman Professor of Physics Syracuse University, NY 13244
Physics Graduate Program Director http://dabrown.expressions.syr.edu




Archive powered by MHonArc 2.6.19.

Top of Page