[Freeswitch-users] Best practice for centralized user registration database

[William King]

It's a bad idea. Use mod_xml_curl instead. Let your web server access
your database directly.

William King
Senior Engineer
Quentus Technologies, INC
1037 NE 65th St Suite 273
Seattle, WA 98115
Main:   (877) 211-9337
Office: (206) 388-4772
Cell:   (253) 686-5518
william.king at quentustech.com

On 06/15/2013 08:50 AM, Emrah wrote:
> Hi William,
> 
> Do you know where I can find the documentation for using PGSQL to store configs, especially user directory entries?
> 
> Thanks!
> On Jun 12, 2013, at 12:51 PM, William King <william.king at quentustech.com> wrote:
> 
>> mod_xml_ldap is on a list to be rewritten. Currently there are 3 main
>> ways to solve this issue: mod_xml_curl, or mod_xml_radius or direct
>> pgsql access. There is another method that involves (re)generating the
>> static xml files, then calling reloadxml.
>>
>> William King
>> Senior Engineer
>> Quentus Technologies, INC
>> 1037 NE 65th St Suite 273
>> Seattle, WA 98115
>> Main:   (877) 211-9337
>> Office: (206) 388-4772
>> Cell:   (253) 686-5518
>> william.king at quentustech.com
>>
>> On 06/12/2013 09:01 AM, Brian Foster wrote:
>>> 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 at gmail.com
>>> <mailto:steveayre at 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 at gmail.com
>>>    <mailto:steveayre at 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 at kavun.ch
>>>        <mailto:lists at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>>>            http://www.freeswitchsolutions.com
>>>
>>>            
>>>            
>>>
>>>            Official FreeSWITCH Sites
>>>            http://www.freeswitch.org
>>>            http://wiki.freeswitch.org
>>>            http://www.cluecon.com
>>>
>>>            FreeSWITCH-users mailing list
>>>            FreeSWITCH-users at lists.freeswitch.org
>>>            <mailto:FreeSWITCH-users at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>>>    http://www.freeswitchsolutions.com
>>>
>>>    
>>>    
>>>
>>>    Official FreeSWITCH Sites
>>>    http://www.freeswitch.org
>>>    http://wiki.freeswitch.org
>>>    http://www.cluecon.com
>>>
>>>    FreeSWITCH-users mailing list
>>>    FreeSWITCH-users at lists.freeswitch.org
>>>    <mailto:FreeSWITCH-users at 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 at freeswitch.org
>>> http://www.freeswitchsolutions.com
>>>
>>> 
>>> 
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://wiki.freeswitch.org
>>> http://www.cluecon.com
>>>
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at 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 at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>