[Serweb-users] Re: [Serusers] Is there a bug in SERWeb ?

[inge]

Hi,

I join to the mail a csv witch is an export from acc table.
As you can see, there are two bye at the same time.

To correct it in SERWeb, I redesign the SQL request like this :

strip this in select : bye_i_uri ; bye_to_uri ; bye_fromtag ;
bye_totag ; bye_from_uri ; bye_sip_from

I add a DISTINCT instruction. So I've got only one call instead of two,
and in SERWEb code I comment the parts wich concerns this column (i.e.
INVITE and BYE unpaired).

For the BYE unpaired, I understand that it was implement for determine
who have hang out. I'm not interresting by this function.So I always put
"n/a".
Moreover, for INVITE unpaired, I think it's a very rare problem. To
prevent it, I have been thinking to add "is not null" in a where clause
for inv_callid column to don't have a result with INVITE unpaired.

Thanks for your support, I wait for your opinion.

Regards

Le vendredi 27 avril 2007 à 08:52 +0200, Karel Kozlik a écrit : 
> Hi,
> thanks for report. Could you please send me an example of acc table 
> content with these double BYEs? I will look if I am able to fix it.
> 
> thanks,
> Karel
> 
> inge napsal(a):
> > No one have an idea on this problem ?
> > 
> > I've got two BYE's only when caller and callee hang out at the same
> > time. 
> > It's not very penalising because of the rarety of the case, but it's
> > obstructing.
> > 
> > Thanks for your support.
> > 
> > Le mercredi 25 avril 2007 à 09:33 +0200, inge a écrit :
> >> Hi all,
> >>
> >> I use SERWeb especially for call history. The core of this function is
> >> method.get_acc_entries.php.
> >> For some calls, I see that they are posted two times.
> >>
> >> During my investigation I see that the problem come from SQL request in
> >> method.get_acc_entries. 
> >>
> >> In fact, it seems that when both calling and called party hang out in
> >> the same time, there are two BYE generated in acc table.
> >>
> >> Maybe the bug have been already reported, but I don't see nothing about
> >> this. Anyone one have an idea to correct it ?
> >>
> >> Thanks for your su
> >>
> >> _______________________________________________
> >> Serusers mailing list
> >> Serusers at lists.iptel.org
> >> http://lists.iptel.org/mailman/listinfo/serusers
> > 
> > _______________________________________________
> > Serweb-users mailing list
> > Serweb-users at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serweb-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: accbyebug.csv
Type: text/x-comma-separated-values
Size: 1529 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070427/c17def17/attachment.bin>