[Serusers] session duration accounting

[Iqbal]

I concur, thats what the initial setup charge is usually for that you 
get billied by calling card companies, the provider gets charged the 
moment a signal hits the gateway, hence that has to be passed onto the 
customer, else the 30secs start to add up

Iqbal

Java Rockx wrote:

>I understand what you're saying, however, I disagree with your
>suggestion because me (as a PSTN gateway owner) will be charged tolls
>based on the INVITE-to-BYE duration from my carriers for completed
>calls.
>
>So if I'm only billing durations from ACK to BYE, then :
>
>1) How would I accurately determine which ACK to account against
>considering that many ACKs can happen during any call? For instance,
>if you get put on hold or a re-INVITE.
>
>2) Why should I give the customer 30 seconds of free platform time
>when my carriers bill me toll charges for that period?
>
>Regards,
>Paul
>
>On 7/5/05, Olivier Taylor <olivier.taylor at gmail.com> wrote:
>  
>
>>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
>>
>>_______________________________________________
>>Serusers mailing list
>>serusers at lists.iptel.org
>>http://lists.iptel.org/mailman/listinfo/serusers
>>
>>    
>>
>
>.
>
>  
>