[asterisk-bugs] [JIRA] (ASTERISK-27167) No data in custom cdr field in database when it set via Gosub

[Denis Pantsyrev (JIRA)]

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

Denis Pantsyrev updated ASTERISK-27167:
---------------------------------------

    Description: 
I have dialplan below. Phone 7777 call to 8888, 8888 answer.
At the moment of the answer the subAnswer is executed, but there is no data in cdr field "cstfld" while in "userfield" it presense. Debug file in attach below.

{code:title=sip.conf|borderStyle=solid}
[7777]
type=friend
host=dynamic
secret=7777
context=buh
callerid="ExtUser" <7777>

[8888]
type=friend
host=dynamic
secret=8888
context=ato
callerid="OneUser" <8888>
{code}
{code:title=extensions.conf|borderStyle=solid}
[buh]
exten => h,1,NoOP
exten => _XXXX,1,NoOP
 same => n,Dial(SIP/${EXTEN},20,tirU(subAnswer))
 same => n,Hangup

[ato]
include => buh

[subAnswer]
exten => s,1,NoOP
 same => n,Set(CDR(userfield)=${CDR(userfield)}:${CALLERID(num)})
 same => n,Set(CDR(cstfld)=${CDR(cstfld)}:${CALLERID(num)})
 same => n,Return()
{code}
{code:title=cdr_adaptive_odbc.conf|borderStyle=solid}
[first]
connection=asterisk
table=cdr
alias start => calldate
{code}
{code:title=res_odbc.conf|borderStyle=solid}
[asterisk]
enabled => yes
dsn => asterisk-connector
username => asterisk
password => Pa$$w0rd
pre-connect => yes
idlecheck => 3600
{code}

  was:
I have dialplan below. Phone 7777 call to 8888, 8888 answer.
At the moment of the answer the subAnswer is executed, but there is no data in cdr field "cstfld" while in "userfield" it presense. Debug file in attach below.

{code:title=sip.conf|borderStyle=solid}
[7777]
type=friend
host=dynamic
secret=7777
context=buh
callerid="ExtUser" <7777>

[8888]
type=friend
host=dynamic
secret=8888
context=ato
callerid="OneUser" <8888>
{code}
{code:title=extensions.conf|borderStyle=solid}
[buh]
exten => h,1,NoOP
exten => _XXXX,1,NoOP
 same => n,Dial(SIP/${EXTEN},20,tirU(subAnswer))
 same => n,Hangup

[ato]
include => buh

[subAnswer]
exten => s,1,NoOP
 same => n,Set(CDR(userfield)=${CDR(userfield)}:${CALLERID(num)})
 same => n,Set(CDR(cstfld)=${CDR(cstfld)}:${CALLERID(num)})
 same => n,Return()
{code}



> No data in custom cdr field in database when it set via Gosub
> -------------------------------------------------------------
>
>                 Key: ASTERISK-27167
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27167
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: CDR/cdr_adaptive_odbc
>    Affects Versions: 11.25.1
>         Environment: CentOS 7 (3.10.0-514.16.1.el7.x86_64)
>            Reporter: Denis Pantsyrev
>            Severity: Minor
>         Attachments: debug.txt
>
>
> I have dialplan below. Phone 7777 call to 8888, 8888 answer.
> At the moment of the answer the subAnswer is executed, but there is no data in cdr field "cstfld" while in "userfield" it presense. Debug file in attach below.
> {code:title=sip.conf|borderStyle=solid}
> [7777]
> type=friend
> host=dynamic
> secret=7777
> context=buh
> callerid="ExtUser" <7777>
> [8888]
> type=friend
> host=dynamic
> secret=8888
> context=ato
> callerid="OneUser" <8888>
> {code}
> {code:title=extensions.conf|borderStyle=solid}
> [buh]
> exten => h,1,NoOP
> exten => _XXXX,1,NoOP
>  same => n,Dial(SIP/${EXTEN},20,tirU(subAnswer))
>  same => n,Hangup
> [ato]
> include => buh
> [subAnswer]
> exten => s,1,NoOP
>  same => n,Set(CDR(userfield)=${CDR(userfield)}:${CALLERID(num)})
>  same => n,Set(CDR(cstfld)=${CDR(cstfld)}:${CALLERID(num)})
>  same => n,Return()
> {code}
> {code:title=cdr_adaptive_odbc.conf|borderStyle=solid}
> [first]
> connection=asterisk
> table=cdr
> alias start => calldate
> {code}
> {code:title=res_odbc.conf|borderStyle=solid}
> [asterisk]
> enabled => yes
> dsn => asterisk-connector
> username => asterisk
> password => Pa$$w0rd
> pre-connect => yes
> idlecheck => 3600
> {code}



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