[OpenSIPS-Users] Users Digest, Vol 69, Issue 32
frank fox
franklyfox at outlook.com
Fri Apr 18 20:54:39 CEST 2014
Hi Jeff,
I would like to have a media server but I don't have one at this moment.
Thank you for the response,
Frank
> From: users-request at lists.opensips.org
> Subject: Users Digest, Vol 69, Issue 32
> To: users at lists.opensips.org
> Date: Sat, 12 Apr 2014 06:39:42 +0200
>
> Send Users mailing list submissions to
> users at lists.opensips.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> or, via email, send a message with subject or body 'help' to
> users-request at lists.opensips.org
>
> You can reach the person managing the list at
> users-owner at lists.opensips.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Users digest..."
>
>
> Today's Topics:
>
> 1. Re: Miliseconds precision for accounting module (Maciej Bylica)
> 2. playing a prompt when backend is down (frank fox)
> 3. help playing a prompt when backend is down (frank fox)
> 4. Re: help playing a prompt when backend is down (Jeff Pyle)
> 5. Issue in VIA Header (B. Buitenhuis)
> 6. Re: Miliseconds precision for accounting module (Ryan Mitchell)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 11 Apr 2014 19:06:51 +0200
> From: Maciej Bylica <mbsip at gazeta.pl>
> Subject: Re: [OpenSIPS-Users] Miliseconds precision for accounting
> module
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID:
> <CACynCY7TYA+hHToS7c-oWNBx0m=W_k4sFLfcPXBEOVU4Y3ROEQ at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Ryan,
>
> One more question.
> Currently i have some db extra attrs setup. My acc table looks like
> following:
>
> +------------+------------------+------+-----+---------+----------------+
>
> | Field | Type | Null | Key | Default | Extra |
>
> +------------+------------------+------+-----+---------+----------------+
>
> | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
>
> | method | char(16) | NO | | | |
>
> | from_tag | char(64) | NO | | | |
>
> | to_tag | char(64) | NO | | | |
>
> | callid | char(64) | NO | MUL | | |
>
> | sip_code | char(3) | NO | | | |
>
> | sip_reason | char(32) | NO | | | |
>
> | time | datetime | NO | | NULL | |
>
> | duration | int(11) unsigned | NO | | 0 | |
>
> | setuptime | int(11) unsigned | NO | | 0 | |
>
> | SourceAddr | char(30) | NO | | NULL | |
>
> | DestAddr | char(30) | NO | | NULL | |
>
> | Anum | char(30) | NO | | NULL | |
>
> | Bnum_rU | char(30) | NO | | NULL | |
>
> | Bnum_tU | char(30) | NO | | NULL | |
>
> | created | datetime | YES | | NULL | |
>
> +------------+------------------+------+-----+---------+----------------+
>
>
> modparam("acc", "db_extra", "SourceAddr=$si; DestAddr=$rd; Anum=$fU;
> Bnum_rU=$rU; Bnum_tU=$tU")
>
>
> Now using additional data like $time will give me the exact moment the call
> is ended, nothing more, am i right?
>
> To have detailed call duration i need to know exact answer and disconnect
> timestamps.
>
>
> Btw: i am using OpenSIPS (1.9.1-notls (x86_64/linux))
>
>
> Thanks,
>
> Mac
>
>
> 2014-04-10 22:03 GMT+02:00 Ryan Mitchell <rjm at tcl.net>:
>
> > Using db_extra to stuff custom data into your acc table, use the $time var
> > with a format such as "%s.%N" or similar.
> >
> > Or, as you suggested, do it on the database level with a trigger or
> > auto-update column.
> >
> >
> >
> > On Thu, Apr 10, 2014 at 10:01 AM, Maciej Bylica <mbsip at gazeta.pl> wrote:
> >
> >> Hello
> >>
> >> I just want to know how to achieve miliseconds precision for accounting
> >> module.
> >> This is quite important while trying to sum up total traffic duration
> >> with the accuracy of hundred of ms.
> >>
> >> As i see there is no rounding feature implemented as well, but heaving ms
> >> precision it could be done directly on DB level.
> >>
> >> Could somebody give me a hand.
> >>
> >> Thanks in advanced
> >> Mac
> >>
> >>
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at lists.opensips.org
> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >>
> >>
> >
> >
> > --
> > Ryan Mitchell <rjm at tcl.net>
> > Telecom Logic, LLC
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.opensips.org/pipermail/users/attachments/20140411/1ab46234/attachment-0001.htm>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 11 Apr 2014 17:51:36 -0400
> From: frank fox <franklyfox at outlook.com>
> Subject: [OpenSIPS-Users] playing a prompt when backend is down
> To: "users at lists.opensips.org" <users at lists.opensips.org>
> Message-ID: <BAY177-W4412F902322E9B93A6598BC8540 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Greetings,
>
> Is there any recommendations for my proxy to play an audio through rtpproxy when there is no response sent back from my UAS? I would like to play a notify prompt to inform users that my system is down.
>
> Can one of these two functions really work for my situation or there are something else?
> rtpproxy_stream2uac
> minor_branch_flag
>
> Thank you,
> Frank
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.opensips.org/pipermail/users/attachments/20140411/004cf9be/attachment-0001.htm>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 11 Apr 2014 18:00:06 -0400
> From: frank fox <franklyfox at outlook.com>
> Subject: [OpenSIPS-Users] help playing a prompt when backend is down
> To: "users at lists.opensips.org" <users at lists.opensips.org>
> Message-ID: <BAY177-W14EEEFAB87E568D2EC1B97C8540 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
>
>
>
> Greetings,
>
> Is there any recommendations for my proxy to play an audio through rtpproxy when there is no response sent back from my UAS? I would like to play a notify prompt to inform users that my system is down.
>
> Can one of these two functions really work for my situation or there are something else?
> rtpproxy_stream2uac
> minor_branch_flag
>
> Thank you,
> Frank
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.opensips.org/pipermail/users/attachments/20140411/c13c93cc/attachment-0001.htm>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 11 Apr 2014 18:02:33 -0400
> From: Jeff Pyle <jpyle at fidelityvoice.com>
> Subject: Re: [OpenSIPS-Users] help playing a prompt when backend is
> down
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID:
> <CACYJG3KV9qnNzz=yWv8S-mDfCiq24RE39WF6GSPCZxV8WGCh8g at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I catch the 408 in a failure_route and re-route (t_relay) the call to a
> media server to play the recording. I haven't tried any rtpproxy-specific
> methods.
>
>
> - Jeff
>
>
> On Fri, Apr 11, 2014 at 6:00 PM, frank fox <franklyfox at outlook.com> wrote:
>
> >
> > Greetings,
> >
> > Is there any recommendations for my proxy to play an audio through
> > rtpproxy when there is no response sent back from my UAS? I would like to
> > play a notify prompt to inform users that my system is down.
> >
> > Can one of these two functions really work for my situation or there are
> > something else?
> > rtpproxy_stream2uac
> > minor_branch_flag
> >
> > Thank you,
> > Frank
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.opensips.org/pipermail/users/attachments/20140411/a78ed599/attachment-0001.htm>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 11 Apr 2014 22:09:49 +0000
> From: "B. Buitenhuis" <bernard at buitenhuis.nu>
> Subject: [OpenSIPS-Users] Issue in VIA Header
> To: "users at lists.opensips.org" <users at lists.opensips.org>
> Message-ID: <CF6E34CD.17B1F%bernard at buitenhuis.nu>
> Content-Type: text/plain; charset="us-ascii"
>
> Hello,
>
> I'm facing the same problem as:
> https://github.com/OpenSIPS/opensips/issues/190
>
> When I look at a wireshark, I see the following in the VIA header:
> Via: SIP/2.0/UDP \000\000\000\000\000\000\000\000\000\000\000\000\000:5060;branch=z9hG4bK9414.22d66c76.0
>
> As far as I can see it's only with the CANCEL method, in the config it looks like:
>
> if (method=="CANCEL")
> {
> set_advertised_address(185.XX.XX.XX);
>
> route("PROCESS_RTP_PROXY");
> unforce_rtp_proxy();
> if (t_check_trans())
> t_relay();
> exit;
> }
>
>
> I've tested it with 1.8.3 and 1.10.1
>
> Does anyone has this same problem?
>
>
> Regards,
>
> Bernard Buitenhuis
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.opensips.org/pipermail/users/attachments/20140411/f7519d71/attachment-0001.htm>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 11 Apr 2014 21:39:33 -0700
> From: Ryan Mitchell <rjm at tcl.net>
> Subject: Re: [OpenSIPS-Users] Miliseconds precision for accounting
> module
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID:
> <CAMnAngA25bNqyjM=ROnMO3Y4KcCKDs083ez+iuQoj2Ds-_iKTA at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello Mac,
>
> Each row in the acc table is for a transaction. To make a proper CDR out
> of the data, you have to combine rows to find the start and end of the
> call. That can be harder than it sounds, especially with forking
> (parallel, or the more common case of serial forking when you are LCR
> routing or simply sending calls to alt destinations after a timeout). I
> wrote scripts that implement a simple dialog state machine to make sense of
> all the distinct legs of a call, though there should be an easier way with
> the auto-cdr / multi call-legs accounting feature of the acc module (anyone
> comment on this please?).
>
> The time field in the acc table will be the timestamp of the response for
> the given transaction. If you assign an extra field for another timestamp,
> it will depend on where you assign that var in your script. In my case I
> assign it in the main routing section so the timestamp indicates the start
> of the transaction.
>
> best regards,
> Ryan
>
>
>
> On Fri, Apr 11, 2014 at 10:06 AM, Maciej Bylica <mbsip at gazeta.pl> wrote:
>
> > Ryan,
> >
> > One more question.
> > Currently i have some db extra attrs setup. My acc table looks like
> > following:
> >
> > +------------+------------------+------+-----+---------+----------------+
> >
> > | Field | Type | Null | Key | Default | Extra |
> >
> > +------------+------------------+------+-----+---------+----------------+
> >
> > | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
> >
> > | method | char(16) | NO | | | |
> >
> > | from_tag | char(64) | NO | | | |
> >
> > | to_tag | char(64) | NO | | | |
> >
> > | callid | char(64) | NO | MUL | | |
> >
> > | sip_code | char(3) | NO | | | |
> >
> > | sip_reason | char(32) | NO | | | |
> >
> > | time | datetime | NO | | NULL | |
> >
> > | duration | int(11) unsigned | NO | | 0 | |
> >
> > | setuptime | int(11) unsigned | NO | | 0 | |
> >
> > | SourceAddr | char(30) | NO | | NULL | |
> >
> > | DestAddr | char(30) | NO | | NULL | |
> >
> > | Anum | char(30) | NO | | NULL | |
> >
> > | Bnum_rU | char(30) | NO | | NULL | |
> >
> > | Bnum_tU | char(30) | NO | | NULL | |
> >
> > | created | datetime | YES | | NULL | |
> >
> > +------------+------------------+------+-----+---------+----------------+
> >
> >
> > modparam("acc", "db_extra", "SourceAddr=$si; DestAddr=$rd; Anum=$fU;
> > Bnum_rU=$rU; Bnum_tU=$tU")
> >
> >
> > Now using additional data like $time will give me the exact moment the
> > call is ended, nothing more, am i right?
> >
> > To have detailed call duration i need to know exact answer and disconnect
> > timestamps.
> >
> >
> > Btw: i am using OpenSIPS (1.9.1-notls (x86_64/linux))
> >
> >
> > Thanks,
> >
> > Mac
> >
> >
> > 2014-04-10 22:03 GMT+02:00 Ryan Mitchell <rjm at tcl.net>:
> >
> >> Using db_extra to stuff custom data into your acc table, use the $time
> >> var with a format such as "%s.%N" or similar.
> >>
> >> Or, as you suggested, do it on the database level with a trigger or
> >> auto-update column.
> >>
> >>
> >>
> >> On Thu, Apr 10, 2014 at 10:01 AM, Maciej Bylica <mbsip at gazeta.pl> wrote:
> >>
> >>> Hello
> >>>
> >>> I just want to know how to achieve miliseconds precision for accounting
> >>> module.
> >>> This is quite important while trying to sum up total traffic duration
> >>> with the accuracy of hundred of ms.
> >>>
> >>> As i see there is no rounding feature implemented as well, but heaving
> >>> ms precision it could be done directly on DB level.
> >>>
> >>> Could somebody give me a hand.
> >>>
> >>> Thanks in advanced
> >>> Mac
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> Users mailing list
> >>> Users at lists.opensips.org
> >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >>>
> >>>
> >>
> >>
> >> --
> >> Ryan Mitchell <rjm at tcl.net>
> >> Telecom Logic, LLC
> >>
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at lists.opensips.org
> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >>
> >>
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
>
>
> --
> Ryan Mitchell <rjm at tcl.net>
> Telecom Logic, LLC
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.opensips.org/pipermail/users/attachments/20140411/f14c1838/attachment.htm>
>
> ------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> End of Users Digest, Vol 69, Issue 32
> *************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140418/e3b21c7f/attachment-0001.htm>
More information about the Users
mailing list