[asterisk-bugs] [JIRA] (ASTERISK-26154) There is no Custom fields on second CDR

[Asterisk Team (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-26154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=231190#comment-231190 ] 

Asterisk Team commented on ASTERISK-26154:
------------------------------------------

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].

> There is no Custom fields on second CDR
> ---------------------------------------
>
>                 Key: ASTERISK-26154
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26154
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: CDR/cdr_adaptive_odbc
>    Affects Versions: 11.21.0
>            Reporter: cagdas kopuz
>            Severity: Critical
>
> I have two cdr tables at two different servers, and I use cdr_adaptive_odbc
> Asterisk doesn't write Custom fields to second CDR table.
> Custom fields = durum,tenant,direction,recording
> (exten => s,n,Set(CDR(recording)=${FILENAME}))
> cdr_adaptive_odbc.conf:
> [cdr]
> connection=veritabani
> table=sanalsantralcdr
> [cdr2]
> connection=sniffer
> table=asterisk_cdr
> -----------------------------
> Same call record's query log for each server:
> cdr server query log:
> INSERT INTO [*******].[dbo].[sanalsantralcdr]           ([start],[answer],[clid],[src],[dst],[aranan],[dcontext],[channel],[dstchannel],[lastapp],[lastdata],[duration],[billsec],[disposition],[amaflags],[accountcode],[uniqueid],[linkedid],[linked_updated],[userfield],[durum],[tenant],[direction],[sequence],[recording])     VALUES ('2016-06-27 09:53:35.000','2016-06-27 09:53:39.000','"******" <****>','*****','s','****-queue-****','****-queue-*****','SIP/*****-00002923','Local/102 at from-internal-*****-00001a04;1','Queue','*****-queue-****,itT,,,,','312','308','ANSWERED','3','NULL','1467010415.23715','1467010415.23715','NULL','******','***','in','26638','****-2016-06-27-09-53-39-*****-1467010415.23715.wav')
> cdr2 server query log:
> INSERT INTO asterisk_cdr (clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,userfield,uniqueid,linkedid,sequence) 
> VALUES 
> ('"******" <*******>','******','s','*******2200-queue-********','SIP/******-00002923','Local/102 at from-internal-****-00001a04;1','Queue','*****-queue-*****,itT,,,,',312,308,'ANSWERED',3,'*****','1467010415.23715','1467010415.23715','26638')



--
This message was sent by Atlassian JIRA
(v6.2#6252)