[Freeswitch-users] Designing a schema for CDRs
Dan-Cristian Bogos
danb.lists at gmail.com
Fri Jan 2 21:28:40 MSK 2015
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 at lists.freeswitch.org>:
> 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: 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 at gmail.com)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 2 Jan 2015 11:13:01 -0600
> From: Brian West <brian at freeswitch.org>
> Subject: Re: [Freeswitch-users] Control of IPv6 vs. IPv4
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> Message-ID:
> <CAEJMVkAvvyFtM7G0j7F-Z9=
> RxtBRt4RfR50JAkN9D85+8L-Jyw at 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 at 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 at 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 at 66.33.147.150 REGED
> >
> > external profile
> > sip:mod_sofia at 54.174.255.168:5080 RUNNING (0)
> >
> > external::switch2voip.us gateway
> > sip:XXXXXXXXXX at 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 at 54.174.255.168:5060 RUNNING (0)
> >
> >
> >
> =================================================================================================
> >
> > 4 profiles 1 alias
> >
> >
> >
> > freeswitch at ip-172-31-33-109.ec2.internal>
> >
> >
> >
> > Thanks,
> >
> >
> >
> > George
> >
> >
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services:
> > consulting at 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 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
> >
>
>
>
> --
>
> *Brian West*
> brian at 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 at gmail.com>
> Subject: Re: [Freeswitch-users] how can i stop freeswitch external
> profile listening on tcp port
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> Message-ID:
> <CAGVOjVVBgy6aMumXvz_=
> FU3H1r3W+ivaZGke__HiZ2F7_Tu94g at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Thank You!
>
> On 1 January 2015 at 23:28, David Villasmil Govea <
> david.villasmil at 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 at gmail.com> wrote:
> >
> >> Hello,
> >>
> >> I am newbie to freeswitch. When i run
> >>
> >> root at 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 at 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 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://confluence.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
> >
> -------------- 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 at gmail.com>
> Subject: Re: [Freeswitch-users] Designing a schema for CDRs
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> Message-ID: <54a6d8d3.6c47c20a.1b44.0acb at 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 at 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 at 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 at 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 at 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 at 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 at 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 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://confluence.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://confluence.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://confluence.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://confluence.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
> -------------- 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 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
>
>
> End of FreeSWITCH-users Digest, Vol 103, Issue 12
> *************************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150102/ef6d5dae/attachment-0001.html
Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users
mailing list