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-requ...@lists.opensips.org > Subject: Users Digest, Vol 69, Issue 32 > To: users@lists.opensips.org > Date: Sat, 12 Apr 2014 06:39:42 +0200 > > Send Users mailing list submissions to > users@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-requ...@lists.opensips.org > > You can reach the person managing the list at > users-ow...@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 <mb...@gazeta.pl> > Subject: Re: [OpenSIPS-Users] Miliseconds precision for accounting > module > To: OpenSIPS users mailling list <users@lists.opensips.org> > Message-ID: > <CACynCY7TYA+hHToS7c-oWNBx0m=w_k4sflfcpxbeovu4y3r...@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 <r...@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 <mb...@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@lists.opensips.org > >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >> > >> > > > > > > -- > > Ryan Mitchell <r...@tcl.net> > > Telecom Logic, LLC > > > > > > _______________________________________________ > > Users mailing list > > Users@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 <frankly...@outlook.com> > Subject: [OpenSIPS-Users] playing a prompt when backend is down > To: "users@lists.opensips.org" <users@lists.opensips.org> > Message-ID: <bay177-w4412f902322e9b93a6598bc8...@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 <frankly...@outlook.com> > Subject: [OpenSIPS-Users] help playing a prompt when backend is down > To: "users@lists.opensips.org" <users@lists.opensips.org> > Message-ID: <bay177-w14eeefab87e568d2ec1b97c8...@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 <jp...@fidelityvoice.com> > Subject: Re: [OpenSIPS-Users] help playing a prompt when backend is > down > To: OpenSIPS users mailling list <users@lists.opensips.org> > Message-ID: > <CACYJG3KV9qnNzz=ywv8s-mdfciq24re39wf6gspczxv8wgc...@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 <frankly...@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@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" <bern...@buitenhuis.nu> > Subject: [OpenSIPS-Users] Issue in VIA Header > To: "users@lists.opensips.org" <users@lists.opensips.org> > Message-ID: <cf6e34cd.17b1f%bern...@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 <r...@tcl.net> > Subject: Re: [OpenSIPS-Users] Miliseconds precision for accounting > module > To: OpenSIPS users mailling list <users@lists.opensips.org> > Message-ID: > <CAMnAngA25bNqyjM=ronmo3y4kcckds083ez+iuqoj2ds-_i...@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 <mb...@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 <r...@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 <mb...@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@lists.opensips.org > >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >>> > >>> > >> > >> > >> -- > >> Ryan Mitchell <r...@tcl.net> > >> Telecom Logic, LLC > >> > >> > >> _______________________________________________ > >> Users mailing list > >> Users@lists.opensips.org > >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >> > >> > > > > _______________________________________________ > > Users mailing list > > Users@lists.opensips.org > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > -- > Ryan Mitchell <r...@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@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > End of Users Digest, Vol 69, Issue 32 > *************************************
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users