[Home]

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-0600Date Closed:2013-02-18 19:07:22.000-0600
Priority:MajorRegression?
Status:Closed/CompleteComponents:CDR/cdr_adaptive_odbc
Versions:1.8.20.1 Frequency of
Occurrence
Related
Issues:
is duplicated byASTERISK-21127 Empty custom CDR value
Environment:Centos 6.2 , Kernel 2.6.32-220, MySQL Server 5.1, UnixODBCAttachments:( 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.