saving data into custom cdr field

asterisk pbx cdr trixbox
voy picture voy · May 8, 2012 · Viewed 8.1k times · Source

I created custom field "rec_name" id table "cdr", database "asteriskcdrdb". In this field I want to store recording name. I know I should do it by adding this line in one of .conf files, but where?

exten => s,1,set(CDR(rec_name)=${CALLFILENAME})

I can do it by sql statement, too, but I don't know where is the file that saves details of call into database.

Answer

arheops picture arheops · May 10, 2012

For mysql you need add into /etc/asterisk/cdr_mysql.conf

[aliases]
rec_name=rec_name

If you HAVE aliases section, just add to it 

rec_name=rec_name

Related questions

Create New EC2 Instance with Custom ISO

I'm using Switchvox, an Asterisk PBX and I'd like to host it on EC2. Digium Switchvox provides an ISO which contains everything needed to host the pbx server: OS, software, etc. It's basically an image of the server. How do …

Read More
Programming Asterisk PBX using PHP?

Ok I installed asterisk, now I would like to know how do I program asterisk PBX using PHP? Does Asterisk have an API that I can work with? Please provide basic examples how I could perform the following scenario send …

Read More
Freepbx can't connect to asterisk wrong password

I've just setup FreePBX on my VPS. Everything is OK there are no notices. There hasn't been any errors in the installation. When I create my extension from the FreePBX create new SIP extension and try to connect afterwards I …

Read More