27 Apr
2007
27 Apr
'07
4:46 a.m.
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(a)lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>
> _______________________________________________
> Serweb-users mailing list
> Serweb-users(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serweb-users