Hi Tayyab

Another option you can have  a look at is the CDR server integrated within CGRateS. You are not forced to any business logic (once stored the CDRs will be queriable/exportable over JSON APIs). You can use or not the rating which comes as bonus in this case and fields which go in are selectable in config templates.

DanB.

Am 02.01.2015 19:44 schrieb <freeswitch-users-request@lists.freeswitch.org>:
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: Control of IPv6 vs. IPv4 (Brian West)
   2. Re: how can i stop freeswitch external profile listening on
      tcp port (Aqs Younas)
   3. Re: Designing a schema for CDRs (tayyabatiq@gmail.com)


----------------------------------------------------------------------

Message: 1
Date: Fri, 2 Jan 2015 11:13:01 -0600
From: Brian West <brian@freeswitch.org>
Subject: Re: [Freeswitch-users] Control of IPv6 vs. IPv4
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Message-ID:
        <CAEJMVkAvvyFtM7G0j7F-Z9=RxtBRt4RfR50JAkN9D85+8L-Jyw@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

FreeSWITCH does one or the other, you should pick where you want your
gateway to register at, and only allow it there and there only.

On Fri, Jan 2, 2015 at 10:02 AM, George F. Phelps <GeorgePhelps@gfphelps.com
> wrote:

> My VoIP provider supports both IPv4 and IPV6 registrations.  I can only
> have one registration active at a time.  Freeswitch is attempting both IPv4
> and IPv6 connections.  Randomly, sometimes a IPv4 connection is the first
> (only) registration established; other times it is the IPv6 connection.
>
>
>
> How to I configure Freeswitch to deterministically only attempt one type
> (my choice of either IPv4 or IPv6) of connection?
>
>
>
> freeswitch@ip-172-31-33-109.ec2.internal> sofia status
>
>
>
>                      Name
> Type                                       Data      State
>
>
> =================================================================================================
>
>             external-ipv6       profile                   sip:mod_sofia@[::1]:5080
> RUNNING (0)
>
> external-ipv6::switch2voip.us   gateway
> sip:XXXXXXXXXX@66.33.147.150      REGED
>
>                  external       profile
> sip:mod_sofia@54.174.255.168:5080      RUNNING (0)
>
> external::switch2voip.us       gateway
> sip:XXXXXXXXXX@66.33.147.150      TRYING (retry: 20s)
>
>             172.31.33.109         alias
> internal      ALIASED
>
>             internal-ipv6       profile                   sip:mod_sofia@[::1]:5060
> RUNNING (0)
>
>                  internal       profile
> sip:mod_sofia@54.174.255.168:5060      RUNNING (0)
>
>
> =================================================================================================
>
> 4 profiles 1 alias
>
>
>
> freeswitch@ip-172-31-33-109.ec2.internal>
>
>
>
> Thanks,
>
>
>
> George
>
>
>
> _________________________________________________________________________
> 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
>



--

*Brian West*
brian@freeswitch.org


*Twitter: @FreeSWITCH , @briankwest*
http://www.freeswitchbook.com
http://www.freeswitchcookbook.com

*T:*+19184209001 | *F:*+19184209002 | *M:*+1918424WEST (9378)
*iNUM:*+883 5100 1420 9001 | *ISN:*410*543 | *Skype:*briankwest
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150102/42707527/attachment-0001.html

------------------------------

Message: 2
Date: Fri, 2 Jan 2015 22:13:20 +0500
From: Aqs Younas <aqsyounas@gmail.com>
Subject: Re: [Freeswitch-users] how can i stop freeswitch external
        profile listening on tcp port
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Message-ID:
        <CAGVOjVVBgy6aMumXvz_=FU3H1r3W+ivaZGke__HiZ2F7_Tu94g@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

Thank You!

On 1 January 2015 at 23:28, David Villasmil Govea <david.villasmil@gmail.com
> wrote:

> Well, you could just block that tcp port with iptables if you really want
> to...
> On Jan 1, 2015 12:44 PM, "Aqs Younas" <aqsyounas@gmail.com> wrote:
>
>> Hello,
>>
>> I am newbie to freeswitch. When i run
>>
>> root@66-226-74-508:~# netstat -nlp | grep freeswitch
>>
>> tcp        0      0 206.225.85.25:6020      0.0.0.0:*
>> LISTEN      4556/freeswitch
>> udp        0      0 206.225.85.25:6020      0.0.0.0:*
>> 4556/freeswitch
>>
>> i see freeswitch external profile listening over tcp and udp port. But i
>> only want external profile to listen over udp port. How can i do so?
>>
>> Thanks
>>
>> _________________________________________________________________________
>> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150102/81cd36ff/attachment-0001.html

------------------------------

Message: 3
Date: Fri, 2 Jan 2015 17:40:44 +0000
From: <tayyabatiq@gmail.com>
Subject: Re: [Freeswitch-users] Designing a schema for CDRs
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Message-ID: <54a6d8d3.6c47c20a.1b44.0acb@mx.google.com>
Content-Type: text/plain; charset="utf-8"

Thanks guys for the suggestions and information.

I did figure out that variables keep changing after I went through the source code. And it looks like fusionpbx takes a few values from CDR and drops everything else. I guess I can modify fusionpbx? parser and use that. This should solve my problem.






Sent from Windows Mail





From: David Villasmil Govea
Sent: ?Friday?, ?January? ?2?, ?2015 ?3?:?29? ?AM
To: FreeSWITCH Users Help





I recommend it only you need something very basic. You won't learn anything about freeSWITCH.

On Jan 1, 2015 5:27 PM, "Luis Daniel Lucio Quiroz" <luis.daniel.lucio@gmail.com> wrote:


Don't waste time, give a look into fusionpbx; it has what you are looking for

On Jan 1, 2015 2:32 PM, "David Villasmil Govea" <david.villasmil@gmail.com> wrote:


There's a very nice php sample somewhere in the git, it parses the XML and you can use it to validate fields,  do billing, whatever.

On Jan 1, 2015 2:16 PM, "Michael Collins" <msc@freeswitch.org> wrote:



It's also a good idea to validate field data before trying to write to your database. That way you could add fields that don't appear on every single call.


-Michael



On Thu, Jan 1, 2015 at 6:04 AM, Avi Marcus <avi@avimarcus.net> wrote:


Mod_xml_cdr gives you all the channel variables that you set, so it changes all the time.


If you want to save everything, you can't stuff that into columns in mysql/postgres...




You can pull out "common" fields for your schema, and then save the rest (if you want) as an XML or json object... or use a nosql DB so you don't need a schema.







-Avi





On Thu, Jan 1, 2015 at 12:19 PM, Tayyab Atiq <tayyabatiq@gmail.com> wrote:





Hi.



I have recently been trying to process CDR from mod_xml_cdr and store it in a db

I first parsed and wrote all the information in a file, then designed a database based on the fields that appeared in the file.

But it seems that FS adds/removes fields sometimes. This causes my query to fail as my program tries to insert columns that do not exist.




Is there a way to figure out all the possible fields that might appear in the xml sent by mod_xml_cdr?


_________________________________________________________________________
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150102/6b638261/attachment.html

------------------------------

_______________________________________________
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


End of FreeSWITCH-users Digest, Vol 103, Issue 12
*************************************************