Hi,
I am pretty new here, so apologies if some questions might seem newbish to you.
First of all, here is my setup:
PIAF(PBX in a Flash) 2.0.6.4.5 - 32bit
A2Billing - 2.0.6
Asterisk 11
FreePBX 2.11.0.11
The target is to make successful calls through PSTN line in my home lab. I have installed PIAF and after the initial setup, I was able to make a successful call with an extension created. Then I installed a2billing using the following method:
http://www.powerpbx.org/content/a2billi ... l-guide-v2Now I am able to create a user, make a call, the system is telling me the current balance, then asking me to input the number which I am trying to call. When I do, it tells me the available minutes and instead of making the call, it start over by telling me my balance and asking me to put the number which I want to call and everything repeats. I tried with a wrong prefix and then it tells me that the "number is unavailable" or something. So definetely the prefix is set up properly. Just dont know why it doesn't make the call.
I checked the logs from asterisk console and here is what I get:
Quote:
[2013-10-31 00:53:28] WARNING[7636][C-0000000a]: sip/config_parser.c:812 sip_par se_nat_option: nat=yes is deprecated, use nat=force_rport,comedia instead
[2013-10-31 00:53:28] WARNING[7636][C-0000000a]: chan_sip.c:30629 build_peer: no value given for outbound proxy on line 0 of sip.conf
[2013-10-31 00:53:28] WARNING[7636][C-0000000a]: sip/config_parser.c:812 sip_par se_nat_option: nat=yes is deprecated, use nat=force_rport,comedia instead
[2013-10-31 00:53:28] WARNING[7636][C-0000000a]: chan_sip.c:30629 build_peer: no value given for outbound proxy on line 0 of sip.conf
== Using SIP RTP TOS bits 184
== Using SIP RTP CoS mark 5
-- Executing [00359883305309@a2billing:1] Answer("SIP/6822465790-0000000a", "") in new stack
-- Executing [00359883305309@a2billing:2] Wait("SIP/6822465790-0000000a", "1 ") in new stack
-- Executing [00359883305309@a2billing:3] AGI("SIP/6822465790-0000000a", "a2 billing.php,1") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/a2billing.php
-- Playing 'prepaid-you-have' (escape_digits=#) (sample_offset 0)
-- <SIP/6822465790-0000000a> Playing 'digits/1.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/hundred.gsm' (language 'en')
-- Playing 'credit' (escape_digits=#) (sample_offset 0)
-- Playing 'prepaid-you-have' (escape_digits=#) (sample_offset 0)
-- <SIP/6822465790-0000000a> Playing 'digits/1.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/thousand.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/4.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/hundred.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/20.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/7.gsm' (language 'en')
-- Playing 'prepaid-minutes' (escape_digits=#) (sample_offset 0)
-- Playing 'vm-and' (escape_digits=#) (sample_offset 0)
-- <SIP/6822465790-0000000a> Playing 'digits/50.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/1.gsm' (language 'en')
-- Playing 'prepaid-seconds' (escape_digits=#) (sample_offset 0)
-- <SIP/6822465790-0000000a> Playing 'prepaid-enter-dest.gsm' (language 'en' )
-- Playing 'prepaid-you-have' (escape_digits=#) (sample_offset 0)
-- <SIP/6822465790-0000000a> Playing 'digits/1.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/thousand.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/4.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/hundred.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/20.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/7.gsm' (language 'en')
-- Playing 'prepaid-minutes' (escape_digits=#) (sample_offset 0)
-- Playing 'vm-and' (escape_digits=#) (sample_offset 0)
-- <SIP/6822465790-0000000a> Playing 'digits/50.gsm' (language 'en')
-- <SIP/6822465790-0000000a> Playing 'digits/1.gsm' (language 'en')
-- Playing 'prepaid-seconds' (escape_digits=#) (sample_offset 0)
Here are the logs from a2billing as well with level4 logging enabled:
Quote:
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:598 - uniqueid:]:[CallerID:]:[CN:]:[A2Billing AGI internal configuration:]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:599 - uniqueid:]:[CallerID:]:[CN:]:[Array
(
[dialcommand_param_call_2did] => |60|HiL(%timeout%:61000:30000)
[description] => agi-config
[asterisk_version] => 1_11
[answer_call] => 1
[play_audio] => 1
[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] => 0
[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
[currency_cents_association] => Array
(
[0] => usd:prepaid-cents
[1] => eur:prepaid-cents
[2] => gbp:prepaid-pence
[3] => all:credit
)
[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
[lcr_mode] => 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
)
[currency_cents_association_internal] => Array
(
[usd] => prepaid-cents
[eur] => prepaid-cents
[gbp] => prepaid-pence
[all] => credit
)
[file_conf_enter_menulang] => prepaid-menulang
[ivr_voucher_prefixe] => 8
[cheat_on_announcement_time] => 0
)
]
[30/10/2013 22:53:29]:[file:a2billing.php - line:117 - uniqueid:]:[CallerID:]:[CN:]:[IDCONFIG : 1]
[30/10/2013 22:53:29]:[file:a2billing.php - line:118 - uniqueid:]:[CallerID:]:[CN:]:[MODE : standard]
[30/10/2013 22:53:29]:[file:a2billing.php - line:130 - uniqueid:]:[CallerID:]:[CN:]:[AGI Request:
Array
(
[agi_request] => a2billing.php
[agi_channel] => SIP/6822465790-0000000a
[agi_language] => en
[agi_type] => SIP
[agi_uniqueid] => 1383173608.10
[agi_version] => 11.6.0
[agi_callerid] => 6822465790
[agi_calleridname] => unknown
[agi_callingpres] => 0
[agi_callingani2] => 0
[agi_callington] => 0
[agi_callingtns] => 0
[agi_dnid] => 00359883305309
[agi_rdnis] => unknown
[agi_context] => a2billing
[agi_extension] => 00359883305309
[agi_priority] => 3
[agi_enhanced] => 0.0
[agi_accountcode] => 6822465790
[agi_threadid] => -1251701904
[agi_arg_1] => 1
)
]
[30/10/2013 22:53:29]:[file:a2billing.php - line:131 - uniqueid:]:[CallerID:]:[CN:]:[[INFO : A2Billing - v2.0.6]]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:712 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:]:[ get_agi_request_parameter = 6822465790 ; SIP/6822465790-0000000a ; 1383173608.10 ; 6822465790 ; 00359883305309]
[30/10/2013 22:53:29]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:]:[Running time=0.00059795379638672 - QUERY=
SELECT id, currency, name, value FROM cc_currencies ORDER BY id
]
[30/10/2013 22:53:29]:[file:a2billing.php - line:165 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:]:[[ANSWER CALL]]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:2862 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:]:[ - Account code ::> 6822465790]
[30/10/2013 22:53:29]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[Running time=0.00066685676574707 - 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 = '6822465790'
]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:2879 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[ - 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 = '6822465790']
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:2948 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[SET CHANNEL(language) en]]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:2952 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[credit=100.00000 :: tariff=2 :: status=1 :: isused=0 :: simultaccess=1 :: typepaid=0 :: creditlimit= :: language=en]]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:744 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[CARD STATUS UPDATE]]
[30/10/2013 22:53:29]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[Running time=0.00027799606323242 - QUERY=
UPDATE cc_card SET inuse = inuse + 1, credit = credit - 0.25 WHERE username = '6822465790'
]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:753 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse = inuse + 1, credit = credit - 0.25 WHERE username = '6822465790']]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:3241 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[A2Billing] SAY BALANCE : 100.00000
]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:2034 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[CURRENCY : BGN]]
[30/10/2013 22:53:29]:[file:Class.A2Billing.php - line:2044 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[BEFORE: 100 SPRINTF : 100.00]]
[30/10/2013 22:53:32]:[file:a2billing.php - line:181 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[TRY : callingcard_ivr_authenticate]]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:2519 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[AUTO SetCallerID]]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:2528 - uniqueid:1383173608.10]:[CallerID:6822465790]:[CN:6822465790]:[[Overwrite callerID security : 6822465790]]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:2549 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[EXEC SetCallerID : unknown]]
[30/10/2013 22:53:32]:[file:a2billing.php - line:194 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CHANNEL STATUS : 6 = Line is up]
[CREDIT : 100.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[30/10/2013 22:53:32]:[file:a2billing.php - line:382 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[TARIFF ID->2]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:803 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[use_dnid:1 && (!in_array:) && len_dnid:(14 || len_exten:14 ) && (try_num:0)]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:812 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[USE_DNID DESTINATION ::> 00359883305309]]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:878 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CALL 2 DID]]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:887 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[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 = '00359883305309' 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')]
[30/10/2013 22:53:32]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[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 = '00359883305309' 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')
]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:893 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[DESTINATION ::> 00359883305309]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:900 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[RULES APPLY ON DESTINATION ::> 359883305309]
[30/10/2013 22:53:32]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00027704238891602 - QUERY=
UPDATE cc_card SET redial = '359883305309' WHERE username = '6822465790'
]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:3703 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '359883305309' WHERE username = '6822465790']:[result: 1]]
[30/10/2013 22:53:32]:[file:Class.RateEngine.php - line:97 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine: (2, 359883305309)]]
[30/10/2013 22:53:32]:[file:Class.RateEngine.php - line:118 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine - CALLERID : unknown]]
[30/10/2013 22:53:32]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.0013229846954346 - 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 = 2 AND ((dialprefix='359883305309' OR dialprefix='35988330530' OR dialprefix='3598833053' OR dialprefix='359883305' OR dialprefix='35988330' OR dialprefix='3598833' OR dialprefix='359883' OR dialprefix='35988' OR dialprefix='3598' OR dialprefix='359' OR dialprefix='35' OR dialprefix='3' OR dialprefix='defaultprefix') OR (dialprefix LIKE '&_%' ESCAPE '&' AND '359883305309' 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 <= 4253 AND endtime >=4253)
AND idtariffgroup = '2'
AND (dnidprefix = SUBSTRING('00359883305309', 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('00359883305309', 1, length(dnidprefix)) AND idtariffgroup = 2) ))
AND (calleridprefix = SUBSTRING('unknown', 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('unknown', 1, length(calleridprefix)) AND idtariffgroup = 2)))
ORDER BY LENGTH(dialprefix) DESC
]
[30/10/2013 22:53:32]:[file:Class.RateEngine.php - line:179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[rate-engine: Count Total result 1]]
[30/10/2013 22:53:32]:[file:Class.RateEngine.php - line:344 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine: Count Total result 1]]
[30/10/2013 22:53:32]:[file:Class.RateEngine.php - line:345 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine: number_trunk 1]]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:1017 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[OK - RESFINDRATE::> 1]
[30/10/2013 22:53:32]:[file:Class.RateEngine.php - line:358 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (100.00000)]]
[30/10/2013 22:53:32]:[file:Class.RateEngine.php - line:364 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:85671]]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:1030 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[RES_ALL_CALCULTIMEOUT ::> 1]
[30/10/2013 22:53:32]:[file:Class.A2Billing.php - line:1963 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[TIMEOUT::> 85671 : minutes=1427 - seconds=51]
[30/10/2013 22:53:42]:[file:a2billing.php - line:560 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[ANSWER fct callingcard_ivr authorize:> 1]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1312 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[app_callingcard: Dialing 'SIP/A2B/00359883305309|60|HRrL(36000000:61000:30000)' with timeout of '85671'.
]
[30/10/2013 22:53:42]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00024914741516113 - QUERY=
SELECT cid FROM cc_outbound_cid_list WHERE activated = 1 AND outbound_cid_group = -1 ORDER BY RAND() LIMIT 1
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1332 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1353 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[This trunk cannot be used because maximum number of connections is reached. Now use failover trunk
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1377 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[K=0]:[ANSWEREDTIME=0-DIALSTATUS=]]
[30/10/2013 22:53:42]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00016212463378906 - QUERY=
SELECT trunkprefix, providertech, providerip, removeprefix, failover_trunk, status, inuse, maxuse, if_max_use FROM cc_trunk WHERE id_trunk = '2'
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1412 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Failover trunk cannot be used because maximum number of connections on this trunk is already reached.
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1416 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Now using its failover trunk
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1377 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[K=0]:[ANSWEREDTIME=0-DIALSTATUS=]]
[30/10/2013 22:53:42]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00018787384033203 - QUERY=
SELECT trunkprefix, providertech, providerip, removeprefix, failover_trunk, status, inuse, maxuse, if_max_use FROM cc_trunk WHERE id_trunk = '2'
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1412 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Failover trunk cannot be used because maximum number of connections on this trunk is already reached.
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1416 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Now using its failover trunk
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1377 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[K=0]:[ANSWEREDTIME=0-DIALSTATUS=]]
[30/10/2013 22:53:42]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00017595291137695 - QUERY=
SELECT trunkprefix, providertech, providerip, removeprefix, failover_trunk, status, inuse, maxuse, if_max_use FROM cc_trunk WHERE id_trunk = '2'
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1412 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Failover trunk cannot be used because maximum number of connections on this trunk is already reached.
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1416 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Now using its failover trunk
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1497 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[USEDRATECARD=0]]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1038 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[:[sessiontime:0 - id_cc_package_offer:-1 - package2apply:]
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1114 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[30/10/2013 22:53:42]:[file:Class.Table.php - line:179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00025701522827148 - QUERY=
INSERT INTO cc_call (uniqueid, sessionid, card_id, nasipaddress, starttime, sessiontime, real_sessiontime, calledstation, terminatecauseid, stoptime, sessionbill, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buycost, id_card_package_offer, dnid, destination) VALUES ('1383173608.10', 'SIP/6822465790-0000000a', '3', '', SUBDATE(CURRENT_TIMESTAMP, INTERVAL 0 SECOND) , '0', '0', '359883305309', 0, now() , '-0', '2', '2', '3', '2', 'unknown', '0', '0', NULL, '00359883305309', '35988')
]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1179 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_stop : SQL: DONE : result=1]]
[30/10/2013 22:53:42]:[file:Class.RateEngine.php - line:1180 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_stop : SQL: INSERT INTO cc_call (uniqueid, sessionid, card_id, nasipaddress, starttime, sessiontime, real_sessiontime, calledstation, terminatecauseid, stoptime, sessionbill, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buycost, id_card_package_offer, dnid, destination) VALUES ('1383173608.10', 'SIP/6822465790-0000000a', '3', '', SUBDATE(CURRENT_TIMESTAMP, INTERVAL 0 SECOND) , '0', '0', '359883305309', 0, now() , '-0', '2', '2', '3', '2', 'unknown', '0', '0', NULL, '00359883305309', '35988')]]
[30/10/2013 22:53:42]:[file:a2billing.php - line:576 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[a2billing account stop]]
[30/10/2013 22:53:42]:[file:a2billing.php - line:194 - uniqueid:1383173608.10]:[CallerID:unknown]:[CN:6822465790]:[[CHANNEL STATUS : 6 = Line is up]
[CREDIT : 100.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[30/10/2013 22:53:42]:[file:a2billing.php - line:382 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[TARIFF ID->2]
[30/10/2013 22:53:42]:[file:Class.A2Billing.php - line:803 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[use_dnid:0 && (!in_array:) && len_dnid:(14 || len_exten:14 ) && (try_num:1)]
[30/10/2013 22:53:51]:[file:Class.A2Billing.php - line:820 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[RES DTMF : 00359877088360]
[30/10/2013 22:53:51]:[file:Class.A2Billing.php - line:878 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CALL 2 DID]]
[30/10/2013 22:53:51]:[file:Class.A2Billing.php - line:887 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[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 = '00359877088360' 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')]
[30/10/2013 22:53:51]:[file:Class.Table.php - line:179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00031304359436035 - 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 = '00359877088360' 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')
]
[30/10/2013 22:53:51]:[file:Class.A2Billing.php - line:893 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[DESTINATION ::> 00359877088360]
[30/10/2013 22:53:51]:[file:Class.A2Billing.php - line:900 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[RULES APPLY ON DESTINATION ::> 359877088360]
[30/10/2013 22:53:51]:[file:Class.Table.php - line:179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00022292137145996 - QUERY=
UPDATE cc_card SET redial = '359877088360' WHERE username = '6822465790'
]
[30/10/2013 22:53:51]:[file:Class.A2Billing.php - line:3703 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '359877088360' WHERE username = '6822465790']:[result: 1]]
[30/10/2013 22:53:51]:[file:Class.RateEngine.php - line:97 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine: (2, 359877088360)]]
[30/10/2013 22:53:51]:[file:Class.RateEngine.php - line:118 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine - CALLERID : unknown]]
[30/10/2013 22:53:51]:[file:Class.Table.php - line:179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.0012750625610352 - 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 = 2 AND ((dialprefix='359877088360' OR dialprefix='35987708835' OR dialprefix='3598770883' OR dialprefix='359877088' OR dialprefix='35987708' OR dialprefix='3598770' OR dialprefix='359877' OR dialprefix='35987' OR dialprefix='3598' OR dialprefix='359' OR dialprefix='35' OR dialprefix='3' OR dialprefix='defaultprefix') OR (dialprefix LIKE '&_%' ESCAPE '&' AND '359877088360' 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 <= 4253 AND endtime >=4253)
AND idtariffgroup = '2'
AND (dnidprefix = SUBSTRING('00359883305309', 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('00359883305309', 1, length(dnidprefix)) AND idtariffgroup = 2) ))
AND (calleridprefix = SUBSTRING('unknown', 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('unknown', 1, length(calleridprefix)) AND idtariffgroup = 2)))
ORDER BY LENGTH(dialprefix) DESC
]
[30/10/2013 22:53:51]:[file:Class.RateEngine.php - line:179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[rate-engine: Count Total result 1]]
[30/10/2013 22:53:51]:[file:Class.RateEngine.php - line:344 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine: Count Total result 1]]
[30/10/2013 22:53:51]:[file:Class.RateEngine.php - line:345 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine: number_trunk 1]]
[30/10/2013 22:53:51]:[file:Class.A2Billing.php - line:1017 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[OK - RESFINDRATE::> 1]
[30/10/2013 22:53:51]:[file:Class.RateEngine.php - line:358 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (100.00000)]]
[30/10/2013 22:53:51]:[file:Class.RateEngine.php - line:364 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:85671]]
[30/10/2013 22:53:51]:[file:Class.A2Billing.php - line:1030 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[RES_ALL_CALCULTIMEOUT ::> 1]
[30/10/2013 22:53:51]:[file:Class.A2Billing.php - line:1963 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[TIMEOUT::> 85671 : minutes=1427 - seconds=51]
[30/10/2013 22:54:00]:[file:a2billing.php - line:560 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[ANSWER fct callingcard_ivr authorize:> 1]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1312 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[app_callingcard: Dialing 'SIP/A2B/00359877088360|60|HRrL(36000000:61000:30000)' with timeout of '85671'.
]
[30/10/2013 22:54:00]:[file:Class.Table.php - line:179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00021100044250488 - QUERY=
SELECT cid FROM cc_outbound_cid_list WHERE activated = 1 AND outbound_cid_group = -1 ORDER BY RAND() LIMIT 1
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1332 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1353 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[This trunk cannot be used because maximum number of connections is reached. Now use failover trunk
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1377 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[K=0]:[ANSWEREDTIME=0-DIALSTATUS=]]
[30/10/2013 22:54:00]:[file:Class.Table.php - line:179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00015687942504883 - QUERY=
SELECT trunkprefix, providertech, providerip, removeprefix, failover_trunk, status, inuse, maxuse, if_max_use FROM cc_trunk WHERE id_trunk = '2'
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1412 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Failover trunk cannot be used because maximum number of connections on this trunk is already reached.
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1416 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Now using its failover trunk
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1377 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[K=0]:[ANSWEREDTIME=0-DIALSTATUS=]]
[30/10/2013 22:54:00]:[file:Class.Table.php - line:179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00017404556274414 - QUERY=
SELECT trunkprefix, providertech, providerip, removeprefix, failover_trunk, status, inuse, maxuse, if_max_use FROM cc_trunk WHERE id_trunk = '2'
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1412 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Failover trunk cannot be used because maximum number of connections on this trunk is already reached.
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1416 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Now using its failover trunk
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1377 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[K=0]:[ANSWEREDTIME=0-DIALSTATUS=]]
[30/10/2013 22:54:00]:[file:Class.Table.php - line:179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00016689300537109 - QUERY=
SELECT trunkprefix, providertech, providerip, removeprefix, failover_trunk, status, inuse, maxuse, if_max_use FROM cc_trunk WHERE id_trunk = '2'
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1412 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Failover trunk cannot be used because maximum number of connections on this trunk is already reached.
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1416 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Now using its failover trunk
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1497 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[USEDRATECARD=0]]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1038 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[:[sessiontime:0 - id_cc_package_offer:-1 - package2apply:]
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1114 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[30/10/2013 22:54:00]:[file:Class.Table.php - line:179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00026679039001465 - QUERY=
INSERT INTO cc_call (uniqueid, sessionid, card_id, nasipaddress, starttime, sessiontime, real_sessiontime, calledstation, terminatecauseid, stoptime, sessionbill, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buycost, id_card_package_offer, dnid, destination) VALUES ('2383173608.1', 'SIP/6822465790-0000000a', '3', '', SUBDATE(CURRENT_TIMESTAMP, INTERVAL 0 SECOND) , '0', '0', '359877088360', 0, now() , '-0', '2', '2', '3', '2', 'unknown', '0', '0', NULL, '00359883305309', '35988')
]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1179 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_stop : SQL: DONE : result=1]]
[30/10/2013 22:54:00]:[file:Class.RateEngine.php - line:1180 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_stop : SQL: INSERT INTO cc_call (uniqueid, sessionid, card_id, nasipaddress, starttime, sessiontime, real_sessiontime, calledstation, terminatecauseid, stoptime, sessionbill, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buycost, id_card_package_offer, dnid, destination) VALUES ('2383173608.1', 'SIP/6822465790-0000000a', '3', '', SUBDATE(CURRENT_TIMESTAMP, INTERVAL 0 SECOND) , '0', '0', '359877088360', 0, now() , '-0', '2', '2', '3', '2', 'unknown', '0', '0', NULL, '00359883305309', '35988')]]
[30/10/2013 22:54:00]:[file:a2billing.php - line:576 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[a2billing account stop]]
[30/10/2013 22:54:00]:[file:a2billing.php - line:194 - uniqueid:2383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CHANNEL STATUS : 6 = Line is up]
[CREDIT : 100.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[30/10/2013 22:54:00]:[file:a2billing.php - line:382 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[TARIFF ID->2]
[30/10/2013 22:54:00]:[file:Class.A2Billing.php - line:803 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[use_dnid:0 && (!in_array:) && len_dnid:(14 || len_exten:14 ) && (try_num:2)]
[30/10/2013 22:54:11]:[file:Class.A2Billing.php - line:820 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[RES DTMF : 359877088360]
[30/10/2013 22:54:11]:[file:Class.A2Billing.php - line:878 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CALL 2 DID]]
[30/10/2013 22:54:11]:[file:Class.A2Billing.php - line:887 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[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 = '359877088360' 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')]
[30/10/2013 22:54:11]:[file:Class.Table.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00028896331787109 - 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 = '359877088360' 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')
]
[30/10/2013 22:54:11]:[file:Class.A2Billing.php - line:893 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[DESTINATION ::> 359877088360]
[30/10/2013 22:54:11]:[file:Class.A2Billing.php - line:900 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[RULES APPLY ON DESTINATION ::> 359877088360]
[30/10/2013 22:54:11]:[file:Class.Table.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00019311904907227 - QUERY=
UPDATE cc_card SET redial = '359877088360' WHERE username = '6822465790'
]
[30/10/2013 22:54:11]:[file:Class.A2Billing.php - line:3703 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '359877088360' WHERE username = '6822465790']:[result: 1]]
[30/10/2013 22:54:11]:[file:Class.RateEngine.php - line:97 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine: (2, 359877088360)]]
[30/10/2013 22:54:11]:[file:Class.RateEngine.php - line:118 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine - CALLERID : unknown]]
[30/10/2013 22:54:11]:[file:Class.Table.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.0013070106506348 - 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 = 2 AND ((dialprefix='359877088360' OR dialprefix='35987708835' OR dialprefix='3598770883' OR dialprefix='359877088' OR dialprefix='35987708' OR dialprefix='3598770' OR dialprefix='359877' OR dialprefix='35987' OR dialprefix='3598' OR dialprefix='359' OR dialprefix='35' OR dialprefix='3' OR dialprefix='defaultprefix') OR (dialprefix LIKE '&_%' ESCAPE '&' AND '359877088360' 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 <= 4254 AND endtime >=4254)
AND idtariffgroup = '2'
AND (dnidprefix = SUBSTRING('00359883305309', 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('00359883305309', 1, length(dnidprefix)) AND idtariffgroup = 2) ))
AND (calleridprefix = SUBSTRING('unknown', 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('unknown', 1, length(calleridprefix)) AND idtariffgroup = 2)))
ORDER BY LENGTH(dialprefix) DESC
]
[30/10/2013 22:54:11]:[file:Class.RateEngine.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[rate-engine: Count Total result 1]]
[30/10/2013 22:54:11]:[file:Class.RateEngine.php - line:344 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine: Count Total result 1]]
[30/10/2013 22:54:11]:[file:Class.RateEngine.php - line:345 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_rate-engine: number_trunk 1]]
[30/10/2013 22:54:11]:[file:Class.A2Billing.php - line:1017 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[OK - RESFINDRATE::> 1]
[30/10/2013 22:54:11]:[file:Class.RateEngine.php - line:358 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (100.00000)]]
[30/10/2013 22:54:11]:[file:Class.RateEngine.php - line:364 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:85671]]
[30/10/2013 22:54:11]:[file:Class.A2Billing.php - line:1030 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[RES_ALL_CALCULTIMEOUT ::> 1]
[30/10/2013 22:54:11]:[file:Class.A2Billing.php - line:1963 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[TIMEOUT::> 85671 : minutes=1427 - seconds=51]
[30/10/2013 22:54:21]:[file:a2billing.php - line:560 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[ANSWER fct callingcard_ivr authorize:> 1]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1312 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[app_callingcard: Dialing 'SIP/A2B/00359877088360|60|HRrL(36000000:61000:30000)' with timeout of '85671'.
]
[30/10/2013 22:54:21]:[file:Class.Table.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00019192695617676 - QUERY=
SELECT cid FROM cc_outbound_cid_list WHERE activated = 1 AND outbound_cid_group = -1 ORDER BY RAND() LIMIT 1
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1332 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1353 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[This trunk cannot be used because maximum number of connections is reached. Now use failover trunk
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1377 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[K=0]:[ANSWEREDTIME=0-DIALSTATUS=]]
[30/10/2013 22:54:21]:[file:Class.Table.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00015115737915039 - QUERY=
SELECT trunkprefix, providertech, providerip, removeprefix, failover_trunk, status, inuse, maxuse, if_max_use FROM cc_trunk WHERE id_trunk = '2'
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1412 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Failover trunk cannot be used because maximum number of connections on this trunk is already reached.
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1416 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Now using its failover trunk
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1377 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[K=0]:[ANSWEREDTIME=0-DIALSTATUS=]]
[30/10/2013 22:54:21]:[file:Class.Table.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00017499923706055 - QUERY=
SELECT trunkprefix, providertech, providerip, removeprefix, failover_trunk, status, inuse, maxuse, if_max_use FROM cc_trunk WHERE id_trunk = '2'
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1412 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Failover trunk cannot be used because maximum number of connections on this trunk is already reached.
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1416 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Now using its failover trunk
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1377 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[K=0]:[ANSWEREDTIME=0-DIALSTATUS=]]
[30/10/2013 22:54:21]:[file:Class.Table.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00018596649169922 - QUERY=
SELECT trunkprefix, providertech, providerip, removeprefix, failover_trunk, status, inuse, maxuse, if_max_use FROM cc_trunk WHERE id_trunk = '2'
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1412 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Failover trunk cannot be used because maximum number of connections on this trunk is already reached.
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1416 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Now using its failover trunk
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1497 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[USEDRATECARD=0]]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1038 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[:[sessiontime:0 - id_cc_package_offer:-1 - package2apply:]
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1114 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[30/10/2013 22:54:21]:[file:Class.Table.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00025486946105957 - QUERY=
INSERT INTO cc_call (uniqueid, sessionid, card_id, nasipaddress, starttime, sessiontime, real_sessiontime, calledstation, terminatecauseid, stoptime, sessionbill, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buycost, id_card_package_offer, dnid, destination) VALUES ('3383173608.1', 'SIP/6822465790-0000000a', '3', '', SUBDATE(CURRENT_TIMESTAMP, INTERVAL 0 SECOND) , '0', '0', '359877088360', 0, now() , '-0', '2', '2', '3', '2', 'unknown', '0', '0', NULL, '00359883305309', '35988')
]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_stop : SQL: DONE : result=1]]
[30/10/2013 22:54:21]:[file:Class.RateEngine.php - line:1180 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CC_asterisk_stop : SQL: INSERT INTO cc_call (uniqueid, sessionid, card_id, nasipaddress, starttime, sessiontime, real_sessiontime, calledstation, terminatecauseid, stoptime, sessionbill, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buycost, id_card_package_offer, dnid, destination) VALUES ('3383173608.1', 'SIP/6822465790-0000000a', '3', '', SUBDATE(CURRENT_TIMESTAMP, INTERVAL 0 SECOND) , '0', '0', '359877088360', 0, now() , '-0', '2', '2', '3', '2', 'unknown', '0', '0', NULL, '00359883305309', '35988')]]
[30/10/2013 22:54:21]:[file:a2billing.php - line:576 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[a2billing account stop]]
[30/10/2013 22:54:21]:[file:Class.A2Billing.php - line:246 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[HANGUP DETECTED!
]
[30/10/2013 22:54:21]:[file:Class.A2Billing.php - line:744 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[CARD STATUS UPDATE]]
[30/10/2013 22:54:21]:[file:Class.Table.php - line:179 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[Running time=0.00022506713867188 - QUERY=
UPDATE cc_card SET inuse = inuse - 1, credit = credit + 0.25 WHERE username = '6822465790'
]
[30/10/2013 22:54:21]:[file:Class.A2Billing.php - line:753 - uniqueid:3383173608.1]:[CallerID:unknown]:[CN:6822465790]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse = inuse - 1, credit = credit + 0.25 WHERE username = '6822465790']]
[30/10/2013 22:54:21]:[CallerID:unknown]:[CN:6822465790]:[[exit]]
Any help to what might be causing those problems and how to make the configuration to make a call, would be greatly appreciated.
On a side note, after the initial installation and the configuration of the extension in FreePBX, I was able to make a successful call. After the installation of a2billing, now the behaviour of calls tried by users made by a2billing is the above and when I try to make a call with the initial user which was working before setting up a2billing, does not work anymore. It asks for a PIN.
Awaiting your responses.
Thanks!