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

[cagdas kopuz (JIRA)]

cagdas kopuz created ASTERISK-26154:
---------------------------------------

             Summary: 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)