[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_invite_record_route] => [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] => ;tag=deb61560 [sip_full_to] => ;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>