I have Freepbx2.3.1 (pbxinaflash) and A2Billing 1.3.1. I have searched the forums for possible clues to my problem. But I am still stuck with the following error Originate FAiled. and got no clues why.
I have a "DID that triggers the custom-a2billing-all-callback context. When I call this number, it answers and then hungs up. After that , I get the error message as seen in the /var/log/asterisk/a2billing-callback-daemon.log
** Number of PENDING callbacks 1 **
UPDATE cc_callback_spool SET status='PROCESSING' WHERE id='25'
WE ARE IN THE PARENT PROCESS -> CHILD PID = 3346 -> RECORD ID = 25
WE ARE IN THE CHILD PROCESS
SQL =SELECT id, server_ip, manager_host, manager_username, manager_secret, lasttime_used FROM cc_server_manager WHERE id_group='1' ORDER BY lasttime_used ASC LIMIT 1 OFFSET 0
[2008-03-26 20:33:07]
[
[2008-03-26 20:33:07]]
::>>> IO::Socket::INET=GLOB(0x9be0614)
[
[2008-03-26 20:33:37]]Response - Error - Message - Originate failed
[
[2008-03-26 20:33:37]]
## CALLBACK FAIL
UPDATE cc_callback_spool SET status='ERROR', manager_result='Error-Originate failed', num_attempt='1', last_attempt_time=now(), id_server='1' WHERE id='25'[
[2008-03-26 20:33:37]]
UPDATE cc_server_manager SET lasttime_used=current_timestamp WHERE id ='1'[
[2008-03-26 20:33:37]]
[END SELECT]
Here;s the output of my CLI as seen in /tmp/a2billing_agi.log when I call the DID number. I don't see any reference to the custom-a2billing-callback context that I use for callback so I don't know if this is useful at all, but I am including it anyway.
--------------------- display of /tmp/a2billing_agi.log
[26/03/2008 20:32:51]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[IDCONFIG : 2]
[26/03/2008 20:32:51]:[file:a2billing.php - line:77]:[CallerID:]:[CN:]:[MODE : all-callback]
[26/03/2008 20:32:51]:[file:Class.A2Billing.php - line:616]:[CallerID:4162732358]:[CN:]:[ get_agi_request_parameter = 4162732358 ; SIP/1513520413-09167a28 ; 1206577969.0 ; ; 16474762108]
[26/03/2008 20:32:51]:[file:a2billing.php - line:555]:[CallerID:4162732358]:[CN:]:[[MODE : ALL-CALLBACK - 4162732358]]
[26/03/2008 20:32:51]:[file:a2billing.php - line:559]:[CallerID:4162732358]:[CN:]:[[HANGUP ALL CALLBACK TRIGGER]]
[26/03/2008 20:32:51]:[file:Class.RateEngine.php - line:73]:[CallerID:4162732358]:[CN:]:[[CC_asterisk_rate-engine: (1, 14162732358)]]
[26/03/2008 20:32:51]:[file:Class.RateEngine.php - line:122]:[CallerID:4162732358]:[CN:]:[[CC_asterisk_rate-engine: CALLERID]
4162732358
]
[26/03/2008 20:32:51]:[file:Class.RateEngine.php - line:136]:[CallerID:4162732358]:[CN:]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=1 WHERE calleridprefix=SUBSTRING('4162732358',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[26/03/2008 20:32:51]:[file:Class.RateEngine.php - line:182]:[CallerID:4162732358]:[CN:]:[[RATE ENGINE 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,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
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
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('14162732358',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 <= 4112 AND endtime >=4112)
AND idtariffgroup='1'
AND ( dnidprefix=SUBSTRING('14162732358',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('4162732358',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[26/03/2008 20:32:51]:[file:Class.RateEngine.php - line:192]:[CallerID:4162732358]:[CN:]:[[rate-engine: Count Total result 1]]
[26/03/2008 20:32:51]:[file:Class.RateEngine.php - line:281]:[CallerID:4162732358]:[CN:]:[[CC_asterisk_rate-engine: Count Total result 1]]
[26/03/2008 20:32:51]:[file:Class.RateEngine.php - line:282]:[CallerID:4162732358]:[CN:]:[[CC_asterisk_rate-engine: number_trunk 1]]
[26/03/2008 20:32:51]:[file:Class.RateEngine.php - line:295]:[CallerID:4162732358]:[CN:]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (1000)]]
[26/03/2008 20:32:51]:[file:Class.RateEngine.php - line:301]:[CallerID:4162732358]:[CN:]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:6000000]]
[26/03/2008 20:32:51]:[file:a2billing.php - line:665]:[CallerID:4162732358]:[CN:]:[[CALLBACK-ALL : INSERT CALLBACK REQUEST IN SPOOL : QUERY= INSERT INTO cc_callback_spool (uniqueid, status, server_ip, num_attempt, channel, exten, context, priority, variable, id_server_group, callback_time, account, callerid, timeout ) VALUES ('11624-wanseqh', 'PENDING', 'localhost', '0', 'SIP/Callcentric/14162732358', '1000', 'a2billing-callback', '1', 'CALLED=14162732358|MODE=ALL|CBID=11624-wanseqh|TARIFF=1|LEG=', '1', ADDDATE( CURRENT_TIMESTAMP, INTERVAL 10 SECOND ), '', '123456', '30000')]]
[26/03/2008 20:32:51]:[CallerID:4162732358]:[CN:]:[[exit]]
and here's my extensions_a2billing.conf
[custom-a2billing]
exten => _X.,1,Answer
exten => _X.,n,Wait(1)
exten => _X.,n,DeadAGI(a2billing.php|1)
exten => _X.,n,Hangup
[custom-a2billing-callback]
exten => _X.,1,DeadAGI(a2billing.php|3|callback)
exten => _X.,n,Hangup
[a2billing-cid-callback]
exten => _X.,1,DeadAGI(a2billing.php|1|cid-callback|1) ;last parameter is the callback area code
exten => _X.,n,Hangup
[custom-a2billing-all-callback]
exten => _X.,1,Answer
exten => _X.,n,Wait(1)
exten => _X.,n,DeadAGI(a2billing.php|2|all-callback|1) ;last parameter is the callback area code
;exten => _X.,n,Hangup
exten => _X.,n,Wait(60)
[a2billing-did]
exten => _X.,1,DeadAGI(a2billing.php|1|did)
exten => _X.,2,Hangup
[a2billing-voucher]
exten => _X.,1,DeadAGI(a2billing.php|1|voucher)
exten => _X.,n,Hangup
in a2billing.conf, I am using extension 1000 to handle the call. I use the context custom-a2billing-callback for this extension. when I call this extension, I was able to callout the trunk, so I know my trunk is working.
Any other information that I need to setup to get this callback function to work???
Many thanks in advance.
|