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). 

It's a lot of work, but it's worth doing. 

- BDF

Thank you,

Brian Foster
Project Manager/Owner's Representative
Davri Investments, Incorporated
P: +1-317-787-2686
M: +1-317-600-9753
Indianapolis, Indiana


On Wed, Jun 12, 2013 at 9:58 AM, Steven Ayre <steveayre@gmail.com> wrote:
>From within FS for ODBC this is probably best practice:

http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh#User_Directory_XML

Being Lua means it's very easy to customise the queries / results.

-Steve




On 12 June 2013 14:51, Steven Ayre <steveayre@gmail.com> wrote:
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.

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.

As far as the API goes check the contrib repository - there are some examples in there you could 'borrow'.

-Steve



On 12 June 2013 12:33, Emrah <lists@kavun.ch> wrote:
Hi all,

What is the best practice today to handle users directory dynamically through a database, ideally PostgreSQL or MySQL?
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?
How about monitoring registration states?

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.

Your help would be greatly appreciated.

Thanks,
E
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org



_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org