similar to: billsec and duration issue

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 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

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

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

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

Hello list, I'm having troubles implementing the ${CDR(duration)} & ${CDR(billsec)} variables in this scenario: PEER CALLS OUT -> CALL GOES TO PEER'S DEFAULT OUTGOING CONTEXT -> THE CALL IS SENT TO A MACRO AND GOES IN HANGUP -> THE CALL RETURNS TO EXTENSION h OF PEER'S DEFAULT OUTGOING CONTEXT (here I'm trying to print the variable)

Hi to all, I was looking in google and also in this mailing list, but I dont find the solution to my problem, so I subscribe me to the list in order to post this e-mail and find the solution. This is the scenario: GSM Phone ----- GSM Network ---- TDM2406E --- ASterisk 1.4.0 (*) -------- VoIP Provider ------- Sip Phone or H323 Phone The problem is that I am generating calls from SIP and also

The behaviour of my Asterisk appears to have changed suddenly without any apparent cause. The version is use is 1.4.27.1 When a call is not answered billsec is set to duration, and calls are charged. I can't see any change I could have made to cause this problem. Is it something already known in Asterisk? /voipfc

Hi, To check telco billing, I'm usinfg Asterisk-Stats from http://www.areski.net/asterisk-stat-v2/about.php . How can you tweak this application to display graphics and data that use Billsec instead of Duration ? Regards -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi, all Sorry that forgot add mail subject last one. I use Ubuntu 12.04.01 TLS and install asterisk 11.7.0 (tar.gz downloaded from asterisk.org). We named it "Asterisk11". I want to generate a call file to /var/spool/asterisk/outgoing. This call will dial out to Local Channel and return to some Extens. Then Asterisk11 will generate a CDR records to MySQL's cdr table(in database

Hi, all Sorry for null subject last mail. I use Ubuntu 12.04.01 TLS and install asterisk 11.7.0 (tar.gz downloaded from asterisk.org). We named it "Asterisk11". I want to generate a call file to /var/spool/asterisk/outgoing. This call will dial out to Local Channel and return to some Extens. Then Asterisk11 will generate a CDR records to MySQL's cdr table(in database

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.

Hello, I have problem with interpretation of CDR entries. What happened? ------------- There was: 1. at 09:00:26 we received call from unknown caller (no callerid) to secretary with extension 17 2. secretary answered and after some conversation called to extension 18 to check if she could transfer customer call 3. at 09:02:55 extension 18 answered and call was forwarded 4. call was very long

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

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

Hi all, I need 2 CDR Records of below 2 numbers for outgoing calls, detail is given as below: *96XXXXXXXX88XXXXXXXX* *=> Call file : outbound call generate through below file* Test.call ====== Channel: local/s at outgoing/n WaitTime: 45 Context: outgoing_ivrs Extension: s Priority: 1 Set: contact_no=96XXXXXXXX extensions.conf ============ [outgoing] exten => s,1,NoOP(----- First LEG

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES

Hi, I have asterisk-server version of 1.8.11-cert7. When external enemy try to using it for calling, server write this string to log: 2014-03-13 09:56:04] VERBOSE[4754] pbx.c: -- Executing [9810972592309759 at from-sip-external:1] NoOp("SIP/external-ip-00065fd2", "Received incoming SIP connection from unknown peer to 9810972592309759") in new stack [2014-03-13

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

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 =>