[Using Sakai] CAS issues

[Rafael Morales Gamboa]

Basically, it seems deleting a user in Sakai means removing the 
corresponding records in sakai_user and sakai_user_id_map, but 
everything else remains in place. So it was a matter of searching for 
the profile tables and identify the one that has information about my 
other accounts (ej. facebook, twitter), then copy the user_id and 
recreate the record in sakai_user_id_map.

Regards,
Rafael

On 21/08/2014 05:18 a. m., Steve Swinsburg wrote:
> Nice one. You should post your technique on list so others might be 
> able to use the same trick :)
>
>
> On Wed, Aug 20, 2014 at 4:19 PM, Rafael Morales Gamboa 
> <rmorales at suv.udg.mx <mailto:rmorales at suv.udg.mx>> wrote:
>
>     It worked! I found my USER_ID in the Profile2 tables and recreated
>     the record in sakai_user_id_map, and my account is back again!
>     Thank you very much Steve.
>
>     Regards,
>     Rafael
>
>
>     On 20/08/2014 01:16 a. m., Rafael Morales Gamboa wrote:
>>     Do you mean deleting the record in sakai_user without deleting
>>     the corresponding one in sakai_user_id_map? I guess to recover my
>>     account I need to find my old user_id and map it to my eid again
>>     in sakai_user_id_map, but where do I find it?
>>
>>     Regards,
>>     Rafael
>>
>>
>>     On 19/08/2014 06:05 a. m., Steve Swinsburg wrote:
>>>     Hi Rafael,
>>>
>>>     Before deleting user accounts, you'll need to merge them by
>>>     mapping the user ids in the sakai_user_id_map table.
>>>
>>>
>>>     On Tue, Aug 19, 2014 at 4:12 PM, Rafael Morales Gamboa
>>>     <rmorales at suv.udg.mx <mailto:rmorales at suv.udg.mx>> wrote:
>>>
>>>         Hello,
>>>
>>>         We have our Sakai (2.9.3) integrated to our CAS but do not
>>>         use the facilities to connect Sakai directly to the
>>>         administrative server, and we have found some issues I would
>>>         like to comment with you hoping I can get some help to solve
>>>         or bypass them.
>>>
>>>          1. Some of our postgraduate students took a selection
>>>             course before being accepted to our programmes, and they
>>>             were registered to Sakai with their email address as
>>>             EID. Now we are replacing their email with their
>>>             students id (known to CAS), and we have found that some
>>>             student ids where already used (the students had done an
>>>             undergraduate with us), but the users where not listed
>>>             in Sakai users because they were authenticated by CAS.
>>>
>>>             Is there a way for Sakai to list all users (Sakai's +
>>>             CAS' ever logged into Sakai)?
>>>
>>>          2. We have many accounts with two records: one in Sakai and
>>>             another in CAS, because we started using Sakai without
>>>             CAS. I deleted the Sakai record for one user (me), and
>>>             still can login using CAS, but I am now unsubscribed
>>>             from all sites I was subscribed before.
>>>
>>>             How can I delete the records for these accounts in Sakai
>>>             without loosing their site subscriptions?
>>>             How can I restore my old subscriptions?
>>>
>>>         Regards,
>>>         Rafael
>>>
>>>
>>>         _______________________________________________
>>>         sakai-user mailing list
>>>         sakai-user at collab.sakaiproject.org
>>>         <mailto:sakai-user at collab.sakaiproject.org>
>>>         http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>>>
>>>         TO UNSUBSCRIBE: send email to
>>>         sakai-user-unsubscribe at collab.sakaiproject.org
>>>         <mailto:sakai-user-unsubscribe at collab.sakaiproject.org> with
>>>         a subject of "unsubscribe"
>>>
>>>
>>
>>
>
>
>
>     _______________________________________________
>     sakai-user mailing list
>     sakai-user at collab.sakaiproject.org
>     <mailto:sakai-user at collab.sakaiproject.org>
>     http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
>     TO UNSUBSCRIBE: send email to
>     sakai-user-unsubscribe at collab.sakaiproject.org
>     <mailto:sakai-user-unsubscribe at collab.sakaiproject.org> with a
>     subject of "unsubscribe"
>
>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20140821/90f247a5/attachment.html