asterisk2billing.org
http://forum.asterisk2billing.org/

OUTBOUND CALLING !! hellp
http://forum.asterisk2billing.org/viewtopic.php?f=14&t=10331
Page 1 of 1

Author:  matrix1233 [ Sun May 05, 2013 12:36 am ]
Post subject:  OUTBOUND CALLING !! hellp

Hello,
i installed a2billing and configured a trunk on asterisk and in to the provider section of a2billing .. all config done and also callplain and rate done .. my problem is that i can't do a call i have alway a IVR who say "Please enter the number you wish to call and then press the pound key " .. how can i remove this message and directly call via my trunk ? thanks

Author:  matrix1233 [ Sun May 05, 2013 3:12 pm ]
Post subject:  Re: OUTBOUND CALLING !! hellp

hello,

here all the log on tha a2billing_agi of a call.. can u plz help me
thanks

[05/05/2013 17:08:47]:[file:Class.A2Billing.php - line:604 - uniqueid:]:[CallerID:]:[CN:]:[A2Billing AGI internal configuration:]
[05/05/2013 17:08:47]:[file:Class.A2Billing.php - line:605 - uniqueid:]:[CallerID:]:[CN:]:[Array
(
[dialcommand_param_call_2did] => |60|HiL(%timeout%:61000:30000)
[description] => agi-config
[asterisk_version] => 1_6
[answer_call] => 1
[play_audio] => 0
[say_goodbye] => 0
[play_menulanguage] => 0
[force_language] =>
[intro_prompt] =>
[min_credit_2call] => 0
[min_duration_2bill] => 0
[notenoughcredit_cardnumber] => 0
[notenoughcredit_assign_newcardnumber_cid] => 0
[use_dnid] => 1
[no_auth_dnid] => Array
(
[0] => 2400
[1] => 2300
)

[number_try] => 3
[force_callplan_id] =>
[say_balance_after_auth] => 1
[say_balance_after_call] => 0
[say_rateinitial] => 0
[say_timetocall] => 1
[auto_setcallerid] => 1
[force_callerid] =>
[cid_sanitize] => 0
[cid_enable] => 0
[cid_askpincode_ifnot_callerid] => 1
[failover_lc_prefix] => 0
[cid_auto_assign_card_to_cid] => 1
[callerid_authentication_over_cardnumber] => 0
[sip_iax_friends] => 0
[sip_iax_pstn_direct_call_prefix] => 555
[sip_iax_pstn_direct_call] => 0
[ivr_voucher] => 0
[ivr_voucher_prefix] => 8
[jump_voucher_if_min_credit] => 0
[dialcommand_param] => |60|HRrL(%timeout%:61000:30000)
[dialcommand_param_sipiax_friend] => |60|HiL(3600000:61000:30000)
[switchdialcommand] => 1
[failover_recursive_limit] => 2
[maxtime_tocall_negatif_free_route] => 5400
[send_reminder] => 0
[record_call] => 0
[monitor_formatfile] => gsm
[agi_force_currency] =>
[currency_association] => Array
(
[0] => usd:dollars
[1] => mxn:pesos
[2] => eur:euros
[3] => all:credit
)

[local_dialing_addcountryprefix] => 0
[max_call_call_2_did] => 3600
[file_conf_enter_destination] => prepaid-enter-dest
[conf_order_menulang] => en:fr:es
[callback_bill_1stleg_ifcall_notconnected] => 1
[international_prefixes] => Array
(
[0] => 011
[1] => 00
[2] => 09
[3] => 1
)

[extracharge_did] => Array
(
[0] => 1800
[1] => 1900
)

[extracharge_fee] => Array
(
[0] => 0
[1] => 0
)

[extracharge_buyfee] => Array
(
[0] => 0
[1] => 0
)

[maxtime_tounlimited_calls] => 5400
[maxtime_tofree_calls] => 5400
[callplan_deck_minute_threshold] =>
[disable_announcement_seconds] => 0
[verbosity_level] => 0
[logging_level] => 4
[dial_balance_reservation] => 0.25
[callerid_update] => 0
[cid_auto_create_card] => 0
[cid_auto_create_card_len] => 10
[cid_auto_create_card_typepaid] => PREPAID
[cid_auto_create_card_credit] => 0
[cid_auto_create_card_credit_limit] => 0
[cid_auto_create_card_tariffgroup] => 1
[busy_timeout] => 1
[callback_reduce_balance] => 1
[ivr_enable_locking_option] => 0
[ivr_enable_account_information] => 0
[ivr_enable_ivr_speeddial] => 0
[play_rate_cents_if_lower_one] => 0
[callback_beep_to_enter_destination] => 0
[cid_prompt_callback_confirm_phonenumber] => 0
[logger_enable] => 1
[log_file] => /var/log/a2billing/a2billing.log
[dialcommand_param_call_2did ] => |30|HL(3600000:61000:30000)
[currency_association_internal] => Array
(
[usd] => dollars
[mxn] => pesos
[eur] => euros
[all] => credit
)

[file_conf_enter_menulang] => prepaid-menulang
[ivr_voucher_prefixe] => 8
[cheat_on_announcement_time] => 0
)
]
[05/05/2013 17:08:47]:[file:a2billing.php - line:106 - uniqueid:]:[CallerID:]:[CN:]:[IDCONFIG : 2]
[05/05/2013 17:08:47]:[file:a2billing.php - line:107 - uniqueid:]:[CallerID:]:[CN:]:[MODE : standard]
[05/05/2013 17:08:47]:[file:a2billing.php - line:124 - uniqueid:]:[CallerID:]:[CN:]:[AGI Request:
Array
(
[agi_request] => a2billing.php
[agi_channel] => SIP/4887623847-00000052
[agi_language] => en
[agi_type] => SIP
[agi_uniqueid] => 1367766527.82
[agi_version] => 1.8.11.1-1digium1~lucid
[agi_callerid] => 4887623847
[agi_calleridname] => unknown
[agi_callingpres] => 0
[agi_callingani2] => 0
[agi_callington] => 0
[agi_callingtns] => 0
[agi_dnid] => 555
[agi_rdnis] => unknown
[agi_context] => a2billing-sip
[agi_extension] => 555
[agi_priority] => 1
[agi_enhanced] => 0.0
[agi_accountcode] => 4887623847
[agi_threadid] => 139868021856000
[agi_arg_1] => 2
)
]
[05/05/2013 17:08:47]:[file:a2billing.php - line:126 - uniqueid:]:[CallerID:]:[CN:]:[[INFO : A2Billing - Version 1.9.4 (Cuprum)]]
[05/05/2013 17:08:47]:[file:Class.A2Billing.php - line:718 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:]:[ get_agi_request_parameter = 4887623847 ; SIP/4887623847-00000052 ; 1367766527.82 ; 4887623847 ; 555]
[05/05/2013 17:08:47]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:]:[Running time=0.0025959014892578 - QUERY=
SELECT id, currency, name, value FROM cc_currencies ORDER BY id
]
[05/05/2013 17:08:47]:[file:a2billing.php - line:162 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:]:[[ANSWER CALL]]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2721 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:]:[ - Account code ::> 4887623847]
[05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00097417831420898 - QUERY=
SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias, status, voicemail_permitted, voicemail_activated, cc_card.restriction, cc_country.countryprefix FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id LEFT JOIN cc_country ON cc_card.country=cc_country.countrycode WHERE username='4887623847'
]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2738 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ - Retrieve account info SQL ::> SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias, status, voicemail_permitted, voicemail_activated, cc_card.restriction, cc_country.countryprefix FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id LEFT JOIN cc_country ON cc_card.country=cc_country.countrycode WHERE username='4887623847']
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2807 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[SET CHANNEL(language) en]]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2811 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[credit=5.00000 :: tariff=1 :: status=1 :: isused=0 :: simultaccess=0 :: typepaid=0 :: creditlimit= :: language=en]]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:750 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CARD STATUS UPDATE]]
[05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00041699409484863 - QUERY=
UPDATE cc_card SET inuse=inuse+1, credit=credit-0.25 WHERE username='4887623847'
]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:759 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse=inuse+1, credit=credit-0.25 WHERE username='4887623847']]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:3099 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[A2Billing] SAY BALANCE : 5.00000
]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:1924 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CURRENCY : EUR]]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:1931 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[BEFORE: 4.1955108034403 SPRINTF : 4.20]]
[05/05/2013 17:08:48]:[file:a2billing.php - line:178 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[TRY : callingcard_ivr_authenticate]]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2392 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[AUTO SetCallerID]]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2398 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[REQUESTED SetCallerID : 4887623847]]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2410 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[EXEC SetCallerID : 4887623847]]
[05/05/2013 17:08:48]:[file:a2billing.php - line:193 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CHANNEL STATUS : 6 = Line is up]
[CREDIT : 5.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[05/05/2013 17:08:48]:[file:a2billing.php - line:396 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[TARIFF ID -> 1]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:808 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[use_dnid:1 && (!in_array:) && len_dnid:(3 || len_exten:3 ) && (try_num:0)]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:817 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[USE_DNID DESTINATION ::> 555]]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:881 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CALL 2 DID]]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:890 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='555' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00')]
[05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00042390823364258 - QUERY=
SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='555' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00')
]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:896 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[DESTINATION ::> 555]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:903 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RULES APPLY ON DESTINATION ::> 555]
[05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00031399726867676 - QUERY=
UPDATE cc_card SET redial = '555' WHERE username='4887623847'
]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:3551 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '555' WHERE username='4887623847']:[result: 1]]
[05/05/2013 17:08:48]:[file:Class.RateEngine.php - line:98 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CC_asterisk_rate-engine: (1, 555)]]
[05/05/2013 17:08:48]:[file:Class.RateEngine.php - line:120 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CC_asterisk_rate-engine - CALLERID : 4887623847]]
[05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00136399269104 - QUERY=
SELECT
tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname,
destination, cc_ratecard.id, dialprefix, destination, buyrate,
buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea,
billingblocka, stepchargeb, chargeb,timechargeb, billingblockb,
stepchargec, chargec, timechargec, billingblockc,cc_tariffplan.id_trunk AS tp_id_trunk,
tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,cc_ratecard.id_trunk AS rc_id_trunk,
rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix, musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk, rt_trunk.failover_trunk AS rt_failover_trunk,tp_trunk.addparameter AS tp_addparameter_trunk, rt_trunk.addparameter AS rt_addparameter_trunk, id_outbound_cidgroup,
id_cc_package_offer, tp_trunk.status, rt_trunk.status, tp_trunk.inuse, rt_trunk.inuse,
tp_trunk.maxuse, rt_trunk.maxuse,tp_trunk.if_max_use, rt_trunk.if_max_use,cc_ratecard.rounding_calltime AS rounding_calltime,
cc_ratecard.rounding_threshold AS rounding_threshold, cc_ratecard.additional_block_charge AS additional_block_charge, cc_ratecard.additional_block_charge_time AS additional_block_charge_time,
cc_ratecard.additional_grace AS additional_grace, cc_ratecard.minimal_cost AS minimal_cost,disconnectcharge_after,announce_time_correction

FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk

WHERE cc_tariffgroup.id=1 AND ((dialprefix='555' OR dialprefix='55' OR dialprefix='5' OR dialprefix='defaultprefix') OR (dialprefix LIKE '&_%' ESCAPE '&' AND '555' REGEXP REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CONCAT('^', dialprefix, '$'), 'X', '[0-9]'), 'Z', '[1-9]'), 'N', '[2-9]'), '.', '.+'), '_', '')))
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL)
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL)
AND (starttime <= 9668 AND endtime >=9668)
AND idtariffgroup='1'
AND ( dnidprefix=SUBSTRING('555',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = (SELECT COUNT(dnidprefix) FROM cc_tariffgroup_plan RIGHT JOIN cc_tariffplan ON cc_tariffgroup_plan.idtariffplan=cc_tariffplan.id WHERE dnidprefix=SUBSTRING('555',1,length(dnidprefix)) AND idtariffgroup=1 ) ))
AND ( calleridprefix=SUBSTRING('4887623847',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = (SELECT count(calleridprefix) FROM cc_tariffgroup_plan RIGHT JOIN cc_tariffplan ON cc_tariffgroup_plan.idtariffplan=cc_tariffplan.id WHERE calleridprefix=SUBSTRING('4887623847',1,length(calleridprefix)) AND idtariffgroup=1 )))
ORDER BY LENGTH(dialprefix) DESC
]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:1017 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ERROR ::> RateEngine didnt succeed to match the dialed number over the ratecard (Please check : id the ratecard is well create ; if the removeInter_Prefix is set according to your prefix in the ratecard ; if you hooked the ratecard to the Call Plan)]
[05/05/2013 17:08:48]:[file:a2billing.php - line:572 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ANSWER fct callingcard_ivr authorize:> -1]
[05/05/2013 17:08:48]:[file:a2billing.php - line:193 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CHANNEL STATUS : 6 = Line is up]
[CREDIT : 5.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[05/05/2013 17:08:48]:[file:a2billing.php - line:396 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[TARIFF ID -> 1]
[05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:808 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[use_dnid:0 && (!in_array:) && len_dnid:(3 || len_exten:3 ) && (try_num:1)]
[05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:825 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RES DTMF : 1]
[05/05/2013 17:08:51]:[file:Class.Table.php - line:182 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00044417381286621 - QUERY=
SELECT phone FROM cc_speeddial WHERE id_cc_card='3' AND speeddial='1'
]
[05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:871 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SPEEDIAL REPLACE DESTINATION ::> 1]
[05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:881 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CALL 2 DID]]
[05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:890 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='1' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00')]
[05/05/2013 17:08:51]:[file:Class.Table.php - line:182 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00040817260742188 - QUERY=
SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='1' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00')
]
[05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:896 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[DESTINATION ::> 1]
[05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:903 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RULES APPLY ON DESTINATION ::> ]
[05/05/2013 17:08:51]:[file:a2billing.php - line:572 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ANSWER fct callingcard_ivr authorize:> -1]
[05/05/2013 17:08:51]:[file:a2billing.php - line:193 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CHANNEL STATUS : 6 = Line is up]
[CREDIT : 5.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[05/05/2013 17:08:51]:[file:a2billing.php - line:396 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[TARIFF ID -> 1]
[05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:808 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[use_dnid:0 && (!in_array:) && len_dnid:(3 || len_exten:3 ) && (try_num:2)]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:825 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RES DTMF : 19]
[05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00040721893310547 - QUERY=
SELECT phone FROM cc_speeddial WHERE id_cc_card='3' AND speeddial='19'
]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:871 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SPEEDIAL REPLACE DESTINATION ::> 19]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:881 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CALL 2 DID]]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:890 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='19' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00')]
[05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00040411949157715 - QUERY=
SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='19' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00')
]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:896 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[DESTINATION ::> 19]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:903 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RULES APPLY ON DESTINATION ::> 9]
[05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.0003821849822998 - QUERY=
UPDATE cc_card SET redial = '9' WHERE username='4887623847'
]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:3551 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '9' WHERE username='4887623847']:[result: 1]]
[05/05/2013 17:08:53]:[file:Class.RateEngine.php - line:98 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CC_asterisk_rate-engine: (1, 9)]]
[05/05/2013 17:08:53]:[file:Class.RateEngine.php - line:120 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CC_asterisk_rate-engine - CALLERID : 4887623847]]
[05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.0013830661773682 - QUERY=
SELECT
tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname,
destination, cc_ratecard.id, dialprefix, destination, buyrate,
buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea,
billingblocka, stepchargeb, chargeb,timechargeb, billingblockb,
stepchargec, chargec, timechargec, billingblockc,cc_tariffplan.id_trunk AS tp_id_trunk,
tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,cc_ratecard.id_trunk AS rc_id_trunk,
rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix, musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk, rt_trunk.failover_trunk AS rt_failover_trunk,tp_trunk.addparameter AS tp_addparameter_trunk, rt_trunk.addparameter AS rt_addparameter_trunk, id_outbound_cidgroup,
id_cc_package_offer, tp_trunk.status, rt_trunk.status, tp_trunk.inuse, rt_trunk.inuse,
tp_trunk.maxuse, rt_trunk.maxuse,tp_trunk.if_max_use, rt_trunk.if_max_use,cc_ratecard.rounding_calltime AS rounding_calltime,
cc_ratecard.rounding_threshold AS rounding_threshold, cc_ratecard.additional_block_charge AS additional_block_charge, cc_ratecard.additional_block_charge_time AS additional_block_charge_time,
cc_ratecard.additional_grace AS additional_grace, cc_ratecard.minimal_cost AS minimal_cost,disconnectcharge_after,announce_time_correction

FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk

WHERE cc_tariffgroup.id=1 AND ((dialprefix='9' OR dialprefix='defaultprefix') OR (dialprefix LIKE '&_%' ESCAPE '&' AND '9' REGEXP REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CONCAT('^', dialprefix, '$'), 'X', '[0-9]'), 'Z', '[1-9]'), 'N', '[2-9]'), '.', '.+'), '_', '')))
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL)
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL)
AND (starttime <= 9668 AND endtime >=9668)
AND idtariffgroup='1'
AND ( dnidprefix=SUBSTRING('555',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = (SELECT COUNT(dnidprefix) FROM cc_tariffgroup_plan RIGHT JOIN cc_tariffplan ON cc_tariffgroup_plan.idtariffplan=cc_tariffplan.id WHERE dnidprefix=SUBSTRING('555',1,length(dnidprefix)) AND idtariffgroup=1 ) ))
AND ( calleridprefix=SUBSTRING('4887623847',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = (SELECT count(calleridprefix) FROM cc_tariffgroup_plan RIGHT JOIN cc_tariffplan ON cc_tariffgroup_plan.idtariffplan=cc_tariffplan.id WHERE calleridprefix=SUBSTRING('4887623847',1,length(calleridprefix)) AND idtariffgroup=1 )))
ORDER BY LENGTH(dialprefix) DESC
]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:1017 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ERROR ::> RateEngine didnt succeed to match the dialed number over the ratecard (Please check : id the ratecard is well create ; if the removeInter_Prefix is set according to your prefix in the ratecard ; if you hooked the ratecard to the Call Plan)]
[05/05/2013 17:08:53]:[file:a2billing.php - line:572 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ANSWER fct callingcard_ivr authorize:> -1]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:750 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CARD STATUS UPDATE]]
[05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00035905838012695 - QUERY=
UPDATE cc_card SET inuse=inuse-1, credit=credit+0.25 WHERE username='4887623847'
]
[05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:759 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse=inuse-1, credit=credit+0.25 WHERE username='4887623847']]
[05/05/2013 17:08:53]:[CallerID:4887623847]:[CN:4887623847]:[[exit]]

Author:  matrix1233 [ Sun May 05, 2013 10:42 pm ]
Post subject:  Re: OUTBOUND CALLING !! hellp

hello,
Solved, the problem is the expiration date

thx

Author:  lisaa [ Fri Nov 21, 2014 11:09 am ]
Post subject:  Re: OUTBOUND CALLING !! hellp

Thank for sharing

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/