5 Jul
2005
5 Jul
'05
3:32 p.m.
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(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] De la
part de Iqbal
Envoyé : mardi 5 juillet 2005 13:28
À : Ryan Pagquil
Cc : serusers(a)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:
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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(a)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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers