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

[Emrah]

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