similar to: cdr records on transfer

Can someone tell me what I am doing wrong? Why doesn't CDR(duration) or CDR(billsec) return the correct values? cdr.conf endbeforehexten=yes extensions.conf [macro-Dial] ; ${ARG1} - Dial String exten => s,1,Dial(${ARG1},,M(post-dial)) exten => h,1,NoOp(Call was hung up - ${CDR(duration)} seconds long, billed for ${CDR(billsec)} seconds) The log shows: -- Executing [h

This is more of mysql question then asterisk :D . Most voip providers use 6 second rounding for costing . My asterisk server stores call cdr's in mysql properly with billsec field containing number of billed seconds . I want to know some function to round this to 6 seconds ( or any custom valud like 30 seconds ) ..Suppose if billsec field is 3 seconds then it should round to 6 seconds , if

Hello, i have call time irregularites in my asterisk CDR. I a currently using a mysqly backent to save CDR records and use this to generate bills at the end of each month. However, my users are complaining that they gety charged for even uncompleted calls (i.e. calls they make whaich have already be setup but canclled). i have noticed that only 'AWNSERED' and 'Busy' show up in my

Hi, My costumers are logged in on my Asterisk PBX through XLite Softphone (SIP). My server is connected to PSTN. Problem is when SIP phone calls ordinary phone via dahdi I get DAHDI/1-1 ANSWERED SIP/number-number and billsec field from cdr is start counting. Is it normal behavior ? Can I change that ? So channel gets in ANSWERED state and billsec starts as soon as line starts to ring even if no

Hi All my incoming dial plans start of with an Answer which I now know starts the billing time. Some of the dialplans then get forwarded out to POTS via a carrier and so the actual amount of time that should be billed is being distorted. I've done a few tests this morning and found that if I don't start with an answer then the billsec of my forwarded call is actually the length of

Hi, I'm stuck on a silly thing. I need to get the "billsec" CDR value after a call. But I'm finding its always 0. Here's my test code: exten => *244*,1,Dial(Local/test@custom-tests/n,,g) exten => *244*,n,Noop(after dial duration is ${CDR(duration)} billsec is ${CDR(billsec)}) exten => *244*,n,Hangup [custom-tests] exten => test,1,Answer exten =>

Hello everyone Is there a possibility to catch an outbound callleg ID for the follovong scenario: some carrier -----> ------(asterisk1) --->-----asterisk2 ? I can get inbound callid for asterisk1 with a ${SIPCALLID} in extensions.conf or to look it up in cdrs field (are the same). But how about outbound? I have all calls just forwarded through asterisk1, not answered and for every call I

Hello, I want to create php rate script and I'm using Deadagi. But I allways get billsec 0 , or nothing. Can you help me to solve this problem... My extension.conf: exten => _123,1,DeadAgi(rate.php) exten => _123,2,hangup And my simple test php script rate.php #!/usr/local/bin/php -q <?php include_once (dirname(__FILE__)."/phpagi.php"); $AGI = new AGI();

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

Hello, I am wondering if someone has got any ideas that can help solve this problem. I have a dial plan that you call into, and depending on certain conditions it calls out on a number grabbed from a database. Something like this : exten => s,n,Do something exten => s,n,Do something else exten => s,n,Dial(ZAP/g1/${OUTBOUND},${timeout}) I need to log the time the person

Hi, I've got a dialplan that transfers all outgoing calls to a Local channel before dialling out via SIP. I did this because sometimes i'm dialling two numbers at the same time and need to know which call is answered for billing purposes. However, I've just noticed that billsec is always equal to 0 even though i know the calls were answered. I now have to take the cdrs from my

How is the billsec field calculated in CDRs? I have a situation where billsec is being reported as 0 despite the call being answered and a conversation occurring. An example record follows: '2007-11-06 21:36:50', '6495566778', '6495566778', '0116495566778', '1100012_1', 'Local/0116495566778 at 1100012_1-887b,2',

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

Hello Asterisk-Users, For some reason my CDR records for disposition and billsec are not working correctly. I always receive a 0 for billsec and the disposition is always at "NO ANSWER', even when I grab the calls. I experience this with Asterisk 1.6.0.1 and Asterisk 1.4.22. Here is information on how I do the call: -----------------------------------------------------------------

I was just going through my call records ( stored in mysql database by cdr_MYSQL module ) and saw a record having duration = 0 and billsec of more than 50 seconds . I did a query on cdr where duration < billsec and saw that there were infact some 250 records with duration less than billsecond ( table had around 4,00,000 records) . Did anyone came across this ? I also checked csv files and they

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

I'm using a macro such that if a call is forwarded to my mobile, I can choose to accept it or not. This is done with the following Dial command: Dial(IAX2/voiptalk/44${ARG1:1},15,trM(screen)ow) and the following macro: [macro-screen] ; Allow called user to accept/reject the call exten => s,1,Wait(0.2) exten => s,2,Read(Accept|loho-support-choose|1) exten =>

Hi I'm having a problem with Asterisk 1.6.2.9 with the MySQL cdr addon. With some calls, the value in the `billsec` field in the CDR is exceeding the value in the `duration` field. I didn't think this was supposed to happen? Our old installation (some ancient version, sorry not available) always had `billsec` <= `duration`. The problem does not seem to be evenly distributed

Hi a new small question ;=) We have two Asterisk, connected in IAX2. On the first, in dialplan, we have: exten => _XX.,1,Set(IAXVAR(ACCOUNTID)=${CDR(accountcode)}) we sent into the IAXVAR "ACCOUNTID" the accountcode. On the second, in dialplan, we have: exten => 18,2,AGI(Caller-ID.agi,${IAXVAR(ACCOUNTID)}) That's work, the second server get the variable. I

When I look at my CDR data for calls to NuFone, the billsec for each call is 14 seconds or less. When I look at my NuFone account, the billsec has normal call lengths. So it seems that the billing on the Asterisk system terminates after about 14 seconds. The calls come in on an IAX connection and go out to NuFone on IAX. Are these calls bridging away from the Asterisk server? How can I