Grouper Users - Open Discussion List

[Shilen Patel <>]

Hi Michael,

I just created a jira for the first step of this effort:

https://bugs.internet2.edu/jira/browse/GRP-1445


The idea is that you can put triggers on the tables that you use for your
SQL jobs to update another table to indicate the subjects that have been
updated.  Then this new job will compare the subjects' groups in Grouper
and the source and make the appropriate changes.

There will be more after this including integration with messaging.
Perhaps using an ldap change log.  The persistent search idea is
interesting as well.  That may not handle deletes as well, but should be
fine for adds at least?

Thanks!

- Shilen

On 12/16/16, 4:55 PM, "Michael R Gettes" 
<>
 wrote:

>I know Chris has discussed in the past work going on for a real-time
>loader capability.
>
>i found 
>https://spaces.internet2.edu/display/Grouper/Grouper+loader+real+time+upda
>tes
>
>i poked around Jira and couldn¹t find an obvious jira item indicating any
>active work and the wiki page doesn¹t say which item and i didn¹t find
>any jira item pointing to the wiki page.
>
>I read the page - i thought there was an ability for SQL SELECT to
>persist looking for changes or to consult some table for changes in the
>DB - depending on the DB.  In LDAP, there is a V3 control for a
>persistent search.  I know 389 LDAP supports it.  I believe openldap does
>but have not tried to verify.  Wouldn¹t these be useful approaches?
>
>Anyway, a pointer the right Jira item would be appreciated and info about
>the future of this development is also appreciated.
>
>Thanks all - have a great weekend!
>
>/mrg
>