[Freeswitch-users] postgresql

Vik Killa vipkilla at gmail.com
Thu Jan 15 16:12:19 MSK 2015


There is a fairly new module called mod_odbc_cdr.
If you're looking to inject any channel variable directly into a database
you can use that module. It supports multiple tables and field
customization.

On Wed, Jan 14, 2015 at 10:30 PM, Michael Collins <msc at freeswitch.org>
wrote:

> Also, most web servers are designed to handle many multiple requests. If
> you have a robust web server/db backend then you can scale as needed and do
> failover, etc.
>
> -MC
>
> On Tue, Jan 13, 2015 at 11:53 PM, John Nash <john.nash778 at gmail.com>
> wrote:
>
>> OK I see the point of manipulating CDR data (Even bill CDR as you said).
>> I am just trying to figure out best approach. But I also see a downside of
>> http post as it will keep web server busy too for each call made specially
>> in high volume systems (Assuming user portal/reporting also are being used
>> on same web server)
>>
>> On the other hand if pg_cdr module is used with postgres function we can
>> manipulating CDR too without keeping web server busy.
>>
>>
>>
>>
>>
>> On Wed, Jan 14, 2015 at 1:15 PM, Michael Collins <msc at freeswitch.org>
>> wrote:
>>
>>> I think David and I agree on these two basic points regarding
>>> mod_xml_curl:
>>> You can validate/manipulate/massage the data prior to insertion
>>> It's uncomplicated, flexible, and reliable
>>>
>>> As for connection pooling I'll have to defer to those who use
>>> mod_cdr_pg_csv.
>>> -MC
>>>
>>>
>>> On Tue, Jan 13, 2015 at 11:33 PM, John Nash <john.nash778 at gmail.com>
>>> wrote:
>>>
>>>> Hello David and Michael,
>>>>
>>>> As per this page
>>>> https://freeswitch.org/confluence/display/FREESWITCH/mod_cdr_pg_csv we
>>>> can define disk spooling in case of insert failure. What are the other
>>>> advantages of xml_cdr over cdr_pg_csv?
>>>>
>>>> Also does cdr_pg_csv use connection pooling?
>>>>
>>>> Regards
>>>>
>>>> Manoj
>>>>
>>>> On Wed, Jan 14, 2015 at 9:05 AM, David Villasmil Govea <
>>>> david.villasmil at gmail.com> wrote:
>>>>
>>>>> You can even do the billing with it... I've had it running in
>>>>> production for years, not a single issue...
>>>>> Is it an absolute requirement to log directly to the database? There
>>>>> has been thorough and intense discussion on this list over the years as to
>>>>> why this is/isn't a good idea. IMHO the best option is to use mod_xml_cdr
>>>>> (see https://wiki.freeswitch.org/wiki/Mod_xml_cdr). It lets you post
>>>>> to a database and store on disk in case of failure. It's also pretty easy
>>>>> to use and lets you do logic/validation prior to storing in the db.
>>>>>
>>>>> -MC
>>>>>
>>>>>
>>>>> On Sat, Jan 10, 2015 at 12:33 PM, Nick Zaitsev <nick.zaitsev at mail.ru>
>>>>> wrote:
>>>>>
>>>>>> Good day to you,
>>>>>> Please,advise me, how can i use postgres schema in freeswitch config
>>>>>> (cdr_pg_csv.conf.xml)?
>>>>>>  I'd like to use cdr schema instead public, for example here
>>>>>>  <param name="db-info" value="host=localhost dbname=freeswitch
>>>>>> connect_timeout=10" />
>>>>>>
>>>>>> --
>>>>>> Nick Zaitsev
>>>>>>
>>>>>>
>>>>>> _________________________________________________________________________
>>>>>> Professional FreeSWITCH Consulting Services:
>>>>>> consulting at freeswitch.org
>>>>>> http://www.freeswitchsolutions.com
>>>>>>
>>>>>> Official FreeSWITCH Sites
>>>>>> http://www.freeswitch.org
>>>>>> http://confluence.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://confluence.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://confluence.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://confluence.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://confluence.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://confluence.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://confluence.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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150115/c8474d32/attachment-0001.html 


Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list