[Freeswitch-users] FreeSWITCH-users Digest, Vol 68, Issue 22

Piyush Sharma piyush.sharma at coraltele.com
Mon Feb 6 08:15:43 MSK 2012


I am new to FreeSWITCH, I am telling you how I did it,
In autoload config there is a file cdr_csv.conf.xml there are few
queries written, I made my own according to my cdr requirement,

After that,
I wrote a function to insert into sql in mod_cdr_csv.c and called it
from my_on_reporting (written function in mod_cdr_cdv.c), and it made my
cdr to mysql.

On Mon, 2012-02-06 at 01:05 +0300,
freeswitch-users-request at lists.freeswitch.org wrote:
> Send FreeSWITCH-users mailing list submissions to
> 	freeswitch-users at lists.freeswitch.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> or, via email, send a message with subject or body 'help' to
> 	freeswitch-users-request at lists.freeswitch.org
> 
> You can reach the person managing the list at
> 	freeswitch-users-owner at lists.freeswitch.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of FreeSWITCH-users digest..."
> Today's Topics:
> 
>    1. Re: sip_gateway dialplan variable (Hynek Cihlar)
>    2. Re: vm_delete (Darcy)
>    3. Server with 2 NICS (Luis Daniel Lucio Quiroz)
>    4. how to store cdr data to sql dB (Sherif Omran)
>    5. Re: how to store cdr data to sql dB (Avi Marcus)
> MHTML Document attachment
> > -------- Forwarded Message --------
> > From: Hynek Cihlar <hynek.cihlar at gmail.com>
> > Reply-To: FreeSWITCH Users Help
> > <freeswitch-users at lists.freeswitch.org>
> > To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> > Subject: Re: [Freeswitch-users] sip_gateway dialplan variable
> > Date: Sun, 5 Feb 2012 19:41:26 +0100
> > 
> > Yes! Thanks for the tip!
> > 
> > Hynek
> > 
> > 
> > 
> > On Sun, Feb 5, 2012 at 11:12 AM, Avi Marcus <avi at avimarcus.net>
> > wrote:
> >         At worst, you can create a variable in the gateway settings
> >         so it populates a channel variable. I couldn't find the
> >         syntax on the wiki, though.. should make that easy to find.
> >         We need a real gateway page..
> >         
> >         -Avi
> >         
> >         
> >         On Wed, Feb 1, 2012 at 9:29 AM, Hynek Cihlar
> >         <hynek.cihlar at gmail.com> wrote:
> >                 Hello Mike and thanks for the reply.
> >                 
> >                 
> >                 Unfortunately sip_req_host only gives me the sip
> >                 host. My setup is probably not quite usual, I have a
> >                 multihome system with many gateways, each gateway
> >                 name assigned to a unique id. The unique id is
> >                 simply a random string identifying the gateway in
> >                 the whole system. The unique id is also persisted in
> >                 the DB, based on the id additional call processing
> >                 takes place. My initial idea was to get the gateway
> >                 name in the dialplan and pass it to an ESL app. But
> >                 it really looks like it is not possible to retrieve
> >                 the gateway name at all, sadly.
> >                 
> >                 Hynek
> >                 
> >                 
> >                 
> >                 On Tue, Jan 24, 2012 at 8:42 AM, Michael Lutz
> >                 <mytemike72 at gmail.com> wrote:
> >                         Hi Hynek,
> >                         
> >                         
> >                         {sip_req_host} should give your own gateway
> >                         (local), and {network_addr} should give the
> >                         remote gateway.
> >                         
> >                         
> >                         Otherwise writing a cdr and look will help
> >                         you with this.
> >                         
> >                         
> >                         Regards,
> >                         Mike
> >                         
> >                         Op 24 jan. 2012 om 08:27 heeft Hynek Cihlar
> >                         <hynek.cihlar at gmail.com> het volgende
> >                         geschreven:
> >                         
> >                         
> >                         
> >                         > In one of the examples on wiki I found
> >                         > ${sip_gateway}, but that doesn't seem to
> >                         > work. Also, there is ${sip_gateway_name},
> >                         > but that works on outbound calls only.
> >                         > 
> >                         > Hynek
> >                         > 
> >                         > 
> >                         > 
> >                         > On Mon, Jan 23, 2012 at 7:03 PM, Hynek
> >                         > Cihlar <hynek.cihlar at gmail.com> wrote:
> >                         >         Dear, is there a dialplan variable
> >                         >         that would hold the gateway name
> >                         >         an incoming call came through?
> >                         >         Searching through the source code
> >                         >         and wiki didn't yield any positive
> >                         >         result.
> >                         >         
> >                         >         
> >                         >         Thanks!
> >                         >         
> >                         >         
> >                         >         Hynek
> >                         >         
> >                         > 
> >                         > 
> >                         > _________________________________________________________________________
> >                         > Professional FreeSWITCH Consulting
> >                         > Services:
> >                         > consulting at freeswitch.org
> >                         > http://www.freeswitchsolutions.com
> >                         > 
> >                         > FreeSWITCH-powered IP PBX: The CudaTel
> >                         > Communication Server
> >                         > 
> >                         > 
> >                         > 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
> >                         
> >                         FreeSWITCH-powered IP PBX: The CudaTel
> >                         Communication Server
> >                         
> >                         
> >                         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
> >                 
> >                 FreeSWITCH-powered IP PBX: The CudaTel Communication
> >                 Server
> >                 
> >                 
> >                 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
> >         
> > 
> > 
> MHTML Document attachment
> > -------- Forwarded Message --------
> > From: Darcy <darcy at primrose.ws>
> > Reply-To: FreeSWITCH Users Help
> > <freeswitch-users at lists.freeswitch.org>
> > To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> > Subject: Re: [Freeswitch-users] vm_delete
> > Date: Sun, 5 Feb 2012 14:47:32 -0500
> > 
> > I did a work around, because I am running this from  a cgi, after I issue 
> > the command to the fs to delete the email, I actually delete the file with 
> > the cgi, not the best way, but it works until I find a seemless fix from fs.
> > 
> > Darcy
> > 
> > -----Original Message----- 
> > From: cogs66
> > Sent: Sunday, February 05, 2012 1:21 PM
> > To: freeswitch-users at lists.freeswitch.org
> > Subject: Re: [Freeswitch-users] vm_delete
> > 
> > Hi
> > 
> > I am experiencing the same but not been able to find a resolve to the issue
> > yet.
> > 
> > Thanks
> > 
> > Andy
> > 
> > --
> > View this message in context: 
> > http://freeswitch-users.2379917.n2.nabble.com/vm-delete-tp7255354p7256341.html
> > Sent from the freeswitch-users mailing list archive at Nabble.com.
> > 
> > _________________________________________________________________________
> > 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 
> > 
> > 
> > 
> > 
> MHTML Document attachment
> > -------- Forwarded Message --------
> > From: Luis Daniel Lucio Quiroz <luis.daniel.lucio at gmail.com>
> > Reply-To: FreeSWITCH Users Help
> > <freeswitch-users at lists.freeswitch.org>
> > To: freeswitch-users at lists.freeswitch.org
> > Subject: [Freeswitch-users] Server with 2 NICS
> > Date: Sun, 5 Feb 2012 09:07:01 -0600
> > 
> > Helo :)
> > 
> > I'm new to FS but not to linux. I've sucessfully install FS into a
> > centos 6.2. But I have an issue.
> > 
> > Server has 2 nics:
> > venet0: 10.9.19.5/16
> > eth0: <public IP>
> > 
> > when starting fs, it listen SIP (5060/udp) using venet0.  Phones can
> > register and they talk each other. However, we are using an external
> > GW and that fails. Doing a depth analisys I've realized that the
> > reason is that because venet0 is being used, SIP payload has venet0
> > within but server IP is eth0's so this is tipical mitchach.
> > 
> > I've sucessfully configure in vars.xml the local_ip4 (or whatever it
> > writes) to use public IP. but after that no phones are registering.
> > (before anyone says, yes phones points to public IP of course).  Nmap
> > reports that SIP (5060/udp) is listen by eth0 but when I got phone
> > SIP, i only get Registering request without  an answer.
> > 
> > I really need to make this listen in eth0.  What suggestion do you
> > have.  Please void telling me to turn of venet0 (not possible for
> > politics).
> > 
> > TIA
> > 
> > 
> MHTML Document attachment
> > -------- Forwarded Message --------
> > From: Sherif Omran <sherifomran2000 at yahoo.com>
> > Reply-To: FreeSWITCH Users Help
> > <freeswitch-users at lists.freeswitch.org>
> > To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> > Subject: [Freeswitch-users] how to store cdr data to sql dB
> > Date: Sun, 5 Feb 2012 14:00:10 -0800 (PST)
> > 
> > Hi guys,
> > 
> > any body knows how to store cdr data into mysql dB through xml-curl?
> > 
> > could you please help
> > 
> > thank you
> > kind regards
> > 
> > Sherif
> > 
> > 
> MHTML Document attachment
> > -------- Forwarded Message --------
> > From: Avi Marcus <avi at avimarcus.net>
> > Reply-To: FreeSWITCH Users Help
> > <freeswitch-users at lists.freeswitch.org>
> > To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> > Subject: Re: [Freeswitch-users] how to store cdr data to sql dB
> > Date: Mon, 6 Feb 2012 00:05:18 +0200
> > 
> > You must
> > mean http://wiki.freeswitch.org/wiki/Mod_xml_cdr or http://wiki.freeswitch.org/wiki/Xmlcdrd
> > xml_cdr "merely" posts the CDR data in XML form to a web page. You
> > can then have you python/perl/ruby/php/node.js/lua script pick out
> > the columns you want and save it to the mysql db.
> > If you want a php sample, fusionpbx has the open source code to save
> > to mysql, sqlite, or pg, via PDO.
> > 
> > 
> > -Avi
> > 
> > 
> > On Mon, Feb 6, 2012 at 12:00 AM, Sherif Omran
> > <sherifomran2000 at yahoo.com> wrote:
> >         Hi guys,
> >         
> >         any body knows how to store cdr data into mysql dB through
> >         xml-curl?
> >         
> >         could you please help
> >         
> >         thank you
> >         kind regards
> >         
> >         Sherif
> >         
> >         
> >         
> >         _________________________________________________________________________
> >         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
> >         
> > 
> > 
> _______________________________________________
> 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
-- 
Piyush Sharma <piyush.sharma at coraltele.com>




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