Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Apr 23, 2024 6:07 pm
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 12 posts ] 
Author Message
 Post subject: Unable to make successfull call
PostPosted: Wed Oct 30, 2013 11:12 pm 
Offline

Joined: Wed Oct 30, 2013 10:00 pm
Posts: 6
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-v2

Now 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!


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Thu Oct 31, 2013 7:13 am 
Offline

Joined: Wed Aug 31, 2011 1:54 pm
Posts: 33
Hello,

you tell="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"

you are need to do your call with ask pin ??

regards


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Thu Oct 31, 2013 9:36 am 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
Do you have a limit of the number of calls on a trunk. Looks like it's hitting that limit -

Failover trunk cannot be used because maximum number of connections on this trunk is already reached


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Thu Oct 31, 2013 10:09 am 
Offline

Joined: Wed Oct 30, 2013 10:00 pm
Posts: 6
Thank you both for your answers.

Here is an update, while I was awaiting your responses:
- I noticed the failover message in the logs and did some changes
- I changed the Trunk settings in a2billing. Specifically I had A2B set as Provider IP in a2billing. I decided to change it to a different value. First I tried with the static IP of the server, then with 127.0.0.1. Both cases it now produces different type of error:
Quote:
WARNING,"Rejecting unknown SIP connection from 127.0.0.1""

Received incoming SIP connection from unknown peer to 00359877088360


I then went to FreePBX and changed the "Asterisk SIP Settings" to "Allow Anonymous Inbound SIP Calls". After making another call, it produced the following:
Quote:
Received incoming SIP connection from unknown peer to 00359877088360

And during a call it says "The number it has dialed, is not in service."

Its definitely a progress, but still I am not able to make a successful call.


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Thu Oct 31, 2013 10:16 am 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
Not too sure what you're trying to do by changing the trunk IP to 127.0.0.1?

The IP should be the IP of your call provider. This assumes you call provider is set up to allow IP authentication?

I would not recommend setting allow anonymous SIP to YES.

Did you check what MAXUSE was set to on the trunk. -1 means no limit. I would suggest leaving at this whilst testing.


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Thu Oct 31, 2013 10:33 am 
Offline

Joined: Wed Oct 30, 2013 10:00 pm
Posts: 6
bucasia wrote:
Not too sure what you're trying to do by changing the trunk IP to 127.0.0.1?

The IP should be the IP of your call provider. This assumes you call provider is set up to allow IP authentication?

I would not recommend setting allow anonymous SIP to YES.

Did you check what MAXUSE was set to on the trunk. -1 means no limit. I would suggest leaving at this whilst testing.


I am using my own PSTN line, not an external SIP provider. That's why I don't know what to put as Provider IP and tried with the local address.

The anonymous SIP was set to yes, just for the purpose of this test. It proved that the request is no more rejected. If it is no, the request is rejected as said in my previous response.

I changed the MAXUSE of the trunk to -1 and it no longer produces the error that the system will use the failover trunk.

Can you please advise what IP should use as Provider IP in my case where I want to use my own PSTN line?
Additionally here is the configuration of /etc/asterisk/manager_custom.conf
Quote:
[phpconfig]
secret = php[onfig
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
read = system,call,log,verbose,command,agent,user
write = system,call,log,verbose,command,agent,user

[phpagi]
secret = phpagi
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
read = system,call,log,verbose,command,agent,user
write = system,call,log,verbose,command,agent,user

[myasterisk]
secret=mycode
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
read=system,call,log,verbose,command,agent,user
write=system,call,log,verbose,command,agent,user


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Thu Oct 31, 2013 10:44 am 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
How is your PSTN line configured in Asterisk? Is it plugged in to an FXO card directly in to the PC?

If so that's not a SIP trunk.


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Thu Oct 31, 2013 10:51 am 
Offline

Joined: Wed Oct 30, 2013 10:00 pm
Posts: 6
bucasia wrote:
How is your PSTN line configured in Asterisk? Is it plugged in to an FXO card directly in to the PC?

If so that's not a SIP trunk.


Yes, it is plugged in an FXO card. I didn't know this is not a SIP.
Can you please let me what would be a proper configuration? Maybe it would be more optimal if I grant you access to the server so that you can quickly see what went wrong. I am ready to pay if you would like me to and since most of it is configured, I suppose it wont take too long.


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Thu Oct 31, 2013 1:56 pm 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
I'm not currently doing any admin work but if you're looking for paid support you should check with star2billing - http://www.star2billing.com/consultancy/


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Thu Oct 31, 2013 5:47 pm 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

I tend to ignore posts with long pastes of logs, they are difficult to read when you are in a hurry, compared to seeing them in say pastebin.

However, in respect of how your card should be configured in A2Billing, it's simply, techtype = DAHDI, and the IP will either be the group number, e.g. G1 or g1, or the channel number, e.g. 1

Joe


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Fri Nov 01, 2013 12:03 pm 
Offline

Joined: Wed Oct 30, 2013 10:00 pm
Posts: 6
Hi,

Thanks for all the responses till now. I apologies for the long log, but as I said, I am very new to this and wasn't aware how disturbing it is to go through such information. I am now getting more info each day, based on my experience, so with confidence I can conclude the following:

1. You can ignore the above case. It was caused by not properly set maximum connections per trunk. Even after I resolved it, the system still wasn't able to make a proper call.
2. If I am not wrong, after reading a log about this, my assumption is that as you suggested, the whole problem is the trunk which is not set up in A2Billing. Initially, when I installed FreePBX and the Trunk was recognized and worked like a charm with a test call from an extension created in FreePBX, I thought there is no need to create a trunk in A2Billing, as it is already existing in FreePBX. However, now I understand that I have to set up the trunk in A2Billing as well.
The problem here is however, that I am not sure what exactly I should put. Obviously, I am trying to set up a PSTN line as trunk. It was straight forward in FreePBX, but here I am not sure. Thanks for the instructions jroper, but they doesn't mean a lot for me (based on my knowledge currently).

I would really appreciate, if someone have 5 mins to explain to me as a newb how exactly I should set the trunks in order to have working PSTN line in A2Billing. As far as I understand, I should set it up in Providers > Trunks. A few questions regarding that:
- Should I set a provider beforehand?
- In Provider Tech, I don't see DAHDI. Does that mean I should not use it, or it simply means it is not included in the example, but can be used?
- As a Provider IP, let's say that the FXO port which is active in my card is 1, what should I put there? Just 1?

Thanks again for all that participated.


Top
 Profile  
 
 Post subject: Re: Unable to make successfull call
PostPosted: Fri Nov 01, 2013 12:26 pm 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

Type DAHDI into the Provider Tech field.

Type the channel number or Channel Group into the Provider IP field.

Joe


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 39 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