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.

Rent Charter Buses Company
READ ALSO
mySQL put results with same id in same column

mySQL put results with same id in same column

I am working on an app that is connected with MySQL database

207
How to implement anonymous likes for the Posts and block that anonymous person's ip address to avoid liking the particular post again?

How to implement anonymous likes for the Posts and block that anonymous person's ip address to avoid liking the particular post again?

How to add anonymous likes for the Posts and block that anonymous person's ip address to avoid liking the particular post again ?

198
Nothing happens when jsonResponse gets null data from mySQL-DB

Nothing happens when jsonResponse gets null data from mySQL-DB

im just new to java/android programming

203
Checkbox value with id in Angular 2

Checkbox value with id in Angular 2

How can I get check box value without additional Boolean variable in angular 2

22