similar to: 1.6, CDR and h extension

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

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

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

This was always possible in the past, however does not work in the current release. I believe this is a bug. To: asterisk-users at lists.digium.com From: cervajs at fpf.slu.cz Date: Fri, 9 Oct 2015 10:04:47 +0200 Subject: Re: [asterisk-users] Storing HANGUPCAUSE in CDR search in archives save the records to another table like cdr_extended Dne

I think HANGUPCAUSE is channel agnostic. See: core show function HANGUPCAUSE Some thing like this IIRC: Set(my_cause=${HANGUPCAUSE(${CHANNEL(name)},tech)}) Remember the incoming leg of the call and the outgoing leg of the call are different channels. Make sure you are giving HANGUPCAUSE the correct channel. On 06/09/2018 02:01 PM, Khalil Khamlichi wrote: > It seems very weird to me

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

Thanks Dovid! Indeed looks a bug but regardless of this, this problem made me think that the HANGUPCAUSE could be used for this purpose with benefits. I couldn't find an explanation about when DIALSTATUS would actually be better. The HANGUPCAUSE was reworked in version 11 ( https://wiki.asterisk.org/wiki/display/AST/Hangup+Cause) but I didn't find someone actually stating it is a better

Hello list, Hope all doing well! I've been checking some cases when a Dial fails and dialplan execution continues to handle this. I am finding it a little confusing how we should handle the DIALSTATUS and the HANGUPCAUSE in this situation.... More specifically, I am facing a case in version 13.6.0 where I am getting a DIALSTATUS=BUSY and HANGUPCAUSE=19 after receiving a 480 SIP error. Seems

Hello, On an Asterisk 1.4.33.1 in a simple scenario: [test] exten => _X.,1,Dial(SIP/12345 at peer01,,,) exten => i,1,Hangup(${HANGUPCAUSE}) exten => t,1,Hangup(${HANGUPCAUSE}) exten => h,1,Hangup(${HANGUPCAUSE}) I have noticed that no matter what value we set in the Hangup(<cause code>) commands, if the call is not answered by peer01 for any reason, the actual cause code

Hi, I'm using Asterisk and a TE110P E1 PRI in Chile. When I call to a disconnected number or any not operational number, the telco sends the Hangupcause disconnection code and an audio message notifying the disconnection cause to the user. Asterisk does not allow the user to hear the audio message form the telco, instead it cuts the call. Any other legacies PRI PBX I've tested allow

Hi, I'm trying to get HANGUPCAUSE on my cdr the problem I'm facing is that this option: endbeforehexten=yes is not working at least on asterisk 1.6.0.1, so if I put yes o no I cant set CDR value with that value. It seems to finish the CDR record before h is executed. I'm using cdr_mysql. Any idea?? Thanks!! -------------- next part -------------- An HTML

Just throwing this out here, hopefully someone can tell me why. *CLI> show version Asterisk CVS-HEAD-11/17/04-10:16:38 built by root@wanderer on a i686 running Linux Zap/g1 is pri_cpe to Bell Canada 5551234 is a normal POTS line I have busied out (handset offhook) exten => 1234,1,Dial(Zap/g1/5551234,,g) exten => 1234,n,NoOp(HANGUPCAUSE is ${HANGUPCAUSE} and DIALSTATUS is

I'm trying to write a dialplan that will allow me to "stress" test it. I want to be able to dial an extension, or pretend that the extension is busy or out of order (so that I can see what to do) given the dialplan snippet: [outbound] exten => _X.,1,NoOp(${TEST}) exten => _X.,n,Dial(SIP/${EXTEN}) exten => Busy,1,Busy(2) exten => Busy,n,Hangup() exten =>

I am seeing some curious behaviour with a 1.2.32 system, which I do not understand and so can't work out how to fix it. I have a PRI routed to context default. Here is the complete default context: [default] exten => _9X.,1,Dial(IAX2/m1peer/${EXTEN:1}) exten => _20XX,1,Dial(IAX2/sipeer/${EXTEN}) exten => _X.,1,Dial(IAX2/m1peer/${EXTEN}) exten =>

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

Hi, I hope this gets picked up by some bug marshall ... I have downloaded (yesterday) the 1.2 branch from svn ... When running: asterisk -vvvvc loaded modules: [modules] autoload=no load => pbx_functions.so load => pbx_config.so load => codec_a_mu.so load => format_pcm_alaw.so load => codec_ulaw.so load => codec_alaw.so load => format_pcm.so load => func_uri.so

I'd like to grab the SIP response code that comes back from an INVITE. The HANGUPCAUSE gives the converted ISDN cause code. Anyone know of a way to get the SIP response code instead? Doug. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -------------- next part -------------- An HTML

Dear, I have this scenario: - PBX Asterisk 1.6.2.10 with private IP 192.168.0.10 - Behind a Cisco ASA firewall that connects to Internet - SIP trunk to Net2Phone with these parameters (nat=no): host=200.58.113.60 username=DOLLY secret=123456 port=5060 type=peer dtmfmode=rfc2833 disallow=all allow=alaw&ulaw nat=no canreinvite=no qualify=yes -Softphones Xlite The PBX can't register to

Hello, you know , when a call setup, either caller hangup first or callee hangup first , the hangupcause will set to 16(means Call Clearing Causes) My question is how could i identify whether the caller or callee hangup the phone first? Best Regards! -- Thanks for your supporting, have a nice day. Sucan

Hi, I am experimenting with getting hold of the sip cause and sip response from outgoing call. How could i make a userevent printing the sip cause and/or sip response. I have tried using hangupcause, sip_cause and such , but i am not getting any data. I would at least like to use the q.850 reason codes in the dialplan which i now am unable to do. Any help appreciated. [Beskrivning: Fogwise -