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

Mon Jun 17 20:26:00 MSD 2013

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