similar to: RESOLUTION: SetCDRUserField not working in A@H?

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

Gang, I'm having this error pop up when I do a ForkCDR, and I'm not sure how to get around it. Here are a few log lines: Nov 8 10:37:08 VERBOSE[28079] logger.c: -- Executing ForkCDR("Zap/49-1", "") in new stack Nov 8 10:37:08 WARNING[28079] app_forkcdr.c: Channel does not have a CDR The scenario occurs like this: I use a .call file to generate a call on

Hi all I am using * to trunk calls to a number of customers. This is proving unreliable - I set qualify=yes on all the trunks: [customer] type=friend host=customer.dyndns.org username=hewlett secret=******* context=int_calls trunk=yes nat=yes qualify=yes All Internet links are ADSL. I am running 1.0.9. I get a no. of symptoms: - every now and again i get a message that

Question: I'm trying to put a double quote into the CDRUserField. What I end up with is a pair of double quotes. Example: exten => s,n,SetCDRUserField(data) exten => s,n,AppendCDRUserField(") exten => s,n,AppendCDRUserField(moredata) My record will look like this: data""moredata What I want is: data"moredata The wiki mentions using a backslash in order to

Hi all, I'm using Asterisk 1.0.9-BRIstuffed-0.2.0-RC8o on box A with a TE410P (EuroISDN cpe) connected to another similar asterisk box B acting as EuroISDN master. I'm performing some load tests by contiously feeding up to concurrent 30 call files to /var/spool/asterisk/outgoing/ on box A which inititate via a dialplan context/extension a outbound call (redirected via chan_local) to

Hi I am trying to get a SNOM 360 to monitor other extensions i.e. when someone makes a call to/from another extension, one of the LED's on the SNOM 360 will change state. I am using 1.0.9/bristuff-8l. I have 2 extensions - 2001 is a SNOM 190, 2002 is a 360 - both are running the latest firmware. (3.60i for 190, 4.0 for 360). I have read all the relevant articles on the wiki on

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

Hi all, I'm trying to add custom billing info into the CDR records. I did a SetCDRUserField from my agi. Asterisk seems to acknowledge the call, but the value is not anywhere in the CDR record. I checked the CSV and Mysql CDR table. The field is always blank. Anyone had any success with this? Cheers and TIA.

I would like to send the CDR records from all our machines around the world to a single database. But I need the hostname included with each record for monitoring purposes. Is there a better way than using the userfield and adding SetCDRUserfield for every call to set the userfield to the name of the host? Thanks...

I have a pretty basic Mandrake 10.2 w/KDE 3.2 and I installed Asterisk-1.0.1-2mdk. I installed the source of main and contrib from ftp, so at the install time I accepted all the packages needed to be installed too. The installation went smooth, but when I try to execute asterisk (#asterisk -vvv) I encounter few warnings I end with an error. At this point I didn't touch any conf file, I was

Hi, I'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install. The add-ons pack has been installed for a while, so now I'm trying to add the Mysql config. I've created a mysql database, added the grants for a user acces, and can run a mysql -u asteriskcdruser -p and can connect to the database. I've been using this as a guide:

Hi, I hope this can help others, so this is it. Use it at your own risk. I have test it on 3 separate systems without any problem. Take care to edit the following files taking into consideration your own settings. If you have all the CDR info in the Master.csv too, then delete all the data from the 'cdr' table in MySQL before running the script bellow in oder to prevent dupplicate

Hi guys, I have recently installed a Asterisk Server with CDR Call Detail Records. I have installed it over a Asterisk 1.2 , but now It do not run . I have installed it with the following procedure: # yum install ncurses #yum install openh323-devel # yum install mysql-server # yum install mysql # yum install php-gd # yum install php-mysql # yum install mysqlclient10 # yum install zlib # yum

SetCDRUserField doesn't appear to be working in the 5/25/05 CVS - Anyone else having this problem?

Hi, I have installed asterisk-1.4.4 and asterisk-addon-1.4.1. I followed every step to configure RealTime but something is not working properly; the warning that I am geting is: WARNING[32709]: config.c:1229 find_engine: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available WARNING[1359]: config.c:1229 find_engine: Realtime mapping for

Hello, I have an Asterisk box with a TE410P connected to a PRI line and agents with X-Lite installed on the same LAN as the Asterisk server. Sometimes, when I make outbound calls it hangs up as soon as other party tries to picks up the call. Does someone ever experienced this situation? On X-Lite, only G711-ulaw is enabled and here is what i put in sip.conf: [4001] type=friend username=4001

hi there :) i get this error in the asterisk CLI: Sep 21 20:31:49 ERROR[3774]: cdr_addon_mysql.c:159 mysql_log: cdr_mysql: Unknown connection error: (2006) MySQL server has gone away when I run 'cdr mysql status' i get: Connected to voiceone at localhost, port 3306 using table cdr for 18 minutes, 24 seconds. Wrote 8 records since last restart and 1 records since last reconnect. I

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

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 For whatever reason we've getting 2 or 3 CDR lines logged for each call, often in different formats: as1:~# grep test-89-1e2c /var/log/asterisk/cdr-csv/*.csv