Custom CDR field in Asterisk

442

September 06, 2017, at 3:56 PM

I am using asterisk 13. In extensions.conf I have code like this:

 [local]
exten => _6XX,1,NoOp(Call from ${CALLERID(all)} to ${EXTEN})
        same => n,Dial(SIP/${EXTEN})
        same => n,Hangup()
exten => h,1,NoOp(-- QoS stats RTPAUDIOQOSLOSS: ${RTPAUDIOQOSLOSS})
exten => h,n,Set(CDR(Loss)=Test)

This extension (with CDR) is executed, I can see it in the asterisk console I have added a new column in my MySQL database called Loss. However, the new field does not show up in my database or in the Master.csv file.

in cdr_mysql.conf file I have inserted text like this:

alias Loss = Loss

Still no luck. Im using cdr_odbc.

Answer 1

cdr_odbc have no alias configuration directive.

Use userfield and accountcode, if you need more then two, put in userfield like value1:value2 after that split in your program or by trigger on insert in mysql.