saving data into custom cdr field

Question

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 1

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