Forum OpenACS Development: Re: RFC: External Authentication
Can you (or others) tell us more about the details of loading user information from a remote system in batch?
We're looking at the IMS Enterprise v 1.1 specification:
You can see our current detailed design here:
Is this what's needed?
How are you doing this at Galileo?
One thing the IMS spec does not talk about it how to get the XML document in the first place. SMB, FTP, HTTP, SOAP ...
Any input on how we should do this?
Does anybody know how Blackboard or any of the other giants do this?
We could really use some feedback from the "real world" on this.
> information from a remote system in batch?
> How are you doing this at Galileo?
Right now we just configured our AOLServer to connect to two databases. The GES database and the University's database - we're lucky that both run Oracle. We have a scheduled tcl procedure that digs in both databases, figures out what changed and updates the GES database accordingly.
We've also built a lot of administrative pages that let you figure out if a particular user is out of sync. Check what happened during the last sync, etc. There's one particularly useful page that lets you merge two users. The cool thing about this page is that, unlike the original merge page which would break whenever a module added a FK to the users table, it looks at the metadata that Oracle stores and figures out from which tables it has to move/delete info in order to merge the users. So even if other programmers add tables and modules that use the users table the merge page still works. I can give you the source code if you want it... altough it only works in Oracle... I don't know enough PostgreSQL to know if it's even possible there...
> Is this what's needed? (* Referring to IMS *)
I don't know! I'll read the standard and come back with more comments.