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.-MCOn Tue, Jan 13, 2015 at 11:53 PM, John Nash <john.nash778@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@freeswitch.org> wrote:-MCAs for connection pooling I'll have to defer to those who use mod_cdr_pg_csv.I think David and I agree on these two basic points regarding mod_xml_curl:It's uncomplicated, flexible, and reliable
You can validate/manipulate/massage the data prior to insertionOn Tue, Jan 13, 2015 at 11:33 PM, John Nash <john.nash778@gmail.com> wrote:ManojRegardsAlso does cdr_pg_csv use connection pooling?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?On Wed, Jan 14, 2015 at 9:05 AM, David Villasmil Govea <david.villasmil@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.-MCOn Sat, Jan 10, 2015 at 12:33 PM, Nick Zaitsev <nick.zaitsev@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@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@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@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@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@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@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@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@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@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@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@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@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org