[Serusers] session duration accounting

[Olivier Taylor]

Hi Iqbal,
I think the query u gave is not really correct, the INVITES are the
beginning of the sessions, I think we must use the ACKs for a real
accounting of the call.
Just think, if it takes 30 seconds to the callee to hang on, u will
overcharge him.
I just suggest to replace the INVITES by ACKs.

Regards.

Olivier

-----Message d'origine-----
De : serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] De la
part de Iqbal
Envoyé : mardi 5 juillet 2005 13:28
À : Ryan Pagquil
Cc : serusers at lists.iptel.org
Objet : Re: [Serusers] session duration accounting


put those queries in mysql and it should lookup your acc table

Iqbal

Ryan Pagquil wrote:

> Hi,
>       So the only concept on how will I account for duration is to 
> account for INVITE and BYE methods...BTW, where will I put those 
> queries? Sorry, I'm in a stage of discovering SER.=)
>
> Thanks,
>
>
>
> Java Rockx wrote:
>
>> Ryan,
>>
>> This MySQL query should do the trick. It joins the acc table to 
>> itself. One side grabs INVITE messages and the other side grabs BYE 
>> messages.
>>
>> NOTE: This will not work if you account for re-INVITE messages 
>> because you will then have multple INVITEs for the same call.
>>
>> Regards,
>> Paul
>>
>> SELECT t1.from_uri as orig_number,  t1.to_uri as term_number,
>> TIMEDIFF(t2.time, t1.time) as duration,  t1.timestamp as calldate 
>> FROM acc t1, acc t2  WHERE t1.sip_callid = t2.sip_callid AND
>> ((t1.fromtag = t2.fromtag and t1.totag = t2.totag) OR
>> (t1.fromtag = t2.totag and t1.totag = t2.fromtag)) AND
>> t1.sip_method='INVITE' AND
>> t2.sip_method='BYE'
>>
>> On 7/4/05, Iqbal <iqbal at gigo.co.uk> wrote:
>>  
>>
>>> its records the INVITE and BYE, so fro there you can work out the 
>>> session duration
>>>
>>> Iqbal
>>>
>>> Ryan Pagquil wrote:
>>>
>>>   
>>>
>>>> guys,
>>>>      just want to ask if i can make ser to account session 
>>>> durations for billing purposes?
>>>>
>>>> Thanks,
>>>>
>>>>     
>>>
>>> _______________________________________________
>>> Serusers mailing list
>>> serusers at lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>>   
>>
>>
>>
>>  
>>
>
>

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