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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

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(a)pernau.at>* 05/27/2004 05:41 AM To: jon(a)bostontech.com cc: serusers(a)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(a)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

> a session, I get multiple entries in SerWeb with the same sip_callid.

> 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

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

-----Original Message----- From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of jon(a)bostontech.com Sent: Friday, 28 May 2004 5:00 AM To: Klaus Darilion Cc: serusers(a)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(a)pernau.at> 05/27/2004 02:19 PM To: jon(a)bostontech.com cc: serusers(a)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(a)bostontech.com wrote: command, multiple INVITE to log all feature in get multiple INVITE messages or 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 > > > > -------------------------------------------------------------- ----------