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

Joshua Colp (JIRA) noreply at issues.asterisk.org
Mon Jun 27 12:42:56 CDT 2016


     [ https://issues.asterisk.org/jira/browse/ASTERISK-26154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joshua Colp updated ASTERISK-26154:
-----------------------------------

    Assignee: cagdas kopuz
      Status: Waiting for Feedback  (was: Triage)

Please provide the schema (on BOTH servers), database in use, and the console output.

> 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
>            Assignee: cagdas kopuz
>            Severity: Minor
>
> 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,aranan
> {noformat}
> (exten => s,n,Set(CDR(recording)=${FILENAME}))
> {noformat}
> {noformat}
> cdr_adaptive_odbc.conf:
> [cdr]
> connection=veritabani
> table=sanalsantralcdr
> [cdr2]
> connection=sniffer
> table=asterisk_cdr
> {noformat}
> -----------------------------
> Same call record's query log for each server:
> cdr server query log:
> {noformat}
> 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')
> {noformat}
> cdr2 server query log:
> {noformat}
> 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')
> {noformat}



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



More information about the asterisk-bugs mailing list