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@lists.freeswitch.org wrote:
Send FreeSWITCH-users mailing list submissions to freeswitch-users@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@lists.freeswitch.org
You can reach the person managing the list at freeswitch-users-owner@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@gmail.com> Reply-To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> To: FreeSWITCH Users Help <freeswitch-users@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@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@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@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@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@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@freeswitch.org > http://www.freeswitchsolutions.com > > FreeSWITCH-powered IP PBX: The CudaTel > Communication Server > http://www.cudatel.com > > Official FreeSWITCH Sites > http://www.freeswitch.org > http://wiki.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
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
MHTML Document attachment
-------- Forwarded Message -------- From: Darcy <darcy@primrose.ws> Reply-To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> To: FreeSWITCH Users Help <freeswitch-users@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@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.ht... Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
MHTML Document attachment
-------- Forwarded Message -------- From: Luis Daniel Lucio Quiroz <luis.daniel.lucio@gmail.com> Reply-To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> To: freeswitch-users@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@yahoo.com> Reply-To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> To: FreeSWITCH Users Help <freeswitch-users@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@avimarcus.net> Reply-To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> To: FreeSWITCH Users Help <freeswitch-users@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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
_______________________________________________ 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 -- Piyush Sharma <piyush.sharma@coraltele.com>