- [2018-02-12 02:31:17] *********************** OUTBOUND CALL ENTRY START *************
- [2018-02-12 02:31:17] INSERT INTO cdrs (uniqueid,accountid,type,callerid,callednum,billseconds,trunk_id,trunkip,callerip,disposition,callstart,debit,cost,provider_id,pricelist_id,package_id,pattern,notes,rate_cost,reseller_id,reseller_code,reseller_code_destination,reseller_cost,provider_code,provider_code_destination,provider_cost,provider_call_cost,call_direction,calltype,profile_start_stamp,answer_stamp,bridge_stamp,progress_stamp,progress_media_stamp,end_stamp,billmsec,answermsec,waitmsec,progress_mediamsec,flow_billmsec) values ('655f9c95-7e47-49d0-87d9-6f75ea6004cc','0','0',' <>','','5',0,"",'72.15.219.140','NORMAL_CLEARING','','0.0000','0.0000',0,'','0','','','0','0','0','',0,'','',0,'0.0000','internal','STANDARD','2018-02-12 02:31:11','2018-02-12 02:31:12','2018-02-12 02:31:12','','2018-02-12 02:31:12','2018-02-12 02:31:17',5100,'1360','1240','1220','6460')
- [2018-02-12 02:31:17] Array
- (
- [core-uuid] => d80f0abf-f491-4ded-8163-c7874125345b
- [switchname] => FS01
- [channel_data] => Array
- (
- [state] => CS_REPORTING
- [direction] => inbound
- [state_number] => 11
- [flags] => 0=1;1=1;3=1;37=1;38=1;40=1;43=1;48=1;53=1;94=1;105=1;111=1;112=1;121=1
- [caps] => 1=1;2=1;3=1;4=1;5=1;6=1
- )
- [callStats] => Array
- (
- [audio] => Array
- (
- [inbound] => Array
- (
- [raw_bytes] => 33368
- [media_bytes] => 33368
- [packet_count] => 194
- [media_packet_count] => 194
- [skip_packet_count] => 68
- [jitter_packet_count] => 0
- [dtmf_packet_count] => 0
- [cng_packet_count] => 0
- [flush_packet_count] => 0
- [largest_jb_size] => 0
- [jitter_min_variance] => 4.347826
- [jitter_max_variance] => 27.586207
- [jitter_loss_rate] => 0
- [jitter_burst_rate] => 0
- [mean_interval] => 20
- [flaw_total] => 0
- [quality_percentage] => 100
- [mos] => 4.5
- )
- [outbound] => Array
- (
- [raw_bytes] => 44204
- [media_bytes] => 44204
- [packet_count] => 257
- [media_packet_count] => 257
- [skip_packet_count] => 0
- [dtmf_packet_count] => 0
- [cng_packet_count] => 0
- [rtcp_packet_count] => 0
- [rtcp_octet_count] => 0
- )
- )
- )
- [variables] => Array
- (
- [direction] => inbound
- [uuid] => 85126565-0fe4-4cd5-8993-384269e69f82
- [session_id] => 36099
- [sip_from_params] => transport=UDP
- [sip_from_user] => 999999
- [sip_from_uri] => 999999@138.197.236.58
- [sip_from_host] => 138.197.236.58
- [video_media_flow] => sendrecv
- [channel_name] => sofia/default/999999@138.197.236.58
- [ep_codec_string] => CORE_PCM_MODULE.PCMA@8000h@20i@64000b,CORE_PCM_MODULE.PCMU@8000h@20i@64000b
- [sip_local_network_addr] => 138.68.252.67
- [sip_network_ip] => 138.197.236.58
- [sip_network_port] => 5060
- [sip_received_ip] => 138.197.236.58
- [sip_received_port] => 5060
- [sip_via_protocol] => udp
- [sip_authorized] => true
- [sip_acl_authed_by] => default
- [sip_from_user_stripped] => 999999
- [sofia_profile_name] => default
- [recovery_profile_name] => default
- [sip_invite_route_uri] => <sip:138.197.236.58;lr;did=931.7b577e03>
- [sip_invite_record_route] => <sip:138.197.236.58;lr;did=931.7b577e03>
- [sip_allow] => INVITE, ACK, CANCEL, BYE, NOTIFY, REFER, MESSAGE, OPTIONS, INFO, SUBSCRIBE
- [sip_req_params] => transport=UDP
- [sip_req_user] => 17027777777
- [sip_req_uri] => 17027777777@138.197.236.58
- [sip_req_host] => 138.197.236.58
- [sip_to_params] => transport=UDP
- [sip_to_user] => 17027777777
- [sip_to_uri] => 17027777777@138.197.236.58
- [sip_to_host] => 138.197.236.58
- [sip_contact_params] => transport=UDP
- [sip_contact_user] => 999999
- [sip_contact_port] => 44498
- [sip_contact_uri] => 999999@117.247.91.162:44498
- [sip_contact_host] => 117.247.91.162
- [sip_via_host] => 138.197.236.58
- [sip_via_port] => 5060
- [max_forwards] => 30
- [presence_id] => 999999@138.197.236.58
- [sip_h_X-AUTH-IP] => 117.247.91.162
- [sip_h_P-Accountcode] => 333320
- [sip_h_P-effective_caller_id_name] => 999
- [sip_h_P-effective_caller_id_number] => 9999999999
- [switch_r_sdp] => v=0
- o=Z 0 0 IN IP4 117.247.91.162
- s=Z
- c=IN IP4 117.247.91.162
- t=0 0
- m=audio 8000 RTP/AVP 3 110 8 0 98 101
- a=rtpmap:110 speex/8000
- a=rtpmap:98 iLBC/8000
- a=fmtp:98 mode=20
- a=rtpmap:101 telephone-event/8000
- a=fmtp:101 0-15
- [call_uuid] => 85126565-0fe4-4cd5-8993-384269e69f82
- [effective_destination_number] => 17027777777
- [callstart] => 2018-02-12 10:31:11
- [hangup_after_bridge] => true
- [continue_on_fail] => true
- [account_id] => 131
- [parent_id] => 0
- [entity_id] => 0
- [call_processed] => internal
- [call_direction] => outbound
- [accountname] => default
- [origination_rates] => ID:192|CODE:^1702.*|DESTINATION:USA|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.03000|INC:60|INITIALBLOCK:60|RATEGROUP:2|MARKUP:0|ACCID:131
- [limit_usage_333320_user_333320] => 1
- [original_caller_id_name] => 999
- [original_caller_id_number] => 999
- [limit_usage_OV_GW_gw_OV_GW] => 1
- [originated_legs] => ARRAY::c086d718-5d65-41fb-b7c6-9b1b3102e29f;Outbound Call;17027777777|:655f9c95-7e47-49d0-87d9-6f75ea6004cc;Outbound Call;17027777777
- [sip_hangup_phrase] => Temporarily not available
- [last_bridge_hangup_cause] => NO_USER_RESPONSE
- [last_bridge_proto_specific_hangup_cause] => sip:480
- [originate_causes] => ARRAY::c086d718-5d65-41fb-b7c6-9b1b3102e29f;NO_USER_RESPONSE|:655f9c95-7e47-49d0-87d9-6f75ea6004cc;NONE
- [originate_failed_cause] => NO_USER_RESPONSE
- [effective_caller_id_name] => 999
- [effective_caller_id_number] => 9999999999
- [calltype] => STANDARD
- [termination_rates] => ID:27163|CODE:^1702777.*|DESTINATION:|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00110|INC:6|INITIALBLOCK:6|TRUNK:7|PROVIDER:8
- [trunk_id] => 7
- [provider_id] => 8
- [absolute_codec_string] => PCMU,PCMA
- [limit_realm] => TQ_GW
- [limit_id] => gw_TQ_GW
- [limit_max] => 25
- [limit_usage] => 1
- [limit_usage_TQ_GW_gw_TQ_GW] => 1
- [current_application_data] => [leg_timeout=30]sofia/gateway/TQ_GW/17027777777
- [current_application] => bridge
- [switch_m_sdp] => v=0
- o=Sonus_UAC 65012 777673 IN IP4 68.68.124.82
- s=SIP Media Capabilities
- c=IN IP4 68.68.124.84
- t=0 0
- m=audio 35010 RTP/AVP 0 101
- a=rtpmap:0 PCMU/8000
- a=rtpmap:101 telephone-event/8000
- a=fmtp:101 0-15
- a=ptime:20
- [audio_media_flow] => sendrecv
- [rtp_use_codec_string] => PCMU,PCMA
- [rtp_audio_recv_pt] => 8
- [rtp_use_codec_name] => PCMA
- [rtp_use_codec_rate] => 8000
- [rtp_use_codec_ptime] => 20
- [rtp_use_codec_channels] => 1
- [rtp_last_audio_codec_string] => PCMA@8000h@20i@1c
- [read_codec] => PCMA
- [original_read_codec] => PCMA
- [read_rate] => 8000
- [original_read_rate] => 8000
- [write_codec] => PCMA
- [write_rate] => 8000
- [dtmf_type] => rfc2833
- [local_media_ip] => 138.68.252.67
- [local_media_port] => 31388
- [advertised_media_ip] => 138.68.252.67
- [rtp_use_timer_name] => soft
- [rtp_use_pt] => 8
- [rtp_use_ssrc] => 1585545727
- [rtp_2833_send_payload] => 101
- [rtp_2833_recv_payload] => 101
- [remote_media_ip] => 117.247.91.162
- [remote_media_port] => 8000
- [originate_disposition] => SUCCESS
- [DIALSTATUS] => SUCCESS
- [last_bridge_to] => 655f9c95-7e47-49d0-87d9-6f75ea6004cc
- [bridge_channel] => sofia/default/17027777777
- [bridge_uuid] => 655f9c95-7e47-49d0-87d9-6f75ea6004cc
- [signal_bond] => 655f9c95-7e47-49d0-87d9-6f75ea6004cc
- [rtp_local_sdp_str] => v=0
- o=FreeSWITCH 1518400084 1518400086 IN IP4 138.68.252.67
- s=FreeSWITCH
- c=IN IP4 138.68.252.67
- t=0 0
- m=audio 31388 RTP/AVP 8 101
- a=rtpmap:8 PCMA/8000
- a=rtpmap:101 telephone-event/8000
- a=fmtp:101 0-16
- a=ptime:20
- a=sendrecv
- [endpoint_disposition] => ANSWER
- [sip_to_tag] => 3maHXmQN3QvgD
- [sip_from_tag] => deb61560
- [sip_cseq] => 2
- [sip_call_id] => MjNiZjRkMjVjY2JlNDg5NTU0YWIzNWIyOGRhMTlhMjk.
- [sip_full_via] => SIP/2.0/UDP 138.197.236.58:5060;branch=z9hG4bKd611.3efe2a84.2,SIP/2.0/UDP 117.247.91.162:44498;branch=z9hG4bK-d8754z-dc6ba4dc63cdcd2f-1---d8754z-
- [sip_full_from] => <sip:999999@138.197.236.58;transport=UDP>;tag=deb61560
- [sip_full_to] => <sip:17027777777@138.197.236.58;transport=UDP>;tag=3maHXmQN3QvgD
- [last_sent_callee_id_name] => Outbound Call
- [last_sent_callee_id_number] => 17027777777
- [sip_term_status] => 200
- [proto_specific_hangup_cause] => sip:200
- [sip_term_cause] => 16
- [sip_bye_h_P-hint] => rr-enforced
- [sip_bye_h_X-AUTH-IP] => 117.247.91.162
- [sip_bye_h_P-Accountcode] => 333320
- [sip_bye_h_P-effective_caller_id_name] => 999
- [sip_bye_h_P-effective_caller_id_number] => 9999999999
- [last_bridge_role] => originator
- [sip_user_agent] => Z 3.3.25608 r25552
- [sip_hangup_disposition] => recv_bye
- [bridge_hangup_cause] => NORMAL_CLEARING
- [hangup_cause] => NORMAL_CLEARING
- [hangup_cause_q850] => 16
- [digits_dialed] => none
- [start_stamp] => 2018-02-12 02:31:11
- [profile_start_stamp] => 2018-02-12 02:31:11
- [answer_stamp] => 2018-02-12 02:31:12
- [bridge_stamp] => 2018-02-12 02:31:12
- [progress_media_stamp] => 2018-02-12 02:31:12
- [end_stamp] => 2018-02-12 02:31:17
- [start_epoch] => 1518431471
- [start_uepoch] => 1518431471225841
- [profile_start_epoch] => 1518431471
- [profile_start_uepoch] => 1518431471225841
- [answer_epoch] => 1518431472
- [answer_uepoch] => 1518431472745859
- [bridge_epoch] => 1518431472
- [bridge_uepoch] => 1518431472605857
- [last_hold_epoch] => 0
- [last_hold_uepoch] => 0
- [hold_accum_seconds] => 0
- [hold_accum_usec] => 0
- [hold_accum_ms] => 0
- [resurrect_epoch] => 0
- [resurrect_uepoch] => 0
- [progress_epoch] => 0
- [progress_uepoch] => 0
- [progress_media_epoch] => 1518431472
- [progress_media_uepoch] => 1518431472605857
- [end_epoch] => 1518431477
- [end_uepoch] => 1518431477825836
- [last_app] => bridge
- [last_arg] => [leg_timeout=30]sofia/gateway/TQ_GW/17027777777
- [caller_id] => "999999" <999999>
- [duration] => 6
- [billsec] => 5
- [progresssec] => 0
- [answersec] => 1
- [waitsec] => 1
- [progress_mediasec] => 1
- [flow_billsec] => 6
- [mduration] => 6600
- [billmsec] => 5080
- [progressmsec] => 0
- [answermsec] => 1520
- [waitmsec] => 1380
- [progress_mediamsec] => 1380
- [flow_billmsec] => 6600
- [uduration] => 6599995
- [billusec] => 5079977
- [progressusec] => 0
- [answerusec] => 1520018
- [waitusec] => 1380016
- [progress_mediausec] => 1380016
- [flow_billusec] => 6599995
- [rtp_audio_in_raw_bytes] => 33368
- [rtp_audio_in_media_bytes] => 33368
- [rtp_audio_in_packet_count] => 194
- [rtp_audio_in_media_packet_count] => 194
- [rtp_audio_in_skip_packet_count] => 68
- [rtp_audio_in_jitter_packet_count] => 0
- [rtp_audio_in_dtmf_packet_count] => 0
- [rtp_audio_in_cng_packet_count] => 0
- [rtp_audio_in_flush_packet_count] => 0
- [rtp_audio_in_largest_jb_size] => 0
- [rtp_audio_in_jitter_min_variance] => 4.35
- [rtp_audio_in_jitter_max_variance] => 27.59
- [rtp_audio_in_jitter_loss_rate] => 0.00
- [rtp_audio_in_jitter_burst_rate] => 0.00
- [rtp_audio_in_mean_interval] => 20.00
- [rtp_audio_in_flaw_total] => 0
- [rtp_audio_in_quality_percentage] => 100.00
- [rtp_audio_in_mos] => 4.50
- [rtp_audio_out_raw_bytes] => 44204
- [rtp_audio_out_media_bytes] => 44204
- [rtp_audio_out_packet_count] => 257
- [rtp_audio_out_media_packet_count] => 257
- [rtp_audio_out_skip_packet_count] => 0
- [rtp_audio_out_dtmf_packet_count] => 0
- [rtp_audio_out_cng_packet_count] => 0
- [rtp_audio_rtcp_packet_count] => 0
- [rtp_audio_rtcp_octet_count] => 0
- )
- [app_log] => Array
- (
- [applications] => Array
- (
- [0] => Array
- (
- [app_name] => set
- [app_data] => effective_destination_number=17027777777
- [app_stamp] => 1518431471280282
- )
- [1] => Array
- (
- [app_name] => sched_hangup
- [app_data] => +7200 normal_clearing
- [app_stamp] => 1518431471280931
- )
- [2] => Array
- (
- [app_name] => set
- [app_data] => callstart=2018-02-12 10:31:11
- [app_stamp] => 1518431471281253
- )
- [3] => Array
- (
- [app_name] => set
- [app_data] => hangup_after_bridge=true
- [app_stamp] => 1518431471281488
- )
- [4] => Array
- (
- [app_name] => set
- [app_data] => continue_on_fail=true
- [app_stamp] => 1518431471281698
- )
- [5] => Array
- (
- [app_name] => set
- [app_data] => account_id=131
- [app_stamp] => 1518431471281911
- )
- [6] => Array
- (
- [app_name] => set
- [app_data] => parent_id=0
- [app_stamp] => 1518431471282128
- )
- [7] => Array
- (
- [app_name] => set
- [app_data] => entity_id=0
- [app_stamp] => 1518431471282363
- )
- [8] => Array
- (
- [app_name] => set
- [app_data] => call_processed=internal
- [app_stamp] => 1518431471282588
- )
- [9] => Array
- (
- [app_name] => set
- [app_data] => call_direction=outbound
- [app_stamp] => 1518431471282836
- )
- [10] => Array
- (
- [app_name] => set
- [app_data] => accountname=default
- [app_stamp] => 1518431471283077
- )
- [11] => Array
- (
- [app_name] => set
- [app_data] => origination_rates=ID:192|CODE:^1702.*|DESTINATION:USA|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.03000|INC:60|INITIALBLOCK:60|RATEGROUP:2|MARKUP:0|ACCID:131
- [app_stamp] => 1518431471283294
- )
- [12] => Array
- (
- [app_name] => limit
- [app_data] => db 333320 user_333320 20/0 !SWITCH_CONGESTION
- [app_stamp] => 1518431471283523
- )
- [13] => Array
- (
- [app_name] => set
- [app_data] => original_caller_id_name=999
- [app_stamp] => 1518431471284405
- )
- [14] => Array
- (
- [app_name] => set
- [app_data] => original_caller_id_number=999
- [app_stamp] => 1518431471284641
- )
- [15] => Array
- (
- [app_name] => set
- [app_data] => effective_caller_id_name=999
- [app_stamp] => 1518431471284878
- )
- [16] => Array
- (
- [app_name] => set
- [app_data] => effective_caller_id_number=9999999999
- [app_stamp] => 1518431471285124
- )
- [17] => Array
- (
- [app_name] => set
- [app_data] => calltype=STANDARD
- [app_stamp] => 1518431471285363
- )
- [18] => Array
- (
- [app_name] => set
- [app_data] => termination_rates=ID:228938|CODE:^1702777.*|DESTINATION:PAHRUMP NEVADA|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00088|INC:6|INITIALBLOCK:6|TRUNK:6|PROVIDER:7
- [app_stamp] => 1518431471285606
- )
- [19] => Array
- (
- [app_name] => set
- [app_data] => trunk_id=6
- [app_stamp] => 1518431471285912
- )
- [20] => Array
- (
- [app_name] => set
- [app_data] => provider_id=7
- [app_stamp] => 1518431471286158
- )
- [21] => Array
- (
- [app_name] => set
- [app_data] => absolute_codec_string=PCMU,PCMA
- [app_stamp] => 1518431471286434
- )
- [22] => Array
- (
- [app_name] => limit_execute
- [app_data] => db OV_GW gw_OV_GW 25 bridge [leg_timeout=30]sofia/gateway/OV_GW/17027777777
- [app_stamp] => 1518431471286725
- )
- [23] => Array
- (
- [app_name] => bridge
- [app_data] => [leg_timeout=30]sofia/gateway/OV_GW/17027777777
- [app_stamp] => 1518431471287235
- )
- [24] => Array
- (
- [app_name] => set
- [app_data] => effective_caller_id_name=999
- [app_stamp] => 1518431471371134
- )
- [25] => Array
- (
- [app_name] => set
- [app_data] => effective_caller_id_number=9999999999
- [app_stamp] => 1518431471371440
- )
- [26] => Array
- (
- [app_name] => set
- [app_data] => calltype=STANDARD
- [app_stamp] => 1518431471371680
- )
- [27] => Array
- (
- [app_name] => set
- [app_data] => termination_rates=ID:27163|CODE:^1702777.*|DESTINATION:|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00110|INC:6|INITIALBLOCK:6|TRUNK:7|PROVIDER:8
- [app_stamp] => 1518431471371938
- )
- [28] => Array
- (
- [app_name] => set
- [app_data] => trunk_id=7
- [app_stamp] => 1518431471372269
- )
- [29] => Array
- (
- [app_name] => set
- [app_data] => provider_id=8
- [app_stamp] => 1518431471372528
- )
- [30] => Array
- (
- [app_name] => set
- [app_data] => absolute_codec_string=PCMU,PCMA
- [app_stamp] => 1518431471372799
- )
- [31] => Array
- (
- [app_name] => limit_execute
- [app_data] => db TQ_GW gw_TQ_GW 25 bridge [leg_timeout=30]sofia/gateway/TQ_GW/17027777777
- [app_stamp] => 1518431471373061
- )
- [32] => Array
- (
- [app_name] => bridge
- [app_data] => [leg_timeout=30]sofia/gateway/TQ_GW/17027777777
- [app_stamp] => 1518431471373563
- )
- )
- )
- [callflow] => Array
- (
- [0] => Array
- (
- [dialplan] => XML
- [profile_index] => 1
- [extension] => Array
- (
- [name] => 17027777777
- [number] => 17027777777
- [applications] => Array
- (
- [0] => Array
- (
- [app_name] => set
- [app_data] => effective_destination_number=17027777777
- )
- [1] => Array
- (
- [app_name] => sched_hangup
- [app_data] => +7200 normal_clearing
- )
- [2] => Array
- (
- [app_name] => set
- [app_data] => callstart=2018-02-12 10:31:11
- )
- [3] => Array
- (
- [app_name] => set
- [app_data] => hangup_after_bridge=true
- )
- [4] => Array
- (
- [app_name] => set
- [app_data] => continue_on_fail=true
- )
- [5] => Array
- (
- [app_name] => set
- [app_data] => account_id=131
- )
- [6] => Array
- (
- [app_name] => set
- [app_data] => parent_id=0
- )
- [7] => Array
- (
- [app_name] => set
- [app_data] => entity_id=0
- )
- [8] => Array
- (
- [app_name] => set
- [app_data] => call_processed=internal
- )
- [9] => Array
- (
- [app_name] => set
- [app_data] => call_direction=outbound
- )
- [10] => Array
- (
- [app_name] => set
- [app_data] => accountname=default
- )
- [11] => Array
- (
- [app_name] => set
- [app_data] => origination_rates=ID:192|CODE:^1702.*|DESTINATION:USA|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.03000|INC:60|INITIALBLOCK:60|RATEGROUP:2|MARKUP:0|ACCID:131
- )
- [12] => Array
- (
- [app_name] => limit
- [app_data] => db 333320 user_333320 20/0 !SWITCH_CONGESTION
- )
- [13] => Array
- (
- [app_name] => set
- [app_data] => original_caller_id_name=999
- )
- [14] => Array
- (
- [app_name] => set
- [app_data] => original_caller_id_number=999
- )
- [15] => Array
- (
- [app_name] => set
- [app_data] => effective_caller_id_name=999
- )
- [16] => Array
- (
- [app_name] => set
- [app_data] => effective_caller_id_number=9999999999
- )
- [17] => Array
- (
- [app_name] => set
- [app_data] => calltype=STANDARD
- )
- [18] => Array
- (
- [app_name] => set
- [app_data] => termination_rates=ID:228938|CODE:^1702777.*|DESTINATION:PAHRUMP NEVADA|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00088|INC:6|INITIALBLOCK:6|TRUNK:6|PROVIDER:7
- )
- [19] => Array
- (
- [app_name] => set
- [app_data] => trunk_id=6
- )
- [20] => Array
- (
- [app_name] => set
- [app_data] => provider_id=7
- )
- [21] => Array
- (
- [app_name] => set
- [app_data] => absolute_codec_string=PCMU,PCMA
- )
- [22] => Array
- (
- [app_name] => limit_execute
- [app_data] => db OV_GW gw_OV_GW 25 bridge [leg_timeout=30]sofia/gateway/OV_GW/17027777777
- )
- [23] => Array
- (
- [app_name] => set
- [app_data] => effective_caller_id_name=999
- )
- [24] => Array
- (
- [app_name] => set
- [app_data] => effective_caller_id_number=9999999999
- )
- [25] => Array
- (
- [app_name] => set
- [app_data] => calltype=STANDARD
- )
- [26] => Array
- (
- [app_name] => set
- [app_data] => termination_rates=ID:27163|CODE:^1702777.*|DESTINATION:|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00110|INC:6|INITIALBLOCK:6|TRUNK:7|PROVIDER:8
- )
- [27] => Array
- (
- [app_name] => set
- [app_data] => trunk_id=7
- )
- [28] => Array
- (
- [app_name] => set
- [app_data] => provider_id=8
- )
- [29] => Array
- (
- [app_name] => set
- [app_data] => absolute_codec_string=PCMU,PCMA
- )
- [30] => Array
- (
- [app_name] => limit_execute
- [app_data] => db TQ_GW gw_TQ_GW 25 bridge [leg_timeout=30]sofia/gateway/TQ_GW/17027777777
- )
- )
- )
- [caller_profile] => Array
- (
- [username] => 999999
- [dialplan] => XML
- [caller_id_name] => 999999
- [ani] => 999999
- [aniii] =>
- [caller_id_number] => 999999
- [network_addr] => 138.197.236.58
- [rdnis] =>
- [destination_number] => 17027777777
- [uuid] => 85126565-0fe4-4cd5-8993-384269e69f82
- [source] => mod_sofia
- [context] => default
- [chan_name] => sofia/default/999999@138.197.236.58
- [originatee] => Array
- (
- [originatee_caller_profiles] => Array
- (
- [0] => Array
- (
- [username] => 999999
- [dialplan] => XML
- [caller_id_name] => 999
- [ani] => 999999
- [aniii] =>
- [caller_id_number] => 9999999999
- [network_addr] => 138.197.236.58
- [rdnis] =>
- [destination_number] => 17027777777
- [uuid] => 655f9c95-7e47-49d0-87d9-6f75ea6004cc
- [source] => mod_sofia
- [context] => default
- [chan_name] => sofia/default/17027777777
- )
- )
- )
- )
- [times] => Array
- (
- [created_time] => 1518431471225841
- [profile_created_time] => 1518431471225841
- [progress_time] => 0
- [progress_media_time] => 1518431472605857
- [answered_time] => 1518431472745859
- [bridged_time] => 1518431472605857
- [last_hold_time] => 0
- [hold_accum_time] => 0
- [hangup_time] => 1518431477825836
- [resurrect_time] => 0
- [transfer_time] => 0
- )
- )
- )
- )
- [2018-02-12 02:31:17] *********************** OUTBOUND CALL ENTRY END *************
- [2018-02-12 02:31:17] *************************** CDR ends ********************************
- [2018-02-12 02:31:17] Return cost 0.0300
- [2018-02-12 02:31:17] Return cost 0.0001
- [2018-02-12 02:31:17] Debit :0.0300 Cost : 0 Provider Cost : 0.0001
- [2018-02-12 02:31:17] *********************** OUTBOUND CALL ENTRY START *************
- [2018-02-12 02:31:17] INSERT INTO cdrs (uniqueid,accountid,type,callerid,callednum,billseconds,trunk_id,trunkip,callerip,disposition,callstart,debit,cost,provider_id,pricelist_id,package_id,pattern,notes,rate_cost,reseller_id,reseller_code,reseller_code_destination,reseller_cost,provider_code,provider_code_destination,provider_cost,provider_call_cost,call_direction,calltype,profile_start_stamp,answer_stamp,bridge_stamp,progress_stamp,progress_media_stamp,end_stamp,billmsec,answermsec,waitmsec,progress_mediamsec,flow_billmsec) values ('85126565-0fe4-4cd5-8993-384269e69f82','131','0','999 <999>','17027777777','5',7,'138.197.236.58','117.247.91.162','NORMAL_CLEARING','2018-02-12 10:31:11','0.0300','0.0001',8,'2','0','^1702.*','USA','0.03000','0','0','',0,'^1702777.*','','0.00110','0.0001','outbound','STANDARD','2018-02-12 02:31:11','2018-02-12 02:31:12','2018-02-12 02:31:12','','2018-02-12 02:31:12','2018-02-12 02:31:17',5080,'1520','1380','1380','6600')
- [2018-02-12 02:31:17] Balance update : UPDATE accounts SET balance=IF(posttoexternal=1,balance+0.0300,balance-0.0300) WHERE id=131
- [2018-02-12 02:31:17] Balance update : UPDATE accounts SET balance=IF(posttoexternal=1,balance+-0.0001,balance--0.0001) WHERE id=8
- [2018-02-12 02:31:17] *********************** OUTBOUND CALL ENTRY END *************
- [2018-02-12 02:31:17] *************************** CDR ends ********************************
- ^C
- root@FS01:/var/log/astpp# mysql -h 138.197.236.58 -uroot -pd5YA6Vipec
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 80721
- Server version: 5.5.55-0+deb8u1-log (Debian)
- Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> use astpp
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- mysql> select posttoexternal from accounts where id =8;
- +----------------+
- | posttoexternal |
- +----------------+
- | 1 |
- +----------------+
- 1 row in set (0.00 sec)
- mysql> select posttoexternal,balance from accounts where id =8;
- +----------------+----------+
- | posttoexternal | balance |
- +----------------+----------+
- | 1 | -0.00060 |
- +----------------+----------+
- 1 row in set (0.00 sec)
- mysql> select posttoexternal,balance from accounts where id =8;
- +----------------+----------+
- | posttoexternal | balance |
- +----------------+----------+
- | 1 | -0.00070 |
- +----------------+----------+
- 1 row in set (0.00 sec)
- mysql>