similar to: CDR updating

asterisk 11.1 Documentation in cdr.conf for endbeforehexten reads: Normally, CDR's are not closed out until after all extensions are finished executing. By enabling this option, the CDR will be ended before executing the "h" extension and hangup handlers so that CDR values such as "end" and "billsec" may be retrieved inside of of this extension. I have

Hi all, I use astersk 11.7.0 on Ubuntu 12.04.01 TLS (i386). I use cdr_adaptive_odbc to write CDR to my MySQL's cdr table. After my testing, this scenario is working well. After a long idle time, I didn't make any call to the asterisk server. When I try to make a call again after 8 hours, I found that the cdr lost. It cannot be inserted to cdr table. Also, I could not find the insert CDR

I have two version 1.6 Asterisks running. One is a small hobbyist thing just at home, and the other is handling calls for several customers. On both, I have added the line exten => h,1,Set(CDR(hangupcause)=${HANGUPCAUSE}) to all relevant contexts. On my little hobbyist box this works perfectly; all calls have their hangupcauses recorded with cdr_adaptive_odbc and cdr_custom. On the

I'm running 1.6.2.13 and need to record a small number of custom values use cdr_odbc and cdr_adaptive_odbc, and only the custom fields. The good news is that the custom records are being stored in the database as desired. The bad news is that I get three sets of warnings/notice about 'SQL Exec Direct failed' and dropping then reconnecting the database handle. I traced the SQL calls

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

Dears, I need to save some information on userfield when calls end in Asterisk13, but I have two error cases: 1. With endbeforehexten=no in cdr.conf, I have a registry in cdr, but userfield is not set. 2. With endbeforehexten=yes, I have two lines in cdr, one with duration, src e dst correct, and a second line with userfield setting and dst h. I am using cdr_odbc.conf, with Asterisk11.14.0 it

Hi, I would like to see the DNID in my MySQL CDR logs. I have read one big thread in the Asterisk Developer List, but I could not figure out how to implement it ? Is there a simple step-by-step. Thx in advance. Vai

2013/3/29 Julian Lyndon-Smith <asterisk at dotr.com> > check out the endbeforehexten option in cdr.conf > > this needs to set to "yes" > > Julian > Unfortunately, this doesn't help. Let's drop the hangup handler at the moment, and focus on the "saving to file" part. Then my issue is I can't update CDR value is hangup exten. Here is a

With endbeforehexten=no I actually get two CDR entries. One for the call and a second one for the "h" extension. "","13","10","sip-locals","""13"" <13>","SIP/13-00000006","SIP/10-00000007","Dial","SIP/10","2015-08-04 06:28:44","2015-08-04

> Hi All > > I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. > > The curious thing is I can find them all inside the database. > I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. > > "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e

What would it do if you exten => h,1,ResetCDR(w) exten => h,2,NoCDR() exten => h,3,DEADAGI(get-unqiueid.php) I have not tried it but in theory it should write the first CDR and then kill the write of the second NO ANSWER CDR. Let me know if it works for you as I may need to do it on some of my h exten code as well. Bryant ---------------------------------------- From:

Hi, Reading this old thread, may I ask if keeping hangup handlers from updating CDR values still enforced in Asterisk 15 ? If positive, would it be very complex to add in Asterisk, a configuration option allowing a system administrator to list in cdr.conf, the CDR fields allowed to be updated in hangup handlers ? I'm planning to store some RTCP stats. Saving them in CDR(userfield) would be

On Sat, 25 Apr 2015 17:11:34 +0200 jg <webaccounts173 at jgoettgens.de> wrote: > > > Hi All > > > > I have dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually

Ok I can't get my CDR values to set from the h extension in either 1.6.2 or 1.8 What is wrong? Here is what I found in the cdr.conf ; Normally, CDR's are not closed out until after all extensions are finished ; executing. By enabling this option, the CDR will be ended before executing ; the "h" extension so that CDR values such as "end" and "billsec" may

Hi, I have the following code that operates when a channel is hung-up: [record-hangupcause]exten => 1,n,Set(CDR(hangupcause)=${HANGUPCAUSE})exten => s,n,Return() Before the dial a hangup handler is registered: Set(CHANNEL(hangup_handler_push)=record-hangupcause,s,1) The routine is called and the variables are being set, however not on the channel's CDR which made the call. I believe this

Hi, I'm trying to migrate from Asterisk 1.8 to Asterisk 13 and can't figure this one out. I'm pretty sure the question has been already asked, but I failed to find a solution. Can you modify CDR values in an h-extension? My cdr.conf contains: [general] enable=yes unanswered=yes endbeforehexten=yes initiatedseconds=no batch=no The diaplan contains a simple "h" extension

Hi All I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. The curious thing is I can find them all inside the database. I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for

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

Every once in a while (like 2 out of 7 times), I get the following message: [Nov 14 12:49:02] NOTICE[6855]: cdr.c:434 ast_cdr_free: CDR on channel 'SIP/5000-082508f0' not posted I look in the cdr table in mySQL and indeed, the record is not posted for that call. This makes me want to create hard file and a compare script between the file cdr and the odbc cdr, but I was wondering if