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
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
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
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 INVITEentries
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
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
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
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
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@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@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 INVITEentries
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 INVITEentries
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
-
jon＠bostontech.com -
Klaus Darilion -
Zeus Ng