[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