<div dir="ltr">I'd use LDAP. Unfortunetly mod_ldap does not look as if it is being maintained, and from the looks of it the module needs a rewrite. So, use your new/existing openLDAP server (every company should have), and there are plenty of PHP examples on the interwebs to create a connector so FS can talk to the database via XML (you could use mod_xml_curl on FS side). <div>
<br></div><div style>It's a lot of work, but it's worth doing. </div><div style><br></div><div style>- BDF</div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr">Thank you,<div><br></div><div>Brian Foster</div>
<div>Project Manager/Owner's Representative</div><div>Davri Investments, Incorporated</div><div>P: +1-317-787-2686</div><div>M: +1-317-600-9753</div><div>Indianapolis, Indiana</div></div></div>
<br><br><div class="gmail_quote">On Wed, Jun 12, 2013 at 9:58 AM, Steven Ayre <span dir="ltr"><<a href="mailto:steveayre@gmail.com" target="_blank">steveayre@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
>From within FS for ODBC this is probably best practice:<div><br></div><div><a href="http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh#User_Directory_XML" target="_blank">http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh#User_Directory_XML</a></div>
<div><br></div><div>Being Lua means it's very easy to customise the queries / results.</div>
<div><br></div><div>-Steve</div><div class="HOEnZb"><div class="h5"><div><br></div><div><br></div><div><br><br><div class="gmail_quote">On 12 June 2013 14:51, Steven Ayre <span dir="ltr"><<a href="mailto:steveayre@gmail.com" target="_blank">steveayre@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Most people are probably using XML curl. It's very flexible and can scale quite well since you can point it at a load balanced farm of servers.<div>
<br></div><div>There's also a LDAP module if you're that way inclined. I don't think there's a module that'll talk directly to a ODBC database right now.</div>
<div><br></div><div>As far as the API goes check the contrib repository - there are some examples in there you could 'borrow'.<br><div><br></div><div>-Steve</div><div><div><div><br></div><div><br><br><div class="gmail_quote">
On 12 June 2013 12:33, Emrah <span dir="ltr"><<a href="mailto:lists@kavun.ch" target="_blank">lists@kavun.ch</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi all,<br>
<br>
What is the best practice today to handle users directory dynamically through a database, ideally PostgreSQL or MySQL?<br>
I'm kind of concerned by what I've seen so far in the available documentation. Do I really have to write an API to serve data from a DB to FreeSwitch?<br>
How about monitoring registration states?<br>
<br>
My goal is simple. I would like to have multiple FS instances share the same users directory and be able to tell on which server the client has registered.<br>
<br>
Your help would be greatly appreciated.<br>
<br>
Thanks,<br>
E<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br></div></div></div></div>
</blockquote></div><br></div>
</div></div><br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div>