[prev in list] [next in list] [prev in thread] [next in thread] 

List:       serusers
Subject:    Re: [Serweb-users] Re: [Serusers] Is there a bug in SERWeb ?
From:       inge <inge () legos ! fr>
Date:       2007-04-27 8:46:51
Message-ID: 1177663611.18589.1.camel () legos01 ! legos ! fr
[Download RAW message or body]

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@lists.iptel.org
> >> http://lists.iptel.org/mailman/listinfo/serusers
> > 
> > _______________________________________________
> > Serweb-users mailing list
> > Serweb-users@lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serweb-users

["accbyebug.csv" (accbyebug.csv)]

"sip:0368345421@sip.domain.fr:5060;tag=d11de6c3b3f354b";"sip:0144239124@sip.domain.fr: \
5060;tag=30D4E1E4-2122";200;INVITE;sip:0144239124@sip.domain.fr:5060;sip:0144239124@ip \
gateway:5060;sip:0368345421@sip.domain.fr:5060;sip:0144239124@sip.domain.fr:5060;1660f \
6540c5da7f815028eac987ca235@85.95.221.11;368345421;sip.legos.fr;d11de6c3b3f354b;30D4E1E4-2122;12/04/2007 \
16:41;12/04/2007 18:41;0;0 \
"sip:0368345421@sip.domain.fr:5060;tag=d11de6c3b3f354b";"sip:0144239124@sip.domain.fr: \
5060;tag=30D4E1E4-2122";200;ACK;sip:0144239124@ipgateway:5060;sip:0144239124@ipgateway \
:5060;sip:0368345421@sip.domain.fr:5060;sip:0144239124@sip.domain.fr:5060;1660f6540c5d \
a7f815028eac987ca235@85.95.221.11;368345421;sip.legos.fr;d11de6c3b3f354b;30D4E1E4-2122;12/04/2007 \
16:41;12/04/2007 18:41;0;0 \
"sip:0368345421@sip.domain.fr:5060;tag=d11de6c3b3f354b";"sip:0144239124@sip.domain.fr: \
5060;tag=30D4E1E4-2122";200;BYE;sip:0144239124@ipgateway:5060;sip:0144239124@ipgateway \
:5060;sip:0368345421@sip.domain.fr:5060;sip:0144239124@sip.domain.fr:5060;1660f6540c5d \
a7f815028eac987ca235@85.95.221.11;368345421;sip.legos.fr;d11de6c3b3f354b;30D4E1E4-2122;12/04/2007 \
17:52;12/04/2007 19:52;0;0 \
"sip:0144239124@sip.domain.fr:5060;tag=30D4E1E4-2122";"sip:0368345421@sip.domain.fr:50 \
60;tag=d11de6c3b3f354b";200;BYE;sip:0368345421@ipUA:5060;sip:0368345421@ipUA:5060;sip: \
0144239124@sip.domain.fr:5060;sip:0368345421@sip.domain.fr:5060;1660f6540c5da7f815028e \
ac987ca235@85.95.221.11;144239124;sip.legos.fr;30D4E1E4-2122;d11de6c3b3f354b;12/04/2007 \
17:52;24/04/2007 18:04;0;0



_______________________________________________
Serusers mailing list
Serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers


[prev in list] [next in list] [prev in thread] [next in thread]