<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hello Martin,<div><br></div><div>Using mod_roster_odbc should work very well in your case. I would use that approach.</div><div><br></div><div><div><div>Le 5 nov. 08 à 19:49, Martin Langhoff a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hi all!<br><br>For the OLPC School Server we are using ejabberd extensively -- so let<br>me preface this with a heartfelt *thanks* to all the dev team and<br>contributors for a fantastic piece of software.<br><br>One of the things ejabberd is doing for us is roster and presence<br>mgmt, which right now boils down to everyone having '@all@'. In other<br>words, no roster mgmt. For many reasons, we need to start doing<br>something smarter. The key ones are:<br><br> - We're starting to plan installations in very large schools (3K to 5K users)<br> - We now have a group / course mgmt tool on the school server (which<br>can feed roster info to ejabberd).<br><br>So I'd like to start driving the rosters that ejabberd publishes for<br>its users. My initial problem is that I don't have erlang or ejabberd<br>internals knowledge. So the obvious answer (write a custom mod_roster)<br>falls in the very hard basket.<br><br>My immedate alternatives seem to be<br><br> - Use mod_roster_odbc with a PostgreSQL backend (as we're using Pg<br>already). Does it work well? Does it scale well? How many queries to<br>the DB an I expect it to make? Does it behave well if an external tool<br>updates its tables?<br><br> - Keep using mod_roster, and write minimal erlang to write to the<br>mnesia tables that mod_roster uses. Is this feasible? Advisable?<br><br>Do we have other alternatives? I am very keen on understanding<br>ejabberd better, and I've been reading my new Erlang book -- but at<br>this stage I could very well be missing something big and obvious.<br><br>RTFM pointers welcome too :-)<br><br>cheers,<br><br><br>martin<br>--<br> <a href="mailto:martin.langhoff@gmail.com">martin.langhoff@gmail.com</a><br> <a href="mailto:martin@laptop.org">martin@laptop.org</a> -- School Server Architect<br> - ask interesting questions<br> - don't get distracted with shiny stuff - working code first<br> - <a href="http://wiki.laptop.org/go/User:Martinlanghoff">http://wiki.laptop.org/go/User:Martinlanghoff</a><br>_______________________________________________<br>ejabberd mailing list<br><a href="mailto:ejabberd@jabber.ru">ejabberd@jabber.ru</a><br><a href="http://lists.jabber.ru/mailman/listinfo/ejabberd">http://lists.jabber.ru/mailman/listinfo/ejabberd</a><br><br></div></blockquote></div><br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="font-size: 12px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>-- </div><div>Mickaël Rémond</div><div> <a href="http://www.process-one.net/">http://www.process-one.net/</a></div><div><br class="webkit-block-placeholder"></div></div></span></div></div></div></span><br class="Apple-interchange-newline"> </div><br></div></body></html>