I'm running 1.6.2.13 and need to record a small number of custom values use cdr_odbc and cdr_adaptive_odbc, and only the custom fields. The good news is that the custom records are being stored in the database as desired. The bad news is that I get three sets of warnings/notice about 'SQL Exec Direct failed' and dropping then reconnecting the database handle. I traced the SQL calls and found these occur when the CDR engine attempts to record all of standard CDR fields. The cdr_adaptive_odbc documentation suggests that it is safe to drop the standard fields, and while my system does continue to function the dropping of the db handle and extra logging is annoying. Have I missed an option to disable recording the standard CDR fields? Dan -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20101020/e75e3570/attachment.htm
On Wednesday 20 October 2010 16:56:23 Dan Austin wrote:> I'm running 1.6.2.13 and need to record a small number of custom > values use cdr_odbc and cdr_adaptive_odbc, and only the custom > fields. > > The good news is that the custom records are being stored in the > database as desired. The bad news is that I get three sets of > warnings/notice about 'SQL Exec Direct failed' and dropping then > reconnecting the database handle. I traced the SQL calls and found > these occur when the CDR engine attempts to record all of standard > CDR fields. > > The cdr_adaptive_odbc documentation suggests that it is safe to drop > the standard fields, and while my system does continue to function the > dropping of the db handle and extra logging is annoying. > > Have I missed an option to disable recording the standard CDR fields?It sounds like you've configured both cdr_odbc and cdr_adaptive_odbc, but you really only want to use cdr_adaptive_odbc. Trying disabling cdr_odbc, either by removing the configuration file or by noload'ing the module in modules.conf. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org
On Wed, Oct 20, 2010 at 5:56 PM, Dan Austin <Dan_Austin at phoenix.com> wrote:> The cdr_adaptive_odbc documentation suggests that it is safe to drop > the standard fields, and while my system does continue to function the > dropping of the db handle and extra logging is annoying. > > Have I missed an option to disable recording the standard CDR fields? >Have you reloaded the module within asterisk? *CLI> module reload cdr -- Paul Belanger | dCAP Polybeacon | Consultant Jabber: paul.belanger at polybeacon.com | IRC: pabelanger (Freenode) blog.polybeacon.com