[Building Sakai] External users and properties

[Matthew Jones]

I believe that SAKAI_USER_PROPERTY was really meant for only storing
properties for internal users. What you'd want is to put your values in the
SAKAI_PREFERENCES table. Where bundles of properties are XML encoded and it
doesn't have any foreign keys.

We saw this with the tutorial tool that had errors when using the
properties table for provided users.
https://jira.sakaiproject.org/browse/SAK-22320

Editing the preferences external XML is more difficult outside of Sakai,
but the code for the UserDirectoryService properties verses
PreferenceService is almost the same.

There is at least 1 open issue with provided users and user properties (
https://jira.sakaiproject.org/browse/KNL-1014). I think we're not the only
ones confused with this! I'm not too sure you're want to risk taking away
that constraint, at least without figuring out the difference between the
SAKAI_USER_PROPERTIES and SAKAI_PREFERENCES..



On Thu, Mar 28, 2013 at 6:01 PM, Joshua Swink <joshua.swink at gmail.com>wrote:

> We store properties for external users in the SAKAI_USER_PROPERTY table.
> With Sakai 2.9.1, there is a constraint that prevents these properties from
> being saved. It only allows user properties for users who are in the
> SAKAI_USER table.
>
> kernel/kernel-impl/src/main/sql/mysql/sakai_user.sql:
>
> ALTER TABLE SAKAI_USER_PROPERTY
>        ADD  ( FOREIGN KEY (USER_ID)
>                              REFERENCES SAKAI_USER (USER_ID) ) ;
>
> I expect that this will be dealt with by removing the constraint, rather
> than adding all external users to SAKAI_USER, or going without saving these
> properties.
>
> These properties will be an important part of our workflow for the
> foreseeable future. I hope there aren't any serious repercussions to
> removing the constraint.
>
> Josh
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130328/fe9a08c3/attachment.html