Hi,
I have trouble to make cid-callback work (SIP trunk for incoming and outgoing calls), I noticed that the SQL query is weird (prefix is the full number) and also that the AGI doesn't see it's a CID-callback (ALL-CALLBACK MODE), see below:
asterisk logs
Code:
Nov 7 15:22:38 VERBOSE[8203] logger.c: -- Executing Goto("SIP/XXX-1-6ef9", "custom-a2billing-cid-callback|s|1") in new stack
Nov 7 15:22:38 VERBOSE[8203] logger.c: -- Goto (custom-a2billing-cid-callback,s,1)
Nov 7 15:22:38 VERBOSE[8203] logger.c: -- Executing DeadAGI("SIP/XXX-1-6ef9", "a2billing.php|1|all-callback|514") in new stack
Nov 7 15:22:38 VERBOSE[8203] logger.c: -- Launched AGI Script /var/lib/asterisk/agi-bin/a2billing.php
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: line:58 - IDCONFIG : 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: line:67 - MODE : all-callback
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: A2Billing AGI internal configuration:
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: Array
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [debug] => 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [answer_call] => 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [logger_enable] => 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [log_file] => /tmp/a2billing.log
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_goodbye] =>
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [play_menulanguage] => 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [force_language] => EN
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [intro_prompt] =>
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [len_cardnumber] => 10
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [len_aliasnumber] => 15
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [len_voucher] => 15
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [min_credit_2call] => 0
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [min_duration_2bill] => 2
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [notenoughcredit_cardnumber] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [notenoughcredit_assign_newcardnumber_cid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [use_dnid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [no_auth_dnid] => Array
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [0] => 2400
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [1] => 2300
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [number_try] => 3
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_balance_after_auth] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_balance_after_call] =>
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_rateinitial] =>
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_timetocall] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [auto_setcallerid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [force_callerid] =>
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_sanitize] => BOTH
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_enable] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_askpincode_ifnot_callerid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card] =>
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_assign_card_to_cid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card_typepaid] => POSTPAY
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card_credit] => 0
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card_credit_limit] => 5
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card_tariffgroup] => 6
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [callerid_authentication_over_cardnumber] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [sip_iax_friends] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [sip_iax_pstn_direct_call_prefix] => 9
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [sip_iax_pstn_direct_call] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [extracharge_did] => Array
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [0] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [extracharge_fee] => Array
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [0] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [dialcommand_param] => |30|HL(%timeout%:61000:30000)
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [dialcommand_param_sipiax_friend] => |30|HL(3600000:61000:30000)
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [switchdialcommand] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [maxtime_tocall_negatif_free_route] => 300
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [send_reminder] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [record_call] => 1
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [monitor_formatfile] => gsm
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [base_currency] => CAD
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_force_currency] =>
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [currency_association] => Array
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [0] => cad:prepaid-dollar
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [1] => usd:prepaid-dollar
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [2] => mxn:pesos
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [3] => eur:euro
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [4] => all:credit
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [file_conf_enter_destination] => prepaid-enter-dest
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [file_conf_enter_menulang] => prepaid-menulang2
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [currency_association_internal] => Array
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cad] => prepaid-dollar
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [usd] => prepaid-dollar
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [mxn] => pesos
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [eur] => euro
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [all] => credit
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: AGI Request:
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: Array
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_request] => a2billing.php
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_channel] => SIP/XXX-1-6ef9
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_language] => en
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_type] => SIP
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_uniqueid] => 1162930958.26630
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callerid] => 5145551111
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_calleridname] => OPENFACE INTERN
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callingpres] => 0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callingani2] => 0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callington] => 0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callingtns] => 0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_dnid] => 5144480254
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_rdnis] => unknown
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_context] => custom-a2billing-cid-callback
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_extension] => s
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_priority] => 1
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_enhanced] => 0.0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_accountcode] =>
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: line:490 get_agi_request_parameter = 5145551111 ; SIP/XXX-1-6ef9 ; 1162930958.26630 ; ; s
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: line:565 - [MODE : ALL-CALLBACK - 5145551111]
then in the a2billing log:
Code:
[07/11/2006 15:22:43]:[CallerID:5145551111]:[CN:]:[CC_asterisk_rate-engine: (1, 5145145551111)]
[07/11/2006 15:22:43]:[CallerID:5145551111]:[CN:]:[CC_asterisk_rate-engine: SUPER 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
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=1
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 (dialprefix=SUBSTRING('5145145551111',1,length(dialprefix)) OR dialprefix='defaultprefix')
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5)
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5)
AND (starttime <= 2362 AND endtime >=2362)
AND idtariffgroup='1'
AND ( cc_tariffplan.dnidprefix LIKE '5145145551111%' OR (cc_tariffplan.dnidprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
[07/11/2006 15:22:43]:[CallerID:5145551111]:[CN:]:[CALLBACK-CALLERID : CALLED=5145145551111 | Error : There is no route to call back your phonenumber !!!]
[07/11/2006 15:22:43]:[CallerID:5145551111]:[CN:]:[exit]
I have a tariff for 514 area code, using the default SIP trunk and "callerid authentication" is set to yes in a2billing.conf.
I don't understand what's wrong, please help !!