[asterisk-users] CDR billsec issue with calls forwarded through the Local channel
Hi I'm using asterisk 1.8.23.1 but I've seen this same issue in previous versions of 1.8. I have created some work arounds but the behaviour is incorrect. This is the scenario: Call comes in and goes to appropriate dialplan In the dialplan the call is forwarded to another number using a Local channel (and using /n ) e.g. Dial(Local/my-number@outbound-context/n,60) The number is dialled and the call is all fine. In the CDR we have 2 entries, one for the inbound leg and one for the outbound leg as is expected by the use of the /n However, the outbound leg CDR entry has a billsec of 0. The CDR for the inbound leg has the correct duration of the call in the billsec column (I'm writing CDRs to MySQL) This is causing issues in my billing module for obvious reasons. I'm having to find the inbound call by matching the channel in one leg with the dstchannel in the other leg and that is quite messy. Would others agree that this behaviour is incorrect? Has anyone else seen this or be able to replicate it? Am I just missing something obvious? Thanks in Advance Ish -- Ishfaq Malik Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: i...@pack-net.co.uk w: http://www.pack-net.co.uk Registered Address: PACKNET LIMITED, Duplex 2, Ducie House 37 Ducie Street Manchester, M1 2JW COMPANY REG NO. 04920552 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR billsec issue with calls forwarded through the Local channel
A big correction to the above! This 0 billsec entry happens when someone forwards a call from their phone using an auto forward (which then uses a Local channel on the asterisk server). The phone in question is a Snom. If I use a Local channel in the dial plan, the entry has a the correct billsec. On 2 May 2014 11:23, Ishfaq Malik i...@pack-net.co.uk wrote: Hi I'm using asterisk 1.8.23.1 but I've seen this same issue in previous versions of 1.8. I have created some work arounds but the behaviour is incorrect. This is the scenario: Call comes in and goes to appropriate dialplan In the dialplan the call is forwarded to another number using a Local channel (and using /n ) e.g. Dial(Local/my-number@outbound-context/n,60) The number is dialled and the call is all fine. In the CDR we have 2 entries, one for the inbound leg and one for the outbound leg as is expected by the use of the /n However, the outbound leg CDR entry has a billsec of 0. The CDR for the inbound leg has the correct duration of the call in the billsec column (I'm writing CDRs to MySQL) This is causing issues in my billing module for obvious reasons. I'm having to find the inbound call by matching the channel in one leg with the dstchannel in the other leg and that is quite messy. Would others agree that this behaviour is incorrect? Has anyone else seen this or be able to replicate it? Am I just missing something obvious? Thanks in Advance Ish -- Ishfaq Malik Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: i...@pack-net.co.uk w: http://www.pack-net.co.uk Registered Address: PACKNET LIMITED, Duplex 2, Ducie House 37 Ducie Street Manchester, M1 2JW COMPANY REG NO. 04920552 -- Ishfaq Malik Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: i...@pack-net.co.uk w: http://www.pack-net.co.uk Registered Address: PACKNET LIMITED, Duplex 2, Ducie House 37 Ducie Street Manchester, M1 2JW COMPANY REG NO. 04920552 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR / billsec / originate / local chan
Sean Brady wrote: Have you tried removing the /n option from the local channel? Just a thought, but it's probably worth a try. You could also try calculating the billsec in the dialplan and write it to the CDR with the adaptive CDR feature in 1.6.2. Not sure if this is helpful but it was a thought. -Sean Hi Sean, Yeah, tried with and without the /n option - it turns out that there was a bug in any release post 1.6.2.0 including the current 1.6.2.2 that meant if you established a call using originate and a local channel the second leg of the channel would not get bridged in - this bug seems to be fixed in the current SVN release and I just need to wait now for a actual release. The issue with cdr is that billsec does not seem to be available on the asterisk side of the channel, only the sip/ iax / other tech channel so when using originate, you dont get to see the tech side of the channel, only the asterisk side if it. There was a mention somewhere on dev forum and in the bug tracker that this was because someone deemed the asterisk side of the channel as non billable any only the tech side as billable so billsec was disabled ( I say disabled because it used to work and doesnt now - why capabilities are removed is beyond me) Cheers, Ben -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR / billsec / originate / local chan
On 1.6.2 I have also tried using a local channel for the outbound leg with the originate looking like the following: action:.Originate.. actionid:.1306903_89#AJ_ORIGINATE_25 timeout:.4 exten:.s async:.true callerid:..612 context:.campaignType_5 priority:.1 channel:.Local/61212142...@outboundsip/n And the Local context as follows; [outboundsip] exten = _XX.,1,Dial(SIP/trunk1/${EXTEN}) exten = _XX.,n,Hangup exten = h,1,NoOp(Billsec is: ${CDR(billsec)}) In this configuration, whilst the outbound call goes out and billsec gets reported correctly in the h exten, the call does not get bridged back into the campaignType_5 context so none of the call processing occurs. I cannot see any options that can be passed to the dial command that may affect the bridging of the call back into the campaignType_5 context??? Have you tried removing the /n option from the local channel? Just a thought, but it's probably worth a try. You could also try calculating the billsec in the dialplan and write it to the CDR with the adaptive CDR feature in 1.6.2. Not sure if this is helpful but it was a thought. -Sean -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] CDR / billsec / originate / local chan
Hi All, I have been running a environment with asterisk 1.4.20.1 for some time now with no issue but have recently added some extra functionality (enabled call recording via MixMonitor) and ran into some deadlock issues which seem to be well documented with earlier 1.4.x releases so have decided to take the plunge and upgrade. I decided to start testing with 1.6.2 but have run into a couple of issues. We run an environment that triggers outbound calls via AMI / asterisk java and places the call upon answer back into a context that has IVR, TTS/ VXML etc. Running with 1.4.20.1, we have not had any issues and have been able to access all of the CDR fields in the h exten (using endbeforehexten=yes in cdr.conf) however after upgrading all our post answer related cdr information is reporting 0. Fields such as billsec, answer etc all return either 0 or null which is causing a lot of issues for us as we use some AGI post call via the h exten to perform processing based on billable duration etc. I have found a number of threads / articles etc discussing various billsec related issues but it is hard to get a picture of what should work on what version of asterisk. For example, I know that my environment works on 1.4.20 but it is broken in 1.4.23 and seems to be broken in 1.6.2 (pretty sure I tried 1.6.0.9 as well with the same result) How t works in 1.4.20.1 is as follows: We trigger call via Originate action as follows: action:.Originate.. actionid:.1306903_89#AJ_ORIGINATE_25 timeout:.4 exten:.s async:.true callerid:..612 context:.campaignType_5 priority:.1 channel:.SIP/trunk1/61212142321 And the campaignType_5 context looks similar to: [campaignType_5_] exten = s,1,Answer() exten = s,n,Set(timestarted=${STRFTIME(${EPOCH},,%Y%m%d%H%M%S)}) exten = s,n,Set(CALLSTATUS=0) exten = s,n,Background(lyrics-louie-louie) exten = s,n,WaitExten(5) exten = s,n,Set(timefinished=${STRFTIME(${EPOCH},,%Y%m%d%H%M%S)}) exten = s,n,Set(DIGITPRESSED=99) exten = s,n,Set(TIMETOPRESS=${timestarted)}) exten = s,n,NoOp(Billsec is: ${CDR(billsec)}) exten = s,n,Hangup exten = 1,1,Set(DIGITPRESSED=${EXTEN}) exten = 1,n,Set(TIMETOPRESS=${STRFTIME(${EPOCH},,%Y%m%d%H%M%S)}) exten = 1,3,Playback(wait-moment) exten = 1,4,Dial(Local/${calllogid}_${agentnumb...@campaigntype_5_agent/n) exten = 1,5,Hangup exten = h,1,Set(timefinished=${STRFTIME(${EPOCH},,%Y%m%d%H%M%S)}) exten = h,2,GotoIf($[${TIMETOPRESS}foo = foo]?h,20) exten = h,3,GotoIf($[${DIGITPRESSED}foo = foo]?h,10) exten = h,4,Set(carrier=9) exten = h,n,AGI(agi://${DB(APPS/AGISERVER)}/ccoAgentActivityAgi.agi?BILLABLEDURATION=${CDR(billsec)}CALLLOGID=${CALLLOGID}CALLSTATUS=${CALLSTATUS}CAMPAIGNID=${CAMPAIGNID}DIGITPRESSED=${DIGITPRESSED}DURATION=${CDR(duration)}TARGETID=${TARGETID}TIMEFINISHED=${TIMEFINISHED}TIMEPRESSED=${TIMETOPRESS}TIME STARTED=${TIMESTARTED}STATECHANGE=CALLDOWNNODEID=${NODEID}) exten = h,10,Set(DIGITPRESSED=77) exten = h,11,Set(timefinished=${STRFTIME(${EPOCH},,%Y%m%d%H%M%S)}) exten = h,12,Goto(h,3) exten = h,20,Set(TIMETOPRESS=${timestarted}) exten = h,21,Goto(h,3) exten = failed,1,Set(DIGITPRESSED=98) exten = failed,2,Set(TIMETOPRESS=${timestarted}) exten = failed,3,Set(CALLSTATUS=6) exten = failed,4,Set(timestarted=${STRFTIME(${EPOCH},,%Y%m%d%H%M%S)}) exten = failed,5,Set(timefinished=${STRFTIME(${EPOCH},,%Y%m%d%H%M%S)}) As mentioned, in 1.4.20 this works fine with all cdr fields being reported correctly, but on 1.6.2 (and various other versions, on the h exten with the AGI call we get duration reported correctly but billsec = 0 We are not using Local channels here unless Asterisk is optimising the outbound leg of the call into one invisibly. On 1.6.2 I have also tried using a local channel for the outbound leg with the originate looking like the following: action:.Originate.. actionid:.1306903_89#AJ_ORIGINATE_25 timeout:.4 exten:.s async:.true callerid:..612 context:.campaignType_5 priority:.1 channel:.Local/61212142...@outboundsip/n And the Local context as follows; [outboundsip] exten = _XX.,1,Dial(SIP/trunk1/${EXTEN}) exten = _XX.,n,Hangup exten = h,1,NoOp(Billsec is: ${CDR(billsec)}) In this configuration, whilst the outbound call goes out and billsec gets reported correctly in the h exten, the call does not get bridged back into the campaignType_5 context so none of the call processing occurs. I cannot see any options that can be passed to the dial command that may affect the bridging of the call back into the campaignType_5 context??? Does anyone out there know which way I need to hang my tongue out of my mouth, how much i need to squint my eye and how far I need to tilt my head (and to which side) to get 1.6.2 or any other post 1.4.20 version of asterisk to report billsec etc back at the h exten for a call established via an Originate action similar
[asterisk-users] CDR(billsec)
Hi people, when I try to get the billsec in the dialplan, it is 0... but if after that I check the database, it is right (not 0). I'm trying to get it in the h extension, like: exten = h,1,Noop(End) exten = h,n,Noop(Time is ${CDR(billsec)}) Is it updated after the extension h is executed? In that case, how can I get the call duration in the h extension? Thanks, Anahi Ludueña _ Infórmate, mantente en contacto y encuéntralo todo, a la vez. Con la nueva Toolbar de MSN nunca has tenido tantas ventajas en tan poco espacio. http://toolbar.es.msn.com/___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR(billsec)
Since CDR(billsec) is a live variable until the Hangup command is issued (actually until the CDR is written), the only way to get the value (IMO) would be after the call was completed. You could do a DeadAGI or System call using CDR(uniqueid) to report the value from the CDR back to another call or web page. _ From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Anahi Ludueña Sent: Wednesday, October 28, 2009 6:35 AM To: asterisk-users@lists.digium.com Subject: [asterisk-users] CDR(billsec) Hi people, when I try to get the billsec in the dialplan, it is 0... but if after that I check the database, it is right (not 0). I'm trying to get it in the h extension, like: exten = h,1,Noop(End) exten = h,n,Noop(Time is ${CDR(billsec)}) Is it updated after the extension h is executed? In that case, how can I get the call duration in the h extension? Thanks, _ Anahi Ludueña _ Todo el espacio y cuidado que merecen tus fotos digitales lo tienes en Windows Live Fotos. ¡Pruébalo! http://www.vivelive.com/compartirfotos/ ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR billsec greater than duration
Yes, I think so Seconds since the presumed media start E. Alex Balashov ha scritto: What is the definition of billsec, just out of curiosity? Seconds since the 200 OK from both ends / presumed media start? On Thu, 16 Aug 2007, Jaswinder Singh wrote: I made same thread few months ago and many people said that they dont have such records in plain asterisk install ( no freepbx ) . I was also using freepbx when i had this problem . Heres mine : mysql select count(*) from cdr where billsec duration; +--+ | count(*) | +--+ | 124 | +--+ this is out of 1749216 cdr records . I am also using freepbx btw . In all such cdr's duration is always 0 but billsec varies . On 15/08/07, Edoardo Serra [EMAIL PROTECTED] wrote: Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- Alex Balashov Evariste Systems Web: http://www.evaristesys.com/ Tel: +1-678-954-0670 Direct : +1-678-954-0671 ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR billsec greater than duration
I noticed that fpbx calls ResetCDR on call hangup (don't know why this choice) Could it be related to that ?? Tnx E. Jaswinder Singh ha scritto: I made same thread few months ago and many people said that they dont have such records in plain asterisk install ( no freepbx ) . I was also using freepbx when i had this problem . Heres mine : mysql select count(*) from cdr where billsec duration; +--+ | count(*) | +--+ | 124 | +--+ this is out of 1749216 cdr records . I am also using freepbx btw . In all such cdr's duration is always 0 but billsec varies . On 15/08/07, *Edoardo Serra* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR billsec greater than duration
The destination numbers are valid in almost all cases . But i do think it might be when someone is on call and on client side internet connection goes off .. I am really not sure about this one but i just saw that maximum such records are from one of my customer who has a very bad connection . On 16/08/07, Edoardo Serra [EMAIL PROTECTED] wrote: I noticed that fpbx calls ResetCDR on call hangup (don't know why this choice) Could it be related to that ?? Tnx E. Jaswinder Singh ha scritto: I made same thread few months ago and many people said that they dont have such records in plain asterisk install ( no freepbx ) . I was also using freepbx when i had this problem . Heres mine : mysql select count(*) from cdr where billsec duration; +--+ | count(*) | +--+ | 124 | +--+ this is out of 1749216 cdr records . I am also using freepbx btw . In all such cdr's duration is always 0 but billsec varies . On 15/08/07, *Edoardo Serra* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR billsec greater than duration
You are a victim of hung channels, just write a script that corrects this. Anthony Mail list wrote: The destination numbers are valid in almost all cases . But i do think it might be when someone is on call and on client side internet connection goes off .. I am really not sure about this one but i just saw that maximum such records are from one of my customer who has a very bad connection . On 16/08/07, *Edoardo Serra* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I noticed that fpbx calls ResetCDR on call hangup (don't know why this choice) Could it be related to that ?? Tnx E. Jaswinder Singh ha scritto: I made same thread few months ago and many people said that they dont have such records in plain asterisk install ( no freepbx ) . I was also using freepbx when i had this problem . Heres mine : mysql select count(*) from cdr where billsec duration; +--+ | count(*) | +--+ | 124 | +--+ this is out of 1749216 cdr records . I am also using freepbx btw . In all such cdr's duration is always 0 but billsec varies . On 15/08/07, *Edoardo Serra* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR billsec greater than duration
Yes it maybe a hung channel problem .. but question is no matter how much billsec ... should duration be more than that ? On 16/08/07, Anthony Francis [EMAIL PROTECTED] wrote: You are a victim of hung channels, just write a script that corrects this. Anthony Mail list wrote: The destination numbers are valid in almost all cases . But i do think it might be when someone is on call and on client side internet connection goes off .. I am really not sure about this one but i just saw that maximum such records are from one of my customer who has a very bad connection . On 16/08/07, *Edoardo Serra* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I noticed that fpbx calls ResetCDR on call hangup (don't know why this choice) Could it be related to that ?? Tnx E. Jaswinder Singh ha scritto: I made same thread few months ago and many people said that they dont have such records in plain asterisk install ( no freepbx ) . I was also using freepbx when i had this problem . Heres mine : mysql select count(*) from cdr where billsec duration; +--+ | count(*) | +--+ | 124 | +--+ this is out of 1749216 cdr records . I am also using freepbx btw . In all such cdr's duration is always 0 but billsec varies . On 15/08/07, *Edoardo Serra* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] CDR billsec greater than duration
Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] CDR billsec greater than duration
Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR billsec greater than duration
What is the definition of billsec, just out of curiosity? Seconds since the 200 OK from both ends / presumed media start? On Thu, 16 Aug 2007, Jaswinder Singh wrote: I made same thread few months ago and many people said that they dont have such records in plain asterisk install ( no freepbx ) . I was also using freepbx when i had this problem . Heres mine : mysql select count(*) from cdr where billsec duration; +--+ | count(*) | +--+ | 124 | +--+ this is out of 1749216 cdr records . I am also using freepbx btw . In all such cdr's duration is always 0 but billsec varies . On 15/08/07, Edoardo Serra [EMAIL PROTECTED] wrote: Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- Alex Balashov Evariste Systems Web: http://www.evaristesys.com/ Tel: +1-678-954-0670 Direct : +1-678-954-0671 ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR billsec greater than duration
I made same thread few months ago and many people said that they dont have such records in plain asterisk install ( no freepbx ) . I was also using freepbx when i had this problem . Heres mine : mysql select count(*) from cdr where billsec duration; +--+ | count(*) | +--+ | 124 | +--+ this is out of 1749216 cdr records . I am also using freepbx btw . In all such cdr's duration is always 0 but billsec varies . On 15/08/07, Edoardo Serra [EMAIL PROTECTED] wrote: Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users