[Serusers] Call Accounting - multiple INVITE entries

[jon at bostontech.com]

Thank you all for your help, this method worked.

-Jon




"Zeus Ng" <zeus.ng at isquare.com.au>
05/27/2004 08:38 PM
 
        To:     <jon at bostontech.com>
        cc:     <serusers at lists.iptel.org>
        Fax to: 
        Subject:        RE: [Serusers] Call Accounting - multiple INVITE 
entries


search("^To:(.*);tag=(.*)$")

That's what I did before discovering has_totag(). It requires the textops
module.

Zeus

> -----Original Message-----
> From: serusers-bounces at lists.iptel.org 
> [mailto:serusers-bounces at lists.iptel.org] On Behalf Of jon at bostontech.com
> Sent: Friday, 28 May 2004 5:00 AM
> To: Klaus Darilion
> Cc: serusers at lists.iptel.org
> Subject: Re: [Serusers] Call Accounting - multiple INVITE entries
> 
> 
> 
> I figured out my confusion. has_totag() is in the development 
> side of the "uri" module. 
> I am running the latest stable version of sip, installed with 
> the rpm package for RedHat 9. It does not have support for 
> the has_totag() command. 
> 
> Without trying to use the new modules, is there any way to do 
> what i was asking below? (things are running pretty smoothly, 
> and i don't really want to have to rewrite a lot of script or 
> stuff like that :) 
> 
> thanks for your help so far. 
> -Jon 
> 
> 
> 
>                Klaus Darilion <klaus.mailinglists at pernau.at> 
> 
> 05/27/2004 02:19 PM 
>         To:        jon at bostontech.com 
>         cc:        serusers at lists.iptel.org 
>         Fax to: 
>         Subject:        Re: [Serusers] Call Accounting - 
> multiple INVITE entries
> 
> 
> 
> sorry, it's called: has_totag().
> Take a look at the README in the "uri" module.
> 
> regards,
> klaus
> 
> jon at bostontech.com wrote:
> 
> > 
> > I'm not completely following you. Is has_to_tag() a regular 
> command, 
> > and
> > which module is it in?
> > thanks
> > 
> > Jon
> > 
> > 
> >                  *Klaus Darilion <klaus.mailinglists at pernau.at>*
> > 
> > 05/27/2004 05:41 AM
> > 
> > 
> >         To:        jon at bostontech.com
> >         cc:        serusers at lists.iptel.org
> >         Fax to: 
> >         Subject:        Re: [Serusers] Call Accounting - 
> multiple INVITE 
> > entries
> > 
> > 
> > 
> > 
> > You can check if the message has a to-tag has_to_tag() und in that 
> > case: don't set the acc flag.
> > 
> > klaus
> > 
> > jon at bostontech.com wrote:
> >  >
> >  > I am running ser 0.8.12 (on RedHat 9) and have it set up 
> to log all 
> > > invite and bye messages, so that I can use the accounting 
> feature in 
> > > SerWeb. It's logging fine.  > My problem is that if there are 
> > multiple invites and only one bye during  > a session, I 
> get multiple 
> > entries in SerWeb with the same sip_callid. I  > noticed that this 
> > happens when the hold feature is used with the XTen  > soft phone.
> >  > Is there any way I can avoid logging these subsequent 
> INVITE messages or
> >  > stop from displaying them in the call log on SerWeb?
> >  >
> >  >
> >  > My accounting routine:
> >  >
> >  > modparam("acc", "log_level",1)
> >  > modparam("acc", "db_flag", 1)
> >  > if ((method=="INVITE") || (method=="BYE")) {
> >  >         setflag (1);
> >  > };
> >  >
> >  >
> >  > Serweb $q call to MySQL (4.0.18) db:
> >  >
> >  > $q="select t1.to_uri, t1.from_uri, t1.sip_callid, t1.time, ".
> >  >         "t1.fromtag as invft, t2.fromtag as byeft, 
> t2.totag as byett, ".
> >  > 
> "sec_to_time(unix_timestamp(t2.time)-unix_timestamp(t1.time)) ".
> >  >                 "as length ".
> >  >         "from ".$config->table_accounting." t1, ".
> >  >                 $config->table_accounting. " t2 ".
> >  >         "where t1.domain='".$config->realm."' and ".
> >  >                 "t1.sip_callid=t2.sip_callid and ".
> >  >                 "t1.sip_method='INVITE' and t2.sip_method='BYE'".
> >  >         "order by t1.time desc";
> >  >
> >  >
> >  >
> >  > Thanks
> >  > -Jon B
> >  >
> >  >
> >  > 
> --------------------------------------------------------------
> ----------
> >  >
> >  > _______________________________________________
> >  > Serusers mailing list
> >  > serusers at lists.iptel.org
> >  > http://lists.iptel.org/mailman/listinfo/serusers
> > 
> 
> 
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20040528/e204100c/attachment.htm>