[Building Sakai] External users and properties

[Matthew Jones]

I guess I didn't read that they were already using it.

Nothing in Sakai should be using it for provided users and I've seen it to
fail in the past, possibly because of this constraint and the inability to
add provided user id's to this table, or possibly something else. In any
case, these table look like they have basically the same function, just
PREFERENCES has an base64 encoded XML blob and no limit on the length of
the property name.

Maybe some other types of preference ids were meant to be stored in there
too? There isn't a UI for either table in the admin workspace, so hard to
tell.


On Thu, Mar 28, 2013 at 6:26 PM, Aaron Zeckoski <azeckoski at unicon.net>wrote:

> The file you are referring to has not changed since 2008.
> /sakai-kernel-impl/src/main/sql/mysql/sakai_user.sql
>
> It also appears that constraint exists in 2.7 and 2.8 so I don't think
> this is anything new. I might be that you removed the constraint
> previously in your DB or something like that. If that worked for you
> before then you should be safe to continue doing this probably.
>
> -AZ
>
>
> 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"
>
>
>
> --
> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
> _______________________________________________
> 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/ed08e530/attachment.html