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

Emrah lists at kavun.ch
Wed Jun 19 12:51:52 MSD 2013


Thanks a million will experiment a bit.

Take care!
On Jun 18, 2013, at 2:46 AM, William King <william.king at quentustech.com> wrote:

> 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
>> 
> 
> _________________________________________________________________________
> 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




Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list