COmanage Users List

[Duncan Brown <>]

Hi Scott,

That's the only entry for that identifier in the cm_identifiers table. Is 
there also another cm_co_ table that I should check?

Cheers,
Duncan.

MariaDB [registry]> select * from cm_identifiers where identifier = 
'';
+-----+----------------------------------------+------+-------+--------+--------------+-----------------+------------------+----------------------+---------------------------+---------------------+---------------------+---------------+----------+---------+----------------------------------------+
| id  | identifier                             | type | login | status | 
co_person_id | org_identity_id | co_department_id | source_identifier_id | 
co_provisioning_target_id | created             | modified            | 
identifier_id | revision | deleted | actor_identifier                       |
+-----+----------------------------------------+------+-------+--------+--------------+-----------------+------------------+----------------------+---------------------------+---------------------+---------------------+---------------+----------+---------+----------------------------------------+
| 287 |  | eppn |     1 | A      |      
   NULL |             247 |             NULL |                 NULL |         
             NULL | 2020-10-01 12:04:03 | 2020-10-01 12:22:24 |          NULL 
|        0 |       1 |  |
+-----+----------------------------------------+------+-------+--------+--------------+-----------------+------------------+----------------------+---------------------------+---------------------+---------------------+---------------+----------+---------+----------------------------------------+
1 row in set (0.00 sec)



> On Oct 2, 2020, at 11:56 AM, Scott Koranda <> 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