similar to: hostname in MySQL CDR records

I have A@H 2.1, running * 1.2.1. I am trying to put information into the userfield with SetCDRUserField and AppendCDRUserField. However, the field is never populated in the cdr - I've checked the csv files and the MySQL asteriskcdrdb table. The field is defined in the MySQL table, but is always empty. The csv files that get created don't have a userfield at all, that is, there

Hi, I write the CDR of my Asterisk 1.2.17 server in MySQL database using cdr_addon_mysql.so. Now I'm trying to write some custom values to userfield column by the SET(CDR(USERFILED)=SOME_TEXT) sintax, but nothing gets writeen in MySQL cdr table!! Why? I'm I skeeping something or what? Taking a look at the URL:

Hi I am trying to use SetCDRUserField in an agi script but with no success. I am using the CDR mysql addon, however I can't see it being at fault as my attempt is not doing anything to the CVS CD either. has anyone used this, any hints guidence would be greatly appreciated. The syntax I am using is like so .. res=DoExec('SetCDRUserField','12345'); and then dialing the

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

Ok... I am reluctant to ask this question as I believe that it may be like asking what someones favorite linux distribution is... but I need to make an informed decision. We are getting ready to upgrade from a TE210P to a quad T1 card with echo cancellation. I am trying to decide between the Sangoma card and the Digium card. I need this to have great quality and I need it to work well. I would

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

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, Is there a way to enable the usage of UNIQUEID CDR field using a MySQL database backend for storing CDRs without having to recompile asterisk-addons as stated here http://www.voip-info.org/wiki-Asterisk+cdr+mysql ? After version 1.4 it is said in release that it can be done (not sure if it applies to mysql backend) How would it be the syntax in cdr.conf? I tried this without success in

Hello... I have a big problem with asterisk. Every time i make a call asterisk does not bridge the zap channels. The zap channel from which i'm calling remains in state:ring and applicaton:dial and the zap channel with the external line configured remains in state:dialling an Application:AppDial. Zap/20-1 agentie s 1 Dialing AppDial (Outgoing Line) 09399 (None) Zap/9-1 int_omg 09399 5 Ring

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

I've discovered that when dialing out using API's Originate action, a no answer is considered a failed attempt, while a busy is considered a successful attempt. The problem I'm having is that when I dial an invalid number, say a disconnected number that gives a fast busy, my CDRs are identical to those generated by a no answer attempt. Is there a way to distinguish between a no

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

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 Is there any way to stop Asterisk from sending Caller ID display on the softphones ? I;ve E1 PRIs and SIP extensions , i need to stop caller ID from appearing on the softphones ...but in CDRs caller Ids should show - so please dont suggest to set "blockcallerid=yes" in zapata.conf ;) Thanks Sriram -------------- next part -------------- An HTML attachment was scrubbed... URL:

Skipped content of type multipart/alternative-------------- next part -------------- A non-text attachment was scrubbed... Name: cdr_tds.c Type: application/octet-stream Size: 11765 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20041001/7193730a/cdr_tds.obj

Hi all, I looked at patching oVirt Server to work with the latest Matahari schema, from Matahari's 'next' branch, version 0.4.0. ovirt-server depends on matahari version 0.0.5, which is currently latest in Fedora, and it is used during Node registration, to enumerate hardware information. Usage extracted from src/host-browser/host-register.rb is as follows: host_list =

Hi, I am trying to find a way to add the following info in CDRs (with asterisk 1.4.23.1): 1. Codec used 2. RTP QoS statistics 3. RTP IP of remote host 4. For answered calls, the peer that requested to end the conversation I have managed to get 1 and 2 for the caller, like that: exten => h,1,Set(CDR(userfield)=RIP=${SIPCHANINFO(recvip)}

Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY

You can use the CDR(userfield) value, to save the ip's in the CDR record. Jon -----Oprindelig meddelelse----- Fra: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] P? vegne af Benjamin Jacob Sendt: 3. november 2006 06:18 Til: Asterisk Users Mailing List - Non-Commercial Discussion Emne: [asterisk-users] ip address in CDR Hello ppl, Any way to store

Greyman-- I'm taking this discussion to the list. Folks, what we are talking about here, is me trying to get a grasp around Greyman's (Aaron's) request for a bare-bones CDR generation that describes just total connect time for channels, stripping out all the details. Who cares about xfer, park, hold, etc.? So in the following is our discussion about what *should* be there, and in