similar to: custom cdr fields and cdr_mysql, howto?

Hi, The Asterisk Wiki (page: http://www.voip-info.org/wiki/view/Asterisk+func+cdr) mentions I can set any custom CDR field I want. Here is the example it gives: ; Update our accountcode field and then save some random music facts too exten => s,1,Set(CDR(accountcode)=8675309) exten => s,2,Set(CDR(MyFavoriteBand)=Foo Fighters) exten => s,3,Set(CDR(MyFavoriteSong)=Hero) I am

So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the database structure for cdr_mysql is: CREATE TABLE cdr ( calldate datetime NOT NULL default '0000-00-00 00:00:00', clid varchar(80) NOT NULL default '', src varchar(80) NOT NULL default '', dst varchar(80) NOT NULL default '', dcontext varchar(80) NOT NULL default '', channel

cdr_mysql doesn't set the userfield when it's set inside a macro called from a feature (1.4.25, addons 1.4.8). I have a feature code: autorecord => *1,self,Macro,apprecord The apprecord macro looks like: [macro-apprecord] exten => s,1,Playback(beep) exten =>

I am trying to compile current cvs asterisk-addons for mysql cdr but I get the following error. Iam running mysql 4.0.20 and cvs v1 stable version of asterisk. cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/local/mysql/include -c -o cdr_addon_mysql.o cdr_addon_mysql.c cdr_addon_mysql.c:50: warning: parameter names (without types) in function declaration cdr_addon_mysql.c:50: warning: data

Here is the error I get compiling the asterisk-addons rpm cc -fPIC -I../asterisk -I/usr/include/mysql -c -o cdr_addon_mysql.o cdr_addon_mysql.c cdr_addon_mysql.c:50: error: `PTHREAD_RECURSIVE_MUTEX_INITIALIZER_NP' undeclared here (not in a function) make: *** [cdr_addon_mysql.o] Error 1 I'm pretty sure I got all that is needed: # rpm -qa | grep mysql mysql-3.23.58-4

How to enable cdr_mysql.conf in Asterisk 1.6? I have installed asterisk-addons which compiled mysql support, "module show" is showing "cdr_addon_mysql.so" but cdr_mysql.conf was not created in /asterisk directory Is there any configuration file to enable mysql support? Comping cdr_mysql.conf from previous installation does not do anything, calls aren't recorded. --

At approximately 3:15pm I shut down the office MySQL server to change out some hardware. Shortly after I received a call from one of two customers whose asterisk servers output CDR data to that server. They could not place or receive calls. Shortly after that I received a call from the other customer. I'm below providing output from the message log (At debug level). I don't see much

Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306

Can anyone give me presise instructions on how to compile cdr_mysql.so? When I initially installed asterisk on the system, I didn't have mysql installed. Since then I have installed mysql, created the database and table structure for cdr_mysql and placed the appropriate settings in the cdr_mysql.conf file. However when I do a show modules at the CLI I cannot find cdr_mysql.so.

Hello list, I keep on getting the error : ERROR[1707] cdr_addon_mysql.c: Cannot connect to database server 127.0.0.1: (1045) Access denied for user 'asteriskcdr'@'localhost' (using password: YES) I have a 'cdr' table in my MySQL-DB. On this table the user 'asteriskcdr' has select, insert, update privileges. GRANT SELECT , INSERT ,UPDATE ON `Asterisk`.`cdr`

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

hello all, I am using the msql cdr module to store cdr in db, I realised that it does't capture the start and end time af a particular call record. Therefore I dive into the source code to add the start and end time into the query (add something like cdr->start, cdr->end), but end up getting segfault. the original version of cdr_mysql.so works fine but I need the start time and end

I noticed a problem this morning with our cdr logging. We have a cron job that places a call file into the spool directory having asterisk call itself to check to make sure its still handling incoming calls correctly, then queries the CDR database in mysql and makes sure that appropriate records exist. I can confirm that the call is happening correctly, but I'm missing records in the

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 have an issue getting agentLogin working /etc/asterisk/queues.conf member => Agent/1001 member => Agent/1002 extension.conf exten => 110,1,Wait,1 exten => 110,2,AgentLogin() now, i call 110 by a firefly client, trying to login in as 1001 agent: Aug 12 16:31:36 DEBUG[1103408048]: chan_sip.c:4423 build_route: build_route: Contact hop: <sip:sip3@192.168.1.151:5060> --

I'm no longer on the DEV mailing list, but: # svn checkout http://svn.digium.com/svn/asterisk/branches/1.4 asterisk svn: URL 'http://svn.digium.com/svn/asterisk/branches/1.4' doesn't exist http://svn.digium.com/svn/asterisk/branches/ -- /Nick -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

Hey, Have i done something wrong or is there something wrong with latest CVS and cdr_mysql, cause after checking out latest CVS today, I got warning: [cdr_mysql.so]WARNING[1074424544]: File loader.c, Line 226 (ast_load_resource): /usr/lib/asterisk/modules/cdr_mysql.so: undefined symbol: uncompress WARNING[1074424544]: File loader.c, Line 345 (load_modules): Loading module cdr_mysql.so failed!

Hello I just settup a realtime mysql table for sip_peers. All peers (friends) is autenticateing but when i want to initiate a call between them i got the following error. Someone have some ideea? Thank you. ---<Cut Here>--- pbx*CLI>console dial 1014 == Console is full duplex -- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new stack