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

[Michael Silveus]

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 
cdr DB through an external script which you could call through cron or 
possibly at the end of you context inside of asterisk. I haven't written 
the script yet but I bet someone out there has.

Regards,
Mike

Emanuele Carbone wrote:
> 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 <alexrecarey at gmail.com 
> <mailto:alexrecarey at 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 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 new column in my MySQL database called q931. However,
>     the new field does not show up in my database or in the Master.csv
>     file.
>
>     Any help would be greatly appreciated.
>
>     Regards,
>
>     Alex
>
>     --
>     _____________________________________________________________________
>     -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>     New to Asterisk? Join us for a live introductory webinar every Thurs:
>                   http://www.asterisk.org/hello
>
>     asterisk-users mailing list
>     To UNSUBSCRIBE or update options visit:
>       http://lists.digium.com/mailman/listinfo/asterisk-users
>
>