2018-07-02 11:36:08.946106 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.caller_id_prefix as trunk_caller_id_prefix,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.dialed_modify,TK.maxchannels,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern ='^918298502.*' OR pattern ='^91829850.*' OR pattern ='^9182985.*' OR pattern ='^918298.*' OR pattern ='^91829.*' OR pattern ='^9182.*' OR pattern ='^918.*' OR pattern ='^91.*' OR pattern ='^9.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (4,5,8,9,10) ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Termination Rates Information ===================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 253492
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Code : ^918298.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Destination : India Mobile Vodafone
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Free Seconds : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prefix : ^918298.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Strip : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prepend : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Carrier id : 4
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] carrier_name : ONO
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] dialplan_variable : ignore_early_media=true
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Failover gateway : ONO2
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Vendor id : 6
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Number Translation : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Max channels : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================END OF TERMINATION RATES=======================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Termination Rates Information ===================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 249818
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Code : ^91.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Destination : India
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Free Seconds : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prefix : ^91.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Strip : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prepend : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Carrier id : 4
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] carrier_name : ONO
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] dialplan_variable : ignore_early_media=true
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Failover gateway : ONO2
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Vendor id : 6
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Number Translation : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Max channels : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================END OF TERMINATION RATES=======================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Termination Rates Information ===================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 581
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Code : ^9.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Destination : España Fijo
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Free Seconds : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prefix : ^9.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Strip : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prepend : 0034
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Carrier id : 5
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] carrier_name : Orange_2
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] dialplan_variable : ignore_early_media=true
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Failover gateway : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Vendor id : 7
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Number Translation : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Max channels : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================END OF TERMINATION RATES=======================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Termination Rates Information ===================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 147620
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Code : ^9.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Destination : España Fijo
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Free Seconds : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prefix : ^9.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Strip : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prepend : 2300134
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Carrier id : 9
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] carrier_name : Bluephone
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] dialplan_variable : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Failover gateway : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Vendor id : 100
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Number Translation : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Max channels : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================END OF TERMINATION RATES=======================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Termination Rates Information ===================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 147605
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Code : ^9.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Destination : España Fijo
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Free Seconds : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prefix : ^9.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Strip : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prepend : 3000
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Carrier id : 8
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] carrier_name : Alisys
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] dialplan_variable : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Failover gateway : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Vendor id : 78
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Number Translation : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Max channels : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================END OF TERMINATION RATES=======================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Termination Rates Information ===================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 16
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Code : ^9.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Destination : España Fijo
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Free Seconds : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prefix : ^9.*
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Strip : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Prepend : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Carrier id : 4
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] carrier_name : ONO
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] dialplan_variable : ignore_early_media=true
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Failover gateway : ONO2
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Vendor id : 6
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Number Translation : 
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] Max channels : 0
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================END OF TERMINATION RATES=======================
2018-07-02 11:36:08.966095 [INFO] switch_cpp.cpp:1365 [ASTPP]  :::::::::::::::: customer_userinfo is_recording 1
2018-07-02 11:36:08.966095 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 9 AND status=0 LIMIT 1
2018-07-02 11:36:08.986119 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [ME DEVANG IN ELSE] : ONO/918298502
2018-07-02 11:36:08.986119 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 9 AND status=0 LIMIT 1
2018-07-02 11:36:09.026109 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [ME DEVANG IN ELSE] : ONO/918298502
2018-07-02 11:36:09.026109 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 9 AND status=0 LIMIT 1
2018-07-02 11:36:09.046128 [WARNING] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] Before number translation : 918298502
2018-07-02 11:36:09.046128 [WARNING] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] After  number translation : 0034918298502
2018-07-02 11:36:09.046128 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [ME DEVANG IN ELSE] : Orange_2/0034918298502
2018-07-02 11:36:09.046128 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 9 AND status=0 LIMIT 1
2018-07-02 11:36:09.066100 [WARNING] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] Before number translation : 918298502
2018-07-02 11:36:09.066100 [WARNING] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] After  number translation : 2300134918298502
2018-07-02 11:36:09.066100 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [ME DEVANG IN ELSE] : Bluephone/2300134918298502
2018-07-02 11:36:09.066100 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 9 AND status=0 LIMIT 1
2018-07-02 11:36:09.086094 [WARNING] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] Before number translation : 918298502
2018-07-02 11:36:09.086094 [WARNING] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] After  number translation : 3000918298502
2018-07-02 11:36:09.086094 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [ME DEVANG IN ELSE] : Alisys/3000918298502
2018-07-02 11:36:09.086094 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 9 AND status=0 LIMIT 1
2018-07-02 11:36:09.106085 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [ME DEVANG IN ELSE] : ONO/918298502
2018-07-02 11:36:09.106085 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Generated XML:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="918298502">
<condition field="destination_number" expression="918298502">
<action application="set" data="effective_destination_number=918298502"/>
<action application="sched_hangup" data="+1440 normal_clearing"/>
<action application="set" data="callstart=2018-07-02 09:51:16"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=0,1,2,3,6,7,16,17,19,18,20,21,22,23,25,27,28,29,30,34,38,41,42,43,44,45,47,50,52,54,57,58,63,65,66,69,79,81,88,95,96,97,98,99,100,101,102,103,111,127,487,500,501,502,503,600,601,602,603,604,605,606,607,608,609"/>
<action application="set" data="account_id=9"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="entity_id=0"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="call_direction=outbound"/>
<action application="set" data="accountname=default"/>
<action application="set" data="fax_enable_t38=true"/>
<action application="set" data="fax_enable_t38_request=true"/>
<action application="set" data="origination_rates=ID:84590|CODE:^9.*|DESTINATION:España Fijo|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.01000|INC:0|INITIALBLOCK:0|RATEGROUP:9|MARKUP:0|ACCID:9"/>
<action application="set" data="effective_caller_id_number=915300145"/>
<action application="export" data="sip_from_display=915300145"/>
<action application="set" data="calltype=STANDARD"/>
<action application="set" data="termination_rates=ID:253492|CODE:^918298.*|DESTINATION:India Mobile Vodafone|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00733|INC:0|INITIALBLOCK:0|TRUNK:4|PROVIDER:6"/>
<action application="set" data="trunk_id=4"/>
<action application="set" data="provider_id=6"/>
<action application="bridge" data="[absolute_codec_string=]sofia/gateway/ONO/918298502"/>
<action application="bridge" data="[absolute_codec_string=]sofia/gateway/ONO2/918298502"/>
<action application="bridge" data="[absolute_codec_string=]sofia/gateway/ONO3/918298502"/>
<action application="set" data="effective_caller_id_number=915300145"/>
<action application="export" data="sip_from_display=915300145"/>
<action application="set" data="calltype=STANDARD"/>
<action application="set" data="termination_rates=ID:249818|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00733|INC:0|INITIALBLOCK:0|TRUNK:4|PROVIDER:6"/>
<action application="set" data="trunk_id=4"/>
<action application="set" data="provider_id=6"/>
<action application="bridge" data="[absolute_codec_string=]sofia/gateway/ONO/918298502"/>
<action application="bridge" data="[absolute_codec_string=]sofia/gateway/ONO2/918298502"/>
<action application="bridge" data="[absolute_codec_string=]sofia/gateway/ONO3/918298502"/>
<action application="set" data="effective_caller_id_number=915300145"/>
<action application="export" data="sip_from_display=915300145"/>
<action application="set" data="calltype=STANDARD"/>
<action application="set" data="termination_rates=ID:581|CODE:^9.*|DESTINATION:España Fijo|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00240|INC:0|INITIALBLOCK:0|TRUNK:5|PROVIDER:7"/>
<action application="set" data="trunk_id=5"/>
<action application="set" data="provider_id=7"/>
<action application="bridge" data="[absolute_codec_string=^^:PCMA:PCMU:OPUS:G729]sofia/gateway/Orange_2/0034918298502"/>
<action application="set" data="effective_caller_id_number=915300145"/>
<action application="export" data="sip_from_display=915300145"/>
<action application="set" data="calltype=STANDARD"/>
<action application="set" data="termination_rates=ID:147620|CODE:^9.*|DESTINATION:España Fijo|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00250|INC:0|INITIALBLOCK:0|TRUNK:9|PROVIDER:100"/>
<action application="set" data="trunk_id=9"/>
<action application="set" data="provider_id=100"/>
<action application="bridge" data="[absolute_codec_string=^^:PCMU:PCMA:OPUS:G729]sofia/gateway/Bluephone/2300134918298502"/>
<action application="set" data="effective_caller_id_number=915300145"/>
<action application="export" data="sip_from_display=915300145"/>
<action application="set" data="calltype=STANDARD"/>
<action application="set" data="termination_rates=ID:147605|CODE:^9.*|DESTINATION:España Fijo|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00290|INC:0|INITIALBLOCK:0|TRUNK:8|PROVIDER:78"/>
<action application="set" data="trunk_id=8"/>
<action application="set" data="provider_id=78"/>
<action application="bridge" data="[absolute_codec_string=^^:PCMA:PCMU:OPUS:G729]sofia/gateway/Alisys/3000918298502"/>
<action application="set" data="effective_caller_id_number=915300145"/>
<action application="export" data="sip_from_display=915300145"/>
<action application="set" data="calltype=STANDARD"/>
<action application="set" data="termination_rates=ID:16|CODE:^9.*|DESTINATION:España Fijo|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00370|INC:0|INITIALBLOCK:0|TRUNK:4|PROVIDER:6"/>
<action application="set" data="trunk_id=4"/>
<action application="set" data="provider_id=6"/>
<action application="bridge" data="[absolute_codec_string=]sofia/gateway/ONO/918298502"/>
<action application="bridge" data="[absolute_codec_string=]sofia/gateway/ONO2/918298502"/>
<action application="bridge" data="[absolute_codec_string=]sofia/gateway/ONO3/918298502"/>
</condition>
</extension>
</context>
</section>
</document>