<br><font size=2 face="sans-serif">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.</font>
<br><font size=2 face="sans-serif">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. </font>
<br><font size=2 face="sans-serif">Is there any way I can avoid logging
these subsequent INVITE messages or stop from displaying them in the call
log on SerWeb?</font>
<br>
<br>
<br><font size=2 face="sans-serif">My accounting routine:</font>
<br>
<br><font size=2 face="sans-serif">modparam("acc", "log_level",1)</font>
<br><font size=2 face="sans-serif">modparam("acc", "db_flag",
1)</font>
<br><font size=2 face="sans-serif">if ((method=="INVITE") ||
(method=="BYE")) {</font>
<br><font size=2 face="sans-serif"> setflag
(1);</font>
<br><font size=2 face="sans-serif">};</font>
<br>
<br>
<br><font size=2 face="sans-serif">Serweb $q call to MySQL (4.0.18) db:</font>
<br>
<br><font size=2 face="sans-serif">$q="select t1.to_uri, t1.from_uri,
t1.sip_callid, t1.time, ".</font>
<br><font size=2 face="sans-serif"> "t1.fromtag
as invft, t2.fromtag as byeft, t2.totag as byett, ".</font>
<br><font size=2 face="sans-serif"> "sec_to_time(unix_timestamp(t2.time)-unix_timestamp(t1.time))
".</font>
<br><font size=2 face="sans-serif">
"as length ".</font>
<br><font size=2 face="sans-serif"> "from
".$config->table_accounting." t1, ".</font>
<br><font size=2 face="sans-serif">
$config->table_accounting. " t2 ".</font>
<br><font size=2 face="sans-serif"> "where
t1.domain='".$config->realm."' and ".</font>
<br><font size=2 face="sans-serif">
"t1.sip_callid=t2.sip_callid and ".</font>
<br><font size=2 face="sans-serif">
"t1.sip_method='INVITE' and t2.sip_method='BYE'".</font>
<br><font size=2 face="sans-serif"> "order
by t1.time desc";</font>
<br>
<br>
<br>
<br><font size=2 face="sans-serif">Thanks</font>
<br><font size=2 face="sans-serif">-Jon B</font>
<br>