I became aware of the External DB Authentication plugin for WordPress (http://wordpress.org/extend/plugins/external-database-authentication/) in this thread:
http://moodle.org/mod/forum/discuss.php?d=64452
This seems like it would still require users to have to log in twice and that profiles could be maintained in two places. I'm wanting something a bit more seamless than that. Also, since our WordPressMU site will already be mature when we add Moodle, I prefer to use WordPressMU as the authentication store.
I was reading the documentation about single sign-on (SSO) between Moodle installations. Here is my understanding of how this works for an end user: if I am a member of MoodleSiteA and I visit MoodleSiteB then everything in MoodleSiteB acts as though I'm a member there, but my profile information is still maintained in MoodleSiteA. I wouldn't have to sign in to MoodleSiteB. I could still be added to a class site or anything else and still maintain my profile in MoodleSiteA.
If this understanding is correct, then it seems that the most seamless way to integrate the two products would be to write a WordPressMU plugin that would us the WordPress authentication store in a manner that emulates a Moodle site. Then a SSO connection could be made between a Moodle site and a WordPressMU site in the same manner that a SSO connection could be made between two Moodle sites.
I would also like to create some other plugins to display some information from Moodle on BuddyPress and WordPressMU pages. This type of integration seems to be the best way to accomplish that interaction as well.
In my mind I may also be oversimplyfying the technicalities of doing this--we'll see when I start digging into the code. Other than that though, does anyone see any glaring problems with this approach to integration? Does anyone have any better ideas?