[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