28 May
2004
28 May
'04
3:53 p.m.
Thank you all for your help, this method worked.
-Jon
"Zeus Ng" <zeus.ng(a)isquare.com.au>
05/27/2004 08:38 PM
To: <jon(a)bostontech.com>
cc: <serusers(a)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(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:
get multiple
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 during > a session, I 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