[asterisk-users] How to add custom CDR fields to MySQL

Hello Alex, I'm struggling with the same problem and, not wanting to modify the CDR backend, I just put in a workaround in the form of a MySQL trigger. I'll describe what I did in case it helps someone, though I'm very inexperienced at making compound procedures in MySQL. In my

Re: [asterisk-users] How to add custom CDR fields to MySQL

If I remember correctly you should do CDR(flavor)=cherry and it should work. I have added custom fields in my CDR table in the past and didn't need triggers. On 2010-03-29 3:40 AM, Robert Price rob...@proxims.com wrote: Hello Alex, I'm struggling with the same problem and, not wanting to modify

Re: [asterisk-users] How to add custom CDR fields to MySQL

Hi Alex, I'm having the same problem and there is an open problem report about it. However, if you modify your /etc/asterisk/cdr_custom.conf file to add the field it will show up in your Master.csv log file but still not in the DB record. You could in essence use the log file to rebuilt your

Re: [asterisk-users] How to add custom CDR fields to MySQL

Hi, i think that you should modify the cdr_addon_mysql module, otherwise you can add it in the userfield. 2010/3/11 Alejandro Recarey alexreca...@gmail.com Hi all, I've been trying to add a custom mysql field to my CDR's, but I must be doing something wrong. I am using asterisk 1.4 and

[asterisk-users] How to add custom CDR fields to MySQL

Hi all, I've been trying to add a custom mysql field to my CDR's, but I must be doing something wrong. I am using asterisk 1.4 and asterisk 1.6, in extensions.conf I add: exten = h,1,Set(CDR(q931)=${HANGUPCAUSE}) This extension is executed, I can see it in the asterisk console. I have added a