[asterisk-bugs] [JIRA] (ASTERISK-25789) Issues with cdr_adaptive_odbc - Not storing custom fields in all cases
Michael Somerville (JIRA)
noreply at issues.asterisk.org
Sat Feb 13 11:09:19 CST 2016
Michael Somerville created ASTERISK-25789:
---------------------------------------------
Summary: Issues with cdr_adaptive_odbc - Not storing custom fields in all cases
Key: ASTERISK-25789
URL: https://issues.asterisk.org/jira/browse/ASTERISK-25789
Project: Asterisk
Issue Type: Bug
Security Level: None
Components: CDR/cdr_adaptive_odbc
Affects Versions: 13.7.2
Environment: Debian 7u2
Reporter: Michael Somerville
There is an issue that the CDR Adaptive is not writing out the variables we are passing to the CDR variable in all cases. Calls to internal dialplan applications work, whereas calls between two internal extensions does not.
{panel:title=Working - Calls to Dialplan Application}
-- Executing [h at ivr:18] Set("SIP/100001-101-00-0000001c", "CDR(application)=call") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function HASH(ext_info,ext_id) result is '34'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:19] Set("SIP/100001-101-00-0000001c", "CDR(caller_ext_id)=34") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function HASH(ext_called,ext_id) result is '48'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:20] Set("SIP/100001-101-00-0000001c", "CDR(called_ext_id)=48") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CALLERID(name) result is 'MICHAEL SOMERVILLE'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:21] Set("SIP/100001-101-00-0000001c", "CDR(caller_name)=MICHAEL SOMERVILLE") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CALLERID(num) result is '101'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:22] Set("SIP/100001-101-00-0000001c", "CDR(caller_num)=101") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(peerip) result is '99.233.242.104'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function ISNULL(99.233.242.104) result is '0'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4889 pbx_substitute_variables_helper_full: Expression result is '0'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'GotoIf'
-- Executing [h at ivr:23] GotoIf("SIP/100001-101-00-0000001c", "0?rate") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:11971 pbx_builtin_gotoif: Not taking any branch
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(peerip) result is '99.233.242.104'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:24] Set("SIP/100001-101-00-0000001c", "CDR(peerip)=99.233.242.104") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(recvip) result is '99.233.242.104'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:25] Set("SIP/100001-101-00-0000001c", "CDR(recvip)=99.233.242.104") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(from) result is 'sip:100001-101-00 at sip.voip.digital'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:26] Set("SIP/100001-101-00-0000001c", "CDR(frompeer)=sip:100001-101-00 at sip.voip.digital") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(uri) result is 'sip:100001-101-00 at 99.233.242.104:37696'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:27] Set("SIP/100001-101-00-0000001c", "CDR(uri)=sip:100001-101-00 at 99.233.242.104:37696") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(useragent) result is 'PolycomVVX-VVX_500-UA/4.1.8.0628'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:28] Set("SIP/100001-101-00-0000001c", "CDR(useragent)=PolycomVVX-VVX_500-UA/4.1.8.0628") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(audioreadformat) result is 'g729'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:29] Set("SIP/100001-101-00-0000001c", "CDR(codec1)=g729") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(audiowriteformat) result is 'g729'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:30] Set("SIP/100001-101-00-0000001c", "CDR(codec2)=g729") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,rxploss) result is '0'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:31] Set("SIP/100001-101-00-0000001c", "CDR(llp)=0") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,txploss) result is '0'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:32] Set("SIP/100001-101-00-0000001c", "CDR(rlp)=0") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,rxjitter) result is '0.000000'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:33] Set("SIP/100001-101-00-0000001c", "CDR(ljitt)=0.000000") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,txjitter) result is '0.004112'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:34] Set("SIP/100001-101-00-0000001c", "CDR(rjitt)=0.004112") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,rtt) result is '0.000000'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:35] Set("SIP/100001-101-00-0000001c", "CDR(rtt)=0.000000") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function HASH(call_rates,description) result is ''
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4889 pbx_substitute_variables_helper_full: Expression result is '1'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'GotoIf'
-- Executing [h at ivr:36] GotoIf("SIP/100001-101-00-0000001c", "1?endcall") in new stack
-- Goto (ivr,h,54)
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CALLERID(rdnis) result is ''
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:54] Set("SIP/100001-101-00-0000001c", "CDR(rdnis)=") in new stack
[2016-02-13 17:00:47] WARNING[19590]: func_cdr.c:352 cdr_write_callback: CDR requires a value (CDR(variable)=value)
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CALLERID(dnid) result is '800'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at ivr:55] Set("SIP/100001-101-00-0000001c", "CDR(dnid)=800") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: pbx.c:4985 pbx_extension_helper: Launching 'NoOp'
-- Executing [h at ivr:56] NoOp("SIP/100001-101-00-0000001c", "") in new stack
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: channel.c:2683 ast_hangup: Hanging up channel 'SIP/100001-101-00-0000001c'
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: chan_sip.c:6960 sip_hangup: Hangup call SIP/100001-101-00-0000001c, SIP callid 47594eb-b99c4e38-88a51a97 at 10.20.30.58
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: chan_sip.c:6577 update_call_counter: Updating call counter for incoming call
[2016-02-13 17:00:47] DEBUG[19589]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-00
[2016-02-13 17:00:47] DEBUG[19589]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-00
[2016-02-13 17:00:47] DEBUG[19589]: devicestate.c:473 do_state_change: Changing state for SIP/100001-101-00 - state 1 (Not in use)
[2016-02-13 17:00:47] DEBUG[19591]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-01
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-01
[2016-02-13 17:00:47] DEBUG[19623]: app_queue.c:2383 device_state_cb: Device 'SIP/100001-101-00' changed to state '1' (Not in use) but we don't care because they're not a member of any queue.
[2016-02-13 17:00:47] DEBUG[20662][C-0000000d]: res_rtp_asterisk.c:4822 ast_rtp_remote_address_set: Setting RTCP address on RTP instance '0x26df518'
[2016-02-13 17:00:47] DEBUG[19591]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM sippeers WHERE name = ? AND host = ?
[2016-02-13 17:00:47] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('name') = '100001-101-01'
[2016-02-13 17:00:47] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 2 ('host') = 'dynamic'
[2016-02-13 17:00:47] DEBUG[19591]: res_odbc.c:1057 odbc_release_obj2: odbc_release_obj2(0x25a9d38) called (obj->txf = (nil))
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:31122 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:31125 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:31127 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:31130 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:5485 realtime_peer: -REALTIME- loading peer from database to memory. Name: 100001-101-01. Peer objects: 0
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:5061 sip_destroy_peer: Destroying SIP peer 100001-101-01
[2016-02-13 17:00:47] DEBUG[19591]: app_queue.c:2458 extension_state_cb: Extension '100001-101 at dialplan' changed to state '1' (Not in use) but we don't care because they're not a member of any queue.
[2016-02-13 17:00:47] DEBUG[19591]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-01
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-01
[2016-02-13 17:00:47] DEBUG[20657]: taskprocessor.c:483 tps_taskprocessor_destroy: destroying taskprocessor '501e1d02-c19d-4dab-b54c-1cd9b724f38a'
[2016-02-13 17:00:47] DEBUG[19591]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM sippeers WHERE name = ? AND host = ?
[2016-02-13 17:00:47] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('name') = '100001-101-01'
[2016-02-13 17:00:47] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 2 ('host') = 'dynamic'
[2016-02-13 17:00:47] DEBUG[19591]: res_odbc.c:1057 odbc_release_obj2: odbc_release_obj2(0x25a9d38) called (obj->txf = (nil))
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:31122 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:31125 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:31127 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:31130 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:5485 realtime_peer: -REALTIME- loading peer from database to memory. Name: 100001-101-01. Peer objects: 0
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:5061 sip_destroy_peer: Destroying SIP peer 100001-101-01
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:3715 __sip_xmit: Trying to put 'NOTIFY sip:' onto UDP socket destined for 99.233.242.104:21523
== Extension Changed 100001-101[dialplan] new state Idle for Notify User 100001-110-00
[2016-02-13 17:00:47] DEBUG[19591]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-01
[2016-02-13 17:00:47] DEBUG[19591]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-01
[2016-02-13 17:00:47] DEBUG[20657]: taskprocessor.c:483 tps_taskprocessor_destroy: destroying taskprocessor 'c7daecbf-6c16-4832-919d-279d1c7266fc'
[2016-02-13 17:00:47] DEBUG[19591]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM sippeers WHERE name = ? AND host = ?
[2016-02-13 17:00:47] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('name') = '100001-101-01'
[2016-02-13 17:00:47] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 2 ('host') = 'dynamic'
0x2918f18 - Beginning finalize/dispatch for SIP/100001-101-00-0000001c
[2016-02-13 17:00:47] DEBUG[19590]: cdr.c:1276 cdr_object_finalize: Finalized CDR for SIP/100001-101-00-0000001c - start 1455382844.353225 answer 1455382844.449087 end 1455382847.431571 dispo ANSWERED
0x2918f18 - Dispatching CDR for Party A SIP/100001-101-00-0000001c, Party B <none>
[2016-02-13 17:00:47] DEBUG[19590]: cdr_adaptive_odbc.c:740 odbc_log: Executing [INSERT INTO cdr (calldate,clid,src,dst,description,rate,dcontext,lastapp,lastdata,duration,billsec,disposition,channel,amaflags,accountcode,uniqueid,answer,end,linkedid,sequence,peerip,recvip,frompeer,uri,useragent,codec1,codec2,llp,rlp,ljitt,rjitt,rtt,dnid,caller_name,caller_num,outbound,application,caller_ext_id,called_ext_id) VALUES ({ ts '2016-02-13 17:00:44' },'"MICHAEL SOMERVILLE" <101>','101','call_ext','Internal Call',0.0000000000,'dialplan','Read','IVR_INPUT,customer_prompts/100001/103,3,,0,3',3.078346,2.982484,'ANSWERED','SIP/100001-101-00-0000001c','DOCUMENTATION',100001,'alpha.sip.tridacom.com-1455382844.102',{ ts '2016-02-13 17:00:44' },{ ts '2016-02-13 17:00:47' },'alpha.sip.tridacom.com-1455382844.102',37,'99.233.242.104','99.233.242.104','sip:100001-101-00 at sip.voip.digital','sip:100001-101-00 at 99.233.242.104:37696','PolycomVVX-VVX_500-UA/4.1.8.0628','g729','g729','0','0','0.000000','0.004112',0,'800','MICHAEL SOMERVILLE','101','Y','call',34,48)]
{panel}
{panel:title=Not Working - Call between two SIP Devices}
Executing [h at internal_call:18] Set("SIP/100001-101-00-00000020", "CDR(application)=call") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function HASH(ext_info,ext_id) result is '34'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:19] Set("SIP/100001-101-00-00000020", "CDR(caller_ext_id)=34") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function HASH(ext_called,ext_id) result is '45'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:20] Set("SIP/100001-101-00-00000020", "CDR(called_ext_id)=45") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CALLERID(name) result is 'MICHAEL SOMERVILLE'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:21] Set("SIP/100001-101-00-00000020", "CDR(caller_name)=MICHAEL SOMERVILLE") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CALLERID(num) result is '101'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:22] Set("SIP/100001-101-00-00000020", "CDR(caller_num)=101") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(peerip) result is '99.233.242.104'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function ISNULL(99.233.242.104) result is '0'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4889 pbx_substitute_variables_helper_full: Expression result is '0'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'GotoIf'
-- Executing [h at internal_call:23] GotoIf("SIP/100001-101-00-00000020", "0?rate") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:11971 pbx_builtin_gotoif: Not taking any branch
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(peerip) result is '99.233.242.104'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:24] Set("SIP/100001-101-00-00000020", "CDR(peerip)=99.233.242.104") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(recvip) result is '99.233.242.104'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:25] Set("SIP/100001-101-00-00000020", "CDR(recvip)=99.233.242.104") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(from) result is 'sip:100001-101-00 at sip.voip.digital'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:26] Set("SIP/100001-101-00-00000020", "CDR(frompeer)=sip:100001-101-00 at sip.voip.digital") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(uri) result is 'sip:100001-101-00 at 99.233.242.104:37696'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:27] Set("SIP/100001-101-00-00000020", "CDR(uri)=sip:100001-101-00 at 99.233.242.104:37696") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(useragent) result is 'PolycomVVX-VVX_500-UA/4.1.8.0628'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:28] Set("SIP/100001-101-00-00000020", "CDR(useragent)=PolycomVVX-VVX_500-UA/4.1.8.0628") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(audioreadformat) result is 'slin'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:29] Set("SIP/100001-101-00-00000020", "CDR(codec1)=slin") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(audiowriteformat) result is 'slin'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:30] Set("SIP/100001-101-00-00000020", "CDR(codec2)=slin") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,rxploss) result is '0'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:31] Set("SIP/100001-101-00-00000020", "CDR(llp)=0") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,txploss) result is '0'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:32] Set("SIP/100001-101-00-00000020", "CDR(rlp)=0") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,rxjitter) result is '0.000000'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:33] Set("SIP/100001-101-00-00000020", "CDR(ljitt)=0.000000") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,txjitter) result is '0.003215'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:34] Set("SIP/100001-101-00-00000020", "CDR(rjitt)=0.003215") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CHANNEL(rtpqos,audio,rtt) result is '0.000000'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:35] Set("SIP/100001-101-00-00000020", "CDR(rtt)=0.000000") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function HASH(call_rates,description) result is ''
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4889 pbx_substitute_variables_helper_full: Expression result is '1'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'GotoIf'
-- Executing [h at internal_call:36] GotoIf("SIP/100001-101-00-00000020", "1?endcall") in new stack
-- Goto (internal_call,h,54)
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CALLERID(rdnis) result is ''
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:54] Set("SIP/100001-101-00-00000020", "CDR(rdnis)=") in new stack
[2016-02-13 17:01:58] WARNING[19590]: func_cdr.c:352 cdr_write_callback: CDR requires a value (CDR(variable)=value)
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4820 pbx_substitute_variables_helper_full: Function CALLERID(dnid) result is '110'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'Set'
-- Executing [h at internal_call:55] Set("SIP/100001-101-00-00000020", "CDR(dnid)=110") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: pbx.c:4985 pbx_extension_helper: Launching 'NoOp'
-- Executing [h at internal_call:56] NoOp("SIP/100001-101-00-00000020", "") in new stack
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: channel.c:2683 ast_hangup: Hanging up channel 'SIP/100001-101-00-00000020'
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: chan_sip.c:6960 sip_hangup: Hangup call SIP/100001-101-00-00000020, SIP callid 27509c1b-9e50fc48-8ccd5a47 at 10.20.30.58
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: chan_sip.c:6577 update_call_counter: Updating call counter for incoming call
[2016-02-13 17:01:58] DEBUG[19589]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-00
[2016-02-13 17:01:58] DEBUG[19589]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-00
[2016-02-13 17:01:58] DEBUG[19589]: devicestate.c:473 do_state_change: Changing state for SIP/100001-101-00 - state 1 (Not in use)
[2016-02-13 17:01:58] DEBUG[19591]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-01
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[19623]: app_queue.c:2383 device_state_cb: Device 'SIP/100001-101-00' changed to state '1' (Not in use) but we don't care because they're not a member of any queue.
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: res_rtp_asterisk.c:4822 ast_rtp_remote_address_set: Setting RTCP address on RTP instance '0x233f8d8'
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM sippeers WHERE name = ? AND host = ?
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('name') = '100001-101-01'
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 2 ('host') = 'dynamic'
[2016-02-13 17:01:58] DEBUG[19591]: res_odbc.c:1057 odbc_release_obj2: odbc_release_obj2(0x25a9d38) called (obj->txf = (nil))
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31122 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31125 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31127 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31130 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5485 realtime_peer: -REALTIME- loading peer from database to memory. Name: 100001-101-01. Peer objects: 0
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5061 sip_destroy_peer: Destroying SIP peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[19591]: app_queue.c:2458 extension_state_cb: Extension '100001-101 at dialplan' changed to state '1' (Not in use) but we don't care because they're not a member of any queue.
[2016-02-13 17:01:58] DEBUG[19591]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-01
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[20678]: taskprocessor.c:483 tps_taskprocessor_destroy: destroying taskprocessor '355e13cc-e97f-4099-86df-4d1dfea3f9a9'
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM sippeers WHERE name = ? AND host = ?
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('name') = '100001-101-01'
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 2 ('host') = 'dynamic'
[2016-02-13 17:01:58] DEBUG[19591]: res_odbc.c:1057 odbc_release_obj2: odbc_release_obj2(0x25a9d38) called (obj->txf = (nil))
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31122 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31125 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31127 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31130 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5485 realtime_peer: -REALTIME- loading peer from database to memory. Name: 100001-101-01. Peer objects: 0
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5061 sip_destroy_peer: Destroying SIP peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:3715 __sip_xmit: Trying to put 'NOTIFY sip:' onto UDP socket destined for 99.233.242.104:21523
== Extension Changed 100001-101[dialplan] new state Idle for Notify User 100001-110-00
[2016-02-13 17:01:58] DEBUG[19591]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-01
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[20678]: taskprocessor.c:483 tps_taskprocessor_destroy: destroying taskprocessor '07660ab8-febd-4a8d-b605-fbf3fe85289e'
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM sippeers WHERE name = ? AND host = ?
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('name') = '100001-101-01'
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 2 ('host') = 'dynamic'
[2016-02-13 17:01:58] DEBUG[19591]: res_odbc.c:1057 odbc_release_obj2: odbc_release_obj2(0x25a9d38) called (obj->txf = (nil))
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31122 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31125 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31127 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31130 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5485 realtime_peer: -REALTIME- loading peer from database to memory. Name: 100001-101-01. Peer objects: 0
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5061 sip_destroy_peer: Destroying SIP peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[20678]: taskprocessor.c:483 tps_taskprocessor_destroy: destroying taskprocessor '6cc25ea8-3834-4516-929c-13bd2888d26f'
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:3715 __sip_xmit: Trying to put 'NOTIFY sip:' onto UDP socket destined for 99.233.242.104:36905
== Extension Changed 100001-101[dialplan] new state Idle for Notify User 100001-100-00
[2016-02-13 17:01:58] DEBUG[19591]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-01
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM sippeers WHERE name = ? AND host = ?
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('name') = '100001-101-01'
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 2 ('host') = 'dynamic'
[2016-02-13 17:01:58] DEBUG[19591]: res_odbc.c:1057 odbc_release_obj2: odbc_release_obj2(0x25a9d38) called (obj->txf = (nil))
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31122 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31125 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31127 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31130 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5485 realtime_peer: -REALTIME- loading peer from database to memory. Name: 100001-101-01. Peer objects: 0
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5061 sip_destroy_peer: Destroying SIP peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[20678]: taskprocessor.c:483 tps_taskprocessor_destroy: destroying taskprocessor '3c88bd81-b4ba-4a59-933f-97d987515eec'
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:3715 __sip_xmit: Trying to put 'NOTIFY sip:' onto UDP socket destined for 99.234.101.72:5060
== Extension Changed 100001-101[dialplan] new state Idle for Notify User 100001-102-01
[2016-02-13 17:01:58] DEBUG[19591]: devicestate.c:368 _ast_device_state: No provider found, checking channel drivers for SIP - 100001-101-01
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:29573 sip_devicestate: Checking device state for peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM sippeers WHERE name = ? AND host = ?
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('name') = '100001-101-01'
[2016-02-13 17:01:58] DEBUG[19591]: res_config_odbc.c:129 custom_prepare: Parameter 2 ('host') = 'dynamic'
[2016-02-13 17:01:58] DEBUG[19591]: res_odbc.c:1057 odbc_release_obj2: odbc_release_obj2(0x25a9d38) called (obj->txf = (nil))
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31122 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31125 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31127 build_peer: Not an IPv4 nor IPv6 address, cannot get port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:31130 build_peer: Not an IPv4 nor IPv6 address, cannot set port.
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5485 realtime_peer: -REALTIME- loading peer from database to memory. Name: 100001-101-01. Peer objects: 0
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:5061 sip_destroy_peer: Destroying SIP peer 100001-101-01
[2016-02-13 17:01:58] DEBUG[20678]: taskprocessor.c:483 tps_taskprocessor_destroy: destroying taskprocessor '5cd7a6f7-3996-4980-bdd3-6dd333f5ee41'
[2016-02-13 17:01:58] DEBUG[19591]: chan_sip.c:3715 __sip_xmit: Trying to put 'NOTIFY sip:' onto UDP socket destined for 99.233.242.104:20422
== Extension Changed 100001-101[dialplan] new state Idle for Notify User 100001-102-00
[2016-02-13 17:01:58] DEBUG[20684][C-0000000f]: chan_sip.c:3715 __sip_xmit: Trying to put 'BYE sip:100' onto UDP socket destined for 99.233.242.104:37696
0x242a778 - Beginning finalize/dispatch for SIP/100001-101-00-00000020
0x242a778 - Dispatching CDR for Party A SIP/100001-101-00-00000020, Party B SIP/100001-110-00-00000022
[2016-02-13 17:01:58] DEBUG[19590]: cdr_adaptive_odbc.c:740 odbc_log: Executing [INSERT INTO cdr (calldate,clid,src,dst,description,rate,dcontext,lastapp,lastdata,duration,billsec,disposition,channel,dstchannel,amaflags,accountcode,uniqueid,answer,end,peeraccount,linkedid,sequence,dnid,outbound) VALUES ({ ts '2016-02-13 17:01:56' },'"MICHAEL SOMERVILLE" <101>','101','call_ext','Internal Call',0.0000000000,'dialplan','Dial','SIP/100001-110-00,21,r',2.081931,1.094636,'ANSWERED','SIP/100001-101-00-00000020','SIP/100001-110-00-00000022','DOCUMENTATION',100001,'alpha.sip.tridacom.com-1455382916.109',{ ts '2016-02-13 17:01:57' },{ ts '2016-02-13 17:01:58' },100001,'alpha.sip.tridacom.com-1455382916.109',41,'110','Y')]
{panel}
{panel:title=cdr.conf}
[general]
enable = yes
unanswered=yes
congestion=yes
endbeforehexten=yes
safeshutdown=yes
debug=yes
[csv]
usegmtime=yes ; log date/time in GMT. Default is "no"
loguniqueid=yes ; log uniqueid. Default is "no"
loguserfield=yes ; log user field. Default is "no"
accountlogs=yes ; create separate log file for each account code. Default is "yes"
[odbc]
usegmtime=yes ; log date/time in GMT. Default is "no"
loguniqueid=yes ; log uniqueid. Default is "no"
loguserfield=yes ; log user field. Default is "no"
{panel}
{panel:title=cdr_adaptive_odbc.conf}
[adaptive_connection]
connection=asterisk-alpha
table=cdr
alias start => calldate
{panel}
{panel:title=extensions.conf}
exten => h,n(default_app),Set(CDR(application)=call)
exten => h,n,Set(CDR(caller_ext_id)=${HASH(ext_info,ext_id)})
exten => h,n,Set(CDR(called_ext_id)=${HASH(ext_called,ext_id)})
exten => h,n,set(CDR(caller_name)=${CALLERID(name)})
exten => h,n,set(CDR(caller_num)=${CALLERID(num)})
exten => h,n(stats),GoToIf($[${ISNULL(${CHANNEL(peerip)})} = 1]?rate)
exten => h,n,set(CDR(peerip)=${CHANNEL(peerip)}) ; like 10.0.0.5 if behind nat
exten => h,n,set(CDR(recvip)=${CHANNEL(recvip)}) ; like 194.79.52.192 - public ip
exten => h,n,set(CDR(frompeer)=${CHANNEL(from)}) ; like sip:1111 at sip.proxy.cz
exten => h,n,set(CDR(uri)=${CHANNEL(uri)}) ; like sip:1111 at 10.0.0.5
exten => h,n,set(CDR(useragent)=${CHANNEL(useragent)}) ; useragent like Aastra_57i
exten => h,n,set(CDR(codec1)=${CHANNEL(audioreadformat)}) ; codec *
exten => h,n,set(CDR(codec2)=${CHANNEL(audiowriteformat)}) ;
exten => h,n,set(CDR(llp)=${CHANNEL(rtpqos,audio,rxploss)}) ; lost packets by local end **
exten => h,n,set(CDR(rlp)=${CHANNEL(rtpqos,audio,txploss)}) ; lost packets by remote end
exten => h,n,set(CDR(ljitt)=${CHANNEL(rtpqos,audio,rxjitter)}) ; the same for jitter
exten => h,n,set(CDR(rjitt)=${CHANNEL(rtpqos,audio,txjitter)})
exten => h,n,set(CDR(rtt)=${CHANNEL(rtpqos,audio,rtt)})
exten => h,n(rate),GoToIf($["${HASH(call_rates,description)}" = ""]?endcall)
{panel}
{panel:title=Reload of cdr_adaptive_odbc}
*CLI> module reload cdr_adaptive_odbc.so
Module 'cdr_adaptive_odbc.so' reloaded successfully.
-- Reloading module 'cdr_adaptive_odbc.so' (Adaptive ODBC CDR backend)
[2016-02-13 17:03:50] DEBUG[20741]: config.c:2087 config_text_file_load: Parsing /etc/asterisk/cdr_adaptive_odbc.conf
== Parsing '/etc/asterisk/cdr_adaptive_odbc.conf': Found
-- Found adaptive CDR table cdr at asterisk-alpha.
> Found id column with type 4 with len 10, octetlen 10, and numlen (0,10)
-- Found alias start for column calldate in cdr at asterisk-alpha
> Found calldate column with type 93 with len 19, octetlen 19, and numlen (0,10)
> Found clid column with type -9 with len 80, octetlen 240, and numlen (0,0)
> Found src column with type -9 with len 80, octetlen 240, and numlen (0,0)
> Found dst column with type -9 with len 80, octetlen 240, and numlen (0,0)
> Found description column with type -9 with len 50, octetlen 150, and numlen (0,0)
> Found cost column with type 3 with len 6, octetlen 6, and numlen (4,10)
> Found billed_sec column with type 4 with len 10, octetlen 10, and numlen (0,10)
> Found rate column with type 3 with len 6, octetlen 6, and numlen (4,10)
> Found rate_cost column with type 3 with len 8, octetlen 8, and numlen (4,10)
> Found dcontext column with type -9 with len 80, octetlen 240, and numlen (0,0)
> Found lastapp column with type -9 with len 200, octetlen 600, and numlen (0,0)
> Found lastdata column with type -9 with len 200, octetlen 600, and numlen (0,0)
> Found duration column with type 7 with len 7, octetlen 7, and numlen (0,0)
> Found billsec column with type 7 with len 7, octetlen 7, and numlen (0,0)
> Found disposition column with type -8 with len 10, octetlen 30, and numlen (0,0)
> Found channel column with type -9 with len 50, octetlen 150, and numlen (0,0)
> Found dstchannel column with type -9 with len 50, octetlen 150, and numlen (0,0)
> Found amaflags column with type -9 with len 50, octetlen 150, and numlen (0,0)
> Found accountcode column with type 4 with len 10, octetlen 10, and numlen (0,10)
> Found uniqueid column with type -9 with len 50, octetlen 150, and numlen (0,0)
> Found userfield column with type 7 with len 7, octetlen 7, and numlen (0,0)
> Found answer column with type 93 with len 19, octetlen 19, and numlen (0,10)
> Found end column with type 93 with len 19, octetlen 19, and numlen (0,10)
> Found peeraccount column with type 4 with len 10, octetlen 10, and numlen (0,10)
> Found linkedid column with type -9 with len 50, octetlen 150, and numlen (0,0)
> Found sequence column with type 4 with len 10, octetlen 10, and numlen (0,10)
> Found peerip column with type -9 with len 20, octetlen 60, and numlen (0,0)
> Found recvip column with type -9 with len 20, octetlen 60, and numlen (0,0)
> Found frompeer column with type -9 with len 80, octetlen 240, and numlen (0,0)
> Found uri column with type -9 with len 80, octetlen 240, and numlen (0,0)
> Found useragent column with type -9 with len 50, octetlen 150, and numlen (0,0)
> Found codec1 column with type -9 with len 20, octetlen 60, and numlen (0,0)
> Found codec2 column with type -9 with len 20, octetlen 60, and numlen (0,0)
> Found llp column with type -9 with len 20, octetlen 60, and numlen (0,0)
> Found rlp column with type -9 with len 20, octetlen 60, and numlen (0,0)
> Found ljitt column with type -9 with len 20, octetlen 60, and numlen (0,0)
> Found rjitt column with type -9 with len 20, octetlen 60, and numlen (0,0)
> Found rtt column with type 4 with len 10, octetlen 10, and numlen (0,10)
> Found rdnis column with type -9 with len 30, octetlen 90, and numlen (0,0)
> Found dnid column with type -9 with len 30, octetlen 90, and numlen (0,0)
> Found caller_name column with type -9 with len 30, octetlen 90, and numlen (0,0)
> Found caller_num column with type -9 with len 25, octetlen 75, and numlen (0,0)
> Found followme column with type -8 with len 1, octetlen 3, and numlen (0,0)
> Found inbound column with type -8 with len 1, octetlen 3, and numlen (0,0)
> Found outbound column with type -8 with len 1, octetlen 3, and numlen (0,0)
> Found invoice_id column with type 4 with len 10, octetlen 10, and numlen (0,10)
> Found application column with type -9 with len 10, octetlen 30, and numlen (0,0)
> Found caller_ext_id column with type 4 with len 10, octetlen 10, and numlen (0,10)
> Found called_ext_id column with type 4 with len 10, octetlen 10, and numlen (0,10)
[2016-02-13 17:03:50] DEBUG[20741]: res_odbc.c:1057 odbc_release_obj2: odbc_release_obj2(0x25a9d38) called (obj->txf = (nil))
{panel}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
More information about the asterisk-bugs
mailing list