Thank you all for your help, this method worked.

-Jon


"Zeus Ng" <zeus.ng@isquare.com.au>

05/27/2004 08:38 PM

       
        To:        <jon@bostontech.com>
        cc:        <serusers@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@lists.iptel.org
> [mailto:serusers-bounces@lists.iptel.org] On Behalf Of jon@bostontech.com
> Sent: Friday, 28 May 2004 5:00 AM
> To: Klaus Darilion
> Cc: serusers@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@pernau.at>
>
> 05/27/2004 02:19 PM        
>         To:        jon@bostontech.com
>         cc:        serusers@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@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@pernau.at>*
> >
> > 05/27/2004 05:41 AM
> >
> >                        
> >         To:        jon@bostontech.com
> >         cc:        serusers@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@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@lists.iptel.org
> >  > http://lists.iptel.org/mailman/listinfo/serusers
> >
>
>
>