[Serusers] Call Accounting - multiple INVITE entries

[Klaus Darilion]

You can test this code - found in a posting some days ago:

/* Prevent using our proxy as a relay */
     if (!search("^To:(.*);tag=(.*)$"))

klaus

jon at bostontech.com wrote:

> 
> 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
>  >
>