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

Tue Jun 18 10:46:18 MSD 2013

http://wiki.freeswitch.org/wiki/Mod_xml_curl

There are a few examples in different languages at the bottom of the
wikipage.

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/17/2013 09:26 AM, Emrah wrote:
> Thank you. Is there any example script I can use on the web server side or should I develop from scratch?
> 
> Thanks!
> On Jun 16, 2013, at 6:07 PM, William King <william.king at quentustech.com> wrote:
> 
>> 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
>>>
>>
>> _________________________________________________________________________
>> 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
> 