Summary: | ASTERISK-21124: cdr_adaptative_odbc does not populate cdr information | ||||
Reporter: | allan ananian (ananian) | Labels: | |||
Date Opened: | 2013-02-16 04:37:54.000-0600 | Date Closed: | 2013-02-18 19:07:22.000-0600 | ||
Priority: | Major | Regression? | |||
Status: | Closed/Complete | Components: | CDR/cdr_adaptive_odbc | ||
Versions: | 1.8.20.1 | Frequency of Occurrence | |||
Related Issues: |
| ||||
Environment: | Centos 6.2 , Kernel 2.6.32-220, MySQL Server 5.1, UnixODBC | Attachments: | ( 0) full.log | ||
Description: | After I upgraded my version asterisk "1.8.16.0" to "1.8.20.1" CDR_ADAPTATIVE_ODBC stopped writin.
Example: {noformat} ; cdr_adaptive_odbc.conf [adaptive_connection] connection=asterisk table=cdr {noformat} {noformat} *CLI> cdr show status Call Detail Record (CDR) settings ---------------------------------- Logging: Enabled Mode: Simple Log unanswered calls: No * Registered Backends ------------------- cdr-syslog Adaptive ODBC cdr-custom csv cdr_manager {noformat} {noformat} exten => _NXXNXXXXXX,1,Verbose(1,Example of adaptive ODBC usage) same => n,Set(CDR(route_rate)=0.01) same => n,Dial(SIP/my_itsp/${EXTEN}) same => n,Hangup() {noformat} {noformat} | src | duration | billsec | route_rate | | 0000FFFF0008 | 37 | 30 | | {noformat} I put back asterisk "1.8.16.0" and came back to work just fine. Thanks. | ||||
Comments: | By: Matt Jordan (mjordan) 2013-02-16 13:24:11.683-0600 We require a complete debug log to help triage the issue. This document will provide instructions on how to collect debugging logs from an Asterisk machine for the purpose of helping bug marshals troubleshoot an issue: https://wiki.asterisk.org/wiki/display/AST/Collecting+Debug+Information By: allan ananian (ananian) 2013-02-18 15:34:29.510-0600 Set("SIP/39-00000013", "CDR(monitor)=20130218-182543-IN-39-41-1361222743.19.WAV") By: allan ananian (ananian) 2013-02-18 16:18:34.050-0600 Resolved Was being inserted two duplicate rows in cdr one with calldate "0000-00-00 00:00:00" Modified configuration: ; cdr_adaptive_odbc.conf [adaptive_connection] connection=asterisk table=cdr alias start => calldate Thanks. |