Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Wed Dec 12, 2018 4:05 am
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: OUTBOUND CALLING !! hellp
PostPosted: Sun May 05, 2013 12:36 am 
Offline

Joined: Sun May 05, 2013 12:25 am
Posts: 3
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


Top
 Profile  
 
 Post subject: Re: OUTBOUND CALLING !! hellp
PostPosted: Sun May 05, 2013 3:12 pm 
Offline

Joined: Sun May 05, 2013 12:25 am
Posts: 3
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]]


Top
 Profile  
 
 Post subject: Re: OUTBOUND CALLING !! hellp
PostPosted: Sun May 05, 2013 10:42 pm 
Offline

Joined: Sun May 05, 2013 12:25 am
Posts: 3
hello,
Solved, the problem is the expiration date

thx


Top
 Profile  
 
 Post subject: Re: OUTBOUND CALLING !! hellp
PostPosted: Fri Nov 21, 2014 11:09 am 
Offline

Joined: Fri Nov 21, 2014 11:07 am
Posts: 2
Thank for sharing


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 
Auto Dialer Software


All times are UTC


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group